Use Norms

Supported Items

  • Provide the readwrite-splitting configuration of one primary database with multiple replica databases, which can be used alone or with sharding table and database;
  • Support SQL pass-through in independent use of readwrite-splitting;
  • Forcible primary database route based on SQL Hint;

Unsupported Items

  • Data replication between the primary and the replica databases;
  • Data inconsistency caused by replication delay between databases;
  • Double or multiple primary databases to provide write operation;
  • The data for transaction across primary and replica nodes are inconsistent. In the readwrite-splitting model, the primary nodes need to be used for both reading and writing in the transaction.

Optional Items

Item Description Default Range Of Application
queryConsistent When the value is true, if there is write operation in the same thread and database connection, all the following read operations are from the write database to ensure data consistency; false ShardingSphere-JDBC