dse client-tool alwayson-sql
Perform operations related to AlwaysOn SQL.
Synopsis
dse client-tool <connection_options> alwayson-sql
(status | stop | start | restart | reconfig)
Syntax conventions | Description |
---|---|
UPPERCASE |
Literal keyword. |
Lowercase |
Not literal. |
<`Italics>` |
Variable value. Replace with a valid option or user-defined value. |
|
Optional.
Square brackets ( |
|
Group.
Parentheses ( |
|
Or.
A vertical bar ( |
|
Repeatable.
An ellipsis ( |
|
Single quotation ( |
|
Map collection.
Braces ( |
|
Set, list, map, or tuple.
Angle brackets ( |
|
End CQL statement.
A semicolon ( |
|
Separate the command line options from the command arguments with two hyphens ( |
|
Search CQL only: Single quotation marks ( |
|
Search CQL only: Identify the entity and literal value to overwrite the XML element in the schema and solrconfig files. |
-
status :: Get the AlwaysOn SQL service status of the datacenter. With the
--dc datacenter name
option, get the status of the specified datacenter.The returned status is one of:
-
RUNNING
: the server is running and ready to accept client requests. -
STOPPED_AUTO_RESTART
: the server is being started but is not yet ready to accept client requests. -
STOPPED_MANUAL_RESTART
: the server was stopped with either astop
orrestart
command. If the server was issued arestart
command, the status will be changed toSTOPPED_AUTO_RESTART
as the server starts again. -
STARTING
: the server is actively starting up but is not yet ready to accept client requests.- stop
-
Manually stop the AlwaysOn SQL service. With the
--dc datacenter name
option, manually stop the service on the specified datacenter. - start
-
Manually start the AlwaysOn SQL service. With the
--dc datacenter name
option, manually start the service on the specified datacenter. The service will start automatically if its been enabled. - restart
-
Manually restart a running AlwaysOn SQL service. With the
--dc datacenter name
option, manually restart the service on the specified datacenter. - reconfig
-
Manually reconfigure the AlwaysOn SQL service. With the
--dc datacenter name
option, manually reconfigure the service on specified datacenter. Running this command will tell the service to re-read the configuration options.The
alwayson_sql_options
section indse.yaml
, described in detail at AlwaysOn SQL, has options for setting the ports, timeout values, log location, and other Spark or Hive configuration settings. Additional configuration options are located inspark-alwayson-sql.conf
.
-
Examples
Stop a running service:
dse client-tool alwayson-sql stop
Start the service on a particular datacenter:
dse client-tool alwayson-sql --dc dc-west start
Force the service to stop:
dse client-tool alwayson-sql stop
Reread the configuration options for a running service:
dse client-tool alwayson-sql reconfig