On Sun, Jun 10, 2001 at 09:29:15AM -0400, Granville A. Gayle Jnr. wrote:
>
> I have just started to use MySQL and like the ease in which it does
> it's one way replication. However I have a situation that has
> multi-sites that would need to do local entry to a database and then
> update the centreal database which could then update those databases
> that don't have the changed/additional info.
>
> i.e. locations HEAD,A,B &C. Entry done in A,B & C. HEAD needs to be
> updated after entry in A,B & C. Likewise A & B needs data from C, B
> & C needs data from A, C & A needs data from B.
>
> Is there any known way to accomplish this with MySQL??
If I understand you correctly, this is a multi-master replication
setup. One in which there are several peers which all should see each
other's updates to the data.
You can do this in MySQL as long as:
(1) You are running one of the latest MySQL versions.
(2) You have a unique server-id for each server.
(3) You configure the servers in a replication ring where A is a
slave of B, B is a slave of C, and C is a slave of A (for a
3-master setup).
(4) You understand that some queries won't work well in this
seutp. For example you can't reliably use AUTO_INCREMENT columns
the way you normally might with only one master. Some of this is
mentioned in the manual, I think.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 439-9951
MySQL 3.23.29: up 16 days, processed 105,706,229 queries (73/sec. avg)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
