Server Picker

SQream DB’s load balancer is called server_picker.

This page serves as a reference for the options and parameters.

Positional command line arguments

$ server_picker [ <Metadata server address> <Metadata server port> [ <TCP listen port> [ <SSL listen port> ] ]

Argument

Default

Description

Metadata server address

IP or hostname to an active metadata server

Metadata server port

TCP port to an active metadata server

TCP listen port

3108

TCP port for server picker to listen on

SSL listen port

3109

SSL port for server picker to listen on

Starting server picker

Starting temporarily

In general, you should not need to run server_picker manually, but it is sometimes useful for testing.

Assuming we have a metadata server listening on the localhost, on port 3105:

$ nohup server_picker 127.0.0.1 3105 &
$ SP_PID=$!

Using nohup and & sends server picker to run in the background.

Starting temporarily with non-default port

Tell server picker to listen on port 2255 for unsecured connections, and port 2266 for SSL connections.

$ nohup server_picker 127.0.0.1 3105 2255 2266 &
$ SP_PID=$!

Using nohup and & sends server picker to run in the background.

Stopping server picker

$ kill -9 $SP_PID

Tip

It is safe to stop any SQream DB component at any time using kill. No partial data or data corruption should occur when using this method to stop the process.