[Maria-discuss] Using 10.0s multi-source replication for database consolidation
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. This is done for all the databases I want to put onto a single server. The rest should be business as usual. BTW: We use similar grants on all servers. So the MariaDB 10.0 will be setup with the same statements and I don't have to care about the "mysql"-database. Does this sound realistic? Or have I missed something? [1] http://www.mysqlperformanceblog.com/2012/12/18/migrating-several-single-stan... Thanks a lot, Shorty
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
Am 08.02.2013 13:08, schrieb Sergei Golubchik:
Hi, Markus!
Hi Sergei,
What MySQL/MariaDB versions are needed before and behind the MariaDB 10 [...] What do you want to replicate to and from? What versions?
That's why I asked the above question. Currently we're still running MySQL 5.0 and want to upgrade to MariaDB 5.1(I know we lag behind). It would be nice if we could "consolidate" from 5.0. But we could also upgrade to 5.1 and then go via MariaDB 10.0. The latter is more work.
Beware that replication from MariaDB 10.0 to earlier versions doesn't work at the moment :(
Meaning everything below 10.0? Hmm, that's bitter for us ;) But how did the Percona folks make it work?
It's a bug that we will fix.
Any time estimates? Regards, Shorty
Hi, Markus! On Feb 08, Markus "Shorty" Uckelmann wrote:
Am 08.02.2013 13:08, schrieb Sergei Golubchik:
Beware that replication from MariaDB 10.0 to earlier versions doesn't work at the moment :(
Meaning everything below 10.0? Hmm, that's bitter for us ;) But how did the Percona folks make it work?
Percona Server doesn't have this problem. Replication has the code where a slave looks at the very first digit of the master's version and chooses the proper binlog format depending on whether it's "3", "4", or "5". It doesn't like the version that starts with "1", this looks ancient :)
It's a bug that we will fix. Any time estimates?
We'll have a workaround in 10.0.2. See https://mariadb.atlassian.net/browse/MDEV-4088 and http://bugs.mysql.com/bug.php?id=68187 Regards, Sergei
Am 14.02.2013 22:15, schrieb Sergei Golubchik:
Hi, Markus!
Peace Sergei, Sorry for taking so long. But I was covered in work.
Percona Server doesn't have this problem.
Hmm, something to think about...
with "1", this looks ancient :)
HaHa, Just great :-D
We'll have a workaround in 10.0.2. See https://mariadb.atlassian.net/browse/MDEV-4088 and http://bugs.mysql.com/bug.php?id=68187
Ok, I think I can wait that long. Thanks for the answer, Shorty
participants (2)
-
Markus "Shorty" Uckelmann -
Sergei Golubchik