Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Digital Ocean Managed Databases

try.digitalocean.com

Post reply on HN
Print view View original

61–70 of 171 posts

Re: Digital Ocean Managed Databases

#61

Post by doh »

manigandham wrote: post #52
doh wrote: post #27

Earlier quoted context omitted.

I believe most of those are offered by Citus Cloud [0]. I know it's not the same, but you can spin just a single worker and essentially end with a faster PG than the vanilla PG. [0] https://www.citusdata.com/product/cloud

It starts at a minimum of 2 workers. And the pricing is steep too. The workers only operate on distributed tables so if you can't shard your data then you won't get any use out of those nodes, and sharding comes with its own problems. Citus isn't recommended unless you really need the size and want to stick with Postgres/OLTP.

Didn't know it's 2. Pricing may be steeper in comparison, but it provides more than just a hosted PG.

You are absolutely correct that you have to shard your data to take an advantage. It's not equal to vanilla PG. It's an alternative though.

Re: Digital Ocean Managed Databases

#62

Post by menacingly »

sdegutis wrote: post #12
nerdywordy wrote: post #6

I for one have always liked the simplicity of DO for hosting but I've never wanted to take on the full liability of self-rolling a DB server (and backups and replicas). So everything my company has I've put on heroku or azure. This has potential to be really significant as I'd wager there are a lot of folks in similar situations.

If you have a relatively small set of users, setting up your own database is usually as simple as setting it up locally and you won't need shards or anything. And setting up backups is as simple as adding a cron job that calls your backup shell script, which you can test separately. And by "small set of users", consider what SQLite's own website[1] says: Generally speaking, any site that gets fewer than 100K hits/day…

For small user counts, performance is the easy part. Failover and point-in-time restores are common examples for me that contain easily overlooked details and you don't find out until the worst possible time.

I think some cloud stuff is overpriced, but RDS easily pays for itself in my case.

Re: Digital Ocean Managed Databases

#63

Post by tejasmanohar »

Scarbutt wrote: post #20
sdegutis wrote: post #12

Earlier quoted context omitted.

If you have a relatively small set of users, setting up your own database is usually as simple as setting it up locally and you won't need shards or anything. And setting up backups is as simple as adding a cron job that calls your backup shell script, which you can test separately. And by "small set of users", consider what SQLite's own website[1] says: Generally speaking, any site that gets fewer than 100K hits/day…

Agree sqlite is great and >80% of websites will probably run fine on it, but 100K hits/day is pretty vague, does that mean 1 hit/sec or 3 hits/sec during peak time, etc...?

Even if that's clarified, it's vague. It doesn't entail how a hit translates to database operations.

That said, I think it's more meant to be an anecdotal rule of thumb to tell people "you're not Google, SQLite will work for most teams".

Re: Digital Ocean Managed Databases

#64

Post by amirexdev »

marpstar wrote: post #59
timdev2 wrote: post #54

Earlier quoted context omitted.

Mostly because databases are the key piece o data-persistence infrastructure. Spinning up a MySQL db to dev against, or a single server for a hobby project is quick and easy. In production, all of a sudden you have a lot of work to do, especially around HA. Figure out replication, get it working, figure out how to monitor/alert if it stops working, figure out failover, figure out how to test that failover actually wo…

For me it isn't even this complicated. I just don't want to have to manage OS/MySQL/Postgres version upgrades or worry about having to troubleshoot when things on the server go south. Just give me a database to connect to and take my money, please.

I think you mean, shut up and take my money :)

Re: Digital Ocean Managed Databases

#66

Post by RSZC »

inscrutable wrote: post #19
joshgachnang wrote: post #11

That's really exciting! DO is knocking it out the park lately as "AWS...but easy to use". I'd love to see Mongo as a managed DB.

Mongo licensing prevents DO doing this themselves, although they could partner with them.

Currently using Mongo Atlas free tier for a side project - it's been pretty wonderful so far

Re: Digital Ocean Managed Databases

#67

Post by jarland »

joering2 wrote: post #21
tnolet wrote: post #14

Just started using the new Kubernetes offering on Digital Ocean. Still in Beta but works pretty good. If this is a sign for how they will do databases, I'm all ears. Add CI/CD and you have a Heroku competitor.

Glad you are having fun working on your after hours side project with DO. But please DO NOT host with DO if you plan to run a real production systems, build a company, hire people etc. I have never found a better company to spun off a server and play with some settings but when their algorithm decides there is something fishy, bye bye your account, servers, backups, you never going to see any of this ever again. The…

Hey friends! My name is Jarland and I'm on the support team at DigitalOcean. We do have a number of fraud and abuse algorithms, and when we are alerted to potentially fraudulent activity, we take appropriate action, which includes notifying and communicating with individual users. I also want to confirm that we are fully compliant with GDPR.

Re: Digital Ocean Managed Databases

#69

Post by mtw »

Would be great to see a benchmark vs a database in a regular DigitalOcean droplet, or information about hardware. This information would be useful for projects requiring high performance per sec.

Re: Digital Ocean Managed Databases

#70

Post by timmaah »

I see some DO employees around.. What is the trick for getting access to the new Kubernetes and/or postgres betas? I'd love to use both for my side hustle (Currently on normal DO droplets)

EDIT - I now see the kubernetes option in my DO account. Thanks!

Post reply on HN