Hi, I am replicating a table between 2 servers. The table on the master executes many transactions that should be replicated to the table on the slave.. The table on the slave is only readable... I have noticed that the changes on the master are not replicated at once but it takes about 2 hours to get the slave updated.. When this happens I see on the slaves error log file the error Error reading packet from server: Lost connection to MySQL server during query (read_errno 134,server_errno=2013) and then the slave seems to reconnect to the master. Has anyone any idea why is this happening? Is it possible that when I read data from the table on the slave, the slave cannot be updated because it gets locked or something like that?
Thanks.. --------------------------------------------------------------------- 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
