I have both databases running with SSL, and I've tested to make sure I can connect to either server using SSL via the mysql client.
The question now is when I connect to the local, federated server using SSL, does the stream remain encrypted when the federated table connects to the remote table in order to pull the data?
Is there a way to test this to make sure the data is being encrypted over the stream between the remote and local databases?