kiwitcms / Kiwi / 5530

76%

master: 77%

push

travis-ci

docker-compose: Upgrade from MariaDB 5.5 to MariaDB 10.3

NOTE: we're upgrading b/c all of the new migrations introduce
schema altering operations which fail on older versions of
MariaDB!

WARNING:

kiwi_db_data volume mount dir changed from `/var/lib/mysql' to
`/var/lib/mysql/data' b/c the latest version of MariaDB uses
a different datadir setting!

DOCS:
https://mariadb.com/kb/en/upgrading/
https://mariadb.com/kb/en/upgrading-from-mariadb-55-to-mariadb-100/

HOW TO UPGRADE:

WARNING: upgrade your database BEFORE upgrading to Kiwi TCMS 8.0 !!!

1) Backup existing database with:

   docker exec -it kiwi_db mysqldump -u kiwi -pYourPass kiwi > backup.sql

2) docker-compose down
3) docker volume rm kiwi_db_data

   will remove existing data volume b/c of incompatibilities between
   different MariaDB versions

4) docker-compose up

   will recreate data volume with missing data. e.g. manage.py showmigrations
   will tell you that 0 migrations have been applied.

5) Restore the data from backup:

   cat backup.sql | docker exec -u 0 -i kiwi_db /opt/rh/rh-mariadb103/root/usr/bin/mysql kiwi

   note: this connects to the database as the root user

6) Proceed to upgrade your Kiwi TCMS container !

697 of 1146 branches covered (60.82%)

Branch coverage included in aggregate %.

3652 of 4591 relevant lines covered (79.55%)

0.8 hits per line