I have an App connecting to an RDS instance on Amazon (r3.Large) and it's working smoothly. However, the boss does not like to spend ~ $1,000 bucks a month on it so we are moving In-house.
We are getting Dell servers with two physical Xeon processors and a ton of RAM, basically an r5.2XLarge r5.4XLarge RDS instance.
I'm no expert on Linux systems and I have installed MySQL through the XAMPP package from Apache friends before but I never get the same result twice. (I'm a newbie, please be kind).
The server is going to be used primarily as a LAMP server, so other web-based apps will be using MySQL as well. The App that uses the current RDS instance on amazon is a set of 3 executables for windows, each one of these executables uses its independent connection to the DB.
We have +500 PCs through 3 different locations but we are planning on expanding to +700 PC by next year.
We estimate we will be having around 5,000,000 to 5,500,000 queries by hour on a busy day. And an average of 2,300 active connections to the DB.
A few times per day the Admin team runs heavy reports that are quite resource-intensive (the tasks take up to 40 sec to finish).
Besides quitting my job and find a better one, do you have any recommendations on the configuration and/or installation of MySQL on the server?
Assuming I have MySQL installed...
Should I modify the "my.cnf" file to avoid having errors like "too many connections" or issues trying to import/export the old DB?