mysql replication - slave server on one database

mysql replication master slave
sabansaulic picture sabansaulic · Dec 22, 2011 · Viewed 27.2k times · Source

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

Frank Fang picture Frank Fang · Dec 22, 2011

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

Related questions

Error: "could not initailize master info structure" while doing Master Slave Replication in MySQL

I am trying to do Master Slave Replication for MySQL. When i am typing the following command: CHANGE MASTER TO MASTER_HOST='10.1.100.1', MASTER_USER='slave_user', MASTER_PASSWORD='slave_password', MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=451228; …

Read More
MySQL slave I/O thread not running

I have set up replication for MySQL server. I can connect from the slave machine to the master server using the replication user/password. I have got the slave SQL thread running, but the slave I/O thread is not …

Read More
Where can I find the file my.ini file for windows mysql server?

The same question is repeated again and again and i am another one repeating this question . I have already set up my mysql server . Its location is C:\Program Files\MySQL\MySQL Server 5.5 but i am not able to find …

Read More