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:

  • Purpose: Disaster recovery and long-term retention.

  • Frequency: Every three hours.

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

Where are the backups stored?

Off-site backups are stored in Google Cloud Storage (GCS).

Off-site backups are 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): 3 hours maximum data loss (based on the backup schedule).

  • Recovery Time Objective (RTO): 3-18 hours dependent on database size.