Replication for Existing Databases in the SQL API

PRAGMAs With Permanent Effects
PRAGMAs That Can Now Operate on Existing Databases

Replication can now be enabled on existing SQL databases, and replication is now disabled permanently instead of temporarily. Replication is enabled on an existing database the same way it is enabled on a new database, with one restriction. The existing database must configure itself as the initial master of a new replication group. To disable replication on a database permanently, use pragma replication=OFF;.

PRAGMAs With Permanent Effects

  • pragma replication=OFF;

PRAGMAs That Can Now Operate on Existing Databases

  • pragma replication_local_site="host:port";
  • pragma replication_initial_master=ON;
  • pragma replication=ON;