is your mysql running on the master host i,e 10.100.1.170
Also can you please execute "show status" on that host to see how long the server is up, may be the server is restarted and your slave is retrying on the same old connection
HTH, -srini Néstor wrote:
In my RHEL5, I am using this link to create MySQL replication an did work the first time I did it: http://crazytoon.com/2008/02/29/mysql-how-do-you-set-up-mastermaster-replication-in-mysql-centos-rhel-fedora/ I change the ip address and the hostname and it is not working now. My new ip is 10.100.1.170 and my hostname is wahoo1. The other ip address in my master/master replication is 10.100.1.171 and wahoo2 *This is what wahoo1 my.cnf looks like*: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock old_passwords=1 auto_increment_increment=2 auto_increment_offset=1 relay-log=wahoo1-relay-bin log-bin=wahoo1-bin binlog-ignore-db=mysql binlog-ignore-db=test server-id = 1 master-host = 10.100.1.171 master-user = slaveuser master-password = slavepw master-port = 3306 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid *This is what wahoo2 my.cnf looks like:* [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock old_passwords=1 auto_increment_increment=2 auto_increment_offset=2 relay-log=wahoo2-relay-bin log-bin=wahoo2-bin binlog-ignore-db=mysql binlog-ignore-db=test server-id = 2 master-host = 10.100.1.170 master-user = slaveuser master-password = slavepw master-port = 3306 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid *This is the error I get on my mysqld.log file*: 080401 15:15:07 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log './wahoo2-relay-bin.000002' position: 98 080401 15:15:07 [ERROR] Slave I/O thread: error connecting to master ' [EMAIL PROTECTED]:3306': Error: 'Lost connection to MySQL server during query' errno: 2013 retry-time: 60 retries: 86400 HELP!!!!! Thanks, Néstor :-)
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
