Jump to content
Fórum Script Brasil
  • 0

Replication Help


Mendigaum

Question

Gostaria de obter alguma ajuda a respeito de replicação

Configurei um servidor master e um servidor slave, porém o servidor slave não está recebendo as atualizações do master.

Eu exportei os 4 bancos do meu interesse com mysqldump, importei no slave e reiniciei ambos os servidores

120118  9:50:20 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000004' at position 106, relay log './mysqld-relay-bin.000020' po$
120118  9:50:20 [Note] Slave I/O thread: connected to master 'slave_user@189.123.163.51:3306',  replication started in log 'mysql-bin.000004' at position 106
120118 14:34:52 [Note] Slave I/O thread killed while reading event
120118 14:34:52 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000004', position 106
120118 14:34:52 [Note] Error reading relay log event: slave SQL thread was killed
mysql> SHOW SLAVE STATUS\G;
*************************** 1. row ***************************
             Slave_IO_State: Waiting for master to send event
                Master_Host: 189.123.163.51
                Master_User: slave_user
                Master_Port: 3306
              Connect_Retry: 60
            Master_Log_File: mysql-bin.000004
        Read_Master_Log_Pos: 106
             Relay_Log_File: mysqld-relay-bin.000026
              Relay_Log_Pos: 243
      Relay_Master_Log_File: mysql-bin.000004
           Slave_IO_Running: Yes
          Slave_SQL_Running: Yes
            Replicate_Do_DB:
        Replicate_Ignore_DB:
         Replicate_Do_Table:
     Replicate_Ignore_Table:
    Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
                 Last_Errno: 0
                 Last_Error:
               Skip_Counter: 0
        Exec_Master_Log_Pos: 106
            Relay_Log_Space: 243
            Until_Condition: None
             Until_Log_File:
              Until_Log_Pos: 0
         Master_SSL_Allowed: No
         Master_SSL_CA_File:
         Master_SSL_CA_Path:
            Master_SSL_Cert:
          Master_SSL_Cipher:
             Master_SSL_Key:
      Seconds_Behind_Master: 0
1 row in set (0.00 sec)

ERROR:
No query specified

Link to comment
Share on other sites

0 answers to this question

Recommended Posts

There have been no answers to this question yet

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



  • Forum Statistics

    • Total Topics
      152.2k
    • Total Posts
      652k
×
×
  • Create New...