LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   sql master/slave replication , add another db (https://www.linuxquestions.org/questions/linux-software-2/sql-master-slave-replication-add-another-db-619370/)

quackyo 02-07-2008 11:12 AM

sql master/slave replication , add another db
 
I have a working setup with mysql master and slave.
The master have three databases (lets call them db1,db2,db3). The slave has in it's setup :

"master-host=master_server.xxx
master-user=username
master-password=password
master-connect-retry=60
replicate-do-db=db1"

The master is set up to log all databases, so the slave actually gets binary logs from all databases.

How do I make the slave replicate db2 and db3 too, without interupting the master ? (There's always load on the master) ...


All times are GMT -5. The time now is 12:16 PM.