LeanXcale Quick Guide

LeanXcale is a distributed database built for scalability and performance. This quick guide provides an introduction to the basics. If you want to go deeper, you can read the Concepts and Architecture documentation.

1. Installation

Installing LeanXcale is very easy. You just have to copy the tgz file with the LeanXcale binaries, untar it, install a few prerequisites and you’re set to go.

Please give a look to the Installation Guide.

2. Basic Operations

In this section you’ll learn how to use the basic operations to manage LeanXcale. Give a look to the Operations Manual to get a deeper look.

  • Start Cluster:

user@host:~/lxs$ admin/startcluster.sh

  • Stop Cluster:

# Stops everything
user@host:~/lxs$ admin/stopcluster.sh MS ZK

# Stops all the components except Zookeeper
user@host:~/lxs$ admin/stopcluster.sh

  • Check the Cluster components and its ports:

user@host:~/lxs$ admin/checkcluster.sh

  • Hot Backup:

user@host:~/lxs$ admin/hotbackupcluster.sh

  • Cold Backup:

# First stop all the workload
user@host:~/lxs$ admin/stopcluster.sh MS ZK

# If any component didn't stop, force to kill it
user@host:~/lxs$ admin/stopcluster.sh force

user@host:~/lxs$ admin/backupcluster.sh

Take into account that backup doesn’t store transaction log files so if the system didn’t stop gracefully some information could be lost.

  • Recover: To recover from a previous backup, there is a scripts but assumes you have first stopped the cluster. The recover, will start the cluster once files were recovered

##First stop all the workload
$BASEDIR/admin> ./stopcluster.sh force
$BASEDIR/admin> ./recovercluster.sh
$BASEDIR/admin> ./checkcluster.sh

3. SQL Clients

LeanXcale provides a simple command line client called lxClient, but we recommend you use your favorite JDBC/SQL client. We provide instructions on how to install and configure the SQuirreL SQL client with LeanXcale.

3.1. Creating the schema

Using SQL DDL commands, you can use the client of your choice to create a database and build your schema.

3.2. Monitoring

LeanXcale is distributed with a Prometheus and a Grafana instance with a standard dashboard so you can have a view on how your cluster is running.

You can access the dashboard at http://{Metaserver}:3000/

Default login:

user admin

password admin

Don’t forget to change the password