1.0

• 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 220):
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
227.
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.
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 220:
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.
Create and Start Gateway Sender provides more information about configuring gateway senders.
vFabric SQLFire User's Guide226
Deploying vFabric SQLFire