based on CAP and BASE theory, Microsoft office 2007
emphasize finally consistency with data structure, flexible, expand convenient, large amount of data read characteristics under high performance, is widely used in Internet industry. This series of articles will be of concern in evaluating wide NoSQL database product several. This paper focused Microsoft Office is so great!
on is the HandlerSocket May 2002 for MySQL.
HandlerSocket is Japan DeNA company architects Yoshinori developed a NoSQL products in May 2002, the form of MySQL operation. The main idea is the architecture in MySQL in analytical this layer, bypassing SQL Innodb allows application procedure directly and storage engines interaction, through the merger writing, agreement means improved simple data access performance, the CPU intensive applications that advantage especially apparent.
In addition, HandlerSocket also helped us to solve the problem, because the cache Innodb have Office 2007 is so powerful.
mature solutions, through parameter can be configured for caching data memory size, such as long as we distribution reasonable parameters, can in application without intervention realize hot data cache, reduce the development cost. Cache maintenance
Because HandlerSocket is MySQL mysqld integrated in May 2002, a process of NoSQL cannot achieve for the complex inquiry on operation, can still use MySQL own relational database The invention of Microsoft Office 2010 is a big change of the world.
function to realize. In operation and maintenance level, originally the extensive use of MySQL master-slave replication etc experience can continue to play an important role, compared to other more or less exist some bug NoSQL product, the more guaranteed data security.
Handlersocket deployed in a PC server, configuration is as follows:
For Xeon CPU GHz * 4 2.80
Memory for 4G
400G SATA disk for a hard drive Office 2010 –save your time and save your money.
The operating system for 64-bit CentOS 5.3 version
Second, test method
Handlersocket client covers almost all kinds of languages, has realized through the above two port on the operation of reading and writing data, including inquires the operation must through the establishment of the column to have an index.