MariaDB

Replication between MySQL and MariaDB

Asked by seattlegaucho

Hi all,

I would like to know if anybody tested using a MariaDB slave to a MySQL master and vice versa. These are the items I can think of:

1. Can somebody think about any issues?
2. Are the binary logs different in any way?
3. Would there be a difference between ROW or STATEMENT replication?
4. What's the plan for the future?

I will do my own tests, but I'd like to build on top of someone else's experience, if there is any.

G

Question information

Language:
English Edit question
Status:
Answered
For:
MariaDB Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Launchpad Janitor (janitor) said : 		#1

This question was expired because it remained in the 'Open' state without activity for the last 15 days.

Revision history for this message
Michael Widenius (monty) said : 		#2

MariaDB 5.1 and 5.2 are true drop in replacements for MYSQL 5.1. Replication will work from MySQL to MariaDB in all cases.
Replication from MariaDB to MySQL will work as long as you don't use any of the new features, like virtual columns.

We are working on a lot of enhancements for replication that will probably be in MariaDB 5.3. When this is done, you may not be able to replicate from MariaDB to MySQL anymore, but you should always be able to replicate from MySQL to MariaDB and MariaDB 5.x to MariaDB 5.3

Can you help with this problem?

Provide an answer of your own, or ask seattlegaucho for more information if necessary.

To post a message you must log in.