statefulset.yaml
2.54 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
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: setup-init-scripts
image: busybox
command:
- /bin/sh
- -c
- |
# 创建初始化脚本
cat > /docker-entrypoint-initdb.d/01-create-databases.sql << 'EOF'
CREATE DATABASE ecommerce_notifications;
CREATE DATABASE ecommerce_orders;
-- 可以在这里添加其他数据库
-- CREATE DATABASE ecommerce_users;
-- CREATE DATABASE ecommerce_products;
EOF
echo "Init scripts created successfully"
echo "Databases to be created: ecommerce_notifications, ecommerce_orders"
volumeMounts:
- name: init-scripts
mountPath: /docker-entrypoint-initdb.d
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
- name: init-scripts
mountPath: /docker-entrypoint-initdb.d
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
- name: init-scripts
emptyDir: {}