MySQL remote host over SSL

[Michal-pl]

SYSTEM INFORMATION
OS type and version	Ubuntu Linux 20.04.5
Virtualmin version	7.3-1

Hello everyone!

I have a high traffic Prestashop store on a VPS with 8 vCPU and 16GB RAM. The MySQL server generates a high CPU load, so I decided to migrate the database to a second (remote) VPS with 4 vCPU and 8GB RAM to balance the load.

In System Settings → Database Servers - there is an option to add a remote host, but I don’t see an SSL connection option. Is the connection protected by SSL by default?

If I add a remote MySQL server in this way, will Prestashop on the first VPS be able to connect to it via localhost, because Virtualmin will take care of the remote SSL connection? Presta does not support SSL connections for remote database servers, so I hope this is the right solution.

I will be grateful for any advice on this matter.

[Michal-pl]

Any suggestions? Sorry for the lack of patience but it’s urgent

[shillongserver]

What do you get when you run the following in mysql?

SHOW VARIABLES LIKE ‘%ssl%’;