Start and stop services

Start

On each SQL broker, as the Linux user of the cluster:

nohup $HOME/bin/synsqld &

The messages go to nohup.out. The MariaDB servers of the master and data brokers must be running first. At startup the broker reads the dictionary and checks the license. It refuses to run if the license is invalid or expired, or if the dictionary holds more data brokers than the license allows.

Stop

shutdown;            stops the broker you are connected to
shutdown cluster;    tells every running broker to stop

Only administrators can do this. Statements that are running finish if they are short; a long select is killed.

Restart after a failure

A broker that comes back reads the cluster state and takes its place. If a data broker was down, put it back with alter databroker NAME set online; (see Manage brokers); tables that lost a copy are repaired with repair table.

License

The license is checked at startup, and again regularly while the broker runs. A broker stops when its license has expired. It logs a warning when the end date comes close. Renew the license before it expires with download license; (see download).