2ndQuadrant is now part of EDB

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

2ndQuadrant | PostgreSQL
Mission Critical Databases
  • Contact us
  • EN
    • FR
    • IT
    • ES
    • DE
    • PT
  • Support & Services
  • Products
  • Downloads
    • Installers
      • Postgres Installer
      • 2UDA – Unified Data Analytics
    • Whitepapers
      • Business Case for PostgreSQL Support
      • Security Best Practices for PostgreSQL
    • 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
      • Security Best Practices for PostgreSQL
    • 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
    • 2ndQuadrant’s Passion for PostgreSQL
    • News
    • Careers
    • Team Profile
  • Blog
  • Menu Menu
You are here: Home1 / Blog2 / Webinars3 / Webinar: BDR – Latest Features & Updates [Follow Up]
BDR Latest Features & Updates Webinar
Bilal Ibrar

Webinar: BDR – Latest Features & Updates [Follow Up]

January 17, 2020/1 Comment/in Webinars /by Bilal Ibrar

BDR is a rapidly evolving project — and has been generating great interest from the Postgres community. In order to give further insights into BDR, how it works and where to best apply it, 2ndQuadrant organized a live webinar on 15th January 2020. 

The BDR – Latest Features and Updates webinar was hosted by Simon Riggs (CEO at 2ndQuadrant), with the aim to bring everyone up-to-speed with the latest BDR features, and give a comprehensive analysis of its architecture and cutting edge use-cases. 

This webinar covered the following topics:

  • Introduction to BDR (Bi-Directional Replication) and BDR fundamentals
  • BDR Architecture and latest features available in BDR
  • AlwaysOn – Advanced high availability and rolling upgrades
  • Disaster Recovery, Latency and Worldwide Clusters with BDR
  • Latest use-cases for BDR
  • Making applications compliant with BDR

Those who weren’t able to attend the live webinar can now view the recording here.


Questions that Simon couldn’t respond to during the live webinar, due to time restrictions have been answered below.

Question: Is there overhead in inserts or updates with BDR always on? in percentage, please.

Answer:  There is no foreground overhead for INSERTs or UPDATEs – changes are written to the transaction log and then replicated from there. That is why we say that the replication is very efficient. Applying the changes on other nodes has a cost, but that is generally much less than the original action. Various replication modes add latency, but very little resource overhead.

Question: Can we configure BDR between heterogeneoushyterogeniues clouds like AWS(node1) and AZURE(node2)?

Answer: Yes, we can support Multi-Cloud deployments

Question: How do you distinguish BDR from other scaling technologies, e.g. CitusDB?

Answer: BDR has better availability

Question: Every node/pod can have its own replica with its own streaming replication? A pg_basebackup can raise the amount of wal-files above 100gb?

Answer: Yes, if needed, but we don’t recommend that architecture.

Question: Can we handle table level unique value?

Answer: Yes

Question: Merge Replication Possible?

Answer: "Merge Replication" is a term used by another replication system. It does look like the description is very similar and I’m not aware of any differences, so Yes.

Question: Do you implement backup for nodes on BDR?  Is it necessary to run a backup on only 1 node or do we have to run it on all nodes?

Answer: It’s best to run it on multiple nodes, to more quickly regenerate lost data in each region


To stay updated on upcoming webinars by 2ndQuadrant, you can visit our Webinars page.

For any questions, comments, or feedback, please visit our website or send an email to [email protected].

Tags: alwayson, BDR, postgres, PostgreSQL, webinar, worldwide clusters
Share this entry
  • Share on Facebook
  • Share on Twitter
  • Share on WhatsApp
  • Share on LinkedIn
1 reply
  1. Zermok
    Zermok says:
    February 1, 2020 at 5:03 pm

    Thanks 2ndQuadrant team for the wonderful work you did!

    Reply

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

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
Support for PostgreSQL’s System identifier in Barman Support for PostgreSQL’s System identifier in Barman jsonb_set_lax jsonb_set_lax
Scroll to top
×