Last_io_error Error Connecting To Master
Contents |
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might error connecting to master - retry-time 60 retries 86400 have Meta Discuss the workings and policies of this site About
Error Connecting To Master 1045
Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads error connecting to master mysql replication with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to error connecting to master error_code 2003 improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Replication on MySQL server up vote 0 down vote favorite I had to
Slave_io_running Connecting Slave_sql_running Yes
stop the slave server to test something. After I started the server again there is a problem with replication on MySQL server On the problematic server mysql> SHOW SLAVE STATUS\G *************************** 1. row *************************** Slave_IO_State: Connecting to master Master_Host: servera Master_User: replica Master_Port: 3306 Connect_Retry: 60 Master_Log_File: servera-bin.000024 Read_Master_Log_Pos: 808459481 Relay_Log_File: serverb-relay-bin.000071 Relay_Log_Pos: 4 Relay_Master_Log_File: servera-bin.000024 Slave_IO_Running: No 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: 808459481 Relay_Log_Space: 106 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: 1129 Last_IO_Error: error connecting to master 'replica@servera:3306' - retry-time: 60 retries: 86400 Last_SQL_Errno: 0 Last_SQL_Error: on the problematic server: SELECT user, host FROM mysql.user WHERE Repl_slave_priv = 'Y'; +---------+-----------+ | user | host | +---------+-----------+ | root | localhost | | root | serverb | | root | 127.0.0.1 | | replica | servera | | replica | serverb | +---------+-----------+ on the main server: SELECT user, host FROM mysql.user WHERE Repl_slave_priv = '
here for a quick overview of the site Help Center Detailed answers to any questions last_io_errno: 2003 you might have Meta Discuss the workings and policies of last_io_error error connecting to master retry time 60 retries 86400 this site About Us Learn more about Stack Overflow the company Business Learn more about hiring
Mysql Replication Error Connecting To Master 2003
developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a http://dba.stackexchange.com/questions/37135/replication-on-mysql-server community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Error during Master to Master Replication of MySQL server [closed] up vote 1 down vote favorite 1 I have setup Master to Master Replication on MySQL server 5.2 with my existing database. I http://stackoverflow.com/questions/12935128/error-during-master-to-master-replication-of-mysql-server 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: Master 1: mysql> show slave status \G; ************* 1. row ************* 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) In Master 2: mysql> show slave status \G; ************* 1. row ************* Slave_IO_State: Waiting for master to send event Master_Host: 10.5.22
2 Configure The Slave On the slave we first have to create the database exampledb: mysql -u root -p Enter password: CREATE https://www.howtoforge.com/mysql_database_replication_p2 DATABASE exampledb; quit; If you have made an SQL dump of exampledb on the master and have transferred it to the slave, then it is time now to import the SQL dump into our newly created exampledb on the slave: mysql -u root -p