Does mySQL Replication: Master DB Name has to be the same as the Slave DB name? -


I named Master DB MDB & amp; In Das server I set to repeat-do-db = sdb & lt; - It was not working? But when I set it as the same DB name then it works there to setup 1 Master DB with 2 different slaves, but there is no solution in the same server ??

You need to specify options:

  - repeat- Rewrite- db = to_name- & gt; To_name  

tells the slave to translate the original database (that is, one selected by the US) to_name in if it was from_name from the master only Tables contain statements are affected (not the statement such as CREATE DATABASE, DROP DATABASE, and ALTER DATABASE), and only when the_name is the default database on the master. This does not work for cross-database updates To specify multiple rewrites, use this option multiple times. The server already uses one that matches that which matches it.

If you are replicating only a few databases, you will need to specify. Note that after the name change operation implemented by replicate-rewrite-db :

  - replicate-do-db = db_name, the name of the database is this argument  

Comments

Popular posts from this blog

MySql variables and php -

url rewriting - How to implement the returnurl like SO in PHP? -

Which Python client library should I use for CouchdB? -