Enhanced BDB SQL Replication Options

New Pragmas

Berkeley DB SQL replicated applications now support multiprocess access. Also, there are several new replication pragmas. The replication_ack_policy, replication_ack_timeout and replication_priority pragmas provide ways to configure a site's acknowledgement criteria and election priority. The other new pragmas provide additional information about the current state of the replication group or the local site.

New Pragmas

  • PRAGMA replication_ack_policy[=all|all_available|none|one|quorum]
  • PRAGMA replication_ack_timeout[=n]
  • PRAGMA replication_priority[=n]
  • PRAGMA replication_get_master
  • PRAGMA replication_num_sites
  • PRAGMA replication_perm_failed
  • PRAGMA replication_site_status