Ever since MariaDB exists, I really like to install and test the performance but time consume for my daily work stopped me to try MariaDB, today I plan to update my MySQL server that serve lot of data in and out to MariaDB 10.0 (today latest version :P )
So there's a few step that should be considered before we can proceed further.
1. BACKUP
- Always backup your data at the first place.
- Save it to the proper place so that if anything goes wrong, you can export back your data.
mysqldump -u root -pYOURPASSWORD --all-databases > allbackup.sql &
If you don't want to wait and you know that the current database is big, just put the process at the background so that you can monitor the process using top :)
- Backup your current configuration files
cp /etc/my.cnf /tmp/my.cnf.bak
2. Let's go
If you're installing mysql from webtatic and made a replacing package name , you may encountered an error like
Error: mysql55w conflicts with MariaDB-server-5.5.41-1.el6.i686
Error: mysql55w-libs conflicts with MariaDB-compat-5.5.41-1.el6.i686
You can try my work around :
yum replace mysql55w-libs --replace-with mysql-libs
Proceed with the step below :
https://mariadb.com/blog/upgrading-mysql-51-mariadb-100-centos-6
So there's a few step that should be considered before we can proceed further.
1. BACKUP
- Always backup your data at the first place.
- Save it to the proper place so that if anything goes wrong, you can export back your data.
mysqldump -u root -pYOURPASSWORD --all-databases > allbackup.sql &
If you don't want to wait and you know that the current database is big, just put the process at the background so that you can monitor the process using top :)
- Backup your current configuration files
cp /etc/my.cnf /tmp/my.cnf.bak
2. Let's go
If you're installing mysql from webtatic and made a replacing package name , you may encountered an error like
Error: mysql55w conflicts with MariaDB-server-5.5.41-1.el6.i686
Error: mysql55w-libs conflicts with MariaDB-compat-5.5.41-1.el6.i686
You can try my work around :
yum replace mysql55w-libs --replace-with mysql-libs
Proceed with the step below :
https://mariadb.com/blog/upgrading-mysql-51-mariadb-100-centos-6
Comments