0

Mysql : mater-slave not connecting

Hi...,

i have installed and configured mysql master-slave configuration on centos. i configured all setup what it exactly appears in websites but still my replication process is not working... finally i checked master status its shows slave running status is No.... i attached that error below please guide me to solve this issue....

mysql> SHOW SLAVE STATUS\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: master1
Master_User: root
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000004
Read_Master_Log_Pos: 931
Relay_Log_File: slave1-relay-bin.000056
Relay_Log_Pos: 950
Relay_Master_Log_File: mysql-bin.000004
Slave_IO_Running: No
Slave_SQL_Running: No

Replicate_Do_DB:

nathan
asked Aug 31, 2017
1 Answer
0

in my thoughts this error occurs due to mysql port is blocked in firewall... please check your firewall settings allow mysql port into firewall and retry the replication process........

nathan

yes this mistake happened due to mysql port blocked in firewall...... once i allowed mysql port into firewall now the replication working fine.... thanks a lot.......

View More
arunkumarak
answered Aug 31, 2017
Your Answer
||||
 
100:0