Mysql replication connection issues when enabling ssl on replication

1

→ i tried to enable ssl on replication using below

CHANGE MASTER TO MASTER_SSL = 1 ;

CHANGE MASTER TO MASTER_SSL_CA = ‘/opt/perconadata/ca.pem’ ;

CHANGE MASTER TO MASTER_SSL_CERT = ‘/opt/perconadata/client-cert.pem’ ;

CHANGE MASTER TO MASTER_SSL_KEY = ‘/opt/perconadata/client-key.pem’ ;

→ the above worked and it also changed Master_SSL_Allowed from ‘No’ to ‘Yes’

→ i then received Last_IO_Errno: 2026, i resolved this by below

CHANGE MASTER TO MASTER_BIND = ‘172.20.149.15’ ;

CHANGE MASTER TO MASTER_HOST = ‘172.20.149.15’ ;

CHANGE MASTER TO MASTER_PORT = 7306 ;

CHANGE MASTER TO MASTER_USER = ‘repl’ ;

CHANGE MASTER TO MASTER_PASSWORD = ‘Hypo^43d4Rde’ ;

CHANGE MASTER TO MASTER_SSL = 1 ;

CHANGE MASTER TO MASTER_SSL_CA = ‘/opt/perconadata/ca.pem’ ;

CHANGE MASTER TO MASTER_SSL_CERT = ‘/opt/perconadata/client-cert.pem’ ;

CHANGE MASTER TO MASTER_SSL_KEY = ‘/opt/perconadata/client-key.pem’ ;

→ i then received Last_IO_Errno: 2003, i resolved this by below

CHANGE MASTER TO MASTER_BIND = ‘172.20.149.15**:7306**’ ;

CHANGE MASTER TO MASTER_HOST = ‘172.20.149.15’ ;

CHANGE MASTER TO MASTER_PORT = 7306 ;

CHANGE MASTER TO MASTER_USER = ‘repl’ ;

CHANGE MASTER TO MASTER_PASSWORD = ‘Hypo^43d4Rde’ ;

CHANGE MASTER TO MASTER_SSL = 1 ;

CHANGE MASTER TO MASTER_SSL_CA = ‘/opt/perconadata/ca.pem’ ;

CHANGE MASTER TO MASTER_SSL_CERT = ‘/opt/perconadata/client-cert.pem’ ;

CHANGE MASTER TO MASTER_SSL_KEY = ‘/opt/perconadata/client-key.pem’ ;

→ I then received Last_IO_Errno: 2005, i am now stuck, any help?

1 Like