Manual Reference Pages - SLONIK_CREATE_SET (7)
CREATE SET - Create Slony-I replication set
CREATE SET (options);
In the Slony-I replication system,
replicated tables are organized in sets. As a general rule of
thumb, a set should contain all the tables of one application,
that have relationships. In a well designed application, this is
equal to all the tables in one schema.
The smallest unit one node can subscribe for replication from
another node is a set. A set always has an origin. In
classical replication terms, that would be the master.
Since in Slony-I a node can be the master over one set,
while receiving replication data in the slave role for
another at the same time, this terminology may easily become
misleading and should therefore be replaced with set
origin and subscriber.
This uses storeset(integer,text) .
ID = ival
ID of the set to be created.
ORIGIN = ival
Initial origin node of the set.
COMMENT = string
A descriptive text added to the set entry.
If none is provided, a default value is set; A replication set so boring no one thought to give it a name.
CREATE SET ( ID = 1,
ORIGIN = 1,
COMMENT = Tables for ticketing system );
No application-visible locking should take place.
SLONIK EVENT CONFIRMATION BEHAVIOUR
Slonik waits for the command submitted to the previous
event node to be confirmed on the specified event node before
submitting this command. Slonik will also wait until any outstanding
DROP SET commands are confirmed by all nodes before it submits
the CREATE SET command.
This command was introduced in Slony-I 1.0
Until version 1.2, it would crash if no comment was provided.
| ||SLONIK CREATE SET (7) ||18 January 2015 |
Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.