Raja_KT
Architect
Architect
  • UID6384
  • Fans5
  • Follows3
  • Posts555
Reads:34636Replies:0

Vertical, Hortizonal sharding, read/write separation , NewSQL....

Created#
More Posted time:Jan 30, 2019 17:08 PM


https://www.alibabacloud.com/blog/breaking-the-limits-of-relational-databases-an-analysis-of-cloud-native-database-middleware-1_594427?spm=a2c65.11461433.0.0.47b65355t8Ve46


TL;DR
Vertical, Hortizonal sharding, read/write separation , NewSQL.... There is no one size fits for all


....Most relational database products use B+ tree indexes. When the data volume exceeds the threshold, the increase in the index depth leads to an increased disk I/O count, the substantially degrading query performance.......


Although table sharding can resolve the performance problems caused by massive data, it cannot resolve the problem of slow responsiveness caused by excessive requests to the same database. For this reason, database sharding is often implemented in horizontal sharding to handle the huge data volume and heavy access traffic. Read/write separation is another way to distribute traffic. However, you must consider the latency between data reading and data writing when designing the architecture.


NewSQL with a brand new architecture resolves this problem in a way that is different from that of the sharding middleware:

  1. In NewSQL with the new architecture, the database storage engine is redesigned to store the data from the same table in a distributed file system.
  2. In the sharding middleware, the impacts of sharding are transparent to users, allowing them to use a horizontally sharded database as a common database.

........
Many may ask what is the difference between HTAP vs NewSQL , though :)


Sharding consists of the following processes: statement parsing, statement routing, statement modification, statement execution, and result aggregation.
Community -> Blog -> Breaking the Limits of Relational Databases: An Analysis of Cloud-Native Database Middleware (1)
Street children suffer not because of their fault. We can help them if we want.Contact me.
Guest