ScalarDB Cluster Standalone Mode

Instead of setting up a Kubernetes cluster and deploying ScalarDB Cluster on top of it by using a Helm Chart, you can run ScalarDB Cluster in standalone mode, which simplifies development and testing processes. A primary use case for this would be when you want to start ScalarDB Cluster in standalone mode via Docker on your local machine and use it for development and testing.

To run ScalarDB Cluster in standalone mode, you need to set the scalar.db.cluster.node.standalone_mode.enabled property to true:

scalar.db.cluster.node.standalone_mode.enabled=true

Run ScalarDB Cluster in standalone mode on Docker Compose

This section explains how to start ScalarDB Cluster in standalone mode on Docker Compose.

warning

You need to have a license key (trial license or commercial license) to use ScalarDB Cluster. If you don't have a license key, please contact us.

Clone the ScalarDB samples repository

Open Terminal, then clone the ScalarDB samples repository by running the following command:

git clone https://github.com/scalar-labs/scalardb-samples

Then, go to the directory that contains the necessary files by running the following command:

cd scalardb-samples/scalardb-cluster-standalone-mode/

Set up your database for ScalarDB Cluster

Follow the instructions below to configure your database for ScalarDB Cluster.

For a list of databases that ScalarDB supports, see Databases.

Relational databases

Select your relational database.

Db2

Run Db2 locally

You can run IBM Db2 in Docker Compose by using the docker-compose.yml file in the scalardb-samples/scalardb-cluster-standalone-mode directory.

To start IBM Db2, run the following command:

docker compose up -d db2

Configure ScalarDB Cluster

The scalardb-cluster-node.properties file in the scalardb-samples/scalardb-cluster-standalone-mode directory contains database configurations. Please uncomment the properties for Db2 in the scalardb-cluster-node.properties file so that the configuration looks as follows:

# For Db2
scalar.db.storage=jdbc
scalar.db.contact_points=jdbc:db2://db2-1:50000/sample
scalar.db.username=db2inst1
scalar.db.password=db2inst1

MariaDB

Run MariaDB locally

You can run MariaDB in Docker Compose by using the docker-compose.yml file in the scalardb-samples/scalardb-cluster-standalone-mode directory.

To start MariaDB, run the following command:

docker compose up -d mariadb

Configure ScalarDB Cluster

The scalardb-cluster-node.properties file in the scalardb-samples/scalardb-cluster-standalone-mode directory contains database configurations. Please uncomment the properties for MariaDB in the scalardb-cluster-node.properties file so that the configuration looks as follows:

# For MariaDB
scalar.db.storage=jdbc
scalar.db.contact_points=jdbc:mariadb://mariadb-1:3306
scalar.db.username=root
scalar.db.password=mariadb

MySQL

Run MySQL locally

You can run MySQL in Docker Compose by using the docker-compose.yml file in the scalardb-samples/scalardb-cluster-standalone-mode directory.

To start MySQL, run the following command:

docker compose up -d mysql

Configure ScalarDB Cluster

The scalardb-cluster-node.properties file in the scalardb-samples/scalardb-cluster-standalone-mode directory contains database configurations. Please uncomment the properties for MySQL in the scalardb-cluster-node.properties file so that the configuration looks as follows:

# For MySQL
scalar.db.storage=jdbc
scalar.db.contact_points=jdbc:mysql://mysql-1:3306/
scalar.db.username=root
scalar.db.password=mysql

Oracle Database

Run Oracle Database locally

You can run Oracle Database in Docker Compose by using the docker-compose.yml file in the scalardb-samples/scalardb-cluster-standalone-mode directory.

To start Oracle Database, run the following command:

docker compose up -d oracle

Configure ScalarDB Cluster

The scalardb-cluster-node.properties file in the scalardb-samples/scalardb-cluster-standalone-mode directory contains database configurations. Please uncomment the properties for Oracle Database in the scalardb-cluster-node.properties file so that the configuration looks as follows:

# For Oracle
scalar.db.storage=jdbc
scalar.db.contact_points=jdbc:oracle:thin:@//oracle-1:1521/FREEPDB1
scalar.db.username=SYSTEM
scalar.db.password=Oracle

PostgreSQL

Run PostgreSQL locally

You can run PostgreSQL in Docker Compose by using the docker-compose.yml file in the scalardb-samples/scalardb-cluster-standalone-mode directory.

To start PostgreSQL, run the following command:

docker compose up -d postgres

Configure ScalarDB Cluster

The scalardb-cluster-node.properties file in the scalardb-samples/scalardb-cluster-standalone-mode directory contains database configurations. Please uncomment the properties for PostgreSQL in the scalardb-cluster-node.properties file so that the configuration looks as follows:

# For PostgreSQL
scalar.db.storage=jdbc
scalar.db.contact_points=jdbc:postgresql://postgres-1:5432/
scalar.db.username=postgres
scalar.db.password=postgres

