{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 continuous backup for AWS/GCP customers, daily backup process for Azure customers and additional options for creating and managing backups through SQL.
1. For AWS and GCP, we have continuous backups available:
Continuous backups asynchronously store all customer data in unlimited storage (bottomless storage) ensuring that every change (inserts, updates, and deletes) is durably persisted with 99.9999% reliability.
With a default 7-day retention period, they allow you to restore your data to a point in time within this window using the always available point-in-time recovery (PITR) option.
- Continuous backups do not interrupt active jobs and do not impact your workload. Since data is continuously backed up in the background, it does not consume additional CPU resources, unlike full backups.
- You can restore your data whenever required, without the need to create Support tickets.
- You can recover your data while your primary database is online.
More details here.
2. Automatic Daily Backups (Azure):
- SingleStoreDB Cloud automatically backs up your data daily on a default schedule for Azure customers.
- 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.
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 Enterprise 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}