Note: Documentation for Pivotal SQLFire 1.1.x is now available at http://docs.gopivotal.com/sqlfire/index.html. Please reference the docs.gopivotal.com site for the latest and most up-to-date documentation on SQLFire. The vFabric SQLFire documentation site will no longer be updated.

sqlf shut-down-all

Instructs all SQLFire accessor and data store members to disconnect from the distributed system and shut down.

Syntax

sqlf shut-down-all 
  [-bind-address=<address>]
  [-locators=<addresses>] 
  [-mcast-port=<port>] [-mcast-address=<address>]
  [-skip-accessors] [-<prop-name>=<prop-value>]*

The table shows arguments and options for sqlf shut-down-all.

Option Description
-bind-address The address to which this peer binds for receiving peer-to-peer messages. By default sqlf uses the hostname, or localhost if the hostname points to a local loopback address.
-locators

List of locators used to discover members of the distributed system. Supply all locators as comma-separated host:port values.

-mcast-address

Multicast address used to discover other members of the distributed system. This value is used only if the -locators option is not specified.

The default multicast address is 239.192.81.1.

-mcast-port

Multicast port used to communicate with other members of the distributed system. If zero, multicast is not used for member discovery (specify -locators instead).

Valid values are in the range 0–65535, with a default value of 10334.

-skip-accessors Include this option to leave SQLFire accessor members (members that were started with host-data=false) running after executing the shut-down-all command.
-prop-name

Any other SQLFire distributed system property.

If no multicast or locator options are specified on the command-line, then the command uses the sqlfire.properties file (if available) to determine the distributed system to which it should connect.

Description

This command provides an orderly shutdown for all SQLFire data store and accessor members. Locators are left running to ensure an orderly shut down of the system; shut down locators only after data stores have stopped. On the next startup, data store members will still need to wait until the member with the most recent copy of persisted data joins the distributed system.

Example

This command shuts down data store and accessor members in a system that uses multicast for discovery:

sqlf shut-down-all -mcast-port=3000
Connecting to distributed system: mcast=/239.192.81.1:3000
Successfully shut down 2 members