diff options
| author | Adam Monsen <haircut@gmail.com> | 2022-09-06 19:45:45 +0300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2022-09-06 19:45:45 +0300 |
| commit | 2a5bc6f3bb3b26b4fc51e7c7bf6d7f9d2c2172f3 (patch) | |
| tree | 6e390120617fc2026f66b78077018613419d8258 | |
| 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>
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 70ed73b..d5e3039 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 44c7948..c3c94f3 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 84e91a4..eaf1867 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 33b3d92..8008899 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 |