I have a master slave replication where the application on the slave server needs to write to the master from time to time. When this happens, the writing is slow as the two servers are on different continents.
What is really slow is establishing the connection. Would it be possible to have a unique MySQL connection between the PHP project and the Master MySQL server and which will always be ready to write in the Master DB.
Thank you.