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