$5 MySQL / PostgreSQL instances [idea]?
Would you use shared mysql/postgres instances to lower the cost of your side hustle database costs?
How it would work:
- pool 5-10 IHers together to share a DB
- only allow access to the IPs those 5-10 people need
- each person can only see their tables
- instances would be hosted on GCP (Google)
Why:
- Hosted mysql instances can get damn expensive
[Edit: This idea died a quick death (in the best way). Very much appreciate everyone's comments! I didn't even write a single line of code :) ]
Trending on Indie Hackers
Can you elaborate? You can set-up a one-click DigitalOcean image with MySQL for $5/mo.
Setting up a DigitalOcean db is easy, maintenance like db updates... backups.. etc is the headache work.
If someone give me half the storage of DO and they maintain the Database I will surely go with them.
I had several MySQL and MongoDB database (for small-medium websites) for many years and never did any maintenance. What kind of maintenance do you do for your databases?
DO also offers full backups for $1 extra per month.
Yes, if you are a company with millions of users you might have a more complicated setup, but I think for basic needs this is enough.
That's nice to know that you never had issues with your DO mysql stability.
I have over 10,000 users for my side projects. Currently most of them are on firebase db. My main concern is performance optimizations over the time and security updates. And for backups (yes DO 1$ backups sound very tempting) I am planning to setup DO db soon and know the drawbacks firsthand.
I have more than 700,000 users on my side project, and I never had issues with my $5 (then $10, and now $15) mysql server. Actually I got issues when I tried their hosted MySql service, there were limitations everywhere. But then I decided to go back and use a regular droplet with mysql installed on it and that was it.
Thank you, your comment gave me confidence. I will try it soon.
With all the fancy networks, you need $150/mo in niche hosting services just to run the "Hello world" website nowadays 🤣
What do you mean? You can get that running on basically any VPS for $5/mo.
A joke. New frameworks that are supposed to be helping, are adding so many levels of complexity, that $5 VPS is not sufficient and/or not cool enough.
What about the 10k rows for free on the hosted Postgres on Heroku? Should be enough for most people to get started I'd say.
agree, this is enough. I'll kill this.
That's only if someone is using heroku. On DO, you can get a base database for $10/month with no standby. It gets expensive when you want to get a HA setup with read replicas.
I would purchase at the other end of the spectrum. 128gb RAM, proper CPU, backups, hot standby. But less than the $7k per month that I currently pay to Amazon.
You pay 7k per month to Amazon for MySQL?
Postgresql with multi AZ and one additional read replica.
I’d love to learn more about your setup. Do you have 15min for a quick chat? My email is [email protected] or share yours and we can set something up.
What about charging per request rather than an hourly rate? Would have to handle autoscaling on the backend.
Hey I found this post from my own blog about sharing a server. http://blog.brainless.in/2006/10/share-our-web-hosting-server.html
It used to be a thing, but that's 13 years old :D
Setup a Packetriot tunnel (free and paid starts at $5/mo) and you can host any number of databases and web applications and almost all of your CI/CD infrastructure too. You can filter IPs and protect web sites with an additional password. Our client manages Let's Encrypt certs for you automatically (once you setup DNS and verify ownership of said domain).
And your setup is portable, you can change networks or locations and everything will work.
Use aiven.io postgresql as a service for a few month. Could turn on and off with one click if your app is still under development phase so you could save some money.
They have some insanely good pricing. How's your experience so far?
Ay,
On my side I'm using Scaleway Managed Database : https://www.scaleway.com/en/database/
It's not so expensive and it's nicely managed. :)
Did we just go full circle back to shared bare metal?
I like this idea and I am actually planning a shared small business software suite around this. For context I come from early days (pre cloud) era when some developers would rent a bare metal and we shared access/cost.
I am not sure IH is the place for this idea though. Lots of techies who are aware of the market and willing to register for the next free host.
Pitch this to small businesses who need not just DB, but a host of open source software and share cost and you have a product to sell.
haha, perhaps! Cloud can get quite expensive.
This wasn't what I had in mind, but there are a few bare metal players doing really interesting things. I'm not sure I'm the right guy to run that business (and agree IH isn't the place for that kind of thing) but I like your bundling idea.
Free instance of Postgresql on Heroku is enough for start and is free.
Idea killed, thank you!
Hmmm I have free instances of PostgreSQL from Elephantsql.
never heard of them, but that's neat. I'll kill this. bad idea. At least i didn't build it!
:( Yes, but I know your feelings. It's hellish hard to find a problem that doesn't have a free solution nowadays :(
This comment was deleted 3 years ago.
That seems more than twice as expensive as DigitalOcean's managed Postgres database, am I missing something?
DO: 1GB Memory, 10GB Disk: 15$
Jaws: 1GB Memory, 5GB Disk: 35$
This comment was deleted 3 years ago.
The price and specs are the same for MySQL and Postgres at DigitalOcean, just in case you ever think about saving some money down the road :)
This comment was deleted 3 years ago.