You could daisy chain the servers together, this would be ineffiecient and not robust, but it would work.
shop1 master to shop2 | customers1 | V shop2 master to shop3 | customers1 customers2 | V shop3 master to office | customers1 customers2 customers2 | V head office Alternatively, if this is just for backup purposes I would write a script that dumps the customers table at each shop, compress it and then ftp it to head office every night. Cheers, chris -----Original Message----- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: 19 November 2004 08:01 To: [EMAIL PROTECTED] Subject: Re: 2 questions about Replication 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]