Skip to main content
Version: v12

Data Backup Policies

This article describes how Brinqa backs up your data, ensuring that your valuable information remains safe and accessible.

Brinqa solution cloud architecture

Before diving into backup policies, let's first explore the architecture and components of Brinqa solution. The following diagram outlines how data flows into the Brinqa Platform, gets processed by the Cyber Risk app, and is then stored in one of two database types: Online Transaction Processing (OLTP) or Online Analytical Processing (OLAP):

  • OLTP: The primary data store that ingests and processes data through orchestration.

  • OLAP: Designed for delivering analytic datasets at speed and scale. The platform takes a complete snapshot of the data from OLTP and stores the results for use in analytics and dashboards.

Brinqa Solution Cloud Architecture 12x

Figure 1. Brinqa solution cloud architecture diagram.

Brinqa Platform version 12 backup policies

If you are using Brinqa Platform version 12, refer to the backup policies in this section.

What data do we back up?

The primary data backup covers the transactional database, which serves as the OLTP database for the Brinqa Platform. The OLAP database is not backed up separately, as it is regenerated daily from the OLTP database as part of the Data Warehouse snapshot process. Off-site backups of the OLTP database are full backups.

The OLTP database is deployed in a distributed cluster architecture with servers spread across 3 availability zones for high availability. This distributed architecture differs significantly from version 11, which used a monolithic deployment with all components in a single virtual machine.

How are the backups configured?

The backup solution implements off-site backups for disaster recovery:

  • In-cluster snapshots with Point-in-Time Recovery (PITR) capabilities will be available in a future release.

  • Off-site backups:

    • Purpose: Disaster recovery and long-term retention.

    • Frequency: Twice daily at 6:00 AM and 6:00 PM.

    • Performance: Backups typically complete in 4-5 minutes per database with minimal impact on production workloads.

Where are the backups stored?

Backups are stored in two different locations based on their type:

  • In-cluster snapshots: Will be available in a future release.

  • Off-site backups: Stored in Google Cloud Storage (GCS).

The retention period differs based on the backup type:

  • In-cluster snapshots: Will be available in a future release.

  • Off-site backups: Retained for 30 days in GCS standard storage, then archived for an additional 90 days using tiered storage options.

What are the recovery objectives?

Brinqa's backup strategy is designed to meet specific recovery objectives:

  • Recovery Point Objective (RPO):

    • Off-site backups: 12 hours maximum data loss (based on twice-daily backup schedule).
  • Recovery Time Objective (RTO):

    • Full cluster recovery from off-site backups: 3-6 hours.
  • PITR: Will be available in a future release.