Hello.
MySQL only supports one master and many slaves. As I saw in comments at: http://dev.mysql.com/doc/mysql/en/Replication_Options.html You may use replicate-rewrite-db for tables: replicate-rewrite-db = RemoteTableName ->LocalTableName >i have 2 questions about Replication. > >1) I managed to make one slave and one master. The replication works fine and >it updates >only one table from one database (cause of the replicate-do-table=db.table1). >The first >question is can I tell mysql that table1 from master to be named table2 on >slave? I >already have another table1 and I dont want to overwrite it. > >2) As far as I read I can have as many slaves as I want and one master. Can I >have the >opposite? Imagine the follow scenario: > >I have 3 Shops with 3 Database (same structure) and they all contain a table >"CUSTOMERS". >I want to put all those customers from 3 shops to a central database. So, I >was thinking >to inverse the master/slave logic and backup each shop to the slave computer. >Thats why I >need to change the name of table. Because i want to backup customers of first >shop to >CUSTOMERS1, customers of second shop to CUSTOMERS2 etc etc. >>"Nikos" <[EMAIL PROTECTED]> wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
