a.sreekumar | cf3133d | 2021-09-10 14:41:30 +0100 | [diff] [blame] | 1 | # Copyright © 2018 Amdocs |
| 2 | # Copyright © 2018,2021 Bell Canada |
Krzysztof Opasiak | 01c975b | 2019-12-16 17:42:38 +0100 | [diff] [blame] | 3 | # Copyright © 2019 Samsung Electronics |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 4 | # Copyright © 2020 Bitnami, Orange |
vaibhavjayas | ea9aee0 | 2018-08-31 06:22:26 +0000 | [diff] [blame] | 5 | # |
| 6 | # Licensed under the Apache License, Version 2.0 (the "License"); |
| 7 | # you may not use this file except in compliance with the License. |
| 8 | # You may obtain a copy of the License at |
| 9 | # |
| 10 | # http://www.apache.org/licenses/LICENSE-2.0 |
| 11 | # |
| 12 | # Unless required by applicable law or agreed to in writing, software |
| 13 | # distributed under the License is distributed on an "AS IS" BASIS, |
| 14 | # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. |
| 15 | # See the License for the specific language governing permissions and |
| 16 | # limitations under the License. |
| 17 | |
Andreas Geissler | cfd8434 | 2023-08-16 17:18:49 +0200 | [diff] [blame] | 18 | ################################################################# |
| 19 | # Global configuration defaults. |
| 20 | ################################################################# |
| 21 | global: |
| 22 | nodePortPrefix: 302 |
| 23 | persistence: |
| 24 | mountPath: /dockerdata-nfs |
| 25 | backup: |
| 26 | mountPath: /dockerdata-nfs/backup |
| 27 | clusterDomain: cluster.local |
| 28 | metrics: {} |
| 29 | mariadbGalera: |
| 30 | # flag to enable the DB creation via mariadb-operator |
| 31 | useOperator: true |
| 32 | # if useOperator set to "true", set "enableServiceAccount to "false" |
| 33 | # as the SA is created by the Operator |
| 34 | enableServiceAccount: false |
| 35 | nameOverride: mariadb-galera |
| 36 | service: mariadb-galera |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 37 | |
vitalied | 1e5876c | 2018-03-29 10:24:27 -0500 | [diff] [blame] | 38 | ################################################################# |
Krzysztof Opasiak | 01c975b | 2019-12-16 17:42:38 +0100 | [diff] [blame] | 39 | # Secrets metaconfig |
| 40 | ################################################################# |
| 41 | secrets: |
Krzysztof Opasiak | a789c1a | 2020-01-22 00:06:32 +0100 | [diff] [blame] | 42 | - uid: '{{ include "common.mariadb.secret.rootPassUID" . }}' |
Krzysztof Opasiak | 01c975b | 2019-12-16 17:42:38 +0100 | [diff] [blame] | 43 | type: password |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 44 | externalSecret: '{{ tpl (default "" .Values.rootUser.externalSecret) . }}' |
| 45 | password: '{{ .Values.rootUser.password }}' |
Krzysztof Opasiak | a789c1a | 2020-01-22 00:06:32 +0100 | [diff] [blame] | 46 | - uid: '{{ include "common.mariadb.secret.userCredentialsUID" . }}' |
Krzysztof Opasiak | 01c975b | 2019-12-16 17:42:38 +0100 | [diff] [blame] | 47 | type: basicAuth |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 48 | externalSecret: '{{ tpl (default "" .Values.db.externalSecret) . }}' |
| 49 | login: '{{ .Values.db.user }}' |
| 50 | password: '{{ .Values.db.password }}' |
| 51 | - uid: '{{ include "common.mariadb.secret.backupCredentialsUID" . }}' |
| 52 | type: basicAuth |
| 53 | externalSecret: '{{ tpl (default "" .Values.galera.mariabackup.externalSecret) . }}' |
| 54 | login: '{{ .Values.galera.mariabackup.user }}' |
| 55 | password: '{{ .Values.galera.mariabackup.password }}' |
Krzysztof Opasiak | 01c975b | 2019-12-16 17:42:38 +0100 | [diff] [blame] | 56 | |
Andreas Geissler | cfd8434 | 2023-08-16 17:18:49 +0200 | [diff] [blame] | 57 | mariadbOperator: |
| 58 | image: mariadb |
| 59 | appVersion: 11.1.2 |
Andreas Geissler | 7a24e5f | 2023-10-12 10:16:29 +0200 | [diff] [blame] | 60 | persistence: |
| 61 | #storageClassName: default |
| 62 | size: 3Gi |
Andreas Geissler | cfd8434 | 2023-08-16 17:18:49 +0200 | [diff] [blame] | 63 | galera: |
| 64 | enabled: true |
| 65 | agentImage: mariadb-operator/agent |
Andreas Geissler | 7a24e5f | 2023-10-12 10:16:29 +0200 | [diff] [blame] | 66 | agentVersion: v0.0.3 |
Andreas Geissler | cfd8434 | 2023-08-16 17:18:49 +0200 | [diff] [blame] | 67 | initImage: mariadb-operator/init |
Andreas Geissler | 7a24e5f | 2023-10-12 10:16:29 +0200 | [diff] [blame] | 68 | initVersion: v0.0.6 |
Andreas Geissler | cfd8434 | 2023-08-16 17:18:49 +0200 | [diff] [blame] | 69 | |
| 70 | ## String to partially override common.names.fullname template (will maintain the release name) |
| 71 | ## |
| 72 | nameOverride: mariadb-galera |
| 73 | |
| 74 | ## Custom db configuration |
| 75 | ## |
| 76 | db: |
| 77 | ## MariaDB username and password |
| 78 | ## Password is ignored if externalSecret is specified. |
| 79 | ## If not set, password will be "randomly" generated |
| 80 | ## ref: https://github.com/bitnami/bitnami-docker-mariadb-galera#creating-a-database-user-on-first-run |
| 81 | ## |
| 82 | user: my-user |
| 83 | # password: |
| 84 | # externalSecret: |
| 85 | ## Database to create |
| 86 | ## ref: https://github.com/bitnami/bitnami-docker-mariadb-galera#creating-a-database-on-first-run |
| 87 | ## |
| 88 | # name: my_database |
| 89 | |
| 90 | ## Desired number of cluster nodes |
| 91 | ## |
| 92 | replicaCount: 3 |
| 93 | |
| 94 | ## Additional pod annotations for MariaDB Galera pods |
| 95 | ## ref: https://kubernetes.io/docs/concepts/overview/working-with-objects/annotations/ |
| 96 | ## -> here required to enable mariadb-galera in istio |
| 97 | ## |
| 98 | podAnnotations: |
| 99 | # sidecar.istio.io/inject: "false" |
| 100 | traffic.sidecar.istio.io/excludeInboundPorts: "4444,4567,4568" |
| 101 | traffic.sidecar.istio.io/includeInboundPorts: '*' |
| 102 | traffic.sidecar.istio.io/excludeOutboundPorts: "4444,4567,4568" |
| 103 | |
| 104 | mariadbOpConfiguration: |- |
| 105 | [mysqld] |
| 106 | max_allowed_packet=256M |
| 107 | lower_case_table_names = 1 |
| 108 | |
| 109 | ## Character set |
| 110 | collation_server=utf8_unicode_ci |
| 111 | init_connect='SET NAMES utf8' |
| 112 | character_set_server=utf8 |
| 113 | |
| 114 | ## MyISAM |
| 115 | key_buffer_size=32M |
| 116 | myisam_recover_options=FORCE,BACKUP |
| 117 | |
| 118 | ## Safety |
| 119 | skip_host_cache |
| 120 | skip_name_resolve |
| 121 | max_allowed_packet=16M |
| 122 | max_connect_errors=1000000 |
| 123 | sql_mode=STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY |
| 124 | sysdate_is_now=1 |
| 125 | |
| 126 | ## Caches and Limits |
| 127 | tmp_table_size=32M |
| 128 | max_heap_table_size=32M |
| 129 | # Re-enabling as now works with Maria 10.1.2 |
| 130 | query_cache_type=1 |
| 131 | query_cache_limit=4M |
| 132 | query_cache_size=256M |
| 133 | max_connections=500 |
| 134 | thread_cache_size=50 |
| 135 | open_files_limit=65535 |
| 136 | table_definition_cache=4096 |
| 137 | table_open_cache=4096 |
| 138 | |
| 139 | ## InnoDB |
| 140 | innodb=FORCE |
| 141 | innodb_strict_mode=1 |
| 142 | # Mandatory per https://github.com/codership/documentation/issues/25 |
| 143 | innodb_autoinc_lock_mode=2 |
| 144 | # Per https://www.percona.com/blog/2006/08/04/innodb-double-write/ |
| 145 | innodb_doublewrite=1 |
| 146 | innodb_flush_method=O_DIRECT |
| 147 | innodb_log_files_in_group=2 |
| 148 | innodb_log_file_size=128M |
| 149 | innodb_flush_log_at_trx_commit=1 |
| 150 | innodb_file_per_table=1 |
| 151 | # 80% Memory is default reco. |
| 152 | # Need to re-evaluate when DB size grows |
| 153 | innodb_buffer_pool_size=2G |
| 154 | innodb_file_format=Barracuda |
| 155 | |
| 156 | ########################################################################################## |
| 157 | # !!! the following configuration entries are ignored, when mariadbOperator is enabled !!! |
| 158 | ########################################################################################## |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 159 | # bitnami image doesn't support well single quote in password |
| 160 | passwordStrengthOverride: basic |
Krzysztof Opasiak | 01c975b | 2019-12-16 17:42:38 +0100 | [diff] [blame] | 161 | |
Michal Jagiello | 4bc879a | 2022-04-20 12:58:42 +0000 | [diff] [blame] | 162 | image: bitnami/mariadb-galera:10.5.8 |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 163 | ## Specify a imagePullPolicy |
| 164 | ## Defaults to 'Always' if image tag is 'latest', else set to 'IfNotPresent' |
| 165 | ## ref: http://kubernetes.io/docs/user-guide/images/#pre-pulling-images |
| 166 | ## |
| 167 | pullPolicy: Always |
vitalied | 1e5876c | 2018-03-29 10:24:27 -0500 | [diff] [blame] | 168 | |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 169 | ## Set to true if you would like to see extra information on logs |
| 170 | ## It turns BASH debugging in minideb-extras-base |
| 171 | ## |
| 172 | debug: true |
vitalied | 1e5876c | 2018-03-29 10:24:27 -0500 | [diff] [blame] | 173 | |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 174 | ## Sometimes, especially when a lot of pods are created at the same time, |
| 175 | ## actions performed on the databases are tried to be done before actual start. |
| 176 | init_sleep_time: 5 |
vitalied | 1e5876c | 2018-03-29 10:24:27 -0500 | [diff] [blame] | 177 | |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 178 | ## Use an alternate scheduler, e.g. "stork". |
| 179 | ## ref: https://kubernetes.io/docs/tasks/administer-cluster/configure-multiple-schedulers/ |
| 180 | ## |
| 181 | # schedulerName: |
| 182 | |
| 183 | ## StatefulSet controller supports relax its ordering guarantees while preserving its uniqueness and identity guarantees. There are two valid pod management policies: OrderedReady and Parallel |
| 184 | ## ref: https://kubernetes.io/docs/tutorials/stateful-application/basic-stateful-set/#pod-management-policy |
| 185 | ## |
| 186 | podManagementPolicy: OrderedReady |
| 187 | |
| 188 | ## MariaDB Gallera K8s svc properties |
| 189 | ## |
| 190 | service: |
| 191 | ## Kubernetes service type and port number |
| 192 | ## |
| 193 | type: ClusterIP |
| 194 | headless: {} |
Mahmoud Abdelhamid | dfa07dd | 2021-06-15 16:43:02 +0200 | [diff] [blame] | 195 | internalPort: &dbPort 3306 |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 196 | ports: |
Andreas Geissler | ba1200c | 2022-04-07 17:02:59 +0200 | [diff] [blame] | 197 | - name: tcp-mysql |
Mahmoud Abdelhamid | dfa07dd | 2021-06-15 16:43:02 +0200 | [diff] [blame] | 198 | port: *dbPort |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 199 | headlessPorts: |
Andreas Geissler | ba1200c | 2022-04-07 17:02:59 +0200 | [diff] [blame] | 200 | - name: tcp-galera |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 201 | port: 4567 |
Andreas Geissler | ba1200c | 2022-04-07 17:02:59 +0200 | [diff] [blame] | 202 | - name: tcp-ist |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 203 | port: 4568 |
Andreas Geissler | ba1200c | 2022-04-07 17:02:59 +0200 | [diff] [blame] | 204 | - name: tcp-sst |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 205 | port: 4444 |
| 206 | |
| 207 | |
| 208 | ## Pods Service Account |
| 209 | ## ref: https://kubernetes.io/docs/tasks/configure-pod-container/configure-service-account/ |
| 210 | ## |
| 211 | serviceAccount: |
| 212 | nameOverride: mariadb-galera |
| 213 | roles: |
| 214 | - read |
| 215 | |
| 216 | ## Pod Security Context |
| 217 | ## ref: https://kubernetes.io/docs/tasks/configure-pod-container/security-context/ |
| 218 | ## |
| 219 | securityContext: |
| 220 | enabled: true |
| 221 | user_id: 10001 |
| 222 | group_id: 10001 |
| 223 | |
| 224 | ## Database credentials for root (admin) user |
| 225 | ## |
| 226 | rootUser: |
| 227 | ## MariaDB admin user |
| 228 | user: root |
| 229 | ## MariaDB admin password |
| 230 | ## Password is ignored if externalSecret is specified. |
| 231 | ## If not set, password will be "randomly" generated |
| 232 | ## ref: https://github.com/bitnami/bitnami-docker-mariadb-galera#setting-the-root-password-on-first-run |
| 233 | ## |
| 234 | # password: |
| 235 | # externalSecret: |
| 236 | |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 237 | ## Galera configuration |
| 238 | ## |
| 239 | galera: |
| 240 | ## Galera cluster name |
| 241 | ## |
| 242 | name: galera |
| 243 | |
| 244 | ## Bootstraping options |
| 245 | ## ref: https://github.com/bitnami/bitnami-docker-mariadb-galera#bootstraping |
| 246 | bootstrap: |
| 247 | ## Node to bootstrap from, you will need to change this parameter incase you want to bootstrap from other node |
| 248 | ## |
| 249 | bootstrapFromNode: |
| 250 | ## Force safe_to_bootstrap in grastate.date file. |
| 251 | ## This will set safe_to_bootstrap=1 in the node indicated by bootstrapFromNode. |
| 252 | forceSafeToBootstrap: false |
| 253 | |
| 254 | ## Credentials to perform backups |
| 255 | ## |
| 256 | mariabackup: |
| 257 | ## MariaBackup username and password |
| 258 | ## Password is ignored if externalSecret is specified. |
| 259 | ## If not set, password will be "randomly" generated |
| 260 | ## ref: https://github.com/bitnami/bitnami-docker-mariadb-galera#setting-up-a-multi-master-cluster |
| 261 | ## |
| 262 | user: mariabackup |
| 263 | # password: |
| 264 | # externalSecret: |
| 265 | |
Jozsef Csongvai | cabbb6f | 2022-03-04 15:58:31 -0500 | [diff] [blame] | 266 | ## The backup job will mount the mariadb data pvc in order to run mariabackup. |
| 267 | ## For this reason the db data pvc needs to have accessMode: ReadWriteMany. |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 268 | backup: |
| 269 | enabled: false |
Andreas Geissler | 829f11c | 2024-01-12 12:19:03 +0100 | [diff] [blame] | 270 | # used in the mariadb-operator to override the backup name (default is DBName) |
| 271 | # nameOverride: |
| 272 | # defines the backup job execution period |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 273 | cron: "00 00 * * *" |
Andreas Geissler | 829f11c | 2024-01-12 12:19:03 +0100 | [diff] [blame] | 274 | # used by mariadb-operator to set the max retention time |
| 275 | maxRetention: 720h |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 276 | retentionPeriod: 3 |
Andreas Geissler | 829f11c | 2024-01-12 12:19:03 +0100 | [diff] [blame] | 277 | # used by mariadb-operator to set the backup storage type (PVC, S3, volume) |
| 278 | storageType: PVC |
| 279 | # configuration used for PVC backup storage |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 280 | persistence: |
| 281 | ## If true, use a Persistent Volume Claim, If false, use emptyDir |
| 282 | ## |
| 283 | enabled: true |
| 284 | # Enable persistence using an existing PVC |
| 285 | # existingClaim: |
| 286 | ## selector can be used to match an existing PersistentVolume |
| 287 | ## selector: |
| 288 | ## matchLabels: |
| 289 | ## app: my-app |
| 290 | selector: {} |
| 291 | ## Persistent Volume Storage Class |
| 292 | ## If defined, storageClassName: <storageClass> |
| 293 | ## If set to "-", storageClassName: "", which disables dynamic provisioning |
| 294 | ## If undefined (the default) or set to null, no storageClassName spec is |
| 295 | ## set, choosing the default provisioner. (gp2 on AWS, standard on |
| 296 | ## GKE, AWS & OpenStack) |
| 297 | ## |
| 298 | # storageClass: "-" |
| 299 | ## Persistent Volume Claim annotations |
| 300 | ## |
| 301 | annotations: |
| 302 | ## Persistent Volume Access Mode |
| 303 | ## |
| 304 | accessMode: ReadWriteOnce |
| 305 | ## Persistent Volume size |
| 306 | ## |
| 307 | size: 2Gi |
Andreas Geissler | 829f11c | 2024-01-12 12:19:03 +0100 | [diff] [blame] | 308 | # requires mariadb-operator v0.24.0 |
| 309 | # configuration used for S3 backup storage |
| 310 | # see: https://github.com/mariadb-operator/mariadb-operator/blob/main/docs/BACKUP.md |
| 311 | s3: |
| 312 | bucket: backups |
| 313 | endpoint: minio.minio.svc.cluster.local:9000 |
| 314 | #region: us-east-1 |
| 315 | accessKeyIdSecretKeyRef: |
| 316 | name: minio |
| 317 | key: access-key-id |
| 318 | secretAccessKeySecretKeyRef: |
| 319 | name: minio |
| 320 | key: secret-access-key |
| 321 | tls: |
| 322 | enabled: false |
| 323 | caSecretKeyRef: |
| 324 | name: minio-ca |
| 325 | key: ca.crt |
| 326 | # configuration used for kubernetes volumes as backup storage |
| 327 | # see: https://github.com/mariadb-operator/mariadb-operator/blob/main/docs/BACKUP.md |
| 328 | volume: {} |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 329 | |
| 330 | readinessCheck: |
| 331 | wait_for: |
Andreas Geissler | cfd8434 | 2023-08-16 17:18:49 +0200 | [diff] [blame] | 332 | apps: |
| 333 | - '{{ include "common.name" . }}' |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 334 | |
| 335 | ## TLS configuration |
| 336 | ## |
| 337 | tls: |
| 338 | ## Enable TLS |
| 339 | ## |
| 340 | enabled: false |
| 341 | ## Name of the secret that contains the certificates |
| 342 | ## |
| 343 | # certificatesSecret: |
| 344 | ## Certificate filename |
| 345 | ## |
| 346 | # certFilename: |
| 347 | ## Certificate Key filename |
| 348 | ## |
| 349 | # certKeyFilename: |
| 350 | ## CA Certificate filename |
| 351 | ## |
| 352 | # certCAFilename: |
| 353 | |
| 354 | ## Configure MariaDB with a custom my.cnf file |
| 355 | ## ref: https://mysql.com/kb/en/mysql/configuring-mysql-with-mycnf/#example-of-configuration-file |
| 356 | ## Alternatively, you can put your my.cnf under the files/ directory |
| 357 | ## |
| 358 | mariadbConfiguration: |- |
| 359 | [client] |
| 360 | port=3306 |
| 361 | socket=/opt/bitnami/mariadb/tmp/mysql.sock |
| 362 | plugin_dir=/opt/bitnami/mariadb/plugin |
| 363 | |
| 364 | [mysqld] |
| 365 | lower_case_table_names = 1 |
| 366 | default_storage_engine=InnoDB |
| 367 | basedir=/opt/bitnami/mariadb |
| 368 | datadir=/bitnami/mariadb/data |
| 369 | plugin_dir=/opt/bitnami/mariadb/plugin |
| 370 | tmpdir=/opt/bitnami/mariadb/tmp |
| 371 | socket=/opt/bitnami/mariadb/tmp/mysql.sock |
| 372 | pid_file=/opt/bitnami/mariadb/tmp/mysqld.pid |
| 373 | bind_address=0.0.0.0 |
| 374 | |
| 375 | ## Character set |
| 376 | collation_server=utf8_unicode_ci |
| 377 | init_connect='SET NAMES utf8' |
| 378 | character_set_server=utf8 |
| 379 | |
| 380 | ## MyISAM |
| 381 | key_buffer_size=32M |
| 382 | myisam_recover_options=FORCE,BACKUP |
| 383 | |
| 384 | ## Safety |
| 385 | skip_host_cache |
| 386 | skip_name_resolve |
| 387 | max_allowed_packet=16M |
| 388 | max_connect_errors=1000000 |
| 389 | sql_mode=STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY |
| 390 | sysdate_is_now=1 |
| 391 | |
| 392 | ## Binary Logging |
| 393 | log_bin=mysql-bin |
| 394 | expire_logs_days=14 |
| 395 | # Disabling for performance per http://severalnines.com/blog/9-tips-going-production-galera-cluster-mysql |
| 396 | sync_binlog=0 |
| 397 | # Required for Galera |
| 398 | binlog_format=row |
| 399 | |
| 400 | ## Caches and Limits |
| 401 | tmp_table_size=32M |
| 402 | max_heap_table_size=32M |
| 403 | # Re-enabling as now works with Maria 10.1.2 |
| 404 | query_cache_type=1 |
| 405 | query_cache_limit=4M |
| 406 | query_cache_size=256M |
| 407 | max_connections=500 |
| 408 | thread_cache_size=50 |
| 409 | open_files_limit=65535 |
| 410 | table_definition_cache=4096 |
| 411 | table_open_cache=4096 |
| 412 | |
| 413 | ## InnoDB |
| 414 | innodb=FORCE |
| 415 | innodb_strict_mode=1 |
| 416 | # Mandatory per https://github.com/codership/documentation/issues/25 |
| 417 | innodb_autoinc_lock_mode=2 |
| 418 | # Per https://www.percona.com/blog/2006/08/04/innodb-double-write/ |
| 419 | innodb_doublewrite=1 |
| 420 | innodb_flush_method=O_DIRECT |
| 421 | innodb_log_files_in_group=2 |
| 422 | innodb_log_file_size=128M |
| 423 | innodb_flush_log_at_trx_commit=1 |
| 424 | innodb_file_per_table=1 |
| 425 | # 80% Memory is default reco. |
| 426 | # Need to re-evaluate when DB size grows |
| 427 | innodb_buffer_pool_size=2G |
| 428 | innodb_file_format=Barracuda |
| 429 | |
| 430 | ## Logging |
| 431 | log_error=/opt/bitnami/mariadb/logs/mysqld.log |
| 432 | slow_query_log_file=/opt/bitnami/mariadb/logs/mysqld.log |
| 433 | log_queries_not_using_indexes=1 |
| 434 | slow_query_log=1 |
| 435 | |
| 436 | ## SSL |
| 437 | ## Use extraVolumes and extraVolumeMounts to mount /certs filesystem |
| 438 | # ssl_ca=/certs/ca.pem |
| 439 | # ssl_cert=/certs/server-cert.pem |
| 440 | # ssl_key=/certs/server-key.pem |
| 441 | |
| 442 | [galera] |
| 443 | wsrep_on=ON |
| 444 | wsrep_provider=/opt/bitnami/mariadb/lib/libgalera_smm.so |
| 445 | wsrep_sst_method=mariabackup |
| 446 | wsrep_slave_threads=4 |
| 447 | wsrep_cluster_address=gcomm:// |
| 448 | wsrep_cluster_name=galera |
| 449 | wsrep_sst_auth="root:" |
| 450 | # Enabled for performance per https://mariadb.com/kb/en/innodb-system-variables/#innodb_flush_log_at_trx_commit |
| 451 | innodb_flush_log_at_trx_commit=2 |
| 452 | # MYISAM REPLICATION SUPPORT # |
| 453 | wsrep_replicate_myisam=ON |
Sylvain Desbureaux | 7d3ddcd | 2021-04-22 17:18:11 +0200 | [diff] [blame] | 454 | binlog_format=row |
| 455 | default_storage_engine=InnoDB |
| 456 | innodb_autoinc_lock_mode=2 |
| 457 | transaction-isolation=READ-COMMITTED |
| 458 | wsrep_causal_reads=1 |
| 459 | wsrep_sync_wait=7 |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 460 | |
| 461 | [mariadb] |
| 462 | plugin_load_add=auth_pam |
| 463 | |
| 464 | ## Data-at-Rest Encryption |
| 465 | ## Use extraVolumes and extraVolumeMounts to mount /encryption filesystem |
| 466 | # plugin_load_add=file_key_management |
| 467 | # file_key_management_filename=/encryption/keyfile.enc |
| 468 | # file_key_management_filekey=FILE:/encryption/keyfile.key |
| 469 | # file_key_management_encryption_algorithm=AES_CTR |
| 470 | # encrypt_binlog=ON |
| 471 | # encrypt_tmp_files=ON |
| 472 | |
| 473 | ## InnoDB/XtraDB Encryption |
| 474 | # innodb_encrypt_tables=ON |
| 475 | # innodb_encrypt_temporary_tables=ON |
| 476 | # innodb_encrypt_log=ON |
| 477 | # innodb_encryption_threads=4 |
| 478 | # innodb_encryption_rotate_key_age=1 |
| 479 | |
| 480 | ## Aria Encryption |
| 481 | # aria_encrypt_tables=ON |
| 482 | # encrypt_tmp_disk_tables=ON |
| 483 | |
| 484 | ## MariaDB additional command line flags |
| 485 | ## Can be used to specify command line flags, for example: |
| 486 | ## |
| 487 | ## extraFlags: "--max-connect-errors=1000 --max_connections=155" |
| 488 | |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 489 | ## updateStrategy for MariaDB Master StatefulSet |
| 490 | ## ref: https://kubernetes.io/docs/concepts/workloads/controllers/statefulset/#update-strategies |
| 491 | ## |
| 492 | updateStrategy: |
| 493 | type: RollingUpdate |
vitalied | 1e5876c | 2018-03-29 10:24:27 -0500 | [diff] [blame] | 494 | |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 495 | ## Pod affinity preset |
| 496 | ## ref: https://kubernetes.io/docs/concepts/scheduling-eviction/assign-pod-node/#inter-pod-affinity-and-anti-affinity |
| 497 | ## Allowed values: soft, hard |
| 498 | ## |
| 499 | podAffinityPreset: "" |
| 500 | |
| 501 | ## Pod anti-affinity preset |
| 502 | ## Ref: https://kubernetes.io/docs/concepts/scheduling-eviction/assign-pod-node/#inter-pod-affinity-and-anti-affinity |
| 503 | ## Allowed values: soft, hard |
| 504 | ## |
| 505 | podAntiAffinityPreset: soft |
| 506 | |
| 507 | ## Node affinity preset |
| 508 | ## Ref: https://kubernetes.io/docs/concepts/scheduling-eviction/assign-pod-node/#node-affinity |
| 509 | ## Allowed values: soft, hard |
| 510 | ## |
| 511 | nodeAffinityPreset: |
| 512 | ## Node affinity type |
| 513 | ## Allowed values: soft, hard |
| 514 | type: "" |
| 515 | ## Node label key to match |
| 516 | ## E.g. |
| 517 | ## key: "kubernetes.io/e2e-az-name" |
| 518 | ## |
| 519 | key: "" |
| 520 | ## Node label values to match |
| 521 | ## E.g. |
| 522 | ## values: |
| 523 | ## - e2e-az1 |
| 524 | ## - e2e-az2 |
| 525 | ## |
| 526 | values: [] |
| 527 | |
| 528 | ## Affinity for pod assignment. Evaluated as a template. |
| 529 | ## Ref: https://kubernetes.io/docs/concepts/configuration/assign-pod-node/#affinity-and-anti-affinity |
| 530 | ## Note: podAffinityPreset, podAntiAffinityPreset, and nodeAffinityPreset will be ignored when it's set |
| 531 | ## |
vitalied | 1e5876c | 2018-03-29 10:24:27 -0500 | [diff] [blame] | 532 | affinity: {} |
| 533 | |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 534 | ## Node labels for pod assignment. Evaluated as a template. |
| 535 | ## ref: https://kubernetes.io/docs/user-guide/node-selection/ |
| 536 | ## |
| 537 | nodeSelector: {} |
vitalied | 1e5876c | 2018-03-29 10:24:27 -0500 | [diff] [blame] | 538 | |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 539 | ## Tolerations for pod assignment. Evaluated as a template. |
| 540 | ## ref: https://kubernetes.io/docs/concepts/configuration/taint-and-toleration/ |
| 541 | ## |
| 542 | tolerations: [] |
vitalied | 1e5876c | 2018-03-29 10:24:27 -0500 | [diff] [blame] | 543 | |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 544 | ## Enable persistence using Persistent Volume Claims |
| 545 | ## ref: http://kubernetes.io/docs/user-guide/persistent-volumes/ |
| 546 | ## |
vitalied | 1e5876c | 2018-03-29 10:24:27 -0500 | [diff] [blame] | 547 | persistence: |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 548 | ## If true, use a Persistent Volume Claim, If false, use emptyDir |
| 549 | ## |
| 550 | enabled: true |
| 551 | # Enable persistence using an existing PVC |
vitalied | 1e5876c | 2018-03-29 10:24:27 -0500 | [diff] [blame] | 552 | # existingClaim: |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 553 | mountPath: /dockerdata-nfs |
| 554 | mountSubPath: "mariadb-galera/data" |
| 555 | ## selector can be used to match an existing PersistentVolume |
| 556 | ## selector: |
| 557 | ## matchLabels: |
| 558 | ## app: my-app |
| 559 | selector: {} |
| 560 | ## Persistent Volume Storage Class |
vitalied | 1e5876c | 2018-03-29 10:24:27 -0500 | [diff] [blame] | 561 | ## If defined, storageClassName: <storageClass> |
| 562 | ## If set to "-", storageClassName: "", which disables dynamic provisioning |
| 563 | ## If undefined (the default) or set to null, no storageClassName spec is |
| 564 | ## set, choosing the default provisioner. (gp2 on AWS, standard on |
| 565 | ## GKE, AWS & OpenStack) |
| 566 | ## |
| 567 | # storageClass: "-" |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 568 | ## Persistent Volume Claim annotations |
| 569 | ## |
| 570 | annotations: |
| 571 | ## Persistent Volume Access Mode |
Jozsef Csongvai | cabbb6f | 2022-03-04 15:58:31 -0500 | [diff] [blame] | 572 | ## Use ReadWriteMany if backup is enabled, see backup section. |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 573 | ## |
Sylvain Desbureaux | 2285a28 | 2019-08-29 16:17:16 +0200 | [diff] [blame] | 574 | accessMode: ReadWriteOnce |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 575 | ## Persistent Volume size |
| 576 | ## |
Michal Jagiello | b15bf67 | 2022-04-07 06:45:50 +0000 | [diff] [blame] | 577 | size: 3Gi |
vitalied | 1e5876c | 2018-03-29 10:24:27 -0500 | [diff] [blame] | 578 | |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 579 | ## Additional pod labels |
vitalied | 1e5876c | 2018-03-29 10:24:27 -0500 | [diff] [blame] | 580 | ## |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 581 | # podLabels: |
| 582 | # extraLabel: extraValue |
vitalied | 1e5876c | 2018-03-29 10:24:27 -0500 | [diff] [blame] | 583 | |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 584 | ## Priority Class Name |
| 585 | # |
| 586 | # priorityClassName: 'priorityClass' |
| 587 | |
| 588 | ## MariaDB Galera containers' resource requests and limits |
| 589 | ## ref: http://kubernetes.io/docs/user-guide/compute-resources/ |
| 590 | ## |
| 591 | flavor: small |
vitalied | 1e5876c | 2018-03-29 10:24:27 -0500 | [diff] [blame] | 592 | resources: |
Sylvain Desbureaux | ff702c7 | 2018-11-23 14:25:57 +0100 | [diff] [blame] | 593 | small: |
| 594 | limits: |
Andreas Geissler | 4753743 | 2024-02-27 08:55:23 +0100 | [diff] [blame] | 595 | cpu: "1" |
| 596 | memory: "4Gi" |
Sylvain Desbureaux | ff702c7 | 2018-11-23 14:25:57 +0100 | [diff] [blame] | 597 | requests: |
Andreas Geissler | 4753743 | 2024-02-27 08:55:23 +0100 | [diff] [blame] | 598 | cpu: "500m" |
| 599 | memory: "2Gi" |
Sylvain Desbureaux | ff702c7 | 2018-11-23 14:25:57 +0100 | [diff] [blame] | 600 | large: |
| 601 | limits: |
Andreas Geissler | 4753743 | 2024-02-27 08:55:23 +0100 | [diff] [blame] | 602 | cpu: "2" |
| 603 | memory: "6Gi" |
Sylvain Desbureaux | ff702c7 | 2018-11-23 14:25:57 +0100 | [diff] [blame] | 604 | requests: |
Andreas Geissler | 4753743 | 2024-02-27 08:55:23 +0100 | [diff] [blame] | 605 | cpu: "1" |
| 606 | memory: "3Gi" |
Sylvain Desbureaux | ff702c7 | 2018-11-23 14:25:57 +0100 | [diff] [blame] | 607 | unlimited: {} |
vitalied | 1e5876c | 2018-03-29 10:24:27 -0500 | [diff] [blame] | 608 | |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 609 | ## MariaDB Galera containers' liveness and readiness probes |
| 610 | ## ref: https://kubernetes.io/docs/concepts/workloads/pods/pod-lifecycle/#container-probes |
| 611 | ## |
| 612 | livenessProbe: |
| 613 | enabled: true |
Sylvain Desbureaux | 7f09e76 | 2021-05-05 09:20:18 +0200 | [diff] [blame] | 614 | initialDelaySeconds: 1 |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 615 | periodSeconds: 10 |
Andreas Geissler | ba1200c | 2022-04-07 17:02:59 +0200 | [diff] [blame] | 616 | timeoutSeconds: 180 |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 617 | successThreshold: 1 |
| 618 | failureThreshold: 3 |
| 619 | readinessProbe: |
| 620 | enabled: true |
Sylvain Desbureaux | 7f09e76 | 2021-05-05 09:20:18 +0200 | [diff] [blame] | 621 | initialDelaySeconds: 1 |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 622 | periodSeconds: 10 |
Andreas Geissler | ba1200c | 2022-04-07 17:02:59 +0200 | [diff] [blame] | 623 | timeoutSeconds: 180 |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 624 | successThreshold: 1 |
| 625 | failureThreshold: 3 |
Sylvain Desbureaux | 7f09e76 | 2021-05-05 09:20:18 +0200 | [diff] [blame] | 626 | startupProbe: |
| 627 | ## Initializing the database could take some time |
| 628 | ## |
| 629 | enabled: true |
| 630 | initialDelaySeconds: 10 |
| 631 | periodSeconds: 10 |
Andreas Geissler | ba1200c | 2022-04-07 17:02:59 +0200 | [diff] [blame] | 632 | timeoutSeconds: 180 |
Sylvain Desbureaux | 7f09e76 | 2021-05-05 09:20:18 +0200 | [diff] [blame] | 633 | successThreshold: 1 |
| 634 | # will wait up for initialDelaySeconds + failureThreshold*periodSeconds before |
| 635 | # stating startup wasn't good (910s per default) |
| 636 | failureThreshold: 90 |
vitalied | 1e5876c | 2018-03-29 10:24:27 -0500 | [diff] [blame] | 637 | |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 638 | ## Pod disruption budget configuration |
| 639 | ## |
| 640 | podDisruptionBudget: |
| 641 | ## Specifies whether a Pod disruption budget should be created |
| 642 | ## |
| 643 | create: true |
| 644 | minAvailable: 1 |
| 645 | # maxUnavailable: 1 |
Akansha Dua | 3fb95ef | 2019-09-04 11:47:43 +0000 | [diff] [blame] | 646 | |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 647 | ## Prometheus exporter configuration |
| 648 | ## |
| 649 | metrics: |
| 650 | ## Bitnami MySQL Prometheus exporter image |
| 651 | ## ref: https://hub.docker.com/r/bitnami/mysqld-exporter/tags/ |
| 652 | ## |
| 653 | image: bitnami/mysqld-exporter:0.12.1-debian-10-r264 |
| 654 | pullPolicy: Always |
| 655 | ## MySQL exporter additional command line flags |
| 656 | ## Can be used to specify command line flags |
| 657 | ## E.g.: |
| 658 | ## extraFlags: |
| 659 | ## - --collect.binlog_size |
| 660 | ## |
| 661 | extraFlags: [] |
| 662 | ## MySQL Prometheus exporter containers' resource requests and limits |
| 663 | ## ref: http://kubernetes.io/docs/user-guide/compute-resources/ |
| 664 | ## |
| 665 | resources: |
| 666 | # We usually recommend not to specify default resources and to leave this as a conscious |
| 667 | # choice for the user. This also increases chances charts run on environments with little |
| 668 | # resources, such as Minikube. If you do want to specify resources, uncomment the following |
| 669 | # lines, adjust them as necessary, and remove the curly braces after 'resources:'. |
| 670 | limits: |
Andreas Geissler | 4753743 | 2024-02-27 08:55:23 +0100 | [diff] [blame] | 671 | cpu: "0.5" |
Andreas Geissler | 8cbb3d9 | 2024-03-12 16:44:56 +0100 | [diff] [blame] | 672 | memory: "200Mi" |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 673 | requests: |
Andreas Geissler | 4753743 | 2024-02-27 08:55:23 +0100 | [diff] [blame] | 674 | cpu: "0.5" |
Andreas Geissler | 8cbb3d9 | 2024-03-12 16:44:56 +0100 | [diff] [blame] | 675 | memory: "200Mi" |
a.sreekumar | cf3133d | 2021-09-10 14:41:30 +0100 | [diff] [blame] | 676 | ## MariaDB Galera metrics container's liveness and readiness probes |
| 677 | ## ref: https://kubernetes.io/docs/concepts/workloads/pods/pod-lifecycle/#container-probes |
| 678 | ## |
| 679 | livenessProbe: |
| 680 | enabled: true |
| 681 | initialDelaySeconds: 30 |
| 682 | periodSeconds: 10 |
| 683 | timeoutSeconds: 5 |
| 684 | successThreshold: 1 |
| 685 | failureThreshold: 3 |
| 686 | readinessProbe: |
| 687 | enabled: true |
| 688 | initialDelaySeconds: 5 |
| 689 | periodSeconds: 10 |
| 690 | timeoutSeconds: 5 |
| 691 | successThreshold: 1 |
| 692 | failureThreshold: 3 |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 693 | ## MySQL Prometheus exporter service parameters |
| 694 | ## |
| 695 | service: |
| 696 | type: ClusterIP |
| 697 | port: 9104 |
| 698 | annotations: |
| 699 | prometheus.io/scrape: "true" |
| 700 | prometheus.io/port: "9104" |
| 701 | |
| 702 | ## Prometheus Operator ServiceMonitor configuration |
| 703 | ## |
| 704 | serviceMonitor: |
| 705 | enabled: false |
| 706 | ## Namespace in which Prometheus is running |
| 707 | ## |
| 708 | # namespace: monitoring |
| 709 | |
| 710 | ## Interval at which metrics should be scraped. |
| 711 | ## ref: https://github.com/coreos/prometheus-operator/blob/master/Documentation/api.md#endpoint |
| 712 | ## |
| 713 | # interval: 10s |
| 714 | |
| 715 | ## Timeout after which the scrape is ended |
| 716 | ## ref: https://github.com/coreos/prometheus-operator/blob/master/Documentation/api.md#endpoint |
| 717 | ## |
| 718 | # scrapeTimeout: 10s |
| 719 | |
| 720 | ## ServiceMonitor selector labels |
| 721 | ## ref: https://github.com/bitnami/charts/tree/master/bitnami/prometheus-operator#prometheus-configuration |
| 722 | ## |
Bartek Grzybowski | a9d2af7 | 2022-02-04 14:19:51 +0100 | [diff] [blame] | 723 | # selector: |
| 724 | # prometheus: kube-prometheus |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 725 | |
| 726 | ## RelabelConfigs to apply to samples before scraping |
| 727 | ## ref: https://github.com/coreos/prometheus-operator/blob/master/Documentation/api.md#relabelconfig |
| 728 | ## Value is evalued as a template |
| 729 | ## |
| 730 | relabelings: [] |
| 731 | |
| 732 | ## MetricRelabelConfigs to apply to samples before ingestion |
| 733 | ## ref: https://github.com/coreos/prometheus-operator/blob/master/Documentation/api.md#relabelconfig |
| 734 | ## Value is evalued as a template |
| 735 | ## |
| 736 | metricRelabelings: [] |
| 737 | # - sourceLabels: |
| 738 | # - "__name__" |
| 739 | # targetLabel: "__name__" |
| 740 | # action: replace |
| 741 | # regex: '(.*)' |
| 742 | # replacement: 'example_prefix_$1' |
| 743 | |
| 744 | ## Prometheus Operator PrometheusRule configuration |
| 745 | ## |
| 746 | prometheusRules: |
| 747 | enabled: false |
| 748 | |
| 749 | ## Additional labels to add to the PrometheusRule so it is picked up by the operator. |
| 750 | ## If using the [Helm Chart](https://github.com/helm/charts/tree/master/stable/prometheus-operator) this is the name of the Helm release and 'app: prometheus-operator' |
| 751 | selector: |
| 752 | app: prometheus-operator |
| 753 | release: prometheus |
| 754 | |
| 755 | ## Rules as a map. |
Andreas Geissler | ba1200c | 2022-04-07 17:02:59 +0200 | [diff] [blame] | 756 | rules: [] |
Sylvain Desbureaux | 93a5b49 | 2020-11-27 11:07:42 +0100 | [diff] [blame] | 757 | # - alert: MariaDB-Down |
| 758 | # annotations: |
| 759 | # message: 'MariaDB instance {{ $labels.instance }} is down' |
| 760 | # summary: MariaDB instance is down |
| 761 | # expr: absent(up{job="mariadb-galera"} == 1) |
| 762 | # labels: |
| 763 | # severity: warning |
| 764 | # service: mariadb-galera |
| 765 | # for: 5m |