diff options
author | Adam Monsen <haircut@gmail.com> | 2022-09-06 09:45:45 -0700 |
---|---|---|
committer | GitHub <noreply@github.com> | 2022-09-06 16:45:45 +0000 |
commit | 2a5bc6f3bb3b26b4fc51e7c7bf6d7f9d2c2172f3 (patch) | |
tree | 6e390120617fc2026f66b78077018613419d8258 /.examples | |
parent | 338b483247502df9be2b5e23b8a1bbaf8c678adc (diff) |
enable mariadb auto upgrade (#1814)
* enable mariadb auto upgrade
This fixes after-upgrade issues, for example:
[ERROR] Incorrect definition of table mysql.event: expected column 'definer' at position 3 to have type varchar(, found type char(141).
The upgrade only happens when necessary.
I also disabled the system database backup because I assume users create
and test their own backups.
Signed-off-by: Adam Monsen <haircut@gmail.com>
* use 1s instead of "yesplease"
Any nonzero value is valid for these environment variables.
Signed-off-by: Adam Monsen <haircut@gmail.com>
Signed-off-by: Adam Monsen <haircut@gmail.com>
Diffstat (limited to '.examples')
4 files changed, 8 insertions, 0 deletions
diff --git a/.examples/docker-compose/insecure/mariadb/apache/docker-compose.yml b/.examples/docker-compose/insecure/mariadb/apache/docker-compose.yml index 70ed73bb..d5e30393 100644 --- a/.examples/docker-compose/insecure/mariadb/apache/docker-compose.yml +++ b/.examples/docker-compose/insecure/mariadb/apache/docker-compose.yml @@ -9,6 +9,8 @@ services: - db:/var/lib/mysql environment: - MYSQL_ROOT_PASSWORD= + - MARIADB_AUTO_UPGRADE=1 + - MARIADB_DISABLE_UPGRADE_BACKUP=1 env_file: - db.env diff --git a/.examples/docker-compose/insecure/mariadb/fpm/docker-compose.yml b/.examples/docker-compose/insecure/mariadb/fpm/docker-compose.yml index 44c79485..c3c94f39 100644 --- a/.examples/docker-compose/insecure/mariadb/fpm/docker-compose.yml +++ b/.examples/docker-compose/insecure/mariadb/fpm/docker-compose.yml @@ -9,6 +9,8 @@ services: - db:/var/lib/mysql environment: - MYSQL_ROOT_PASSWORD= + - MARIADB_AUTO_UPGRADE=1 + - MARIADB_DISABLE_UPGRADE_BACKUP=1 env_file: - db.env diff --git a/.examples/docker-compose/with-nginx-proxy/mariadb/apache/docker-compose.yml b/.examples/docker-compose/with-nginx-proxy/mariadb/apache/docker-compose.yml index 84e91a41..eaf18678 100644 --- a/.examples/docker-compose/with-nginx-proxy/mariadb/apache/docker-compose.yml +++ b/.examples/docker-compose/with-nginx-proxy/mariadb/apache/docker-compose.yml @@ -9,6 +9,8 @@ services: - db:/var/lib/mysql environment: - MYSQL_ROOT_PASSWORD= + - MARIADB_AUTO_UPGRADE=1 + - MARIADB_DISABLE_UPGRADE_BACKUP=1 env_file: - db.env diff --git a/.examples/docker-compose/with-nginx-proxy/mariadb/fpm/docker-compose.yml b/.examples/docker-compose/with-nginx-proxy/mariadb/fpm/docker-compose.yml index 33b3d92b..80088993 100644 --- a/.examples/docker-compose/with-nginx-proxy/mariadb/fpm/docker-compose.yml +++ b/.examples/docker-compose/with-nginx-proxy/mariadb/fpm/docker-compose.yml @@ -9,6 +9,8 @@ services: - db:/var/lib/mysql environment: - MYSQL_ROOT_PASSWORD= + - MARIADB_AUTO_UPGRADE=1 + - MARIADB_DISABLE_UPGRADE_BACKUP=1 env_file: - db.env |