On Mon, Nov 04, 2002 at 02:04:35PM -0500, Ray Zimmerman wrote: > I'm looking into options to improve performance of mysql in our app > and have a question about replication. I need the following > guarantee, which I believe is not possible with replication ... > > If a client successfully updates the master, any subsequent read from > a slave must reflect that update. Or to put it negatively, it must be > impossible for a client to update the master and subsequently read an > old (pre-update) value from the slave. > > Am I correct in assuming that replication can not make this guarantee?
Yes. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 90 days, processed 1,877,572,814 queries (240/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