← Back to team overview

maria-discuss team mailing list archive

Re: Using 10.0s multi-source replication for database consolidation


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.


Follow ups