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&#