Postgres-BDR®
Advanced Clustering & Scaling for PostgreSQL
BDR from 2ndQuadrant presents true high availability for mission critical databases running on PostgreSQL across various industry verticals such as financial services, telecommunications, and more. BDR presents up to six 9s of availability and allows flexible deployment options depending on budget, internal resources, access to hardware, and more.
On This Page
BDR Features
AlwaysOn Availability
BDR provides up to 99.9999% (six 9s) availability for your PostgreSQL databases. BDR achieves true high availability with rapid switchover and rolling upgrades for database and schemas.
Worldwide Clusters
BDR supports geographically distributed clusters without any limitations on distance and includes the ability for geo-fencing. It is designed to minimize latency across nodes.
Cloud Native
BDR is designed ground up for cloud deployments. Using the self-healing Kubernetes operator you can quickly deploy BDR in trusted configurations with very high availability.
Multi-Master Replication
Multi-Master Replication in BDR allows efficient replication for both DDL and DML with automatic conflict resolution. It also offers Conflict-free Replicated Data Types (CRDTs) which support merging values from concurrently modified rows.
Feature of the Month: Geo-fencing
BDR supports Geo-fencing, allowing you to selectively replicate data for security compliance and jurisdiction control, as well as providing performance improvements. Read more about this and other BDR features in the whitepaper.
Deployment Options
Choose the best for your requirements from amongst a variety of different deployment options for BDR. All listed options include 24/7 Support, Training, hands-on help, & access to our Portal.
- BDR 60-Day Trial. Install BDR on physical or virtual platforms.
- Cloud Native BDR Quickstart. Deploy your cluster using cloud native, self healing BDR operator for Kubernetes
- BDR 60-Day Trial in the Cloud. Access a ready-to-use deployment with immediate access to BDR in a Cloud environment.
Didn’t find the right BDR Deployment option for you? Find out more about tailored BDR deployment options.
Monitoring and Management
OmniDB
OmniDB is an interactive and powerful, yet lightweight, database management tool. It allows users to manage multiple databases in a unified workspace with a user-friendly and fast-performing interface. OmniDB provides monitoring and management for BDR clusters, allowing the user to view/add/remove nodes from groups and perform all tasks on every node.
An example of the OmniDB interface and the BDR plugin is available here.
What Our Customers Say
BDR Knowledge Base
Case Studies
Global Performance Consistency Achieved using BDR
SaaS project management and collaboration software company, ClickUp, uses BDR to achieve consistent performance for their global customers. After tremendous growth, the complexity of their application’s scalability and performance requirements increased and it became clear that they were hitting limits of performance and scalability. Learn how 2ndQuadrant’s BDR helped ClickUp achieve consistent performance for their global customers.
Massive productivity increase on overall production of Globally Distributed database
Animal Logic, groundbreaking animation and visual effects company, has been using PostgreSQL as a core database technology for many years and identified BDR as a superior solution to help establish a stable and highly available globally distributed database infrastructure. BDR combined with 2ndQuadrant Support service, helped this award-winning studio achieve a highly efficient management of their data.
BDR provides High Availability to International Telecommunications Company
Chilean telecommunications company, Telefonica del Sur, uses BDR to ensure efficient management of data with a high performing and highly available database environment. After evaluating several PostgreSQL replication tools, BDR stood out as the best option for their requirements and has helped Telefónica del Sur achieve an effective and accurate replication system for geographically distributed Postgres databases.
Whitepapers
BDR Whitepaper
This whitepaper offers an in-depth overview of BDR3, the third generation of BDR, including its features and their benefits, use cases, and deployment options.
AlwaysOn Postgres Whitepaper
A deeper look into the scenarios when designing an ‘Always On’ architecture for PostgreSQL in a business environment.
Videos
Webinar: BDR – Latest Features & Updates
This webinar covers an overview of BDR (Bi-Directional Replication) and BDR fundamentals, its architecture, use-cases and the latest features available.
Webinar: pglogical and BDR Update
This webinar covers the following topics: Latest information on pglogical and BDR, existing features overview, new features update, and pglogical/BDR roadmaps.
Webinar: Introduction to BDR
This webinar covers the following topics: Introduction to BDR, BDR architecture, high availability, disaster recovery, rolling upgrades, latency and geographical distribution with BDR, common use cases, and making applications compliant.
BDR for Postgres – A Multi-Master Solution
This talk covers an overview of BDR as a Multi-Master Solution for PostgreSQL databases, why it is needed and what to be aware of if you’re interested in using BDR.
Webinar: Cloud Native BDR and PostgreSQL
This webinar explored how Cloud-Native BDR & PostgreSQL products developed by 2ndQuadrant work & how they can be integrated into your Kubernetes workloads
Training
2ndQuadrant offers a variety of courses to improve understanding and practical knowledge of PostgreSQL. Courses are available online, in-person, or on-site for teams.
BDR
This course covers the basic concepts of Bi-Directional Replication for PostgreSQL. This one-day training covers areas such as setting up geographically distributed clusters, using highly efficient asynchronous logical replication, and exploring deployment options for Postgres-BDR® databases.
Introduction to PostgreSQL and Kubernetes
This course introduces the concept of containerization using Kubernetes, an open source orchestration platform. The purpose of this course is to make users familiar with the concept of immutable infrastructure and the self-healing capabilities of Kubernetes when using PostgreSQL.
Blogs
.
Webinar: COMMIT Without Fear – The Beauty of CAMO [Follow Up]
/0 Comments/in 2ndQuadrant, Webinars /by Quratulain GhazaliPostgres BDR has seen exciting growth in the financial services and telecommunication industries. These industries present a new set of challenges that push the limits of Postgres Synchronous COMMIT features for Highly Available clusters. This webinar explored the Postgres Synchronous COMMIT deployment models and discussed the limitations associated with them. The webinar also introduced a […]
Why we chose immutable application containers for our Cloud Native PostgreSQL and BDR products
/0 Comments/in Cloud Native /by Gabriele BartoliniCloud Native PostgreSQL and Cloud Native BDR are the two Kubernetes operators written by 2ndQuadrant entirely from scratch in the Go language and relying exclusively on the Kubernetes API.
Webinar: Cloud Native BDR and PostgreSQL [Follow Up]
/0 Comments/in Webinars /by Bilal IbrarCloud-Native BDR is a multi-master database system based on PostgreSQL and designed for Kubernetes 1.15+ that thanks to the WriteAnywhere architecture, allows your applications to reach up to 6-nines uptime availability in a year. To further explore this topic, 2ndQuadrant arranged a live webinar, “Cloud Native BDR and PostgreSQL”, hosted by Gabriele Bartolini. This webinar […]