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.

  • 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 Dec 26 '17 at 2:25
  • Any solution for mariadb master, mysql slave? – hpaknia Jul 27 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. – Christopher Schultz Jul 28 at 4:53
1

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.

  • Yes You can, but you can't use GTID repliction. Because mariadb and mysql have different GTID method – HamoonDBA Dec 25 '17 at 15:55
  • MySQL 5.5 doesn't have GTID replication so it's a non-issue :) – dbdemon Dec 25 '17 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. – Christopher Schultz Jan 8 at 14:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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