3 ms·
I love PlanetScale and if I had one request it would be a plan between Hobby and Scalar (or even a way to combine multiple DBs in 1 plan, and no 2 prod branches
by joshstrange 3y ago
I love PlanetScale and if I had one request it would be a plan between Hobby and Scalar (or even a way to combine multiple DBs in 1 plan, and no 2 prod branches won't cut it).
I have 2 paid Scalar DBs on PlanetScale and I have no intention of moving elsewhere but it does kill me that they both sit almost unused ~10 months out of the year (I have bursty traffic and only during the events, in-person events, that the software is built for). At ~$348/yr per DB it's still a steal compared to managing it all myself but I look at my usage (even during my "busy" months) and I barely make a dent in the usage tier I'm on. In fact I think you could total up my total usage for the lifetime of my account (both DBs) and they wouldn't total up to 1 month of the usage tier.
Again, I'm not complaining and the cost is manageable but I did create and sell some new software in the last year that I built on DynamoDB (in part to learn, in part due to costs). My software that uses PS is single-tenant so I need 1 per client which is on me, if I was able to rewrite it to be multi-tenant then I'd only have to pay $348 total a year instead of per-client.
All in all I have had nothing but good experiences with PlanetScale from the product itself to the support staff. I love the migrations and the rollback support, it feels natural when you start using it and dealing with migrations in other DBs feels like a huge pain once you've done it in PlanetScale.
- hu3 3y agoI'm interested in using PlanetScale. Would you happen to know the magnitude of how many simultaneous connections could $348/yr buy me in PlanetScale? One of my clients hovers around 50 simultaneous connections to their main MySQL server on a normal day, but they have bursts of 3k simultaneous connections for an entire day, twice per year. Their workload is about 5% writting (INSERTs, UPDATEs), 95% reading (SELECTS).
- tbarn 3y agoThis number of connections on any of the paid plans should be no issue.
- purelogiq 3y agoPlanetscale advertises up to 10,000 concurrent connections on their $29/mo Scalar plan (https://planetscale.com/pricing https://planetscale.com/pricing - click on "Compare all plan options and benefits"). Being based on Vitess as well, I believe that number.
- gsanderson 3y agoThe blog post shows both the Scaler and Scaler Pro plan supporting up to 10,000 concurrent connections: https://planetscale.com/blog/announcing-scaler-pro#scaler-pro-pricing https://planetscale.com/blog/announcing-scaler-pro#scaler-pr...
- no_wizard 3y agoyou might find Supabase[0] is closer to what you need. I'd recommend giving them a look, that is, if MySQL compat isn't a requirement of course, since Supabase is all PostgresSQL. disclosure: not a employee or investor in Supabase, but I sure am a fan. [0]: https://supabase.com/ https://supabase.com/