I try to connect with PHP to a MySql Server and it took in average 2 seconds to establish the connection.
We host our Database in Germany (Frankfurt) and the PHP-Application in Singapore.
We're hosting on AWS. Our Database Server is a RDS Multi-AZ instance (db.m4.2xlarge).
At the moment the connection is via public internet.
A solution would be to create a master/master replication for the Database, but it's not that easy on AWS and for the current usecase it's a little bit overengineered.
Is there any way to reduce the latency? Is it faster to establish the connection via a VPN?