SingleStore Node Config Files
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
The following is an example of a default installation directory structure for two nodes on a host.
/var/lib/memsql/
├── <node-1> A node directory
| |
| ├── memsql.cnf The node configuration file; also stores engine variables
| |
│ ├── auditlogs When audit logging is enabled, holds an audit
| | log of all database activity from the cluster
| |
│ ├── data The node's data; the default backup
| | | directory for local backups made to “./”
| | |
│ │ ├── logs Transaction logs used in node recovery and replication
| | |
│ │ └── snapshots Database snapshots
| |
│ ├── plancache Files for plans in the plancache
│ └── tracelogs
│ └── memsql.log The consolidated general/error log
|
├── <node-2> Same file and directory descriptions as node-1 above
| ├── memsql.cnf
│ ├── auditlogs
│ ├── data
│ │ ├── logs
│ │ └── snapshots
│ ├── plancache
│ └── tracelogs
│ └── memsql.log
|
├── db_files The location from which data can be loaded locally if SECURE_FILE_PRIV
| has not been set to NULL; SECURE_FILE_PRIV can also be set to a
| different directory; refer to Setting SECURE_FILE_PRIV for more info.
|
└── nodes.hcl The memsqlctl state file; also referred to as the node metadata file;
contains information about the nodes that reside on a host
All nodes on a host and their data reside within a default installation, or "base," directory which is defined by:
-
The
defaultInstallDir
entry in the memsqlctl configuration file, memsqlctl.hcl. -
The
basedir
entry in the node configuration file,memsql.
.cnf
To locate the default node base directory on a host, run the memsqlctl env
command.
memsqlctl env
+-------------------+---------------------------------+
| memsqlctlConfig | /etc/memsql/memsqlctl.hcl |
| defaultInstallDir | /var/lib/memsql |
| nodeMetadataFile | /var/lib/memsql/nodes.hcl |
| userInfo | uid=985(memsql) gid=978(memsql) |
| user | memsql |
+-------------------+---------------------------------+
The following table lists each configuration file and provides the location of each file, additional information about each file, and each file’s format.
File |
Location & Description |
Format |
|
|
|
||
The node configuration file. Stores engine variables, the values of which are loaded when a node starts. This file contains a The location of this file can be overridden temporarily by either:
|
|||
|
|
||
The memsqlctl state file. Also referred to as the node metadata file. The file where This file contains
The location of this file can be overridden:
If an error is displayed stating that the node metadata file ( The following is an example of an empty
The following is an example of a
|
Last modified: August 21, 2024