Análise e benchmarking das soluções NewSQL CockroachDB, MemSQL, NuoDB e VoltDB

Advances in Web technologies and the proliferation of mobile and internetconnected devices have created in the area of computing a need to store large amounts of data. The first paradigm to try to organize this data was the relational one. The exponential increase in the volumes of data stored over the years, and at the same time the need to retrieve information with agility, has given rise to new paradigms in databases such as NoSQL (Not Only SQL). Such paradigms were important, but they sacrificed characteristics of traditional banks, such as normalization and integrity. A common scenario in enterprises is to use the same database for OLTP and OLAP processing. This means that there can be no lack of integrity, but at the same time operational transactions can not suffer from the process. In this work, the paradigm studied is NewSQL, created with the intention of integrating the benefits of previous pardigms, offering among its characteristics transactions that respect ACID properties, natively distributed to offer speed and without blocking competition. For this analysis, the benchmark technique was used, using specific domain benchmarks, through a framework called OLTP-Bench. These benchmarks involve an application context, which demonstrates behavior closer to reality in a real-world environment. Three benchmarks were chosen that present loads of different types and complexities, in order to cover the analysis of the processing of loads by the products. This work compared four products that use the NewSQL paradigm, through a benchmarking process, using three tests that employ loads of different types and complexities, in order to cover the analysis of the processing of loads by the products. The analysis can contribute as a reference for future uses of technology. The benchmark results show that in general the product MemSQL was ahead in the observed characteristics, obtaining high throughput rate and low latency. Also, it was also the only product that was able to perform the TPC-H test loads showing more flexibility than other products. The VoltDB and NuoDB products have similar behavior in most of the analyzed contexts, also showing a good execution of the analyzed loads, but can’t finish the execution of the tests of the TPC-H benchmark as well as the product CockroachDB, damaging the analysis on the OLAP processing by part products.