List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:July 12 2002 1:53pm
Subject:Re: Replication problems
View as plain text  
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 <mysql-thread114413@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


Thread
Replication problemsSantiago Alba12 Jul
  • Re: Replication problemsGerald Clark12 Jul
  • Re: Replication problemsRalf Narozny12 Jul
  • RE: Replication problemsSantiago Alba15 Jul
  • RE: Replication problemsSantiago Alba15 Jul