Reg. Synchronization between MySQL DBs

2001-03-28 Thread Aigars Grins
Hi, The short version: Does anyone know an automated way of keeping two MySQL db's (located on different machines) in sync? A small window of non-sync could be acceptable. The long version: I'm working on a project which basically is about capturing a lot of data from different places and

Re: Reg. Synchronization between MySQL DBs

2001-03-28 Thread Mat Murdock
h 28, 2001 3:27 PM Subject: Reg. Synchronization between MySQL DBs Hi, The short version: Does anyone know an automated way of keeping two MySQL db's (located on different machines) in sync? A small window of non-sync could be acceptable. The long version: I'm working on a project which

Re: Reg. Synchronization between MySQL DBs

2001-03-28 Thread Ralph Graulich
Hi, Does anyone know an automated way of keeping two MySQL db's (located on different machines) in sync? A small window of non-sync could be acceptable. Read about "replication" in the corresponding chapters in the online manual of mySQL (http://www.mysql.com/) - Documentation. Regards ...

Re: Reg. Synchronization between MySQL DBs

2001-03-28 Thread nigel wood
On Wed, 28 Mar 2001, Aigars Grins wrote: Hi, The short version: Does anyone know an automated way of keeping two MySQL db's (located on different machines) in sync? A small window of non-sync could be acceptable. The long version: snip The important question is how much availability

Re: Reg. Synchronization between MySQL DBs

2001-03-28 Thread Aigars Grins
From: "Ralph Graulich" [EMAIL PROTECTED] Read about "replication" in the corresponding chapters in the online manual of mySQL (http://www.mysql.com/) - Documentation. From: "Mat Murdock" [EMAIL PROTECTED] Did you look at doing something with replication? Thanks for the quick reply. I hadn't

Re: Reg. Synchronization between MySQL DBs

2001-03-28 Thread Aigars Grins
Tnx for the answer. From: "nigel wood" [EMAIL PROTECTED] The important question is how much availability ( the ability to survive network partitions) your looking for: 1) Is simple master -- slave replication good enough for your application ? all inserts updates going onto the Master the