Výkonnostní porovnání Open Source NewSQL databázových systémů

The goals of this thesis are to perform a market analysis of open source NewSQL database systems, to choose a suitable benchmark for their comparison and to compare chosen systems using this benchmark. The database systems of choice are CockroachDB and TiDB. Benchmark of choice is TPC-C, which measures the throughput of a database based on the tpmC metric that measures the quantity of new order type transactions per minute. TPC-C is configured for ten and twenty warehouses and each specific test is performed ten times. The average of those is then interpreted to determine the results of the comparison in a specific testing environment.The goals are picked to give the author and the reader a broad understanding of open source NewSQL databases and their performance benchmarking. The main representatives are found by a market analysis, two most popular ones are chosen for further analysis. On these, the process of performance benchmarking is presented. The goals also exemplify the process of picking a suitable open source NewSQL database system by performance in a production environment.The main benefit of this thesis is a performance comparison of chosen OpenSource NewSQL database systems, CockroachDB and TiDB, using the TPC-C benchmark. CockroachDB performed better when measuring the throughput using tpmC and had a better increase in performance when the benchmark load scaled with different TPC-C parametres. It is possible to analogously perform these steps to test the systems in production environments and to determine which one of them performs better. Another benefit is the introduction to the concept of NewSQL database systems and further specifics of selected systems.