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.