/myharem

MySQL/MariaDB/Percona tool to install multiple instances on the same host, easy and quick.

Primary LanguageShell

myharem

MySQL/MariaDB/Percona tool to install multiple instances on the same host, easy and quick.

INSTALLATION:

Copy all mh-* files under your bin directory.

Copy etc/myharem.conf under /etc and set basedir to your preferred location, user must have privileges.

Under the folder 'myharem/local' put the .tar.gz packages.

GENERAL INSTRUCTIONS:

Type 'mh' for a list of commands.

Type 'mh ' for the syntax.

EXAMPLES:

To install an instance just use:

$ mh deploy <package.tar.gz>

E.g.:

$ mh deploy mariadb-10.1.14-linux-x86_64.tar.gz 10114

To install another instance just use:

$ mh deploy mariadb-10.1.14-linux-x86_64.tar.gz 20114

START AN INSTANCE:

$ mh service start 10114

STOP AN INSTANCE:

$ mh service stop 10014

STATUS OF INSTANCES:

$ mh service status

INSTALL A 3 NODES GALERA CLUSTER:

$ mh deploygalera <package.tar.gz> <first instance id>

E.g.:

$ mh deploygalera mariadb-10.1.14-linux-x86_64.tar.gz 10114

Three Instances will be installed using the following ports:

DB_PORT WSREP_PORT SST_PORT 10114 11114 12114 20114 21114 22114 30114 31114 32114

CONNECT TO INSTANCE:

$ mh cli

CONNECT TO INSTANCE USING SOCKET (MariaDB 10.3+ requires this as root right after installation):

mh scli