RE: Replication / Synchronizing DB across different machines

2004-03-01 Thread John McCaskey
point for this type of 2 way replication setup. John -Original Message- From: Gowtham Jayaram [mailto:[EMAIL PROTECTED] Sent: Monday, March 01, 2004 1:22 PM To: [EMAIL PROTECTED] Subject: Re: Replication / Synchronizing DB across different machines >> But what happens i

Re: Replication / Synchronizing DB across different machines

2004-03-01 Thread Gowtham Jayaram
>> But what happens if there is a break of >> communication and the same record on both machines >> is modified? For example, if the sync link is ? >> down, and I update record #1 on A, while at the >> same time, another user is modifying record #1 on >> server B. When the link comes back onlin

Re: Replication / Synchronizing DB across different machines

2004-02-29 Thread Eric B.
alf of Eric B. Sent: Sun 2/29/2004 9:51 PM To: [EMAIL PROTECTED] Subject: Replication / Synchronizing DB across different machines Hi, I'm at the stage where I need to create redundancy in my network / DB server. Am currently using MySQL 4.0.x, and have been trying to figure out how I c

RE: Replication / Synchronizing DB across different machines

2004-02-29 Thread John McCaskey
this will all be handled automatically as soon as the servers are able to reconnect to each other. John From: news on behalf of Eric B. Sent: Sun 2/29/2004 9:51 PM To: [EMAIL PROTECTED] Subject: Replication / Synchronizing DB across different machines Hi

Replication / Synchronizing DB across different machines

2004-02-29 Thread Eric B.
Hi, I'm at the stage where I need to create redundancy in my network / DB server. Am currently using MySQL 4.0.x, and have been trying to figure out how I can safely replicate/synchronize between different machines. I know there is a way to do a Master / Slave replication, but I'm looking more f