I am trying to secure my db servers secured on the live setup. I have read it like we can enable ssl in mysql to make the data transfer over the network between master and slave to be encrypted.
Shall someone help on how can i know whether i have the ssl support or not. If i have how can i enable this as i cant compile a binary again with --have-ssl
Thanks in advance.
Try starting MySQL with
mysqld --ssl --help
If the server does not support SSL, you'll see an error:
[ERROR] mysqld: unknown option '--ssl'
On running server, you can check
mysql> SHOW VARIABLES LIKE 'have_ssl'; mysql> SHOW VARIABLES LIKE 'have_openssl';