Comment to DB separate VM , is it worth it?
-
Yes as Baloo mentioned I tested seperate mysql scenario.
The important thing is both the app and database servers should be powerful.
With innodb disabled, with aria engine it goes to an acceptable speed.
Normally separate mysql server scenario should be considered when one very powerful server is not enough.
İn this case you will have a minimum of 2 app servers + one database server and load balancer.
All in a private network.