I was wondering how one might go about setting the
local.xml file (if it's even possible) for a Magento install to connect to a MySQL server over a secure connection.
I currently have my webserver and MySQL server hosted on different machines (in the Amazon Web Services cloud), and so I wanted to make sure that Magento communicates with the database over a secure connection.
Unfortunately so far I can't seem to find any workable answers for this, and considering how important security is for ecommerce sites, I would think this sort of configuration would be available in Magento out of the box.
I know from the command line you can invoke a mysql secure connection to Amazon with the following sort of example statement:
mysql -h myinstance.amazonaws.com --ssl_ca=rds-ssl-ca-cert.pem --ssl-verify-server-cert
rds-ssl-ca-cert.pem is a reference to the public key.
I guess I was thinking Magento must make a similar call using the
local.xml file, and that there ought to be a way to similarly invoke the secure connection.