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

Re: 2 ways replication

2007-02-13 Thread Rilawich Ango
ngo wrote: > > > Hi all, > > > > I know it is an old question and I have read from the mysql website > > about the topic. Until now, mysql still doesn't support 2 ways > > replication, quoted from mysql website. As I have multiple location > > and ea

Re: 2 ways replication

2007-02-13 Thread Juan Eduardo Moreno
gt; I know it is an old question and I have read from the mysql website > about the topic. Until now, mysql still doesn't support 2 ways > replication, quoted from mysql website. As I have multiple location > and each location will have a DB. Most of all need to read and write >

Re: 2 ways replication

2007-02-13 Thread Cory Robin
have read from the > mysql website > about the topic. Until now, mysql still doesn't support > 2 ways > replication, quoted from mysql website. As I have > multiple location > and each location will have a DB. Most of all need to > read and write > to the database.

Re: 2 ways replication

2007-02-12 Thread Atle Veka
ml If you need more than 2 masters, then all bets are off.. Atle On Mon, 12 Feb 2007, Rilawich Ango wrote: > Hi all, > > I know it is an old question and I have read from the mysql website > about the topic. Until now, mysql still doesn't support 2 ways > replication, qu

2 ways replication

2007-02-11 Thread Rilawich Ango
Hi all, I know it is an old question and I have read from the mysql website about the topic. Until now, mysql still doesn't support 2 ways replication, quoted from mysql website. As I have multiple location and each location will have a DB. Most of all need to read and write to the dat

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
ometimes for a day or more a city lost the > connection to the master database and the users could not work. Now I am > going to change the method to have a copy of database on each location. Each > location should be able to change the data also. All tables are myISAM. I am > th

2 ways Replication in MySQL

2004-11-18 Thread Mojtaba Faridzad
I am going to change the method to have a copy of database on each location. Each location should be able to change the data also. All tables are myISAM. I am thinking about 2 ways Replication in MySQL but as MySQL document recommended not to do it because there is no guarantee that we won&#