RE: [PHP-DB] Php with MySQL replication

Have you made any progess with this yet? Could it simply be a delay due to replication log size before the replication is triggered...its much more a mysql issue than a php one... Bastien

From: "David Brinks" <brinks@power-net.net> To: <php-db@lists.php.net> Subject: [PHP-DB] Php with MySQL replication Date: Fri, 5 Aug 2005 17:20:22 -0400 I seem to be having a problem when using php with a replicated database and the replicated database not being updated correctly. I have verified that replication in general works. When transactions are entered through either a perl script or through console, the replicated client receives the updates almost instantly. When a transaction goes through php, on the other hand, the master database will be updated but the master does not seem to send the update to the replicated client. Mysql version are both 4.0.18. Mod_php4-4.3.7 is the php code. Sample from php script... $conn = mysql_connect($Server, $User, $Pass); $sql = "INSERT INTO test.database VALUE ('','hello')"; $result = mysql_query($sql,$conn); $closed = Mysql_close($conn); If anyone has any suggestions, I would appreciate it. Thanks. David Brinks --- Power-Net Internet Services brinks@power-net.net Local Office : 402 N. Mission, Mount Pleasant, MI 48858 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php