Is there a way to slave a single database?

MySQL & MariaDB Other MySQL® Questions
1

I would like to setup a slave/master server for high availability databases from multiple MySQL servers.

Is there a way to slave replicate only a specific database from a server instead of master/slave the whole MySQL server instance?

I would like to end up with a MySQL server that acts as a slave or master for originating databases spread across multiple servers.

So I have several MySQL servers already in place, but only replicate/slave certain high traffic databases from each of those servers to a heavy duty MySQL server.

Thanks,
Chuck

2

Chuck,

Certainly, you can use replication filtering rules to achieve that. For example, on the slave, add to the my.cnf file:

replicate-wild-do-table =.%

Please read about replication filtering rule in the documentation: [url]http://dev.mysql.com/doc/refman/5.6/en/replication-rules.html[/url]. There are some details on why filtering on the slave side is preferred, and why replicate-wild-do-table is safer than replicate-do-db.