I am trying to set up a MySQL slave to use replication via SSL.
The my.cnf file contains the following:
server-id = 1012 master-host = host master-port = port master-user = user master-password = password ssl-ca=/etc/mysqld/ssl/ca-cert.pem ssl-cert=/etc/mysqld/ssl/client-cert.pem ssl-key=/etc/mysqld/ssl/client-key.pem
Starting the slave fails with SLAVE STATUS showing
When I manually set up the slave as follows:
CHANGE MASTER TO MASTER_HOST='host', MASTER_USER='user', MASTER_PASSWORD='secret', MASTER_SSL=1; START SLAVE;
Everything works. Any idea what parameter I need to enter into my.cnf in order to force the slave to use SSL? The obvious choice - "master-ssl=1" did not work.