DDL replication v5

DDL stands for data definition language, the subset of the SQL language that creates, alters, and drops database objects.

PGD provides Automatic DDL replication which makes certain DDL changes easier without your having to manually distribute the DDL change to all nodes and ensure that they're consistent.

This section looks at how DDL replication is handled in PGD.

  • Overview provides a general outline of what PGD's DDL replication is capable of.

  • Replication Options looks at the options for controlling replication.

  • Locking examines how DDL replication uses locks to safely replicate DDL.

  • Managing DDL with PGD replication give best practice advice on why and how to limit the impact of DDL changes so they do not overly affect the smooth running of the cluster.

  • Command Handling is a reference to all DDL commands, what locks they take and any special handling that may be involved in their use and execution.

  • DDL role manipulation notes issues around manipulating roles over multiple databases in a cluster

  • Workarounds gives a range of options for handling situations where DDL replication may present restrictions, such as altering columns, constraints and types.

  • DDL-like PGD functions details the PGD functions which behave like DDL and therefore behave in a similar way and are subject to similar restrictions.