I recently had a client ask me how to use Percona Toolkit tools with an SSL connection to MySQL (MySQL-SSL). SSL connections aren’t widely used in MySQL due to most installations being within an internal network. Still, there are cases where you could be accessing MySQL over public internet or even over a public “private” network (ex: WAN between two colo datacenters). In order to keep packet sniffers at bay, the connection to MySQL should be encrypted.
If you are connecting to Amazon RDS from home or office (ie: not within the AWS network) you better be encrypted!
As there is already a MySQL Performance Blog post on how to setup MySQL SSL connections, we can skip that and dive right in.
As you probably know, the mysql client …[Read more]