I've got a mysql server with in North America (using Amazon RDS) and a read replica. I've also got a read replica for a new region - Australia.
The Australian server is brutally slow due to the dynamic nature of Joomla reading off the main DB server in N.America. I've tried to use mysql proxy for this to split the read/write but that isn't a long term solution. Mysql proxy looks to be effectively dead.
What other options do I have?