Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am trying to set up replication with slave on Amazon EC2 and master in our local environment. The setup went fine without SSL encryption. But when I set up the replication to be SSL encrypted, it is failing to connect to Master.

MySQL version on Master : Server version: 5.5.19-log MySQL Community Server (GPL)
MySQL version on Slave : Server version: 5.5.14-log MySQL Community Server (GPL)

I have SSL encrypted replication set up and going fine where the Master's MySQL version is Server version: 5.1.56-log Source distribution. But it is failing for the other Master machine which has MySQL 5.5.

So my question is, does SSL encrypted replication work for MySQL 5.5?

Anyone here faced the same problem? Please throw some light on how to get around this problem. Note that I have changed the permissions for my SSL certificates used in Slave machine to be mysql instead of root (Both failed anyway)

Thanks.

share|improve this question
add comment

1 Answer

To use SSL for encrypting the transfer of the binary log required during replication, both the master and the slave must support SSL network connections. If either host does not support SSL connections (because it has not been compiled or configured for SSL), replication through an SSL connection is not possible.

Setting up replication using an SSL connection is similar to setting up a server and client using SSL. You must obtain (or create) a suitable security certificate that you can use on the master, and a similar certificate (from the same certificate authority) on each slave.

For more information on setting up a server and client for SSL connectivity refer this link

Please follow the steps mentioned here:

http://dev.mysql.com/doc/refman/5.1/en/replication-solutions-ssl.html

I was searching in bugs.mysql.com related to MySQL 5.5 but there is nothing reported w.r.t "replication with SSL" for v5.5. You can mention exact error message here for analysis.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.