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 - name: {{ include "common.name" . }}-readiness
110 - {{ include "common.mariadbAppName" . }}
116 fieldPath: metadata.namespace
117 image: {{ include "repositoryGenerator.image.readiness" . }}
118 imagePullPolicy: {{ .Values.global.pullPolicy | default .Values.pullPolicy }}
127 - name: {{ include "common.name" . }}-config
128 image: {{ include "repositoryGenerator.repository" . }}/{{ .Values.image }}
129 imagePullPolicy: {{ .Values.global.pullPolicy | default .Values.pullPolicy }}
134 {{- if include "common.onServiceMesh" . }}
135 echo "waiting 15s for istio side cars to be up"; sleep 15s;{{- end }}
136 mysql() { /usr/bin/mysql -h ${DB_HOST} -P ${DB_PORT} "$@"; };
138 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 }};
139 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;
140 {{- if .Values.global.migration.enabled }}
141 mysql -vv --user=root --password=${MYSQL_ROOT_PASSWORD} < `ls -tr /var/data/mariadb/* | tail -1`;
145 value: {{ include "common.mariadbService" . }}
147 value: {{ include "common.mariadbPort" . | quote }}
148 - name: MYSQL_ROOT_PASSWORD
149 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "db-root-pass" "key" "password") | indent 10 }}
151 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "db-user-creds" "key" "login") | indent 10 }}
153 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "db-user-creds" "key" "password") | indent 10 }}
155 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "db-admin-creds" "key" "login") | indent 10 }}
156 - name: DB_ADMIN_PASSWORD
157 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "db-admin-creds" "key" "password") | indent 10 }}
158 - name: CAMUNDA_DB_USER
159 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "camunda-db-creds" "key" "login") | indent 10 }}
160 - name: CAMUNDA_DB_PASSWORD
161 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "camunda-db-creds" "key" "password") | indent 10 }}
162 - name: REQUEST_DB_USER
163 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "request-db-creds" "key" "login") | indent 10 }}
164 - name: REQUEST_DB_PASSWORD
165 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "request-db-creds" "key" "password") | indent 10 }}
166 - name: CATALOG_DB_USER
167 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "catalog-db-creds" "key" "login") | indent 10 }}
168 - name: CATALOG_DB_PASSWORD
169 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "catalog-db-creds" "key" "password") | indent 10 }}
171 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "nfvo-db-creds" "key" "login") | indent 10 }}
172 - name: NFVO_DB_PASSWORD
173 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "nfvo-db-creds" "key" "password") | indent 10 }}
175 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "cnfm-db-creds" "key" "login") | indent 10 }}
176 - name: CNFM_DB_PASSWORD
177 {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "cnfm-db-creds" "key" "password") | indent 10 }}
179 - mountPath: /etc/localtime
182 - name: docker-entrypoint-initdb-d-sh
183 mountPath: "/docker-entrypoint-initdb.d"
184 - name: docker-entrypoint-initdb-d-sql
185 mountPath: "/docker-entrypoint-initdb.d/db-sql-scripts"
186 {{- if .Values.global.migration.enabled }}
187 - name: backup-storage
188 mountPath: /var/data/mariadb
190 resources: {{ include "common.resources" . | nindent 10 }}
191 {{ include "common.waitForJobContainer" . | indent 6 | trim }}
192 {{- if .Values.nodeSelector }}
194 {{ toYaml .Values.nodeSelector | indent 10 }}
196 {{- if .Values.affinity }}
198 {{ toYaml .Values.affinity | indent 10 }}
200 serviceAccountName: {{ include "common.fullname" (dict "suffix" "read" "dot" . )}}
205 - name: docker-entrypoint-initdb-d-sh
207 name: {{ include "common.fullname" . }}-mariadb-sh
208 - name: docker-entrypoint-initdb-d-sql
210 name: {{ include "common.fullname" . }}-mariadb-sql
211 {{- if .Values.global.migration.enabled }}
212 - name: backup-storage
213 persistentVolumeClaim:
214 claimName: {{ include "common.fullname" . }}-migration
218 - name: "{{ include "common.namespace" . }}-docker-registry-key"