settings.conf

MemSQL Ops has been deprecated

Please follow this guide to learn how to migrate to SingleStore tools.

Each individual MemSQL Ops agent installation has their settings stored in <MEMSQL OPS HOME>/settings.conf. The possible configuration settings are:

Setting Description Default
user The user that the local MemSQL Ops agent should run as. MemSQL
interface The network interface that the local MemSQL Ops agent should use. First non-loopback interface
host The hostname that the local MemSQL Ops agent should use. 0.0.0.0
port The port that the local MemSQL Ops agent should use. 9000
ssl_port The SSL port that this MemSQL Ops agent should use, if SSL is configured. 9001
ops_datadir The directory to use as the root path for MemSQL Ops data directories, logs, and other files. data/
memsql_installs_dir The directory to use for MemSQL installs. /var/lib/memsql
backups_dir The directory where MemSQL Ops will store backup files. We recommend that this directory is an NFS directory. data/backups
tmp_dir The directory MemSQL Ops will use as a staging area during a MemSQL Ops upgrade. This directory must be executable. /tmp
user_analytics_disabled Setting this flag to true will disable the sending of usage statistics to MemSQL to improve product performance and diagnose issues. False
debug Whether or not to enable debug logging. False
log_rotate_interval The interval for rotating log files in hours. 6
log_archive_count The number of archived logs to retain. 28
max_file_upload_size The maximum file size that can be uploaded in the Ops web UI. 1024 MB
websocket_origins Comma delimited list of locations through which the MemSQL Ops UI will be accessed. The protocol + domain/ip + port must all be specified. For example, http[s]://HOST:PORT
num_parallel_jobs The maximum number of jobs MemSQL Ops can execute in parallel across the cluster. Must be set on the Primary Agent. 10