-
Notifications
You must be signed in to change notification settings - Fork 19
/
mysql-db.yaml
97 lines (96 loc) · 2.42 KB
/
mysql-db.yaml
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
# Copyright 2022 Google LLC
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
# http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
# [START anthosbaremetal_k8_manifests_mysql_db_statefulset_mysql_db]
kind: StatefulSet
apiVersion: apps/v1
metadata:
name: mysql-db
labels:
app: mysql-db
tier: db
spec:
serviceName: mysql-db
replicas: 1
selector:
matchLabels:
app: mysql-db
tier: db
template:
metadata:
labels:
app: mysql-db
tier: db
spec:
serviceAccountName: default
terminationGracePeriodSeconds: 10
containers:
- name: mysql-db
image: mysql:8.0.28-oracle
envFrom:
- configMapRef:
name: mysql-db-config
ports:
- name: mysqldb
protocol: TCP
containerPort: 3306
resources:
requests:
cpu: 100m
memory: 128Mi
limits:
cpu: 500m
memory: 1Gi
volumeMounts:
- name: mysqldb
mountPath: /var/lib/mysql
volumes:
- name: mysqldb
emptyDir: {}
# [END anthosbaremetal_k8_manifests_mysql_db_statefulset_mysql_db]
---
# [START anthosbaremetal_k8_manifests_mysql_db_service_mysql_db]
apiVersion: v1
kind: Service
metadata:
name: mysql-db
labels:
app: mysql-db
tier: db
spec:
clusterIP: None
ports:
- port: 3306
name: tcp
targetPort: 3306
protocol: TCP
selector:
app: mysql-db
tier: db
# [END anthosbaremetal_k8_manifests_mysql_db_service_mysql_db]
---
# [START anthosbaremetal_k8_manifests_mysql_db_configmap_mysql_db_mysql_db_config]
apiVersion: v1
kind: ConfigMap
metadata:
name: mysql-db-config
labels:
app: mysql-db
data:
MYSQL_HOST: mysql-db
MYSQL_DATABASE: pos_db
MYSQL_USER: demouser
MYSQL_PASSWORD: demopassword
MYSQL_ROOT_PASSWORD: totoallysafepassword
MYSQL_DB_URI: jdbc:mysql://demouser:demopassword@mysql-db:3306/pos_db
# [END anthosbaremetal_k8_manifests_mysql_db_configmap_mysql_db_mysql_db_config]