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 
> load-balancing thing.
> 
> I now have an instance where I'd like to do inserts on several of
> the machines at once. The inserts are just logged info, so there's
> no unique key, no auto-increment, etc...
> 
> Is it safe to do this, in this configuration?

Yes.

> If simultaneous updates hit 2 or more of the servers at the same
> time, will it still replicate all updates properly (even if they may
> chronologically occur at different times)?

That's correct.
-- 
Jeremy D. Zawodny     |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/

MySQL 4.0.8: up 8 days, processed 282,721,681 queries (371/sec. avg)

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to