Thanks a lot. I've fixed my problems with this. Best regards.
----- Original Message ----- From: Gerald Clark <[EMAIL PROTECTED]> To: Santiago Alba <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, July 12, 2002 3:53 PM Subject: Re: Replication problems Did you copy the master.info file over too? Santiago Alba wrote: >Hi All, > >I had a system replication on Linux consisting of MASTER and only one SLAVE. >I stopped replication, I did a backup on my slave and it recreated in >another machine so now I have two SLAVES connected to database MASTER. > >But I found problems. I show you the output on my database MASTER and SLAVE >who is failed: > >*************************************************** > >MASTER > >mysql> show master status; >+---------+----------+--------------+------------------+ >| File | Position | Binlog_do_db | Binlog_ignore_db | >+---------+----------+--------------+------------------+ >| log.101 | 54557 | | | >+---------+----------+--------------+------------------+ >1 row in set (0.00 sec) > > >SLAVE: > >mysql> show slave status; >+--------------------------+-------------+-------------+---------------+--- - >------+-----+---------------+-----------------+---------------------+------ - >-----+------------+--------------+ >| Master_Host | Master_User | Master_Port | Connect_retry | >Log_File | Pos | Slave_Running | Replicate_do_db | Replicate_ignore_db | >Last_errno | Last_error | Skip_counter | >+--------------------------+-------------+-------------+---------------+--- - >------+-----+---------------+-----------------+---------------------+------ - >-----+------------+--------------+ >| spiderman.terravista.srv | replica | 3306 | 60 | >| 4 | Yes | | | 0 | >| 0 | >+--------------------------+-------------+-------------+---------------+--- - >------+-----+---------------+-----------------+---------------------+------ - >-----+------------+--------------+ >1 row in set (0.00 sec) > > >mysql> show processlist; >+----+-------------+-----------+------+---------+------+------------------- - >----------------------+------------------+ >| Id | User | Host | db | Command | Time | State >| Info | >+----+-------------+-----------+------+---------+------+------------------- - >----------------------+------------------+ >| 1 | system user | none | NULL | Connect | 7729 | Waiting to >reconnect after a failed read | NULL | >| 2 | root | localhost | NULL | Sleep | 337 | >| NULL | >| 3 | root | localhost | NULL | Query | 0 | NULL >| show processlist | >+----+-------------+-----------+------+---------+------+------------------- - >----------------------+------------------+ > >In errors log: > >020712 12:43:40 Error reading packet from server: Could not open log file >(server_errno=2) >020712 12:44:40 Slave: Failed reading log event, reconnecting to retry, log >'FIRST' position 4 >020712 12:44:40 Slave: reconnected to master >'replica#spiderman.terravista.srv:3306',replication resumed in log 'FIRST' >at position 4 >020712 12:44:40 Error reading packet from server: Could not open log file >(server_errno=2) >020712 12:45:40 Slave: Failed reading log event, reconnecting to retry, log >'FIRST' position 4 >020712 12:45:40 Slave: reconnected to master >'replica#spiderman.terravista.srv:3306',replication resumed in log 'FIRST' >at position 4 >020712 12:45:40 Error reading packet from server: Could not open log file >(server_errno=2) > >my.cnf: > ># The MySQL server >[mysqld] >port = 3306 >socket = /tmp/mysql.sock >skip-locking >set-variable = key_buffer=384M >set-variable = max_allowed_packet=1M >set-variable = table_cache=512 >set-variable = sort_buffer=2M >set-variable = record_buffer=2M >set-variable = thread_cache=8 ># Try number of CPU's*2 for thread_concurrency >set-variable = thread_concurrency=8 >set-variable = myisam_sort_buffer_size=64M >#log-bin = /mysql/log/log.nnn >server-id = 3 > >master-host = spiderman.terravista.srv >master-user = replica >master-password = xxxxx > >*********************************************** > >Any suggestion? > >Thanks in advance. > >Santiago. > > > >--------------------------------------------------------------------- >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 > > --------------------------------------------------------------------- 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
