Re: 2 ways replication

2007-02-15 Thread Rilawich Ango
Hi, Most of the documents talk about the normal replication and dual master. None of them talk about the conflict handling. Does it mean that we need to handle the conflict ourselves? As I know, MSSQL has a way to implement 2 ways replication. Any drawback if using MSSQL for this kind of rep

Re: 2 ways replication

2007-02-13 Thread Rilawich Ango
Thanks for the links. It seems helpful for me. I will read it then. BTW, does anyone implement multi-master replication successfully? I have read a lot of document and they all don't recommend to do it. On 2/13/07, Juan Eduardo Moreno <[EMAIL PROTECTED]> wrote: Dear all, We can view interes

Re: 2 ways replication

2007-02-13 Thread Juan Eduardo Moreno
Dear all, We can view interesting tipic into : http://www.onlamp.com/lpt/a/6549 Regards, Juan Eduardo On 2/12/07, Atle Veka <[EMAIL PROTECTED]> wrote: 2 way replication, also referred to as dual master replication, has been available for quite some time. However implementation can be tric

Re: 2 ways replication

2007-02-13 Thread Cory Robin
Here are some links for you... http://www.howtoforge.com/mysql_master_master_replication http://sequoia.continuent.org/ http://www.howtoforge.com/loadbalanced_mysql_cluster_debian_p5 --- Rilawich Ango <[EMAIL PROTECTED]> wrote: > Hi all, > > I know it is an old question and I have read from

Re: 2 ways replication

2007-02-12 Thread Atle Veka
2 way replication, also referred to as dual master replication, has been available for quite some time. However implementation can be tricky. Look for the "Dual master" section in chapter 7 of the High Performance MySQL book: http://dev.mysql.com/books/hpmysql-excerpts/ch07.html If you nee

Re: 2 ways Replication in MySQL

2004-11-18 Thread Mojtaba Faridzad
uot;Kevin Cowley" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, November 18, 2004 9:56 AM Subject: RE: 2 ways Replication in MySQL I worked on a military system that went further than this, but again required a proprietary application to perform the updates. Database

Re: 2 ways Replication in MySQL

2004-11-18 Thread Mojtaba Faridzad
rever :> anyways, it's complicated. - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, November 18, 2004 9:34 AM Subject: Re: 2 ways Replication in MySQL "Mojtaba Faridzad" <[EMAIL PROTECTED]&

RE: 2 ways Replication in MySQL

2004-11-18 Thread Kevin Cowley
I worked on a military system that went further than this, but again required a proprietary application to perform the updates. Databases were either slave, master, of standalone. Any update transaction was logged to a file. If the master was available then If we are the master we apply the updat

Re: 2 ways Replication in MySQL

2004-11-18 Thread Alec . Cawley
"Mojtaba Faridzad" <[EMAIL PROTECTED]> wrote on 18/11/2004 13:59:21: > Hi, > I need to expand the database to 3 different locations. We have 3 servers in > 3 cities. So far the database has been in one city and 2 others have been > linked to it and worked. But sometimes for a day or more a ci