Search code examples
mysqlreplicationmaster-slave

mysql replication - slave server on one database

I couldn't find an answer to my question.

I have 2 mysql servers.

  1. Master server
  2. Slave server

Now i want to add another Slave server but i have other website running on that server.

Can i replicate just one database?

Solution

  • Yes you can

    If you want to replicate just one database from master, you can set replicate-do-db in your /etc/my.cnf or set replicate-do-db as mysql argument, for example:

    replicate-do-db=db01

    If you have multi databases to be replicated, /etc/my.cnf should be like this:

    replicate-do-db=db01
replicate-do-db=db02

    If you just want slave to ignore some database, you can set replicate-ignore-db:

    replicate-ignore-db=db01

    More details on MySQL document: http://dev.mysql.com/doc/refman/5.1/en/replication-options-slave.html#option_mysqld_replicate-do-db