pxc_scheduler_handler statements¶
Statement reference¶
The standard pxc_scheduler_handler statement includes
percona-scheduler-admin --config-file=<configuration file name and
extension>. A pxc_scheduler_handler example statement has the following syntax:
percona-scheduler-admin --config-file=config.toml [option] [option]
If you do not include the configuration file in the command, the result is an error and nothing happens.
$ percona-scheduler-admin --debug
ERROR : The --config-file option is required but is missing from the command.
The options determine what the statement does. The pxc_scheduler_handler statement must include at least one option. A command without an option returns an error and nothing happens.
For most options, two hyphens (–) precede an option name. The disable and the enable option can be selected with one hyphen (-) and the appropriate abbreviation.
For example, the following commands return the same result:
$ percona-scheduler-admin --config-file=config.toml -e
$ percona-scheduler-admin --config-file=config.toml --enable
You can combine some options with other, optional options to modify the statement behavior. Multiple options are separated by a space. You can combine the options in any order.
An example of combining options in one statement:
$ percona-scheduler-admin --config-file=config.toml --write-node=127.0.0.1:4130 --update-cluster
For some options, they must be combined with a required option to return a result.
An example of an option combined with a required option:
$ percona-scheduler-admin --config-file=config.toml --force -e
If you do not combine the option with the required option, the statement does not run and returns an error.
$ percona-scheduler-admin --config-file=tests/testsuite.toml --update-write-weight="127.0.0.1:33,112"
Expected output
ERROR : --update-write-weight requires --update-cluster.
Specific options, such as -–write-node or –-server, require a value.
$> percona-scheduler-admin --config-file=config.toml --server=192.168.56.32:3306
For the available options, see pxc_scheduler_handler options