How sure am I?

What is my certainty that this database of mine or other users will not crash one day, what is the guarantee that it will stay that way for good, the servers will not crash, what is it all about, what are these databases
12 Replies
!!RoteXRFox
!!RoteXRFoxOP9mo ago
What do these databases stand on? :supabase:
garyaustin
garyaustin9mo ago
Supabase by default uses AWS EC2 compute instances for the DB and a few other things. Then one of the AWS filesystem solutions and s3 for storage. Other than that any solution you do should be backed up and you should have your own backups in addition to the providers backups if you are a serious business. All databases and compute are subject to crashing. And backups or using read replicas if large enough to deal with failure are important.
!!RoteXRFox
!!RoteXRFoxOP9mo ago
So if there is a failure in your company, the failure will only be in your company, not in the server room Because the server is on Amazon, right?
garyaustin
garyaustin9mo ago
Not sure if you mean Supabase by "your company". This is mainly a user helping user forum and not monitored regularly by Supabase. Your instance is standalone in the AWS center as far as compute/disk/etc. Common things are the dashboard mainly and that is run on Vercel last I checked.
!!RoteXRFox
!!RoteXRFoxOP9mo ago
I mean supabase, it is only on the server where the databases are, and the entire database and all of them are on Amazon, that's how I understand it Whether or not you explain it to me wrong, it is important to me
garyaustin
garyaustin9mo ago
Not sure what you mean by Supabase on a server. Supabase is an enhanced Postgres Database, and other server components like PostgREST and Auth. That is all on an individual EC2 instance. Realtime/Storage API/Supavisor are on shared AWS servers around the world. The Dashboard is a react application running on Vercel. I'm sure there are many infrastructure things like backups, logging that are dependent on Supabase to run. You can also take your data and selfhost.
!!RoteXRFox
!!RoteXRFoxOP9mo ago
So if there is a supabase failure, my database will work but there will be a problem with the dashboard, right?
garyaustin
garyaustin9mo ago
If you depend on storage/realtime/supavisor(pooler) those are on shared AWS servers. Your biggest risk is software updates that you can't control that break your code. Auth and all the shared things I mentioned can be upgraded at anytime. You do not control more than your database version. This is similar to any SaaS provider that updates OS's etc like AWS.
!!RoteXRFox
!!RoteXRFoxOP9mo ago
What if there is a supabase failure? I mean the website and the database will be exclusive, that's what I'm asking
garyaustin
garyaustin9mo ago
Supabase is alot of parts. The website has nothing to do with the dashboard or database. The dashboard can crash and the database instances keeps running. You can see the history of issues here: https://status.supabase.com/
Supabase Status
Welcome to Supabase's home for real-time and historical data on system performance.
!!RoteXRFox
!!RoteXRFoxOP9mo ago
So if the website goes down, the databases still work on other Amazon shared drives, right?
garyaustin
garyaustin9mo ago
Yes. But now you throw in the words shared drives. Your EC2 CPU instance is a single point of failure. There is no fail over or redundancy unless you do read replicas. But that is an AWS thing and not dependent on Supabase engineers.

Did you find this page helpful?