mysql replication - slave server on one database

Question

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?

Answer 1

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