Recommended ways to upgrade MySQL to MariaDB

[ccto]

Hello Everyone,

May I know -

Q1) What is the recommended ways to upgrade MySQL 5.5 x64 to MariaDB 10.1 x64?

(Shall I copy /var/lib/mysql/ to MariaDB 5.5 db host first, then ./build set mariadb 10.0; ./build mariadb ; then ./build set mariadb 10.1; ./build mariadb )

Q2) Similarly, what is the recommended ways to upgrade MySQL 5.6 x64 to MariaDB 10.1 x64?

Q3) Is MariaDB 10.0 similar to MySQL 5.6?

Q4) Is MariaDB 10.1 similar to MySQL 5.7?

Thank you very much for your information.

Regards
George

 

[Petertjuh360]

1. Create a copy/backup of /var/lib/mysql
2. Edit /usr/local/directadmin/custombuild/options.conf and set the mariadb version you want to use.
3. Run /usr/local/directadmin/custombuild/build mariadb
4. You're done!

 

[Nexxterra.com]

What are the pros/cons of doing this?
Will mysql compatibility issues with scripts occur?

 

[zEitEr]

Hello,

Commonly there is no much difference for PHP scripts. MariaDB is the default with CentOS 7.

More reading: https://mariadb.com/kb/ru/mariadb-vs-mysql-features/

 

[janw.oostendorp]

If I use these steps do I need to recreate/import the databases? Or will it automatically import/work with my existing databases?

 

[zEitEr]

Custombuild will take care of the existing databases, so no need to do import/export of them.

 

[wattie]

Q3 and Q4 - most of the things are compatible. But the only fully compatible versions are MySQL 5.5 and MariaDB 5.5. All newer features are not 100% the same and not 100% compatible. You can count them as different projects from MySQL 5.6 and MariaDB 10