I got to the point where I want to separate the MySQL database from the server where the website resides. And keep those 2 parts separate so I can do load balancing of the web servers later.
How do I calculate what resources I would need for the MySQL db server? At the moment there are some slow queries in the app which I cannot avoid, so this is why I want to separate the DB and increase the resources to handle more connections and more queries.
Would be better to have 2 replicated db servers and implement load balancing? What would be the best practice for that?
What would be the best practices for my situation?