Adding Members to Server Groups

You define server group membership and/or create a server group when you start a SQLFire member using the server-groups boot property.

For example, if you start a SQLFire server from the command line with sqlf, use the server-groups property to specify the names of one or more server groups that the server should join:

sqlf server start -server-groups=OrdersDB,OrdersReplicationGrp,DBProcessInstance1

In this example, the SQLFire server participates in three server groups: OrdersDB, OrdersReplicationGrp and DBProcessInstance1. If this is the first SQLFire member to define a named server group, then SQLFire creates the group and adds the new member after startup. If other SQLFire members in the cluster were booted using the same server group, then SQLFire adds this new member to the existing group. If you specify no -server-groups property, then SQLFire automatically adds the data store member to the default server group.

If you start a SQLFire peer client from within a Java application, specify the server-groups property as part of the JDBC peer client connection string. For example, use the connection URL:
jdbc:sqlfire:;mcast-port=33666;host-data=true;server-groups=OrdersDB,OrdersReplicationGrp,DBProcessInstance1

Starting and Configuring SQLFire Servers and Starting SQLFire Servers with the FabricServer Interface provide more information about specifying boot properties.