PrevFast BackwardFast ForwardNext

Chapter 17. EDB-Replication

Table of Contents
17.1. Introduction to EDB-Replication
17.2. Limitations of EDB-Replication
17.3. EDB-Replication Concepts
17.3.1. Cluster
17.3.2. Node
17.3.3. Replication Set
17.3.4. Master, Slaves and Subscribers
17.3.5. The edb-replication process
17.3.6. Slonik Configuration Processor
17.4. EDB-Replication Setup
17.4.1. System Requirements
17.4.2. EDB-Replication Software Dependencies
17.4.3. Creating a database user for replication
17.4.4. Configuring the Database for Replication
17.4.5. EDB-Replication Subscribtion
17.5. Slonik Command Summary
I. Slonik Meta Commands
INCLUDE --  pulling in slonik code from another file
DEFINE --  Defining a named symbol
I. Slonik Preamble Commands
CLUSTER NAME --  preamble - identifying edb-async-replic cluster
ADMIN CONNINFO --  preamble - identifying PostgreSQL database
I. Configuration and Action commmands
ECHO --  Generic output tool
EXIT --  Terminate Slonik script with signal
INIT CLUSTER -- Initialize edb-async-replic cluster
STORE NODE --  Initialize edb-async-replic node
DROP NODE --  Decommission edb-async-replic node
UNINSTALL NODE --  Decommission edb-async-replic node
RESTART NODE --  Restart edb-async-replic node
STORE PATH --  Configure edb-async-replic node connection
DROP PATH --  Delete edb-async-replic connection information
STORE LISTEN --  Configure edb-async-replic node to indicate where to listen for events
DROP LISTEN --  Eliminate configuration indicating how edb-async-replic node listens for events
TABLE ADD KEY --  Add primary key for use by edb-async-replic for a table with no suitable key
CREATE SET --  Create edb-async-replic replication set
DROP SET --  Discard edb-async-replic replication set
MERGE SET --  Merge edb-async-replic replication sets together
SET ADD TABLE --  Add a table to a edb-async-replic replication set
SET ADD SEQUENCE --  Add a sequence to a edb-async-replic replication set
SET DROP TABLE --  Remove a table from a edb-async-replic replication set
SET DROP SEQUENCE --  Remove a sequence from a edb-async-replic replication set
SET MOVE TABLE --  Move a table from one edb-async-replic replication set to another
SET MOVE SEQUENCE --  Move a sequence from one edb-async-replic replication set to another
STORE TRIGGER --  Indicate that a trigger should not be disabled by edb-async-replic on a subscriber node
DROP TRIGGER --  Return a trigger to default behavior, where it will not fire on subscriber nodes
SUBSCRIBE SET --  Start replication of edb-async-replic set
UNSUBSCRIBE SET --  End replication of edb-async-replic set
LOCK SET --  Guard edb-async-replic replication set to prepare for MOVE SET
UNLOCK SET --  Unlock a edb-async-replic set that was locked
MOVE SET --  Change origin of a edb-async-replic replication set
FAILOVER --  Fail a broken replication set over to a backup node
EXECUTE SCRIPT --  Execute SQL/DDL script
UPDATE FUNCTIONS --  Reload stored functions
WAIT FOR EVENT --  Have Slonik script wait for previous event to complete

17.1. Introduction to EDB-Replication

EDB-Replication is a "master to multiple slaves" replication system with cascading and slave promotion that includes all features and capabilities needed to replicate large databases to a reasonably limited number of slave systems.

EDB-Replication allows databases to be started and stopped on an existing database with out the need for a dump/reload cycle.

PrevHomeNext
FeaturesUpLimitations of EDB-Replication