System Databases

SingleStore has several internal or "System" databases (views):

cluster: Stores cluster-level metadata that is replicated to all nodes in the cluster. This includes information about nodes host/ports etc. and information about databases and database partitions). Cluster replicas (named something like: cluster_{uint64_t}) are created during DR (disaster recovery) cluster-to-cluster replication.
information.schema: Read-only. A large set of system tables containing metadata about clusters and all the components within them.
memsql: Stores metadata local to a given node, including which local databases exist, which local users exist, etc.

Other than information.schema, these databases are not intended for users. Some commands are not allowed for these databases. For example: ATTACH / DETACH DATABASE, BACKUP DATABASE, DROP DATABASE, REPLICATE DATABASE, REBALANCE PARTITIONS, RESTORE REDUNDANCY.

Last modified: July 12, 2022

Was this article helpful?

Verification instructions

Note: You must install cosign to verify the authenticity of the SingleStore file.

Use the following steps to verify the authenticity of singlestoredb-server, singlestoredb-toolbox, singlestoredb-studio, and singlestore-client SingleStore files that have been downloaded.

You may perform the following steps on any computer that can run cosign, such as the main deployment host of the cluster.

(Optional) Run the following command to view the associated signature files.
Shell
```
curl undefined
```
Download the signature file from the SingleStore release server.
- Option 1: Click the Download Signature button next to the SingleStore file.
- Option 2: Copy and paste the following URL into the address bar of your browser and save the signature file.
- Option 3: Run the following command to download the signature file.
  Shell
```
curl -O undefined
```

After the signature file has been downloaded, run the following command to verify the authenticity of the SingleStore file.

Shell

echo -n undefined |
    cosign verify-blob --certificate-oidc-issuer https://oidc.eks.us-east-1.amazonaws.com/id/CCDCDBA1379A5596AB5B2E46DCA385BC \
      --certificate-identity https://kubernetes.io/namespaces/freya-production/serviceaccounts/job-worker \
      --bundle undefined \
      --new-bundle-format -

Verified OK