Create a trial cluster

A trial cluster can run on a single machine: one SQL broker, one master broker and a few data brokers, each with its own MariaDB database.

1. Prepare MariaDB

Create one database for the master broker and one for each data broker, with a user that has all privileges on it:

create database syndb;
create database DATA0000;
create user 'synsql'@'%' identified by 'a-long-password';
grant all on syndb.* to 'synsql'@'%';
grant all on DATA0000.* to 'synsql'@'%';

2. Write config.txt

The name of a SQL broker or of a master broker is the host name of its machine: the installation connects to it by that name, and a name cannot be used for two brokers. On a single machine, give it several names in /etc/hosts (for example trial-sql and trial-master for 127.0.0.1... or, better, for the address of the machine).

SQL_BROKER      trial-sql     11000 synsql    /var/tmp
MASTER_BROKER   trial-master  3306  synsql    a-long-password  syndb
DATA_BROKER     trial-d0   10.0.0.11 3306 synsql a-long-password DATA0000 DC1 Rack1 *
DATA_BROKER     trial-d1   10.0.0.12 3306 synsql a-long-password DATA0001 DC1 Rack1 *

The data brokers are given by IP address; their name is only a label. See Create a production cluster for the meaning of each column.

3. Check and install

./check_conf.sh
./install.sh

check_conf.sh tests every line: names, ports, IP addresses (ping), logins on every database. Fix what it reports and run it again. install.sh refuses to run if the check did not pass since the last change of config.txt.

4. Start and connect

nohup $HOME/bin/synsqld &
$HOME/bin/synsql -u system -p manager

The installation creates an administrator account named system, with the password manager. Change it at once:

alter user system identified by 'a-long-password';

5. First table

Follow Manage objects in the user's guide.