I need to create a MySQL slave instance which replicates the data from a MariaDB master. I guess it won't work. Any advices on how to create this replica architecture using MariaDB and MySQL? I am also investigating and considering using tungsten https://github.com/vmware/tungsten-replicator. Did anybody has experience on it?
I think it can work, see e.g. this question (with answers). Note that:
- You won't be able to use GTID replication as this is implemented differently in MariaDB and MySQL
- You need to use versions of MySQL and MariaDB which are somewhat compatible.
- Avoid using any MariaDB-specific features.