Database Replication

Asynchronous database replication is the process of maintaining a replica of a physical Yellowbrick database on a remote Yellowbrick appliance. Replication supports the following use cases:
  • Disaster recovery (DR) and high availability (HA): A replica is virtually a live backup, preserving an exact copy of a database on a separate system, ready for use in the event of a failure or loss of data on the source system. The primary and secondary (source and target) systems can reverse roles as needed, providing failover and failback support.
  • Automated backup and restore: Replication may be used simply as a way to automate backup and restore operations without the need for intermediate storage.

Replication occurs at the database level, based on transactions that have been committed to a source database. A database replica is maintained by "backup snapshots" of the source database in the source system. These backups are taken frequently and automatically by a service that runs on the manager node. The changes are automatically streamed to the database replica in the target system at regular intervals.

The following sections explain how to set up appliances for replication, create database replicas, and start the replication of specific databases.