Articles in this section

See more

Understanding SingleStoreDB Cloud Backup and Point In Time Recovery (PITR) Features

{question}

What processes are involved in the backup and restoration functionalities of SingleStoreDB Cloud?

{question}

{answer}

SingleStoreDB Cloud provides robust data backup and recovery features to ensure the integrity and availability of your data. This Knowledge base article outlines the automatic daily backup process, how to request restores, and additional options for creating and managing backups through SQL.

  1. Automatic Daily Backups:

    • SingleStoreDB Cloud automatically backs up your data daily on a default schedule.
    • The retention period for these backups is set to 7 days.
    • All backups are stored securely in Cloud Storage for easy accessibility and retrieval.

    Note: If you need a restore from a specific day within the last seven days, you can initiate the process by requesting a restore through our support ticket system.

  2. Modifying Backup Schedule:

    • If the default backup schedule does not suit your needs, you have the flexibility to alter the scheduled backup time.
    • To make adjustments, raise a support ticket, and our team will assist you in configuring a backup schedule that aligns with your requirements.

  3. Manual Backups via SQL:

    • In addition to automatic backups, users can create manual backups through SQL using the Studio or Command Line Client.
    • Backups can be directed to your preferred cloud storage service, such as AWS S3, Azure Blob storage, or GCS. Click here to learn more.
    • Restoration of data from these backups can be performed as needed.

    Important: Only full backups are supported; incremental backups are not available.

  4. Point In Time Recovery (PITR):

    • SingleStoreDB supports Point In Time Recovery (PITR) for Premium and Dedicated Editions.
    • PITR allows you to recover your database to a specific point in time, offering enhanced data recovery options.

    For more details on Attaching an Unlimited Storage Database Using PITR and Online PITR, please refer to the provided links.

    Attaching an Unlimited Storage Database Using PITROnline PITR

  5. Backup Considerations for Workspaces:

    • Workspaces in SingleStoreDB Cloud take backups against databases attached in “Read & Write” mode.
    • It's essential to note that workspaces with databases attached in “Read Only” mode are not backed up as part of the automatic process.

By leveraging these backup and recovery features, you can ensure the security and availability of your data while having the flexibility to manage backups based on your specific needs. For detailed instructions and further information, refer to the provided links throughout this article.

{answer}

Related articles