Is it worth creating a separate VM for the DB? I have my own Server
Hello, I think Cem tried using a separate server dedicated to Mysql without good results
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.
Hello, I think Cem tried using a separate server dedicated to Mysql without good results
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.