I am setting up a replication slave. Master is server-id = 1 Slave is server-id = 2
Relevant section of /etc/my.cnf from the slave # The MySQL server [mysqld] port = 3306 socket = /tmp/mysql.sock skip-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=8M set-variable = table_cache=128 set-variable = sort_buffer=512K set-variable = net_buffer_length=64K set-variable = myisam_sort_buffer_size=8M log-bin server-id = 2 master-host = ********* master-user = ****** master-password = ****** master-port = 3306 log-slave-updates >From the err log on the slave: 011109 15:03:16 mysqld ended 011109 15:03:22 mysqld started /usr/local/nusphere/mysql/bin/mysqld: ready for connections 011109 15:03:22 Slave: connected to master *********, replication started in log 'FIRST' at position 4 011109 15:03:23 Slave: received 0 length packet from server, apparent master shutdown: (0) 011109 15:03:23 Slave: Failed reading log event, reconnecting to retr y, log 'FIRST' position 29 011109 15:03:23 Slave: reconnected to master *********** ,replication resumed in log 'FIRST' at position 29 011109 15:03:23 Slave: received 0 length packet from server, apparent master shutdown: (0) 011109 15:04:23 Slave: Failed reading log event, reconnecting to retr y, log 'FIRST' position 29 This is the first few relevant lines after the first startup, all subsequent lines are just repeated. My guess as to the problem: ./mysqladmin variables reports the slave as being server-id = 1 No matter what I can't change it. Permissions have been checked and double checked. Have been all around the globe on this one and can't figure it. Master is running MySql version 3.23.34 Slave is running MySql version 3.23.37 All indications are that the setup is correct but no updates happen. I am left to believe the server-id problem is causing this to not work. I understand that the server-id's need to be different on the master and the slave. On a test system at home when I change the server-id and restart the server the change takes. This test system is running MySql 3.23.43 Has anyone seen this before and am I on the right track? Paul [EMAIL PROTECTED] --------------------------------------------------------------------- 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
