Live Music Jukebox
I'm on the hunt for a dedicated server that will be running a MySQL database and Express server, most likely on a Linux instance. I've considered using a bigger company like GCP, AWS, Azure but have found that they tend to be a bit overpriced/ may be overkill for what we need. I've began exploring some smaller companies, most of which are referenced on https://www.hostingadvice.com/how-to/web-hosting-prices/.
Some things to note:
- At the moment, we are using Firestore, a Firebase product, as a database. It also provides a socket-like real-time updating system.
- I would like to switch to MySQL since the current database schema is built in a relational manner and will allow me to batch-read data.
- We currently have a maximum of around 200 concurrent socket connections on a busy day.
- We need to consider scalability.
All help/advice is appreciated. Thank you!