The Chapter Introduction

  • To take a quick look on basic concepts, please read Basic Concepts.
  • A detailed example is given in section Database Sharding to introduce how to use Sharding-JDBC to shard database or table.
  • To further improve performance after sharding, you can read Read-write splitting.
  • In consideration of flexible and complex Sharding-JDBC configuration, Domain Model Configuration clearly shows you the relationships among the various configuration classes.
  • Configuration Manual describes how to configure some items with JAVA, YAML, Spring or Spring Boot.
  • To manage the access to databases, please read Orchestration.
  • Generally Sharding-JDBC obtains sharded data through SQL parsing, but the data can also be got using the Mandatory Routing. You perfer to choose this strategy for the expansion of existing system.
  • How to generate the Distributed primary key? Distributed Primary key will give you the answer.
  • How to implement transaction support? Transaction Support describes how Sharding-JDBC implements distributed transactions by using B.A.S.E Transaction.
  • Will the pagination affect the performance? How to deal with the subquery SQL for pagination in Oracle or SQLServer? Please read Pagination & Subqueries.
  • How does Sharding-JDBC run unit testing and integration testing? You can get answer in Test Engine.
  • Do you want to find performance problems? Please refer to the recommendations in the Application Performance Monitoring (APM).