How does Render handle database maintenance?

With Heroku, they’ll create a standby follower and transfer my application over to the follower then do maintenance on the other one.

I’ve been with Render since October and I’ve not seen an update on our database instance yet?

Has any been done in the background without me noticing at all?

Hi Che,

You’ll be notified via email and a banner in the dashboard when your database is nearing its scheduled maintenance window.

1 Like

Thanks, still have a few questions below:

  • How often are the maintenance windows?
  • What effect do maintenance windows have on my application?
  • Does my app experience any downtime?
  • If so are there ways to perform zero-downtime DB maintenance?

hey @shantanu could I get a response on my follow-up questions.

Hi @che ,

  • How often are the maintenance windows?

We don’t have a specific schedule, since it depends on when maintenance is necessary, but it tends to be on the order of many months between required maintenance.

  • What effect do maintenance windows have on my application?

During the maintenance window, we might need to restart your database, which usually takes a few minutes to complete before your database is able to serve queries again.

  • Does my app experience any downtime?

Your app will be unable to use the database during the few minutes of database downtime. The downtime isn’t during the entire maintenance window, but will just be a period during the maintenance window when we are restarting your database.

  • If so are there ways to perform zero-downtime DB maintenance?

We know zero-downtime databases are important, and a requirement for many use cases, and are planning on adding support in a coming update to our database product. Unfortunately, we don’t have a specific timeline for this, so I can’t promise a time when you’d be able to use it.

Please let me know if you need any more clarification, or have any more questions.

1 Like