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 provides additional information about creating receivers.