Transactd Advantage over other NoSQL plugins

Environment Comparison

Environment		Transactd	memcached plugin	HandlerSocket
Unix	MySQL 5.5	o	x	o
	MySQL 5.6	o	o	o
	MySQL 5.7	o	o	x
	MySQL 8.0	Scheduled support	o	x
	MariaDB 5.5	o	x	o
	MariaDB 10.0	o	x	o
	MariaDB 10.1	o	x	o
	MariaDB 10.2	o	x	o
Windows	MySQL 5.5	o	x	x
	MySQL 5.6	o	x	x
	MySQL 5.7	o	x	x
	MySQL 8.0	Scheduled support	x	x
	MariaDB 5.5	o	x	x
	MariaDB 10.0	o	x	x
	MariaDB 10.1	o	x	x
	MariaDB 10.2	o	x	x

The advantage of Transactd

• Transactd Plugin and clients can also runs on Windows as well as Linux.
• Transactd Plugin is compatible with MySQL 5.5/5.6/5.7 and MariaDB 5.5/10.0/10.1/10.2.
• Clients for C++ / PHP / Ruby / ActiveX (COM) are available.

Features Comparison

Feature	Transactd	memcached plugin	HandlerSocket
Read/Insert/Update/Delete	o	o	o
Start Transaction/Commit/Rollback	o	x	x
Create/Drop Database Create/Drop Table	o	x	x
Read multi records	o	x	o
Protocols	Transactd HandlerSocket	memcached	HandlerSocket

The advantage of Transactd

• In addition to the basic operations of Read / Insert / Update / Delete, you can use transaction.
• It can do almost all of the necessary to develop applications, such as create tables or databases etc.
• You can also access by HandlerSocket protocol. (Only some features.)

Speed Comparison

The advantage of Transactd

• In most tests, it is the fastest. In particular, the difference is remarkable in Read-intensive operation.
• About Insert of Update operations, you can do even faster by using Bulk-Insert or Transaction that are not possible on other plugins.
• It works high-speed on Ruby too.

Results list of speed test (click graph to enlarge)

Ubuntu Server and Ubuntu Client
	Read	Read Range	Insert	Insert Transaction	Insert Bulk	Update	Update Transaction
1 client
5 client
Ubuntu Server and Windows Client
	Read	Read Range	Insert	Insert Transaction	Insert Bulk	Update	Update Transaction
1 client
5 client
Windows Server and Ubuntu Client
	Read	Read Range	Insert	Insert Transaction	Insert Bulk	Update	Update Transaction
1 client
5 client
Windows Server and Windows Client
	Read	Read Range	Insert	Insert Transaction	Insert Bulk	Update	Update Transaction
1 client
5 client

Method for measuring

• SQL / memcached / HandlerSocket / Transactd (Ruby) tests are measured by Ruby program.
• Transactd (C++) test. is measured by C++ program.
• SQL test with mysql, memcached test with dalli, HandlerSocket test with handlersocket.
• Measured in MySQL Server 5.6.14.
• Server machine: AMD Opteron (TM) Processor 6212 / 10GB RAM. OS: Ubuntu Server and Windows Server 2012 12.04 x86_64.
• Client machine: Intel (R) Core (TM) 2 Duo CPU P8400@2.26GHz / 4GB RAM. OS: Ubuntu Server 11.10 x86_64 and 7 64bit Windows.