Hello everyone I've read about replication mechanism in MySQL, but I've still got some reservations regarding transactions.
In the manual thay say that in case of a transaction, all update instructions are hold in a cache, and on commit they are written to the binary transaction log. After the update instructions are written in binary update log, the slave starts reading them and executint. But what happends if a client executes a query on the slave machine in this period of time? Wouldn't he see an inconsistent database state (a state in the middle of the transaction)? So, actually, on the slave machine it's like there are no transactions at all..... Am I wrong somewhere? Please give me some advice, Thank you -- Sincerely Catalin Grigoroscuta Junior Programmer One5 Development SRL Str Intrarea Glucozei No 37-39, sector 2, Bucharest, Romania Phone: +40 1-234-5080, Fax: +40 1-243-0579 E-Mail: [EMAIL PROTECTED] Visit us on the Internet: http://www.one5.com/ One5 Corporation - Wireless Infrastructure for 3rd Generation ************************************************************* --------------------------------------------------------------------- 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