statefulset.yaml
3.18 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
apiVersion: apps/v1
kind: StatefulSet
metadata:
name: postgresql
namespace: ecommerce
spec:
serviceName: postgresql-service
replicas: 1
selector:
matchLabels:
app: postgresql
template:
metadata:
labels:
app: postgresql
spec:
# 添加初始化容器来创建额外的数据库
initContainers:
- name: init-databases
image: postgres:15
command:
- /bin/sh
- -c
- |
set -e
echo "Waiting for PostgreSQL to be ready..."
until pg_isready -h localhost -U admin; do
sleep 2
done
echo "PostgreSQL is ready. Creating additional databases..."
# 创建 notification service 数据库 - 使用 IF NOT EXISTS
psql -U admin -d postgres -c "CREATE DATABASE IF NOT EXISTS ecommerce_notifications;"
echo "Database ecommerce_notifications ensured"
# 可以在这里添加其他微服务的数据库 - 都使用 IF NOT EXISTS
# psql -U admin -d postgres -c "CREATE DATABASE IF NOT EXISTS ecommerce_users;"
# echo "Database ecommerce_users ensured"
# psql -U admin -d postgres -c "CREATE DATABASE IF NOT EXISTS ecommerce_orders;"
# echo "Database ecommerce_orders ensured"
# psql -U admin -d postgres -c "CREATE DATABASE IF NOT EXISTS ecommerce_products;"
# echo "Database ecommerce_products ensured"
echo "All additional databases created/ensured successfully"
env:
- name: PGPASSWORD
valueFrom:
secretKeyRef:
name: postgresql-secret
key: password
volumeMounts:
- name: postgresql-data
mountPath: /var/lib/postgresql/data
containers:
- name: postgresql
image: postgres:15
ports:
- containerPort: 5432
env:
- name: POSTGRES_DB
value: "ecommerce"
- name: POSTGRES_USER
value: "admin"
- name: POSTGRES_PASSWORD
valueFrom:
secretKeyRef:
name: postgresql-secret
key: password
- name: PGDATA
value: /var/lib/postgresql/data/pgdata
volumeMounts:
- name: postgresql-data
mountPath: /var/lib/postgresql/data
livenessProbe:
exec:
command:
- pg_isready
- -U
- admin
initialDelaySeconds: 60
periodSeconds: 20
timeoutSeconds: 10
failureThreshold: 3
readinessProbe:
exec:
command:
- pg_isready
- -U
- admin
initialDelaySeconds: 30
periodSeconds: 10
timeoutSeconds: 5
failureThreshold: 3
resources:
requests:
memory: "256Mi"
cpu: "250m"
limits:
memory: "512Mi"
cpu: "500m"
volumes:
- name: postgresql-data
persistentVolumeClaim:
claimName: postgresql-pvc