2

I've been a MySQL user/administrator for many years and I've been considering a switch to MariaDB. We have a statement-replicated setup with a MySQL slave and I've been thinking that one way to ease-into a MariaDB environment might be to swap the slave out for MariaDB until we're comfortable, then switch the master to MariaDB.

Is that something that is possible? I suspect it is, since the replication interface is fairly simple, especially for a statement-replicated setup.

Is that something that makes any sense?

UPDATE I happen to be using MySQL 5.5 as the master and MySQL 5.6 as the replicated slave in my current environment, just in case that has any bearing on anything. But I'm curious if different versions might be better or worse for a mixed-vendor setup.

3
  • Older version on Master + newer version of Slave is strongly recommended. MariaDB on slave to a Master running Oracle's MySQL is more likely to work than the opposite.
    – Rick James
    Commented Dec 26, 2017 at 2:25
  • Any solution for mariadb master, mysql slave?
    – hpaknia
    Commented Jul 27, 2019 at 18:11
  • You should ask your question separately to get a better answer. The short answer is that MariaDB has a nice compatibility-matrix of versions where it should be clear. Commented Jul 28, 2019 at 4:53

1 Answer 1

2

Yes, this is possible, and probably makes sense. See e.g. Replicating from MySQL Master to MariaDB Slave. So with MySQL 5.5 as the master, you can use MariaDB 5.5 or later as the slave.

3
  • Yes You can, but you can't use GTID repliction. Because mariadb and mysql have different GTID method
    – HamoonDBA
    Commented Dec 25, 2017 at 15:55
  • MySQL 5.5 doesn't have GTID replication so it's a non-issue :)
    – dbdemon
    Commented Dec 25, 2017 at 16:00
  • FWIW, I ended up running MySQL 5.5 master and MariaDB 10.1 slave for quite a while and all was well. GTID wasn't an issue, since MySQL 5.5 hadn't yet diverged. MySQL 5.5 isn't on the list here, but it is indeed compatible as a master database for MariaDB replication slaves. Commented Jan 8, 2019 at 14:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.