We have installed App and DB on a single server with 2 core and 8 GB configuration. I have set the innodb_buffer_size to 3 GB. We are now having performance issue with CPU reaching 100% many a times( used htop) . We are planning to increase the configuration. We are contemplating on the below two approach.
Increase the single server to 4 Core and 16GB Ram and set the innodb_buffer_size to 8GB.
Have Separate Server for DB with 2 core and 8GB and keep the previous server only for App.
Would like to hear feedback about existing deployments and the also which approach would be more advisable.