SQL Server

Run SQL Server locally

You can run SQL Server in Docker Compose by using the docker-compose.yml file in the scalardb-samples/scalardb-cluster-standalone-mode directory.

To start SQL Server, run the following command:

docker compose up -d sqlserver

Configure ScalarDB Cluster

The scalardb-cluster-node.properties file in the scalardb-samples/scalardb-cluster-standalone-mode directory contains database configurations. Please uncomment the properties for SQL Server in the scalardb-cluster-node.properties file so that the configuration looks as follows:

# For SQL Server
scalar.db.storage=jdbc
scalar.db.contact_points=jdbc:sqlserver://sqlserver-1:1433;encrypt=true;trustServerCertificate=true
scalar.db.username=sa
scalar.db.password=SqlServer22

NewSQL databases

Select your NewSQL database.

YugabyteDB

Run YugabyteDB locally

You can run YugabyteDB in Docker Compose by using the docker-compose.yml file in the scalardb-samples/scalardb-cluster-standalone-mode directory.

To start YugabyteDB, run the following command:

docker compose up -d yugabyte

Configure ScalarDB Cluster

The scalardb-cluster-node.properties file in the scalardb-samples/scalardb-cluster-standalone-mode directory contains database configurations. Please uncomment the properties for YugabyteDB in the scalardb-cluster-node.properties file so that the configuration looks as follows:

# For Yugabyte
scalar.db.storage=jdbc
scalar.db.contact_points=jdbc:yugabytedb://yugabyte-1:5433/postgres
scalar.db.username=yugabyte
scalar.db.password=yugabyte

NoSQL databases

Select your NoSQL database.

Cassandra

Run Cassandra locally

You can run Apache Cassandra in Docker Compose by using the docker-compose.yml file in the scalardb-samples/scalardb-cluster-standalone-mode directory.

To start Apache Cassandra, run the following command:

docker compose up -d cassandra

Configure ScalarDB Cluster

The scalardb-cluster-node.properties file in the scalardb-samples/scalardb-cluster-standalone-mode directory contains database configurations. Please uncomment the properties for Cassandra in the scalardb-cluster-node.properties file so that the configuration looks as follows:

# For Cassandra
scalar.db.storage=cassandra
scalar.db.contact_points=cassandra-1
scalar.db.username=cassandra
scalar.db.password=cassandra

Cosmos DB for NoSQL

To use Azure Cosmos DB for NoSQL, you must have an Azure account. If you don't have an Azure account, visit Create an Azure Cosmos DB account.

Configure Cosmos DB for NoSQL

Set the default consistency level to Strong according to the official document at Configure the default consistency level.

Configure ScalarDB Cluster

The scalardb-cluster-node.properties file in the scalardb-samples/scalardb-cluster-standalone-mode directory contains database configurations. Be sure to change the values for scalar.db.contact_points and scalar.db.password as described.

# For Cosmos DB
scalar.db.storage=cosmos
scalar.db.contact_points=<COSMOS_DB_FOR_NOSQL_URI>
scalar.db.password=<COSMOS_DB_FOR_NOSQL_KEY>

note

You can use the primary key or the secondary key in your Azure Cosmos DB account as the value for scalar.db.password.

DynamoDB

Run Amazon DynamoDB Local

You can run Amazon DynamoDB Local in Docker Compose by using the docker-compose.yml file in the scalardb-samples/scalardb-cluster-standalone-mode directory.

To start Amazon DynamoDB Local, run the following command:

docker compose up -d dynamodb

Configure ScalarDB Cluster

The scalardb-cluster-node.properties file in the scalardb-samples/scalardb-cluster-standalone-mode directory contains database configurations. Please uncomment the properties for Amazon DynamoDB Local in the scalardb-cluster-node.properties file so that the configuration looks as follows:

# For DynamoDB Local
scalar.db.storage=dynamo
scalar.db.contact_points=sample
scalar.db.username=sample
scalar.db.password=sample
scalar.db.dynamo.endpoint_override=http://dynamodb-1:8000

Set the license key

Set the license key (trial license or commercial license) for the ScalarDB Clusters in the configuration file scalardb-cluster-node.properties. For details, see How to Configure a Product License Key.

Start ScalarDB Cluster in standalone mode

To start ScalarDB Cluster in standalone mode, run the following command:

note

If you want to change other configurations for ScalarDB Cluster, update the scalardb-cluster-node.properties file before running the command below.

docker compose up -d scalardb-cluster-node

Client configurations for the ScalarDB Cluster Java API

You can use the indirect client mode to connect to ScalarDB Cluster in standalone mode. For details about client configurations for the ScalarDB Cluster Java API, see Developer Guide for ScalarDB Cluster with the Java API.