Sharding JDBC introduction
Sharding-jdbc is an open source distributed database middleware developed by Dangdang. Sharding-jdbc has been included in Sharding-Sphere since 3.0. After that, the project entered the Apache incubator and Apache version followed by version 4.0.
ShardingSphere is an ecosystem of open source distributed database middleware solutions, which is composed of three independent products, Sharding-JDBC, Sharding-Proxy and Sharding-Sidecar (planned). They all provide standardized data sharding, distributed transactions, and database governance capabilities.
For now, we only need to focus on Sharding-JDBC, which is positioned as a lightweight Java framework, providing additional services in Java JDBC layer in the form of JAR packages, without additional deployment and dependency, can be understood as an enhanced VERSION of JDBC driver, fully compatible with JDBC and various ORM frameworks.
The core functions of Sharding-JDBC are data Sharding and read/write separation. With Sharding-JDBC, applications can transparently access individual databases using JDBC, regardless of the number of data sources and how the data is distributed.
Compare with JDBC performance
1. Performance loss test: in the case of sufficient server resources and the same number of concurrent applications, compare JDBC and Sharding-JDBC performance loss, and sharding-JDBC relative to JDBC loss does not exceed 7%.
Benchmark performance comparison:
2. Performance comparison test: server resources are used to the limit, and the throughput of JDBC and Sharding-JDBC in the same scenario is the same.
conclusion
Pay attention to me and get more learning materials.
