YEs, both of MySQL are running on each system. Show status display a big long list of items, any specific? uptime is 3239 on 10.100.1.170 uptime is 3353 on 10.100.1.171
Thanks, Néstor :-) On Tue, Apr 1, 2008 at 3:46 PM, Srini <[EMAIL PROTECTED]> wrote: > 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 :-) > > > > > >
