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

Reply via email to