MariaDB upgrade to v10¶
The purpose of this spec is to upgrade MariaDB from v5.5 to v10.0
MariaDB + Galera is presently using v5.5 which is old and should be upgraded. Additionally, we are using xtrabackup v1 which was deprecated in favor of xtrabackup v2 as such that should be changed as we upgrade to v10 so that we can take advantage of the performance and security enhancement available in the new releases.
Upgrade MariaDB - this is a package change as well as upstream mariadb repo change
Change xtrabackup to xtrabackup-v2 - This will add a configuration section in the default
my.cnffor the xtrabackup client(s).
Leave everything the way it is.
There will be no playbook impact however the The galera_server and galera_client roles will change to support the new packages for xtrabackup-v2 and mariadb+galera v10.
Upgrading to MariaDB v10 w/ xtrabackup v2 will result OSAD being able to take advantage of better security options in the future if we so choose.
Upgrading to MariaDB v10 w/ xtrabackup v2 will result in greater performance.
End user impact¶
The deployer will need to be aware that mariadb v5.5 is being upgraded however all of the post upgrade processes should be handled automatically.
SPEC/Limit the distribution of .my.cnf - https://review.openstack.org/#/c/203754/
Primary assignee: (unassigned)
Change the package for MariaDB10 w/ Galera
Add repo for new versions of XtraBackup
Update the my.cnf for use with MariaDB10 (revise it for anything that may need to be removed)
Update the cluster.cnf for use with MariaDB10 (revise it for anything that may need to be removed)
The testing for this change will be automatic in upstream as everybuild will change to using this by default.