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
Open the zip file downloaded in Explorer. Check if transactd.dll is exists.
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 | +---------------+----------------------------------------------------+
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
Move to the directory where downloaded tar.gz file is.
cd [TargetFolder]
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
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/
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.
root@127.0.0.1
allows access from a local machine.root@192.168.0.3
allows access from host 192.168.0.3.root@192.168.0.0/255.255.255.0
allows access from host 192.168.0.x.
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.