1.1.1

• To create and automatically start a gateway sender in SQLFire cluster 1 to forward data to cluster 2 (as shown
in Figure 5: WAN configuration with multiple gateway senders on page 232):
CREATE GATEWAYSENDER cluster2sender
(
REMOTEDSID 2
ENABLEPERSISTENCE true
DISKSTORENAME cluster1store
)
SERVER GROUPS (sender_group);
The preceding statement starts gateway senders in the designated server group. The first gateway sender that
starts becomes the primary sender for the local cluster. SQLFire will use the sender to replicate DML operations
to a SQLFire cluster with distributed system ID 2.
If there are additional SQLFire servers in the designated server group in cluster 1, SQLFire starts additional
gateway senders on those members to act as secondary senders for high availability.
• To start gateway senders manually at a later time, specify the MANUALSTART clause:
CREATE GATEWAYSENDER 'cluster-1-sender'
{
REMOTEDSID 2
MANUALSTART TRUE
ENABLEPERSISTENCE true
DISKSTORENAME cluster-1-wan-store
}
SERVER GROUPS (secondary_sender_group)
You can manually start the gateway sender using the instructions in Start and Stop Gateway Senders on page
239.
The CREATE GATEWAYSENDER reference page contains additional information about options that you
can configure when creating gateway senders.
Create Tables with Gateway Senders
To replicate table DML operations to a remote WAN site, you specify one or more named gateway senders when
you create the table, or after you create a table (using the ALTER TABLE statement). The gateway senders that
you specify then replicate the DML operations to the remote SQLFire clusters for which they are configured.
Note: A table must have identical column definitions in each cluster in order for SQLFire to replicate it
between clusters. Use the same DDL command in each cluster to create the table. If you achieve identical
column definitions using different DDL commands (for example, by using ALTER TABLE to change
one table to match another), then you may need to use SYS.INCREMENT_TABLE_VERSION to ensure
that both tables have the same version in each cluster.
Procedure
1. Use the GATEWAYSENDER clause with the CREATE TABLE statement to specify one or more gateway
senders. For example, to create a WAN-replicated table in cluster 1 shown in Figure 5: WAN configuration
with multiple gateway senders on page 232:
CREATE TABLE test_table (ID INT NOT NULL, NAME VARCHAR(10))
GATEWAYSENDER(cluster-2-sender, cluster-3-sender) SERVER GROUPS
(primary_sender_group, secondary_sender_group)
Note: You can configure both partitioned tables and replicated tables to use a gateway sender. However,
you must create replicated tables in the same server groups as the gateway sender(s) that you specify
in the CREATE TABLE statement.
vFabric SQLFire User's Guide238
Deploying vFabric SQLFire