SingleStoreDB Directory Layout

For installations using the SingleStoreDB RPM and Debian packages, SingleStoreDB follows the Linux Standard Base (LSB) layout.

/var/lib/memsql/                        [Default nodes installation directory.]

        <hashed-node-id>/

                auditlogs/              [When audit logging is enabled, holds a log of all database activity from the cluster.]

                data/                   [The data on the node; the default backups directory for local backups made to “./”]

                        logs/           [Location of transaction logs used in node recovery and replication.]

                        snapshots/      [Location of database snapshots.]

                memsql.cnf/             [The configuration file for the node. Also includes system variables.]

                plancache/              [Location of the files for the various plans in the plancache.]

                tracelogs/              

                        memsql.log      [The consolidated general/error log.]

                db_files/               [If secure_file_priv has not been set to NULL, the location where data can be loaded

                                        from locally; secure_file_priv can also be set to a different directory.

                                        Refer to Setting SECURE_FILE_PRIV for more information.]

                nodes.hcl/              [The memsqlctl state file which contains information about the nodes local to the host.]

The directory layout resembles the following when viewed as a directory tree.

/var/lib/memsql/
  ├── <hashed-node-id>
  │   ├── auditlogs
  │   ├── data
  │   │   ├── logs
  │   │   └── snapshots
  │   ├── memsql.cnf
  │   ├── plancache
  │   └── tracelogs
  │       └── memsql.log
  ├── db_files
  └── nodes.hcl