Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to choose sub-database and sub-table and NewSQL". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Next let the editor to take you to learn "sub-library sub-table and NewSQL how to choose" it!

Where is the advanced NewSQL database?

First of all, on the question of whether "middleware + relational database sub-database and sub-table" is regarded as NewSQL distributed database, there is a foreign paper pavlo-newsql-sigmodrec:

Https://db.cs.cmu.edu/papers/2016/pavlo-newsql-sigmodrec2016.pdf

According to the classification in this article, Spanner, TiDB and OB are the first new architecture, while middleware solutions such as Sharding-Sphere, Mycat and DRDS are the second (there is a third kind of cloud database in this article, which will not be described in detail in this article).

Is the mode based on middleware (including SDK and Proxy) + traditional relational database (sub-database and sub-table) distributed architecture?

I think so, because the storage is indeed distributed and can be scaled out. But not a "pseudo" distributed database? From the perspective of the advanced nature of the architecture, there is also some truth in saying so.

"pseudo" is mainly reflected in the generation of SQL parsing and execution plan repeated between the middleware layer and the underlying DB, and the storage engine is based on B+Tree, which is actually redundant and inefficient in the distributed database architecture.

In order to avoid the war of words between true and false distributed databases, NewSQL database in this paper specifically refers to this new architecture NewSQL database.

What is the advantage of NewSQL database compared to middleware + sub-library and sub-table? Draw a simple architectural comparison diagram:

Traditional database is not as efficient as NewSQL database in disk-oriented design, memory-based storage management and concurrency control.

The middleware mode SQL parsing and execution plan optimization work repeatedly in the middleware and database, and the efficiency is relatively low.

The distributed transaction of NewSQL database is optimized compared with XA, and the performance is higher.

The new architecture NewSQL database storage design is based on Paxos (or Raft) protocol multiple copies, compared with the traditional database master-slave mode (semi-synchronous to asynchronous also has the problem of data loss), in order to achieve the real high availability and high reliability (RTO

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.