1.1

2. Alternatively, use the SQLFire ALTER TABLE statement after you have created a table to add or remove
gateway sender configurations. For example, if you did not supply a GATEWAYSENDER clause in the
CREATE TABLE statement, you could add it later:
ALTER TABLE test_table SET GATEWAYSENDER (cluster-2-sender,
cluster-3-sender);
3. Repeat these steps to create the same table definitions in each SQLFire cluster that will replicate DML
operations for those tables. The WAN replication process does not automatically create a table in the target
SQLFire cluster.
Create a Gateway Receiver
To accept DML replication requests from remote SQLFire clusters, a SQLFire cluster requires a gateway receiver,
which specifies the members that can receive connections from one or more remote gateway senders.
A SQLFire cluster needs only a single gateway receiver, regardless of how many remote sites replicate data to
the cluster. However, you can deploy multiple instances of a gateway receiver to different SQLFire members
for high availability.
Procedure
Note: The SQLFire cluster that replicates DML operations from another cluster must have the same table
definitions available to apply the DML operations. The tables that are used in WAN replication do not
have to reside on the same SQLFire members that host the gateway receiver.
1. Use the CREATE GATEWAYRECEIVER statement and specify the server group to which you want to
deploy the receiver. Also specify a range of port numbers to use for the receivers. SQLFire selects an unused
port number from the range you specify when starting the receiver. If no port number in the range is available,
an exception is thrown.
For example:
CREATE GATEWAYRECEIVER test_receiver (startport 1530 endport 1541) server
groups (receivergroup1);
This creates a receiver on receivergroup1 using an available port number from 1530 to 1540.
2. Query the GATEWAYRECEIVERS to determine which port number was selected to listen for WAN
connections:
select id, running_port, server_groups from sys.gatewayreceivers;
ID |RUNNING_PORT |SERVER_GROUPS
-----------------------------------------------------------
TEST_RECEIVER |1537 |RECEIVERGROUP1
1 row selected
In this example, the gateway receiver listens on port 1537.
CREATE GATEWAYRECEIVER on page 468 provides additional information about creating receivers.
Start and Stop Gateway Senders
vFabric SQLFire can start a gateway sender process by default, but you can also specify a manual start when
you create a sender.
SQLFire automatically starts a gateway sender process when you use the CREATE GATEWAYSENDER
statement. If you specify the MANUALSTART TRUE clause when creating a sender, you must manually start
the sender processes using the SYS.START_GATEWAYSENDER procedure. Specify the name of the sender
that you want to start, as in:
CALL START_GATEWAYSENDER ("cluster-1-sender");
235
Configuring Multi-site (WAN) Deployments