Digital Ocean Managed Databases
try.digitalocean.com
try.digitalocean.com
Generally speaking, any site that gets fewer than 100K
hits/day should work fine with SQLite. The 100K hits/day
figure is a conservative estimate, not a hard upper bound.
SQLite has been demonstrated to work with 10 times that
amount of traffic.
If SQLite is able to comfortably handle 100k hits/day, I imagine that more "legitimate" databases can handle more traffic comfortably without needing to jump to scale horizontally.[1] https://www.sqlite.org/whentouse.html under "Websites" section
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".
It really depends. Also, configuring everything right gets hard. Most don't even think to do RAID over a few block storage devices, but that's something that comes with cloud storage. That doesn't count HA and other issues before getting to the application layer.
It's something that unless you're paying a full-time DBA, you are probably better off buying as a service. It's one of the few holes in DO's offerings and I'm very happy to see this.
The SQLite website (https://www.sqlite.org/) uses SQLite
itself, of course, and as of this writing (2015) it handles
about 400K to 500K HTTP requests per day, about 15-20% of
which are dynamic pages touching the database. Dynamic
content uses about 200 SQL statements per webpage. This
setup runs on a single VM that shares a physical server
with 23 others and yet still keeps the load average below
0.1 most of the time.I think some cloud stuff is overpriced, but RDS easily pays for itself in my case.
Notably, the SQLite website is (as far as I can see) read-only. So it's great if all you need is a SQL read API atop your structured data (and 100k hits/day is probably only limited by the filesystem/os since SQLite isn't a server). But you're setting yourself up for headaches by using SQLite if you need simultaneous read/writes combined with HA.
- Not very willing to setup DBs for several projects both paid and hobby because it's a fixed time sink. And before anybody tells me "but with this script it can take 2 minutes!" please don't forget that to learn to use your magical script I have to learn a few other things beforehand. (Although admittedly that's most likely a small time investment.)
The more "best practices" I can automate the better since it reduces cognitive load on my poor noggin.
I seriously can't be bothered to setup yet another cool and young database promising me quantum entanglement teleportation anymore. It's what is stopping me from trying 99.9% of what I see on the net.
I have a few scripts to which I just pass a DB name / user / pass and it brings me up (or tears down) a Postgres or MySQL/Maria database. I'd do the same for Elastic and a few others if I wasn't so lazy about it for years now.
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 works, etc.
Support around that stuff has improved over the years, but it's still non-trivial and high-risk to DIY. It's a very different scenario than a stateless app server where you can have easy redundancy.
Just give me a database to connect to and take my money, please.
If we had staff to dedicate directly to this then it wouldn't be an issue. But paying for a managed service that gives us production grade data access is a no-brainer for any non-trivial application we build.
For hobby projects, a single self-managed instance is fine. For production in a business critical environment, much more thought needs to go in.
I'm happy to pay a few dollars a month for someone else to automate.
I prefer the managed services. Save for the high availability you get tons of best security practices -- all for a few bucks a month. It's usually a such a crazy cheap deal it's almost not fair to them.
Really asking, bc for next personal projects I was getting ready to abandon DO and use AWS Lightsail + RDS.
Hetzner is not a reasonable choice for servers IMO, its akin to hosting in a datahole in Dallas, expect mixed bandwidth quality and questionable policies when issues arise. Comparatively, OVH looks stable.
Scaleway doesn't take abuse reports seriously FYI, these attacks are still primarily coming from IPs announced by their ASN, over a year after this article was written: https://badpackets.net/ongoing-large-scale-sip-attack-campai...
Really surprised to hear that, can you please elaborate? I only heard good things about them up until now...
> Comparatively, OVH looks stable.
What kind of stable do you mean? Bandwidth, latency, average I/O ops, CPU load?
Hetzner does pay lip service to improving their network, but its akin to ColoCrossing, the internal network infrastructure is not amazing due to budget constraints, and the peering situation isn't apt to improve as its essentially money and politics that created it.
> What kind of stable do you mean (referring to OVH)? Bandwidth, latency, average I/O ops, CPU load?
I am referring to bandwidth, latency & jitter when comparing OVH to others. One thing OVH has nailed is keeping jitter minimal, and there has been significant optimizations for routes in their newer datacenters as time has gone on.
Mature OVH locations already have fairly good peering, to the point that many time sensitive workloads that can't be fronted/cached choose OVH in certain regions.
Its really sad to see Google Cloud and AWS flunking on this front, the lack of internal IPv6 support to the VM kills mobile performance, adding tens of milliseconds of latency and incurring a stateful connection in cellular carriers CGNAT (which gets killed after ~100 seconds), reducing performance and breaking long term open connections. Sending a packet over IPv6 to a cellphone is often faster than using push messaging on iOS or Android.
OVH Latency Optimizations: https://www.lowendtalk.com/discussion/comment/2873074#Commen...
Thanks a lot! Changed my perspective.
If I physically operate in the US and I base my servers in the EU, then I open myself up to not only US but also EU jurisdiction and compliance in a myriad of ways. It's an entirely unnecesary additional burden in exchange for a discount on infrastructure (which is rarely the biggest cost in anything these days).
I have no intention of ever complying with GDPR for example, unless I'm running a very large organization. Not because I disagree with most of GDPR, rather, because I'm going to comply with US laws, as that's my legal jurisdiction and those are the laws I'm governed by.
Hosting with Scaleway, OVH or Hetzner is a big jurisdiction mistake in most cases for smaller US organizations, just as it would be to arbitrarily host in Japan or China or Brazil (ie foreign locales with entirely different laws).
For everyone EXCEPT the US-based businesses, being multi-juristiction by default form the get-go is the default, you know. And for any small or freshly created projects GDPR compliance is pretty easy though. EU's new copyright laws though... those are an abomination, hope it changes before they start being enforced. Nowadays EU and US are probably equally horrible and competing at being the most horrible with respect to restricting internet freedoms.
What I'm actually looking for is hosting services that are outside of BOTH US and EU for some more side project ideas that risk falling on the wrong side of IP laws (US's DMCA and all are horrible too btw...). Something that would be both run by a non-US and non-EU company and with datacenters physically outside this space. Something in Middle-East, SE-Asia or Russia could have decent bandwith tot he rest of the civilized world and at the same time be blessed with the capability to delay/ignore/missfile etc. requests from US and EU authorities, giving you a time buffer to damage control if s really hits the fan, while serving end users in those regions. Maybe after Brexit even the UK could become a nice place with more freedom too.
For a DO only solution, I'd probably use SQL more and then rely on their blob (s3 compatible) storage for some bits. I have a few small projects that I've been getting anxious to finally work on, and don't want to spend a bunch of money on them in the interim.
In case of modest growth, I also don't want to be hamstrung doing DB operations work for something that isn't actually making me money... I'll split things up to save a bit in the nearer term so long as I can have a migration path.
If I did split with data in azure/aws and the apps in DO, I might go all azure later, or I might go all DO and take on the DB operations side... it depends on if/how things grow.
Also, PostgreSQL is described as powerful, reliable, full-featured, and fast, while MySQL as the most popular: that's all.
What is not said can be as important as what is.
Assuming managed K8S is next, or maybe more "AZ/Region" h/a features. Great to have a new player coming into this space. Especially one with reasonable egress charges.
The last startup I heavily pushed with switching to OVH or even Rackspace was exact sample of what happens when DO algorithm decides you are not genuine. That's it. No explanation, no phone number to call, nothing. These people blindly decided to believe their algorithm and never wanted even discuss resuming the account or even get us backup of data. There was nothing shady going on I assure you. Funny part is as of today DigitalOcean is still in violation of GPPR, as we have requested to hopefully find out what was wrong with our account by filing request for info. Nope, zit, nada, totally ignored. We have filed complain with proper authority and also notified Attorney General in NY and continue await result.
Build all you want on DigitalOcean, but please understand not people but their weird algorithm is in charge of the future of your startup, future of your company and future salary or lack therefore when you are forced to fire team of people because you fall behind with payroll. In other words: be warned and build at your own risk.
In the case of DigitalOcean when an account is flagged it is locked, which simply prevents a user from creating more resources and an email notification goes out to the user to establish a line of communication.
There is no service interruption, and certainly the account, it's droplets, and other resources are not deleted, and never deleted automatically when the account is initially flagged.
There are numerous communications that go out even if a user is unresponsive.
Edit: my original post got downvoted severely in few minutes from posting. Hello DigitalOcean staff and/or owners!
If you have a real complaint against DO, please provide specific allegations and support for those allegations.
I guess, one should also have backups off site. Relying on just one provider constitutes a single point of failure.
I love DO because the performance for the price is great. Also have no issue supporting emerging tech companies with cultures I connect with.
In the digital age, startups and businesses rely on cloud providers for their livelihood. These providers must be reliable and trustworthy, otherwise they shouldn't get a penny.
Also, I'm not intimately familiar with OP's situation, my comments are just common sense generalizations; I think!
I’m not going to comment any more on this situation as I don’t know all the details, I do hope I won’t see comments of unhappy DO customers on HN in the future, as that would be a sign you guys are not up to expectations.
P.S. I have been a happy DO customer for years; thus far (:
I use DO for production and have gradually migrated my infrastructure away from AWS and Linode to Digital Ocean as the platform improved.
Just a quick question: If the algorithm is triggered (regardless if it is a false positive or not) and the user is notified, what happens with the droplets in the meantime? Is there a grace period for the user to act before DO takes action? And is the whole account frozen or just the offending droplets?
It seems the major concern amongst commenters here is the sudden lost of service.
Thanks for the great service, and I look forward to your insight on this.
Those guidelines aren't published specifically because if they were, then the abusers would immediately begin to route around them, so it's meant to be opaque for a reason, but that is against fraudulent use, not legitimate use.
The account is also notified about the action and a dialogue is opened, to determine what the situation is.
There is no sudden loss of service. There is no loss of service without communication. If after multiple rounds of communication it is determined that the account is fraudulent, even then there is no loss of service that isn't communicated well in advance of the situation.
I'll never use DO for anything, even testing and mucking around. At the very least you would have to provide excessive evidence of identity if you get flagged by their magic algorithm, and if they restore your service it could be after days of wrangling with support (it took support over a day to answer my support tickets at the time).
Over 2 hours later and still no response to my support ticket asking why and how it happened.
I'll be interested in the response I get. Unless there's a good reason why, or a plan to prevent the how from happening again, I'll be shifting anything critical away from DO, and go back to just using it for spinning things up to play with or test on.
I guess getting your droplets cutoff in the middle of business day and waiting 4 days for customer support copy and paste template answer has to happen to everyone before they themselves realize how crucial over the phone support is when it comes to hosting a production website. Its all good anyways.
How are you liking the K8s on DO? I just got access a couple days ago but haven't touched it yet, I seem so out of the loop.
I have used it both for work and in personal projects and haven't ran into any issues/headaches.
DO, Lonnie Linode, and Vultr are very simple, so that's what I use. Perhaps if I start needing more from my hosting I'll look at AWS, but it's just not worth my time to figure it out for the scale of projects I'm doing.
EDIT - I now see the kubernetes option in my DO account. Thanks!
By the way this comes just a week after AWS Lightsail started offering the same. Excellent stuff. https://aws.amazon.com/blogs/aws/new-managed-databases-for-a...
Droplets <- EC2
Spaces <- S3
Managed Databases <- RDS
Would be great to have something similar for Redis.
They were generous enough, but at the expense of uncertainty + you needing to play an active role in getting them to pay your bill. Depending on what sort of service you run, it may be a constant ordeal.
After getting some large CloudFront bills taken care of, I left and wondered what sort of person had the stomach it.
Would DO be open to a limited 'hobby tier' for this set at the price of the droplet?
I’ve found Jaws DB works well for my needs (and pricing), but given they are layered on AWS it does feel like I’m still a bit limited - ie it would be good to still access the DB server so I can spin up multiple DBs (pre-prod, production etc), despite my usage being minimal.
If DO can hit a sub $10pm price point (even with severely restricted performance) that would be awesome!
#1 thing you can do to make this compete with RDS and Cloud SQL would be to support extensions out there that they don’t. HypoPG needed by Dexter, pg_partman, etc. Lack of certain extensions is the biggest failing of those offerings IMO.
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.
And there are tons of managed database hosting providers outside of Heroku.
https://news.netcraft.com/archives/2015/05/01/digitalocean-b...
I suspect that DO is a factor in AWS introducing Lightsail.
All the other stuff you need like logs and monitoring can be installed with helm charts.
[1] https://aws.amazon.com/blogs/aws/new-managed-databases-for-a...
[0]: https://blog.digitalocean.com/2018-mid-year-product-update/ (look at the bottom of the article)
I'm leading a team that is _literally_ days away from provisioning a cluster for an existing production SaaS application that's currently on DO vm's. Would prefer to stay with DO..
My email is in profile - happy to answer any questions.
I just added you so you have access to the product. I will reach out to the PM on DBaaS as well.
On the Subject of DO, I am wondering am I the only one who felt the need of 1vCPU to 1GB RAM droplet? Given the vCPU aren't even core but thread. Now that Managed DB is in place that is even more need for frameworks like Rails, my guess for other framework would need even less memory per process / Thread. I was hoping AMD EPYC will make that happen, but so far nothing has happened yet on all other VM hosting providers. May be EPYC 2.
And if DO will someday provide an CDN, or reselling of CDN through partnership.( Although BunnyCDN seems to be working great for me at the moment.)
Also interesting timing too. Amazon Lightsail (the cheaper AWS alternative) is similarly priced to providers such as DigitalOcean, Linode, etc and released their managed database offering the other day: https://aws.amazon.com/blogs/aws/new-managed-databases-for-a...
DO has definitely a lot to offer via some simple cloudy things as
1) Good ol VMS and load balancers - they already do
2) Managed K8s - may be they already do? I dunno
3) Managed DBs - good to see this.
4) Big fat blob store (like s3) - not sure. CDN that operates over blob store would be nice too.
With this pieces, one can develop quite a significantly complex and scalable application without worrying about infra.
AWS, Azure, GCP are wayyy too complicated. There’s definitely a niche for an IAAS Company to only do the few important things and do them better (speed, reliability, price) than the big 3 and steal a meaningful chunk of the market.
Not sure how deep it'll go in the managed usage, but very happy to see it. The one piece I've really felt was deeply missing.
I wonder how long they've been working on this.
bryan at priceflow.com
Here's to hoping that receiving access doesn't take too long ^_^
I know MemSQL back in 2017 announced managed services, but I'm pretty sure they closed it. Although I can't find a link.
I put up a few different sights on a droplet and have been preparing to make a switch over to Heroku exactly for the sake of the managed postgres.
Maybe I won't have to!
note: I'm not affiliated with DO in any way and pricing and capacity are only speculation.
I just hope it's not terribly expensive for the smallest tier.