Hello all,
I am running 3.23.31 (rpm install) on a couple servers. The replication is
setup for bi-directional although most, if not all, of the updates are only
going in one direction. The other direction is only if the webserver fails
over and suddenly users are updating the backup server's mysql database.
Anyway, all replication appears to work fine for the first hour or so...
then suddenly the slave on the backup machine just hangs... Here is the
corresponding errors from the log file:
010118 15:10:24 Slave: load data infile at position 31908 in log '(null)'
produced 135994754
warning(s)
010118 15:10:24 Error reading packet from server: Lost connection to MySQL
server during
query (read_errno 0,server_errno=2013)
010118 15:10:24 Slave: Failed reading log event, reconnecting to retry, log
'FIRST' position 32194
010118 15:10:24 Slave: reconnected to master
'[EMAIL PROTECTED]:3306',replication resumed
in log 'FIRST' at position 32194
Upon stopping and restarting the slave again with "SLAVE STOP;" and then
"SLAVE START;", the replication will almost immediately stop again with the
same type of error:
010118 15:38:12 Slave: connected to master '[EMAIL PROTECTED]:3306',
replication started
in log 'FIRST' at position 36702
010118 15:38:12 Slave: load data infile at position 41819 in log '(null)'
produced 135994754
warning(s)
010118 15:38:12 Error reading packet from server: Lost connection to MySQL
server during
query (read_errno 0,server_errno=2013)
010118 15:38:12 Slave: Failed reading log event, reconnecting to retry, log
'FIRST' position 42105
010118 15:38:12 Slave: reconnected to master
'[EMAIL PROTECTED]:3306',replication resumed
in log 'FIRST' at position 42105
I have had this problem with every version of MySQL that I have tried. I
read in a post a couple weeks ago about setting the max_allowed_packet size
larger. I set it to the largest supported value, and it did not fix the
stalling problem. Any help will be greatly appreciated! Let me know if
more information is needed.
Here is a copy of the my.cnf file just incase it helps:
[mysqld]
server-id=51
log-bin
master-host=192.168.1.1
master-user=replicate
master-password=*****
set-variable = max_allowed_packet=17M
The my.cnf files are basically identical on the two servers with the
exception of the servier-id and master-host settings.
Thanks,
Jon
---------------------------------------------------------------------
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
