We have two networks which are very far apart in separate data centres
over 1,000 miles apart. Web servers are in both locations but our MySQL
db servers are in one. All web servers talk to those servers.
After debugging some problems with a counter field I discovered that
UPDATE statements from the remote network were silently dying. A SELECT
immediately before works fine but I had to add a loop to make sure the
UPDATE caught. It would have to loop two or three times for it to execute.
I'm mystified. MySQL doesn't raise an error, and affected rows is either
0 or 1 (regardless of whether it succeeds or not) so I can't rely on that.
I tried adding a delay, but waiting up to a second didn't fix it.
Platform is Linux, MySQL servers are 4.1.11, web servers use PHP and
MySQL Client API version 3.23.49.
Has anyone else had problems communicating with remote db servers?
Thanks!
Donncha.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
