Subject: Re: Replication problems From: "Jared Richardson" <[EMAIL PROTECTED]> === Did you change the slave number in the second slave's config file? I forget the exact syntax, but if memory serves, there is a number in the my.ini (or my.cnf) that must be unique. If you just copied, you may have missed that.
"Santiago Alba" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... > 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
