2 # Copyright © 2017 Amdocs, Bell Canada
3 # Modifications Copyright (C) 2022/23 Nordix Foundation
5 # Licensed under the Apache License, Version 2.0 (the "License");
6 # you may not use this file except in compliance with the License.
7 # You may obtain a copy of the License at
9 # http://www.apache.org/licenses/LICENSE-2.0
11 # Unless required by applicable law or agreed to in writing, software
12 # distributed under the License is distributed on an "AS IS" BASIS,
13 # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
14 # See the License for the specific language governing permissions and
15 # limitations under the License.
17 {{- if .Values.global.migration.enabled }}
21 name: {{ include "common.fullname" . }}-backup
22 namespace: {{ include "common.namespace" . }}
24 app: {{ include "common.name" . }}
25 chart: {{ .Chart.Name }}-{{ .Chart.Version | replace "+" "_" }}
26 release: {{ include "common.release" . }}
27 heritage: {{ .Release.Service }}
29 "helm.sh/hook": pre-upgrade,pre-install
30 "helm.sh/hook-weight": "1"
31 "helm.sh/hook-delete-policy": before-hook-creation
37 app: {{ include "common.name" . }}
38 release: {{ include "common.release" . }}
39 name: {{ include "common.name" . }}
42 - name: {{ include "common.fullname" . }}
43 image: {{ include "repositoryGenerator.image.mariadb" . }}
44 imagePullPolicy: {{ .Values.global.pullPolicy | default .Values.pullPolicy }}
47 value: {{ .Values.global.migration.dbHost }}
49 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "db-backup-creds" "key" "login") | indent 10 }}
51 value: "{{ .Values.global.migration.dbPort }}"
53 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "db-backup-creds" "key" "password") | indent 10 }}
58 {{- if include "common.onServiceMesh" . }}
59 echo "waiting 15s for istio side cars to be up"; sleep 15s;{{- end }}
60 mysqldump -vv --user=${DB_USER} --password=${DB_PASS} --host=${DB_HOST} --port=${DB_PORT} --databases --single-transaction --quick --lock-tables=false catalogdb requestdb nfvo cnfm > /var/data/mariadb/backup-`date +%s`.sql
62 - mountPath: /etc/localtime
65 - name: backup-storage
66 mountPath: /var/data/mariadb
67 {{ include "common.waitForJobContainer" . | indent 6 | trim }}
68 serviceAccountName: {{ include "common.fullname" (dict "suffix" "read" "dot" . )}}
73 - name: backup-storage
74 persistentVolumeClaim:
75 claimName: {{ include "common.fullname" . }}-migration
76 {{- include "common.imagePullSecrets" . | nindent 6 }}
83 name: {{ include "common.fullname" . }}-config-job
84 namespace: {{ include "common.namespace" . }}
86 app: {{ include "common.name" . }}
87 chart: {{ .Chart.Name }}-{{ .Chart.Version | replace "+" "_" }}
88 release: {{ include "common.release" . }}
89 heritage: {{ .Release.Service }}
91 "helm.sh/hook": post-upgrade,post-rollback,post-install
92 "helm.sh/hook-weight": "0"
93 "helm.sh/hook-delete-policy": before-hook-creation
99 app: {{ include "common.name" . }}-job
100 release: {{ include "common.release" . }}
101 name: {{ include "common.name" . }}
104 {{- if .Values.global.mariadbGalera.localCluster }}
105 {{- if .Values.global.mariadbGalera.useOperator }}
106 {{ include "common.readinessCheck.waitFor" (dict "dot" . "wait_for" .Values.readinessCheck.wait_for_local_operator ) | indent 6 | trim }}
108 {{ include "common.readinessCheck.waitFor" (dict "dot" . "wait_for" .Values.readinessCheck.wait_for_local ) | indent 6 | trim }}
111 {{- if .Values.global.mariadbGalera.useOperator }}
112 {{ include "common.readinessCheck.waitFor" (dict "dot" . "wait_for" .Values.readinessCheck.wait_for_global_operator ) | indent 6 | trim }}
114 {{ include "common.readinessCheck.waitFor" (dict "dot" . "wait_for" .Values.readinessCheck.wait_for_global ) | indent 6 | trim }}
118 - name: {{ include "common.name" . }}-config
119 image: {{ include "repositoryGenerator.repository" . }}/{{ .Values.image }}
120 imagePullPolicy: {{ .Values.global.pullPolicy | default .Values.pullPolicy }}
125 {{- if include "common.onServiceMesh" . }}
126 echo "waiting 15s for istio side cars to be up"; sleep 15s;{{- end }}
127 mysql() { /usr/bin/mysql -h ${DB_HOST} -P ${DB_PORT} "$@"; };
129 mysql --user=root --password=${MYSQL_ROOT_PASSWORD} requestdb -e exit > /dev/null 2>&1 {{ if not .Values.global.migration.enabled }} && echo "Database already initialized!!!" && exit 0 {{ end }};
130 for f in /docker-entrypoint-initdb.d/*; do case "$f" in *.sh) echo "$0: running $f"; . "$f" ;; *.sql) echo "$0: running $f"; "${mysql[@]}" < "$f"; echo ;; *.sql.gz) echo "$0: running $f"; gunzip -c "$f" | "${mysql[@]}"; echo ;; *) echo "$0: ignoring $f" ;; esac; echo; done;
131 {{- if .Values.global.migration.enabled }}
132 mysql -vv --user=root --password=${MYSQL_ROOT_PASSWORD} < `ls -tr /var/data/mariadb/* | tail -1`;
136 value: {{ include "common.mariadbService" . }}
138 value: {{ include "common.mariadbPort" . | quote }}
139 - name: MYSQL_ROOT_PASSWORD
140 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "db-root-pass" "key" "password") | indent 10 }}
142 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "db-user-creds" "key" "login") | indent 10 }}
144 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "db-user-creds" "key" "password") | indent 10 }}
146 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "db-admin-creds" "key" "login") | indent 10 }}
147 - name: DB_ADMIN_PASSWORD
148 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "db-admin-creds" "key" "password") | indent 10 }}
149 - name: CAMUNDA_DB_USER
150 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "camunda-db-creds" "key" "login") | indent 10 }}
151 - name: CAMUNDA_DB_PASSWORD
152 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "camunda-db-creds" "key" "password") | indent 10 }}
153 - name: REQUEST_DB_USER
154 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "request-db-creds" "key" "login") | indent 10 }}
155 - name: REQUEST_DB_PASSWORD
156 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "request-db-creds" "key" "password") | indent 10 }}
157 - name: CATALOG_DB_USER
158 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "catalog-db-creds" "key" "login") | indent 10 }}
159 - name: CATALOG_DB_PASSWORD
160 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "catalog-db-creds" "key" "password") | indent 10 }}
162 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "nfvo-db-creds" "key" "login") | indent 10 }}
163 - name: NFVO_DB_PASSWORD
164 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "nfvo-db-creds" "key" "password") | indent 10 }}
166 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "cnfm-db-creds" "key" "login") | indent 10 }}
167 - name: CNFM_DB_PASSWORD
168 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "cnfm-db-creds" "key" "password") | indent 10 }}
170 - mountPath: /etc/localtime
173 - name: docker-entrypoint-initdb-d-sh
174 mountPath: "/docker-entrypoint-initdb.d"
175 - name: docker-entrypoint-initdb-d-sql
176 mountPath: "/docker-entrypoint-initdb.d/db-sql-scripts"
177 {{- if .Values.global.migration.enabled }}
178 - name: backup-storage
179 mountPath: /var/data/mariadb
181 resources: {{ include "common.resources" . | nindent 10 }}
182 {{ include "common.waitForJobContainer" . | indent 6 | trim }}
183 {{- if .Values.nodeSelector }}
185 {{ toYaml .Values.nodeSelector | indent 10 }}
187 {{- if .Values.affinity }}
189 {{ toYaml .Values.affinity | indent 10 }}
191 serviceAccountName: {{ include "common.fullname" (dict "suffix" "read" "dot" . )}}
196 - name: docker-entrypoint-initdb-d-sh
198 name: {{ include "common.fullname" . }}-mariadb-sh
199 - name: docker-entrypoint-initdb-d-sql
201 name: {{ include "common.fullname" . }}-mariadb-sql
202 {{- if .Values.global.migration.enabled }}
203 - name: backup-storage
204 persistentVolumeClaim:
205 claimName: {{ include "common.fullname" . }}-migration
208 {{- include "common.imagePullSecrets" . | nindent 6 }}