Hello List, I'm using MySQL 4.0.3-beta on 2 RedHat 7.3 Boxes belonging to a 2 node HA Cluster.
To allow the takeover of the database node I formed a replication ring. So node1 replicates to node2 and the other way round. Read/Write operations are only done on Node 2. The nodes are connected with 1 Gbit Nic's The replication ring seems to work but I have another problem. With v 3.x the whole replication seemed much more stable. At least it run several days without an error. It was also possible to resume replication without any errors when a node was rebootet. Now with 4.0.3 the whole thing isn't that stable anymore. Mostly it is this error: When I shut down the master the slave complains that the query log is truncated. | 021007 22:54:31 Error reading packet from server: binlog truncated in the middle of event (server_errno=1236) | 021007 22:54:31 Got fatal error 1236: 'binlog truncated in the middle of event' from master when reading data from binary | log Another strange thing is that the slave doesn't seem to try to reconnect top the master after a server restart. I always have to restart the slave. LOAD DATA FROM MASTER doesn't work the way I expected as it constantly complains about the missing SUPER priviliege. But I did set it. Here the my.cnf of one of the nodes: mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock [mysql.server] user=mysql basedir=/var/lib skip-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = table_cache=64 set-variable = sort_buffer=512K set-variable = net_buffer_length=8K set-variable = myisam_sort_buffer_size=8M set-variable = max_allowed_packet=16M [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid [mysqld] skip-innodb master-host=10.1.0.212 master-user=replicator master-password=secret server-id = 102 log-bin slave_net_timeout=120 I'm pretty sure that the problems are not directly associated with the replication itself but with my setup. Can anyone provide tips how to tune my setup? Please CC to me as I don't know if ezmlm allready added me to this list. Thanks in advance Daniel Khan --------------------------------------------------------------------- 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
