Using mariadb instead of mysql 5.6

[servan12 0]

I want to use mariadb instead of mysql 5.6
how can I do it?

[Vanilla 1538]

Mariadb is a drop-in replacement for MySQL. Backup your database, deinstall mysql and install mariadb instead, it'll do the magic automatically.

[servan12 0]

On 7/18/2020 at 5:00 PM, Vanilla said:

Mariadb is a drop-in replacement for MySQL. Backup your database, deinstall mysql and install mariadb instead, it'll do the magic automatically.

 

I will not make any adjustments from sourcing dbden etc.?

[Vanilla 1538]

16 minutes ago, servan12 said:

 

I will not make any adjustments from sourcing dbden etc.?

Nope, mariadb will just run like a mysql server.

If you wanna use the libmysqlclient from mariadb for compiling you have to remove the reconnect variabe in libasyncsql on connect function call, you'll get the message once you try to compile it, it's pretty simple. Either way, it's only necessary if you're using the lib from mariadb for compiling.

On live server, removing mysql and installing mariadb will just do fine. Of course Mariadb offers some different storage engines and if you wanna use them you'll have to change that on your database. If not, you can just drop it in and run it. No need to change anything.