Deployment and Management
On this page
How can I get a copy of SingleStoreDB?
Sign into our Cloud Portal and use the free license to test out SingleStoreDB.
-
A 30-Day Free Enterprise Trial (trial key available through the Cloud Portal).
-
A license that allows free use of SingleStoreDB up to four license units.
Does SingleStoreDB run in the cloud?
Yes.
Does SingleStoreDB run on Windows?
Yes, the SingleStoreDB Quick Start cluster-in-a-box
packaged via Docker can run on Windows.cluster-in-a-box
is a SingleStoreDB master aggregator and leaf node collocated on a single host.
SingleStoreDB production environments run on modern 64-bit Linux versions, as described in the System Requirements and Recommendations section.
You can also run SingleStoreDB on Microsoft Azure, using Azure Linux instances.
On which Linux distribution does SingleStoreDB run best?
SingleStoreDB is developed and tested most extensively on Red Hat/CentOS 6.
See System Requirements and Recommendations for the current list of Linux distributions that are officially supported.
How much disk space should I allocate for SingleStoreDB?
SingleStoreDB uses disk for three types of storage:
-
Snapshot and log files that backup row store data.
You should allocate about as much space on disk for this purpose as memory on your machine. -
Compressed columnstore data files that contain column store data in SingleStoreDB.
-
Object files that are the result of code generation.
This includes for Data Definition Language (DDL) queries like CREATE TABLE
andALTER TABLE
and for Data Manipulation Language (DML) queries likeINSERT
,UPDATE
,DELETE
andSELECT
.On average, these usually require about 0. 1 MB per unique plan.
Therefore, you should allocate roughly the amount of memory on your machine + space for compressed column store data + 0.
What happens if I run out of memory?
If the amount of memory used by row store tables (Alloc_
from SHOW STATUS EXTENDED
) is greater than the maximum_
global variable (from SHOW GLOBAL VARIABLES
), SingleStoreDB will refuse to start new write queries (INSERT
, UPDATE
and LOAD DATA
).DELETE
queries are not affected by this limit.
If a currently running query runs out of memory, it will rollback and notify the client of the error.
What happens if I run out of disk space?
If the amount of available disk space (in the <MEMSQL HOME>/data
directory) is less than the minimal_
global variable (from SHOW GLOBAL VARIABLES
), SingleStoreDB will refuse to start new write queries (INSERT
, UPDATE
and LOAD DATA
).DELETE
queries are not affected by this limit, and the database will remain online for reads.
If a currently running write query exhausts the available disk space before making its changes durable, it will wait until more disk space becomes available before continuing.hang
when this happens.SHOW STATUS EXTENDED LIKE 'Threads_
.
Last modified: January 17, 2023