Hao Kuang | 27af4a3 | 2017-12-15 20:38:03 +0000 | [diff] [blame] | 1 | #{{ if not .Values.disableSdncSdncDbhost }} |
| 2 | apiVersion: apps/v1beta1 |
| 3 | kind: StatefulSet |
| 4 | metadata: |
| 5 | name: sdnc-dbhost |
BorislavG | 8bfc6cf | 2018-02-27 15:04:26 +0000 | [diff] [blame] | 6 | namespace: "{{ .Values.nsPrefix }}" |
Hao Kuang | 27af4a3 | 2017-12-15 20:38:03 +0000 | [diff] [blame] | 7 | spec: |
| 8 | serviceName: "dbhost" |
| 9 | replicas: {{ .Values.numberOfDbReplicas }} |
| 10 | selector: |
| 11 | matchLabels: |
| 12 | app: sdnc-dbhost |
| 13 | template: |
| 14 | metadata: |
| 15 | labels: |
| 16 | app: sdnc-dbhost |
| 17 | name: sdnc-dbhost |
| 18 | spec: |
| 19 | initContainers: |
| 20 | - name: init-mysql |
| 21 | image: {{ .Values.image.mysql }} |
| 22 | imagePullPolicy: {{ .Values.pullPolicy }} |
| 23 | command: |
| 24 | - bash |
| 25 | - "-c" |
| 26 | - | |
| 27 | set -ex |
| 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/ |
| 38 | else |
| 39 | cp /mnt/config-map/slave.cnf /mnt/conf.d/ |
| 40 | fi |
| 41 | volumeMounts: |
| 42 | - name: conf |
| 43 | mountPath: /mnt/conf.d |
| 44 | - name: config-map |
| 45 | mountPath: /mnt/config-map |
| 46 | - name: clone-mysql |
| 47 | image: {{ .Values.image.xtrabackup }} |
| 48 | env: |
| 49 | - name: MYSQL_ROOT_PASSWORD |
| 50 | value: openECOMP1.0 |
| 51 | command: |
| 52 | - bash |
| 53 | - "-c" |
| 54 | - | |
| 55 | set -ex |
| 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]} |
| 61 | echo ${BASH_REMATCH} |
| 62 | [[ $ordinal -eq 0 ]] && exit 0 |
| 63 | # Clone data from previous peer. |
BorislavG | 8bfc6cf | 2018-02-27 15:04:26 +0000 | [diff] [blame] | 64 | ncat --recv-only sdnc-dbhost-$(($ordinal-1)).dbhost.{{ .Values.nsPrefix }} 3307 | xbstream -x -C /var/lib/mysql |
Hao Kuang | 27af4a3 | 2017-12-15 20:38:03 +0000 | [diff] [blame] | 65 | # Prepare the backup. |
| 66 | xtrabackup --user=root --password=$MYSQL_ROOT_PASSWORD --prepare --target-dir=/var/lib/mysql |
| 67 | ls -l /var/lib/mysql |
| 68 | volumeMounts: |
| 69 | - name: sdnc-data |
| 70 | mountPath: /var/lib/mysql |
| 71 | subPath: mysql |
| 72 | - name: conf |
| 73 | mountPath: /etc/mysql/conf.d |
| 74 | containers: |
| 75 | - env: |
| 76 | - name: MYSQL_ROOT_PASSWORD |
| 77 | value: openECOMP1.0 |
| 78 | - name: MYSQL_ROOT_HOST |
| 79 | value: '%' |
| 80 | - name: MYSQL_ALLOW_EMPTY_PASSWORD |
| 81 | value: "0" |
| 82 | image: {{ .Values.image.mysql }} |
| 83 | imagePullPolicy: {{ .Values.pullPolicy }} |
| 84 | name: sdnc-db-container |
| 85 | volumeMounts: |
| 86 | - mountPath: /var/lib/mysql |
| 87 | name: sdnc-data |
| 88 | subPath: mysql |
| 89 | - name: conf |
| 90 | mountPath: /etc/mysql/conf.d |
| 91 | ports: |
| 92 | - containerPort: 3306 |
| 93 | resources: |
| 94 | requests: |
| 95 | cpu: 500m |
| 96 | memory: 1Gi |
| 97 | livenessProbe: |
| 98 | exec: |
| 99 | command: ["mysqladmin", "ping"] |
| 100 | initialDelaySeconds: 30 |
| 101 | periodSeconds: 10 |
| 102 | timeoutSeconds: 5 |
| 103 | readinessProbe: |
| 104 | tcpSocket: |
| 105 | port: 3306 |
| 106 | initialDelaySeconds: 5 |
| 107 | periodSeconds: 10 |
| 108 | - name: xtrabackup |
| 109 | image: {{ .Values.image.xtrabackup }} |
| 110 | env: |
| 111 | - name: MYSQL_ROOT_PASSWORD |
| 112 | value: openECOMP1.0 |
| 113 | ports: |
| 114 | - name: xtrabackup |
| 115 | containerPort: 3307 |
| 116 | command: |
| 117 | - bash |
| 118 | - "-c" |
| 119 | - | |
| 120 | set -ex |
| 121 | cd /var/lib/mysql |
| 122 | ls -l |
| 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 |
| 138 | fi |
| 139 | |
| 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]} |
| 145 | echo $ordinal |
| 146 | until mysql --user=root --password=$MYSQL_ROOT_PASSWORD -h 127.0.0.1 -e "SELECT 1"; do sleep 1; done |
| 147 | |
| 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), |
BorislavG | 8bfc6cf | 2018-02-27 15:04:26 +0000 | [diff] [blame] | 153 | MASTER_HOST="sdnc-dbhost-0.dbhost.{{ .Values.nsPrefix }}", |
Hao Kuang | 27af4a3 | 2017-12-15 20:38:03 +0000 | [diff] [blame] | 154 | MASTER_USER="root", |
| 155 | MASTER_PASSWORD="$MYSQL_ROOT_PASSWORD", |
| 156 | MASTER_CONNECT_RETRY=10; |
| 157 | START SLAVE; |
| 158 | EOF |
| 159 | fi |
| 160 | |
| 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" |
| 164 | volumeMounts: |
| 165 | - name: sdnc-data |
| 166 | mountPath: /var/lib/mysql |
| 167 | subPath: mysql |
| 168 | - name: conf |
| 169 | mountPath: /etc/mysql/conf.d |
| 170 | resources: |
| 171 | requests: |
| 172 | cpu: 100m |
| 173 | memory: 100Mi |
| 174 | volumes: |
| 175 | - name: conf |
| 176 | emptyDir: {} |
| 177 | - name: config-map |
| 178 | configMap: |
BorislavG | 8bfc6cf | 2018-02-27 15:04:26 +0000 | [diff] [blame] | 179 | name: sdnc-mysql |
Hao Kuang | 27af4a3 | 2017-12-15 20:38:03 +0000 | [diff] [blame] | 180 | - name: localtime |
| 181 | hostPath: |
| 182 | path: /etc/localtime |
BorislavG | 8bfc6cf | 2018-02-27 15:04:26 +0000 | [diff] [blame] | 183 | #{{ if .Values.disableNfsProvisioner }} |
| 184 | - name: sdnc-data |
| 185 | hostPath: |
| 186 | path: /dockerdata-nfs/{{ .Values.nsPrefix }}/sdnc/data |
| 187 | #{{ else }} |
Hao Kuang | 27af4a3 | 2017-12-15 20:38:03 +0000 | [diff] [blame] | 188 | volumeClaimTemplates: |
| 189 | - metadata: |
| 190 | name: sdnc-data |
| 191 | annotations: |
| 192 | volume.beta.kubernetes.io/storage-class: "{{ .Values.nsPrefix }}-sdnc-data" |
| 193 | spec: |
| 194 | accessModes: ["ReadWriteMany"] |
| 195 | resources: |
| 196 | requests: |
| 197 | storage: 1Gi |
| 198 | #{{ end }} |
BorislavG | 8bfc6cf | 2018-02-27 15:04:26 +0000 | [diff] [blame] | 199 | #{{ end }} |