Last updated: 2020-02-28

The main Bucardo schema is contained in the bucardo.schema file. This file is processed when running bucardo install to create the Bucardo control database. There are also some tables and functions that are created on the remote databases. All tables and functions are always in the ‘bucardo’ schema.

Main Bucardo tables

  • bucardo_config
    • Holds global configuration information: use bucardo show all to view
  • db
    • Contains information about each replicated database. Use bucardo list dbs to view.
  • dbgroup
    • Contains the names of database groups. View with bucardo list dbgroups
  • dbmap
    • Maps databases to database groups (many to many)
  • goat
    • Contains information on specific items to be replicated: tables or sequences. View with bucardo list goats
  • herd
    • A group of goats is a herd: this contains the names of all herds. View with bucardo list herds
  • herdmap
    • Maps goats to herds (many to many)
  • sync
    • A single named replication event. Links a specific source herd to a remote database or database group. View with bucardo list syncs
  • customcode
    • Perl subroutines that fire at some point in the replication process. Contains code for conflict handling and exception handling. View with bucardo list codes
  • customcode_map
    • Maps customcodes to a specific sync or a goat
  • upgrade_log
    • Populated when you run bucardo upgrade
  • bucardo_rate
    • Track latency and speed of sync, when the “track_rates” column of a sync is set to true
  • bucardo_custom_trigger
    • Allows replacement of the standard trigger for replication of only some rows in a table.
  • bucardo_log_message
    • Used internally for the messaging feature, e.g. bucardo message Foobar
  • q
    • Internal table used by Bucardo to coordinate active syncs
  • audit_pid
    • Lists the PIDs of active processes. No longer on by default.
  • db_connlog
    • A historical record of connection attempts to remote databases. Rarely used or needed.

Main Bucardo functions

Remote Bucardo tables

Each database that is used as a source for a swap or pushdelta sync has the following tables installed into the bucardo schema:

Remote Bucardo functions

Bucardo.org is hosted and supported by End Point Dev

End Point Dev logo

Need assistance with Bucardo?

End Point Dev offers professional support for Bucardo, as well as specializing in developing, designing, and marketing effective websites. Since 1995, our diverse team of developers has shown that End Point can handle your organization’s greatest web and database challenges.