Install Transactd Plugin

This document consists of the installation of Transactd Plugin.

Download Transactd Plugin binary

Check the version of your MySQL/MariaDB and download suitable Transactd Plugin binary. If you don't know what is version, start MySQL Command Line client and run following command:

mysql>show variables like 'version';
+---------------+--------+
| Variable_name | Value  |
+---------------+--------+
| version       | 5.6.14 |
+---------------+--------+

Please download the verification version of the Transactd Plugin. (Mac OSX requires a build from the source code.)

You can also build from the source code, if necessary.
How to build from source code, Please refer to the Transactd build guide for Windows or Transactd build guide for Unix.

Installing Transactd Plugin

Transactd Plugin can be installed by copying file, without adding any change to the binary of MySQL/MariaDB. You don't have to stop MySQL/MariaDB to install the plugin. It requires administrator authority.

Installing on Windows

  1. Open the zip file downloaded in Explorer. Check if transactd.dll is exists.

  2. Copy transactd.dll to [MySQL|MariaDB installed directory]/lib/plugin. If you don't know where is [MySQL|MariaDB installed directory], start MySQL Command Line client and run following command:

    mysql>show variables like 'plugin%';
    +---------------+----------------------------------------------------+
    | Variable_name | Value                                              |
    +---------------+----------------------------------------------------+
    | plugin_dir    | C:\Program Files\MySQL\MySQL Server 5.6\lib\Plugin |
    +---------------+----------------------------------------------------+
    
  3. Start MySQL Command Line client and run following command:

    mysql>INSTALL PLUGIN transactd SONAME 'transactd.dll';
    

    Installation of Transactd Plugin is finished now.

Installing on Linux

  1. Move to the directory where downloaded tar.gz file is.

    cd [TargetFolder]
    
  2. Extract the tar.gz file and move into it.

    tar zxf transactd-linux-x86_64-[version]_mysql-5.6.14.tar.gz
    cd transactd-linux-x86_64-[version]_mysql-5.6.14
    
  3. Copy libtransactd.so to [MySQL|MariaDB installed directory]/lib/plugin. If you don't know where is [MySQL|MariaDB installed directory], start MySQL Command Line client and run following command:

    mysql>show variables like 'plugin%';
    +---------------+-----------------------------+
    | Variable_name | Value                       |
    +---------------+-----------------------------+
    | plugin_dir    | /usr/local/mysql/lib/plugin |
    +---------------+-----------------------------+
    mysql>exit
    cp libtransactd.so /usr/local/mysql/lib/plugin/
    
  4. Start mysql client and run following command:

    mysql>INSTALL PLUGIN transactd SONAME 'libtransactd.so';
    

    Installation of Transactd Plugin is finished now.

Setting host permission to access Transactd

To access data through Transactd, register root@[host] to user table of MySQL.

Start MySQL Command Line client and run following commands to register hosts.

mysql>CREATE USER root@'192.168.0.0/255.255.255.0';

This operation allow root user to access database. If the root password is not set, you MUST SET IT.

Setup root password on Windows

Open command prompt and run following command:

"C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqladmin" -u root password 'xxxxx'

(Replace xxxxx to your password.)

Setup root password on Linux

/usr/local/mysql/bin/mysqladmin -u root password 'xxxxx'

(Replace xxxxx to your password.)

Using other name than root

It is also possible to register another user name than "root". In order to use another user name, please add the following to the [mysqld] section of my.cnf or my.ini.

loose-transactd_hostcheck_username = yourUserName

Replace yourUserName to an actual user name.

Setting of firewall

Transactd Plugin uses TCP port 8610 as default. If this port is blocked, please be able to access from your client host.

Test

Now you are ready to access from clients. If a client has been installed, you can run the test.