Databases
StackOverflow2013
Postsdbo
POError during Master to Master Replication of MySQL server
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POError during Master to Master Replication of MySQL server
    primarykey
    data
    text
    <p>I have setup Master to Master Replication on MySQL server 5.2 with my existing database. I am sucessfully able to replicate data of my Master 1 to Master 2 with the user named as replication. But I am getting error from Master 1 when I try to connect to master 2. Here is the detail information of them:</p> <p><strong>Master 1:</strong></p> <p>mysql> show slave status \G;</p> <p><em><strong></em>**<em>*</em>**<em>*</em>**<em>*</em>**<em>*</em>*</strong> 1. row <strong><em>*</em>**<em>*</em>**<em>*</em>**<em>*</em>**<em>*</em></strong></p> <pre><code> Slave_IO_State: Connecting to master Master_Host: 10.34.1.37 Master_User: replication Master_Port: 3306 Connect_Retry: 10 Master_Log_File: mysql-bin.000018 Read_Master_Log_Pos: 107 Relay_Log_File: XX-XX-01-relay-bin.000002 Relay_Log_Pos: 4 Relay_Master_Log_File: mysql-bin.000018 Slave_IO_Running: Connecting 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: 107 Relay_Log_Space: 107 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: NULL Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 2003 Last_IO_Error: error connecting to master 'replication@10.34.1.3 7:3306' - retry-time: 10 retries: 86400 Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 0 1 row in set (0.00 sec) </code></pre> <p><strong>In Master 2:</strong></p> <p>mysql> show slave status \G;</p> <p><em><strong></em>**<em>*</em>**<em>*</em>**<em>*</em>**<em>*</em>*</strong> 1. row <strong><em>*</em>**<em>*</em>**<em>*</em>**<em>*</em>**<em>*</em></strong></p> <pre><code> Slave_IO_State: Waiting for master to send event Master_Host: 10.5.224.12 Master_User: replication Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000019 Read_Master_Log_Pos: 107 Relay_Log_File: xx-xx-xx-relay-bin.000029 Relay_Log_Pos: 253 Relay_Master_Log_File: mysql-bin.000019 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: 107 Relay_Log_Space: 560 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 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 1 1 row in set (0.00 sec) ERROR: No query specified </code></pre> <p>Please help me. Your solution will guide me to resolve task. Thank you in advance. Regards, Udhyan.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USMainio
    1. USMainio
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POError during Master to Master Replication of MySQL server
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    2. VO
      singulars
      1. POError during Master to Master Replication of MySQL server
      1. USMainio
      1. VTFavorite
    3. VO
      singulars
      1. POError during Master to Master Replication of MySQL server
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload