I currently have an application (API) hosted on a small server 1 GB RAM, 1 vCPU (Digital Ocean), the application read/writes to a MYSQL database which is also hosted on the same server.
I expect that the server will receive a huge POST requests soon, nearly 50K request per hour.
So the questions are, What do is your recommendation on upgrading the server?
Should I use a dedicated server for database? Should I use NGINX or Apache?, Is there custom settings needs to be done on the web server?; ex max concurrent connections, connection pool ..etc
Thank you