Hi, Markus! On Feb 06, Markus "Shorty" Uckelmann wrote:
Hi all,
I want to consolidate the databases on several servers onto a single server. And all this without or only minimal downtime. After reading an article[1] from the Percona folks I was thinking of using the multi-source replication feature of 10.0. But there are a few things I'm not sure about. Maybe someone can help me out.
What MySQL/MariaDB versions are needed before and behind the MariaDB 10 server?
My plan/idea/dream was the following:
1. Stop the server on a slave and start it with skip-slave and skip-networking. Write down replication data. 2. Dump the databases I want to move with "mysqldump <db-name>" 3. Load the dump into MariaDB 10.0 and configure replication.
What do you want to replicate to and from? What versions? Beware that replication from MariaDB 10.0 to earlier versions doesn't work at the moment :( It's a bug that we will fix. Regards, Sergei