1 #{{ if not .Values.disableSdncSdncDbhost }}
2 apiVersion: apps/v1beta1
6 namespace: "{{ .Values.nsPrefix }}-sdnc"
9 replicas: {{ .Values.numberOfDbReplicas }}
21 image: {{ .Values.image.mysql }}
22 imagePullPolicy: {{ .Values.pullPolicy }}
28 # Generate mysql server-id from pod ordinal index.
29 [[ `hostname` =~ -([0-9]+)$ ]] || exit 1
30 ordinal=${BASH_REMATCH[1]}
31 echo BASH_REMATCH=${BASH_REMATCH}
32 echo [mysqld] > /mnt/conf.d/server-id.cnf
33 # Add an offset to avoid reserved server-id=0 value.
34 echo server-id=$((100 + $ordinal)) >> /mnt/conf.d/server-id.cnf
35 # Copy appropriate conf.d files from config-map to emptyDir.
36 if [[ $ordinal -eq 0 ]]; then
37 cp /mnt/config-map/master.cnf /mnt/conf.d/
39 cp /mnt/config-map/slave.cnf /mnt/conf.d/
43 mountPath: /mnt/conf.d
45 mountPath: /mnt/config-map
47 image: {{ .Values.image.xtrabackup }}
49 - name: MYSQL_ROOT_PASSWORD
56 # Skip the clone if data already exists.
57 [[ -d /var/lib/mysql/mysql ]] && exit 0
58 # Skip the clone on master (ordinal index 0).
59 [[ `hostname` =~ -([0-9]+)$ ]] || exit 1
60 ordinal=${BASH_REMATCH[1]}
62 [[ $ordinal -eq 0 ]] && exit 0
63 # Clone data from previous peer.
64 ncat --recv-only sdnc-dbhost-$(($ordinal-1)).dbhost.{{ .Values.nsPrefix }}-sdnc 3307 | xbstream -x -C /var/lib/mysql
66 xtrabackup --user=root --password=$MYSQL_ROOT_PASSWORD --prepare --target-dir=/var/lib/mysql
70 mountPath: /var/lib/mysql
73 mountPath: /etc/mysql/conf.d
76 - name: MYSQL_ROOT_PASSWORD
78 - name: MYSQL_ROOT_HOST
80 - name: MYSQL_ALLOW_EMPTY_PASSWORD
82 image: {{ .Values.image.mysql }}
83 imagePullPolicy: {{ .Values.pullPolicy }}
84 name: sdnc-db-container
86 - mountPath: /var/lib/mysql
90 mountPath: /etc/mysql/conf.d
99 command: ["mysqladmin", "ping"]
100 initialDelaySeconds: 30
106 initialDelaySeconds: 5
109 image: {{ .Values.image.xtrabackup }}
111 - name: MYSQL_ROOT_PASSWORD
123 # Determine binlog position of cloned data, if any.
124 if [[ -f xtrabackup_slave_info ]]; then
125 echo "Inside xtrabackup_slave_info"
126 # XtraBackup already generated a partial "CHANGE MASTER TO" query
127 # because we're cloning from an existing slave.
128 mv xtrabackup_slave_info change_master_to.sql.in
129 # Ignore xtrabackup_binlog_info in this case (it's useless).
130 rm -f xtrabackup_binlog_info
131 elif [[ -f xtrabackup_binlog_info ]]; then
132 echo "Inside xtrabackup_binlog_info"
133 # We're cloning directly from master. Parse binlog position.
134 [[ `cat xtrabackup_binlog_info` =~ ^(.*?)[[:space:]]+(.*?)$ ]] || exit 1
135 rm xtrabackup_binlog_info
136 echo "CHANGE MASTER TO MASTER_LOG_FILE='${BASH_REMATCH[1]}',\
137 MASTER_LOG_POS=${BASH_REMATCH[2]}" > change_master_to.sql.in
140 # Check if we need to complete a clone by starting replication.
141 if [[ -f change_master_to.sql.in ]]; then
142 echo "Waiting for mysqld to be ready (accepting connections)"
143 [[ `hostname` =~ -([0-9]+)$ ]] || exit 1
144 ordinal=${BASH_REMATCH[1]}
146 until mysql --user=root --password=$MYSQL_ROOT_PASSWORD -h 127.0.0.1 -e "SELECT 1"; do sleep 1; done
148 echo "Initializing replication from clone position"
149 # In case of container restart, attempt this at-most-once.
150 mv change_master_to.sql.in change_master_to.sql.orig
151 mysql --user=root --password=$MYSQL_ROOT_PASSWORD -h 127.0.0.1 <<EOF
152 $(<change_master_to.sql.orig),
153 MASTER_HOST="sdnc-dbhost-0.dbhost.{{ .Values.nsPrefix }}-sdnc",
155 MASTER_PASSWORD="$MYSQL_ROOT_PASSWORD",
156 MASTER_CONNECT_RETRY=10;
161 # Start a server to send backups when requested by peers.
162 exec ncat --listen --keep-open --send-only --max-conns=1 3307 -c \
163 "xtrabackup --user=root --password=$MYSQL_ROOT_PASSWORD --backup --slave-info --stream=xbstream --host=127.0.0.1"
166 mountPath: /var/lib/mysql
169 mountPath: /etc/mysql/conf.d
183 volumeClaimTemplates:
187 volume.beta.kubernetes.io/storage-class: "{{ .Values.nsPrefix }}-sdnc-data"
189 accessModes: ["ReadWriteMany"]