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) ...
|