Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Bucardo.pdf

Sponsored · Your Podcast. Everywhere. Effortlessly. Share. Educate. Inspire. Entertain. You do you. We'll handle the rest.
Avatar for KMKLabs KMKLabs
January 18, 2016

 Bucardo.pdf

Avatar for KMKLabs

KMKLabs

January 18, 2016
Tweet

More Decks by KMKLabs

Other Decks in Education

Transcript

  1. Bucardo • async PostgreSQL replication system • allow multi-master and

    multi-slave op • Developed by Jon Jesen and Greg Sabino • Free and Open Source (BSD License)
  2. Bucardo Terms • Goat : database object such as tables

    and sequence • Herd : a group of goats • Sync : sync event. one sync, one herd
  3. Installing (Ubuntu 14.04) • add repo : deb http://apt.postgresql.org/pub/repos/ apt/

    trusty-pgdg main • install requirement : • perl, dbix-safe-perl, postgresql-plperl • get source code : https://github.com/bucardo/ bucardo/archive/5.3.1.tar.gz
  4. Config • ./bucardo install • ./bucardo add all tables db=source_db

    • ./bucardo add all sequences db=source_db • ./bucardo add herd copying_herd all tables
  5. El Replicado • Test • ./bucardo validate all • Replicate

    • ./bucardo add sync vidio_sync relgroup=copying_herd dbs=source_db:source,dest_db:target onetimecopy=2 • ./bucardo start
  6. How Bucardo Replicate INSERT/UPDATE/ DELETE BUCARDO ADD DELTA BUCARDO TRIGGER

    SYNC CONTROLLER SYNC KID NOTIFY/ LISTEN REPLICATION EVENT
  7. Verdict • No lock on slave • Conflict resolution •

    Multi Master and Multi Slave • ————————————————- • not for HA / Failover • not available on windows