What is Point-in-time-recovery (PITR)?

A process to restore the database state to a particular point in time. This is often achieved by first restoring the database using a base backup (baselining) and then replaying the change-data-capture (CDC) logs up to the desired point in time.

External reference

Database schema migration and version control, Database CI/CD, and DevOps for developers and DBAs

Bytebase is an open source, web-based database schema change and version control tool for teams. It offers a web-based collaboration workspace to help DBAs and Developers manage the lifecycle of application database schemas.

MySQL
PostgreSQL
Snowflake
Oracle
SQL Server
MongoDB
Redis
Redshift
ClickHouse
TiDB
OceanBase
Spanner
MariaDB
GitLab
GitHub
Bitbucket
Azure DevOps
Terraform
Jira

Features

SQL ReviewMore
Change Propagation & RollbackMore
SQL EditorMore
Dynamic Data MaskingMore
Data Access ControlMore
GitOpsMore
Batch ChangeMore
Schema SynchronizationMore
Index AdvisorMore
Online Schema ChangeMore
RBACMore
SSOMore

What is Point-in-time-recovery (PITR)?

Database schema migration and version control, Database CI/CD, and DevOps for developers and DBAs

Features

Subscribe to Newsletter