From Fedora Project Wiki

< Infrastructure

Revision as of 22:22, 19 June 2017 by Kevin (talk | contribs) (Created page with "= Postgres-BDR and Fedora Infrastructure = == History / Background == Fedora infrastructure has tried to standardize on using postgresql for database needs. Additionally we ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Postgres-BDR and Fedora Infrastructure

History / Background

Fedora infrastructure has tried to standardize on using postgresql for database needs. Additionally we want to make our databases highly available and handle some common sysadmin cases like: updates/reboots, one hardware machine failing to function, etc. We want this to be as easy and transparent for the sysadmins, so we settled on BDR (Bi-drectional Replication). There are however some limitations application developers need to take into account, so we are going to move applications over as application developers feel they are ready for BDR.

Goals

  • Examine choices and select HA method. DONE: BDR
  • Setup some applications with BDR in staging. DONE.
  • FY18 move more applications as they are ready for BDR
  • FY18 move to postgresql 10 as it's ready.

Staging status

The following apps are currently using BDR:

on db-koji01.stg and db-koji02.stg:

koji

on pgbdr01.stg and pgbdr02.stg:

bodhi2 datanommer elections fedocal koschei tahrir

Not using BDR:

tagger hyperkitty/mailman kerneltest mbs notifs nuancier pagure pkgdb2 summershum


Production status

  • No BDR applications currently, we plan to setup a db pair soon to allow ready applications to move to BDR.

Notes and links

http://bdr-project.org/docs/stable/overview.html