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]