We have an existing SAAS app that we are trying to scale as currently we can have up to 700 connections per second which is causing errors such as:
Can't connect to MySQL server on ‘[url removed, login to view]’ (99)
We are looking for a mySQL database admin who is very experienced with optimising database or web application (PHP in this case) for high volume transactions.
We want to be able to scale our application so that we do not encounter these time outs.
We currently have a dedicated VM for the database server with the following specs:
- 48GB ram
- 430GB ssd
- 4 Cores CPU
- debian 8.5
- Percona 5.5.49-37.9
Preference will be given to someone that can communicate via Skype and start right away.