Schedule Provisioned Database On or Off

  • how-to
    +
    You can schedule when your provisioned database is on and off to save costs.

    Turning off your database turns off the compute for your cluster but the storage remains. All of your data, schema (buckets, scopes, and collections), and indexes remain, as well as your cluster configuration, including users and allow lists.

    When you turn your provisoned database off, you will be charged the OFF amount for the database.

    Private endpoint charges still apply when your database is off. To avoid charges, delete your endpoints and turn off Private Endpoints before you turn off your database.

    Variable backup and data transfer costs still apply when your database is off.
    Public API

    You can also schedule your provisioned database to turn on or off using the Public API:

    When a Database is Turned Off

    Linked App Services

    • Linked App services will be turned off.

    Application and client connections

    • Application and client connections will be disconnected.

      You cannot connect to or read/write from your database.

    • You will receive an authentication error if you try to connect to a provisioned database that is off. Verify the database status if the application returns an authentication error.

    Replications

    • Replications will be deleted.

    Backups and scheduled backups

    • Backups cannot run, be downloaded, or restored - even to another database.

    • If the database is scheduled to turn off while a backup or restore operation is running, Capella waits for the operation to complete before turning off the database. If you try to manually turn off the database while a backup or restore operation is running, Capella will return an error and the database will not turn off.

    Maintenance

    • If the database is running maintenance or due to run maintenance in the next hour, the database cannot be turned off manually or through a schedule.

    • When the database is turned back on, it might need maintenance. Avoid scheduling an off soon after turning your database back on.

    Schedule Database On/Off

    To schedule your provisioned database:

    1. Log in to your account and click Databases.

    2. Choose your provisioned database to go to your database page.

    3. Click on the Settings tab.

    4. In the navigation menu, click Schedule On/Off.

    5. Choose your timezone for your schedule from the drop-down list.

    6. Choose the day and time ranges you want your database to be on.

      To add different time ranges for different days, click + Add Scheduling Row to add new rows.

    7. Click Start Schedule.

    Capella will not turn off the database if a database backup is running, if maintenance is running, or if maintenance is scheduled within 1 hour. If a database that is off requires maintenance, the maintenance begins when it turns on.

    Edit Database Schedule

    To edit your database schedule:

    1. Log in to your account and click Databases.

    2. Choose your provisioned database to go to your database page.

    3. Click on the Settings tab.

    4. In the navigation menu, click Schedule On/Off.

    5. Click Edit Schedule.

    6. Edit your timezone, day, and time ranges as needed.

      To add different time ranges for different days, click + Add Scheduling Row to add new rows.

    7. Click Start Schedule.

    Delete Database Schedule

    You cannot recover a deleted schedule.

    To delete your database schedule:

    1. Log in to your account and click Databases.

    2. Choose your provisioned database to go to your database page.

    3. Click on the Settings tab.

    4. In the navigation menu, click Schedule On/Off.

    5. Click Delete Schedule.

    6. Type "delete" to confirm and click Delete Schedule.