Is it possible to set up a MySQL master-slave replication for a single database to a slave server with multiple (shared) databases
Posted on 2015-01-29
I have a setup with currently two dedicated servers for the MySQL database.
One is the production server with the MySQL database which is accessed for read/ write transactions.
There is a second server that acts as a hot-standby and is in slave replication from this production server.
I would now like to add another slave server on a third dedicated server, but that MySQL server already has databases installed. The replicated database will be used for read-only analytics purpose and I want it separate so heavy analytics queries don't affect the production environment.
My question is, can I set up slave replication from the master MySQL server to this third MySQL server for just one database?