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
77 - name: "{{ include "common.namespace" . }}-docker-registry-key"
84 name: {{ include "common.fullname" . }}-config-job
85 namespace: {{ include "common.namespace" . }}
87 app: {{ include "common.name" . }}
88 chart: {{ .Chart.Name }}-{{ .Chart.Version | replace "+" "_" }}
89 release: {{ include "common.release" . }}
90 heritage: {{ .Release.Service }}
92 "helm.sh/hook": post-upgrade,post-rollback,post-install
93 "helm.sh/hook-weight": "0"
94 "helm.sh/hook-delete-policy": before-hook-creation
100 app: {{ include "common.name" . }}-job
101 release: {{ include "common.release" . }}
102 name: {{ include "common.name" . }}
105 {{- if .Values.global.mariadbGalera.localCluster }}
106 {{- if .Values.global.mariadbGalera.useOperator }}
107 {{ include "common.readinessCheck.waitFor" (dict "dot" . "wait_for" .Values.readinessCheck.wait_for_local_operator ) | indent 6 | trim }}
109 {{ include "common.readinessCheck.waitFor" (dict "dot" . "wait_for" .Values.readinessCheck.wait_for_local ) | indent 6 | trim }}
112 {{- if .Values.global.mariadbGalera.useOperator }}
113 {{ include "common.readinessCheck.waitFor" (dict "dot" . "wait_for" .Values.readinessCheck.wait_for_global_operator ) | indent 6 | trim }}
115 {{ include "common.readinessCheck.waitFor" (dict "dot" . "wait_for" .Values.readinessCheck.wait_for_global ) | indent 6 | trim }}
119 - name: {{ include "common.name" . }}-config
120 image: {{ include "repositoryGenerator.repository" . }}/{{ .Values.image }}
121 imagePullPolicy: {{ .Values.global.pullPolicy | default .Values.pullPolicy }}
126 {{- if include "common.onServiceMesh" . }}
127 echo "waiting 15s for istio side cars to be up"; sleep 15s;{{- end }}
128 mysql() { /usr/bin/mysql -h ${DB_HOST} -P ${DB_PORT} "$@"; };
130 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 }};
131 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;
132 {{- if .Values.global.migration.enabled }}
133 mysql -vv --user=root --password=${MYSQL_ROOT_PASSWORD} < `ls -tr /var/data/mariadb/* | tail -1`;
137 value: {{ include "common.mariadbService" . }}
139 value: {{ include "common.mariadbPort" . | quote }}
140 - name: MYSQL_ROOT_PASSWORD
141 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "db-root-pass" "key" "password") | indent 10 }}
143 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "db-user-creds" "key" "login") | indent 10 }}
145 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "db-user-creds" "key" "password") | indent 10 }}
147 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "db-admin-creds" "key" "login") | indent 10 }}
148 - name: DB_ADMIN_PASSWORD
149 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "db-admin-creds" "key" "password") | indent 10 }}
150 - name: CAMUNDA_DB_USER
151 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "camunda-db-creds" "key" "login") | indent 10 }}
152 - name: CAMUNDA_DB_PASSWORD
153 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "camunda-db-creds" "key" "password") | indent 10 }}
154 - name: REQUEST_DB_USER
155 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "request-db-creds" "key" "login") | indent 10 }}
156 - name: REQUEST_DB_PASSWORD
157 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "request-db-creds" "key" "password") | indent 10 }}
158 - name: CATALOG_DB_USER
159 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "catalog-db-creds" "key" "login") | indent 10 }}
160 - name: CATALOG_DB_PASSWORD
161 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "catalog-db-creds" "key" "password") | indent 10 }}
163 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "nfvo-db-creds" "key" "login") | indent 10 }}
164 - name: NFVO_DB_PASSWORD
165 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "nfvo-db-creds" "key" "password") | indent 10 }}
167 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "cnfm-db-creds" "key" "login") | indent 10 }}
168 - name: CNFM_DB_PASSWORD
169 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "cnfm-db-creds" "key" "password") | indent 10 }}
171 - mountPath: /etc/localtime
174 - name: docker-entrypoint-initdb-d-sh
175 mountPath: "/docker-entrypoint-initdb.d"
176 - name: docker-entrypoint-initdb-d-sql
177 mountPath: "/docker-entrypoint-initdb.d/db-sql-scripts"
178 {{- if .Values.global.migration.enabled }}
179 - name: backup-storage
180 mountPath: /var/data/mariadb
182 resources: {{ include "common.resources" . | nindent 10 }}
183 {{ include "common.waitForJobContainer" . | indent 6 | trim }}
184 {{- if .Values.nodeSelector }}
186 {{ toYaml .Values.nodeSelector | indent 10 }}
188 {{- if .Values.affinity }}
190 {{ toYaml .Values.affinity | indent 10 }}
192 serviceAccountName: {{ include "common.fullname" (dict "suffix" "read" "dot" . )}}
197 - name: docker-entrypoint-initdb-d-sh
199 name: {{ include "common.fullname" . }}-mariadb-sh
200 - name: docker-entrypoint-initdb-d-sql
202 name: {{ include "common.fullname" . }}-mariadb-sql
203 {{- if .Values.global.migration.enabled }}
204 - name: backup-storage
205 persistentVolumeClaim:
206 claimName: {{ include "common.fullname" . }}-migration
210 - name: "{{ include "common.namespace" . }}-docker-registry-key"