mysql Ver 11.18 Distrib 3.23.53a, for pc-linux-gnu (i686) (and pretty much any other version from the past 12 months or so)
Speaking from the view of using mysql primarily via Php 4.2.3 (and other versions) with either bundled libraries or linked against the above version of MySQL: It appears that if you don't select the database with mysql_select_db(), but instead refer to 'database.table' in your sql string, 'insert' queries and 'alter table' queries (possibly others also) are not written to the binary log and thus not picked up by slaves. I'm not sure if this is by design or just an oversight, but basically it means searching through old code and using mysql_select_db() everywhere. This probably has implications outside the Php scope too I'd imagine. Regards, Jason --------------------------------------------------------------------- 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
