Re: Insert & Replication issues...

2003-02-11 Thread Jeremy Zawodny
On Wed, Feb 12, 2003 at 10:59:00AM +0800, Trevor Phillips wrote: > I have a setup of 3 servers, with MySQL replication in a round-robin fashion > between all 3. So far, any writes to a particular table are done only on one > machine at any time. The replication is used as a hot backup, not a > l

Insert & Replication issues...

2003-02-11 Thread Trevor Phillips
I have a setup of 3 servers, with MySQL replication in a round-robin fashion between all 3. So far, any writes to a particular table are done only on one machine at any time. The replication is used as a hot backup, not a load-balancing thing. I now have an instance where I'd like to do inserts