Néstor escribió:
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
This error is a mysql error, it isn't a Hearbeat error. You need to look
at bind-addres, if you have this variable in config file the value must
be an IP address which slave server can access. You must test if you can
connect to the master server from the slave server (mysql -h master-host
-P master_port -u user -p password). In master server you must look at
user grants. Your slave user must have REPLICATION SLAVE grants.
Lucky!
HELP!!!!!
Thanks,
Néstor :-)
_______________________________________________
Linux-HA mailing list
[email protected]
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems
_______________________________________________
Linux-HA mailing list
[email protected]
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems
