Live Music Jukebox
engineering
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!
DigitalOcean or Scaleway can provide a very cheap server. If you're looking for the equivalent of Firebase real time update feature, look at PostgreSQL instead. If you add a Hasura GraphQL server to it you can get what Firebase does but with rich SQL capabilities. You'll need to switch to GraphQL protocol though, which is not bad by itself.
VP Engineering @ Blueboard
Budget?
Founder, MD @ PivotNorth Capital
@Arin Sarkissian
Researching my next Startup
Hi - check out this link. I'd be surprised if you couldn't find a setup that didn't meet your performance and pricing needs. (Also being so pervasive there's lots of people with admin experience with aws) - https://aws.amazon.com/rds/mysql/pricing/