Froilan Mendoza wrote: > Hello, > > I have two machines that I am trying to use replication on. Here are their > configurations: > master (my.cnf) > log-bin > serveri-d = 1 > > slave: > server-id = 2 > master-host=master.domain.com > master-user=replicate > master-password=replicatedb > log-bin > > I followed the steps in the manual but found this error on my slave logs: > 020820 13:24:52 Slave I/O thread: connected to master > '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at > position 4 > 020820 13:24:52 Error updating slave list: > 020820 13:24:52 Slave I/O thread exiting, read up to log 'FIRST', position 4 > > What does this mean? > > Whenever I make changes to the master, the Position changes: > mysql> show master status; > +----------------+----------+--------------+------------------+ > | File | Position | Binlog_do_db | Binlog_ignore_db | > +----------------+----------+--------------+------------------+ > | master-bin.002 | 208 | | | > +----------------+----------+--------------+------------------+ > > but doesn't reflect on the slave: > mysql> show master status; > +----------------+----------+--------------+------------------+ > | File | Position | Binlog_do_db | Binlog_ignore_db | > +----------------+----------+--------------+------------------+ > | slave-bin.002 | 79 | | | > +----------------+----------+--------------+------------------+ > > Should the "file"s be the same for both master and slave? > > Here are other things that might help: > (slave) > mysql> show processlist; > | 2 | system user | none | NULL | Connect | 1945 | Slave: waiting > for binlog update | NULL | > > mysql> show slave status; > | master.domain.com | replicate | 3306 | > 60 | | 4 | slave-relay-bin.002 > | 4 | | No | > Yes | | | > 0 | | 0 | 0 | > 4 | > > Any tips/advice? > > TIA! > > Froilan > > --------------------------------------------------------------------- > 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
on the slave you should run show slave status also on the slave check /path/to/mysql/master.info this file gives you good info and I had to change it manually when I changed master server names in the my.cnf file also, add set-variable = slave_net_timeout=3600 set-variable = net_read_timeout=3600 in the my.cnf on the slave to keep it from fillng the log with junk --------------------------------------------------------------------- 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
