2ndQuadrant is now part of EDB

Bringing together some of the world's top PostgreSQL experts.

2ndQuadrant | PostgreSQL
Mission Critical Databases
  • Contact us
  • Support & Services
    • Support
      • 24/7 PostgreSQL Support
      • Developer Support
    • DBA Services
      • Remote DBA
      • Database Monitoring
    • Consulting Services
      • Health Check
      • Performance Tuning
      • Database Security Audit
      • PostgreSQL Upgrade
    • Migration Services
      • Migrate to PostgreSQL
      • Migration Assessment
  • Products
    • Postgres-BDR ®
    • PostgreSQL High Availability
    • Kubernetes Operators for BDR & PostgreSQL
    • Managed PostgreSQL in the Cloud
    • Installers
      • Postgres Installer
      • 2UDA
    • 2ndQPostgres
    • pglogical
    • Barman
    • repmgr
    • OmniDB
    • SQL Firewall
    • Postgres-XL
  • Downloads
    • Installers
      • Postgres Installer
      • 2UDA – Unified Data Analytics
    • Whitepapers
      • Business Case for PostgreSQL Support
      • AlwaysOn Postgres
      • PostgreSQL with High Availability
      • Security Best Practices
      • BDR
    • Case Studies
      • Performance Tuning
        • BenchPrep
        • tastyworks
      • Distributed Clusters
        • ClickUp
        • European Space Agency (ESA)
        • Telefónica del Sur
        • Animal Logic
      • Database Administration
        • Agilis Systems
      • Professional Training
        • Met Office
        • London & Partners
      • Database Upgrades
        • Alfred Wegener Institute (AWI)
      • Database Migration
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
  • Postgres Learning Center
    • Webinars
      • Upcoming Webinars
      • Webinar Library
    • Whitepapers
      • Business Case for PostgreSQL Support
      • AlwaysOn Postgres
      • PostgreSQL with High Availability
      • Security Best Practices
      • BDR
    • Blog
    • Training
      • Course Catalogue
    • Case Studies
      • Performance Tuning
        • BenchPrep
        • tastyworks
      • Distributed Clusters
        • ClickUp
        • European Space Agency (ESA)
        • Telefónica del Sur
        • Animal Logic
      • Database Administration
        • Agilis Systems
      • Professional Training
        • Met Office
        • London & Partners
      • Database Upgrades
        • Alfred Wegener Institute (AWI)
      • Database Migration
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
    • Books
      • PostgreSQL 11 Administration Cookbook
      • PostgreSQL 10 Administration Cookbook
      • PostgreSQL High Availability Cookbook – 2nd Edition
      • PostgreSQL 9 Administration Cookbook – 3rd Edition
      • PostgreSQL Server Programming Cookbook – 2nd Edition
      • PostgreSQL 9 Cookbook – Chinese Edition
    • Videos
    • Events
    • PostgreSQL
      • PostgreSQL – History
      • Who uses PostgreSQL?
      • PostgreSQL FAQ
      • PostgreSQL vs MySQL
      • The Business Case for PostgreSQL
      • Security Information
      • Documentation
  • About Us
    • About 2ndQuadrant
    • What Does “2ndQuadrant” Mean?
    • 2ndQuadrant’s Passion for PostgreSQL
    • News
    • Careers
    • Team Profile
  • Blog
  • Menu Menu
You are here: Home1 / Products2 / Postgres-BDR®

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

  1. BDR Features
  2. Deployment Options
  3. Case Studies
  4. Monitoring and Management
  5. What Our Customers Say
  6. BDR Knowledge Base

BDR Features

BDR provides AlwaysOn Availability, meaning up to 99.9999% (six 9s) availability for your PostgreSQL databases with rapid switchover and rolling upgrades.

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.

BDR supports geographically distributed clusters, includes the ability for geo-fencing, and is designed to minimize latency across nodes.

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.

BDR is fully designed for cloud deployments and can be configured easily using self-healing Kubernetes operators.

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.

BDR Multi-Master Replication allows efficient replication for both DDL and DML with automatic conflict resolution.

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.

Download Now

Back to top

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.

Get in Touch

Back to top

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.

Back to top

What Our Customers Say

 
12

“Postgres-BDR® has become a standard replication solution for all the systems in our company. Any project/ application that uses PostgreSQL as the backend database uses BDR by default.”

José Calquín, Development Engineer, Telefónica del Sur

“We can certainly attribute help in our growth to Postgres-BDR® since we now have consistent performance globally and are able to grow our business in multiple regions.”

Alex Yurkowski, CTO, ClickUp

Back to top

BDR Knowledge Base

Case Studies

Global Performance Consistency Achieved using BDR

Project Management SaaS company ClickUp uses BDR for scalability and performance requirements of their distributed database clusters.

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.

Download Case Study

Massive productivity increase on overall production of Globally Distributed database

Digital creative studio Animal Logic utilizes BDR and 2ndQuadrant Support for their geographically 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.

Download Case Study

BDR provides High Availability to International Telecommunications Company

Chilean Telecommunication giant, Telefónica del Sur, implemented BDR to provide customers with uninterrupted service and access to updated data.

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.

Download Case Study

Whitepapers

Whitepapers from 2ndQuadrant will help you develop a deeper knowledge about PostgreSQL, its tools, and highlight some of the common issues faced by day-to-day Postgres users and possible solutions to overcome them.

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.

Download PDF

AlwaysOn Postgres Whitepaper
A deeper look into the scenarios when designing an ‘Always On’ architecture for PostgreSQL  in a business environment.

Download PDF

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.

Watch Video

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.

Watch Video

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.

Watch Video

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.

Watch Video

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

Watch Video

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.

Training by 2ndQuadrant

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.

Learn More

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.

Learn More

Blogs

Webinar: COMMIT Without Fear – The Beauty of CAMO [Follow Up]

November 13, 2020/0 Comments/in 2ndQuadrant, Webinars /by Quratulain Ghazali

Postgres 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 […]

Read more

Why we chose immutable application containers for our Cloud Native PostgreSQL and BDR products

July 6, 2020/0 Comments/in Cloud Native /by Gabriele Bartolini

Cloud 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.

Read more

Webinar: Cloud Native BDR and PostgreSQL [Follow Up]

June 2, 2020/0 Comments/in Webinars /by Bilal Ibrar

Cloud-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 […]

Read more
View All Blogs
Back to top

.

Get in touch with us!

Please fill in the form below and we'll be in touch as soon as possible.

Support & Services

24/7 Production Support

Developer Support

Remote DBA for PostgreSQL

PostgreSQL Database Monitoring

PostgreSQL Health Check

PostgreSQL Performance Tuning

Database Security Audit

Upgrade PostgreSQL

PostgreSQL Migration Assessment

Migrate from Oracle to PostgreSQL

Products

HA Postgres Clusters

Postgres-BDR®

2ndQPostgres

pglogical

repmgr

Barman

Postgres Cloud Manager

SQL Firewall

Postgres-XL

OmniDB

Postgres Installer

2UDA

Postgres Learning Center

Introducing Postgres

Blog

Webinars

Books

Videos

Training

Case Studies

Events

About Us

About 2ndQuadrant

What does 2ndQuadrant Mean?

News

Careers 

Team Profile

© 2ndQuadrant Ltd. All rights reserved. | Privacy Policy
  • Twitter
  • LinkedIn
  • Facebook
  • Youtube
  • Mail
Scroll to top
×