Hello! You will get problems when you set the 2nd slaves server-id the same as other one. server-ids MUST be unique...once made that mistake too...
Greetings Ralf Gerald Clark wrote: > 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 > -- Ralf Narozny SPLENDID Internet GmbH & Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de --------------------------------------------------------------------- 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
