Home Page >  News List >> Tech >> Tech

21 rules for dividing databases and tables, hold!

Tech 2023-05-16 11:06:13 Source: Network
AD

ShardingSphere5.xt_orderDB_1DB_2t_order_1t_order_2 t_order t_order_0t_order_1t_order_n DB_1

ShardingSphere5.x

t_orderDB_1DB_2t_order_1t_order_2

t_order t_order_0t_order_1t_order_n

DB_1.t_order_1DB_2.t_order_2

t_order t_order_0 t_order_910 t_ordert_order_n

SQLSQL t_orderSQLSQL t_order

SQL

select * from t_order where order_no='A11111'

SQL

select * from DB_1.t_order_n where order_no='A11111'

DB_1.t_order_n

JOIN

  • JOIN

t_cityDB_n.t_order_nJOINJOIN

10001000SQL

t_order SQLSQLorder_no order_no % 2 DB_1 DB_2

order_no t_order order_no

ShardingSphere

  • ID
  • order_no % 2
  • .....

JOIN

t_order t_order_item order_no order_no

t_order t_order_item SQL

SELECT * FROM t_order o JOIN t_order_item i ON o.order_no=i.order_no

SQL

SELECT * FROM t_order_0 o JOIN t_order_item_0 i ON o.order_no=i.order_no SELECT * FROM t_order_0 o JOIN t_order_item_1 i ON o.order_no=i.order_no SELECT * FROM t_order_1 o JOIN t_order_item_0 i ON o.order_no=i.order_no SELECT * FROM t_order_1 o JOIN t_order_item_1 i ON o.order_no=i.order_no 

t_order_n t_order_item_n

SELECT * FROM t_order_0 o JOIN t_order_item_0 i ON o.order_id=i.order_id SELECT * FROM t_order_1 o JOIN t_order_item_1 i ON o.order_id=i.order_id 

t_order t_order_item t_order

SQL

SQL SQL -> -> SQL -> SQL -> SQL ->

SQLSQLSQL

SELECT order_no FROM t_order where  order_status > 0  and user_id = 10086 

SQLFieldTableConditionOrder ByGroup ByLimit SQL

SQLuser_idSQL

SELECT order_no FROM t_order where user_id = 10086 and order_status > 0

SQL

SQL SQL

SQL SQLSQL

3

SQL

SQL = BETWEEN IN SQLSQL

SELECT * FROM t_order  where t_order_id in (1,2)

SQL

SELECT * FROM t_order_0  where t_order_id in (1,2)SELECT * FROM t_order_1  where t_order_id in (1,2)

SQLSQLSQL

t_order t_order_id t_usert_order_id

SELECT * FROM t_order_0 t LEFT JOIN t_user_0 u ON u.user_id = t.user_id WHERE t.user_id = 1SELECT * FROM t_order_0 t LEFT JOIN t_user_1 u ON u.user_id = t.user_id WHERE t.user_id = 1SELECT * FROM t_order_1 t LEFT JOIN t_user_0 u ON u.user_id = t.user_id WHERE t.user_id = 1SELECT * FROM t_order_1 t LEFT JOIN t_user_1 u ON u.user_id = t.user_id WHERE t.user_id = 1

5

DQL DML DDL t_order SQL t_order_0 t_order_n

SET TCL

autocommit

SET autocommit=0;

DCL order order

CREATE USER order@127.0.0.1 identified BY '';

DESCRIBE t_order; 

t_order t_order_0 t_order_n

SQL

USE order_db;

ShardingSphere Schema

SQL

SQLSQL t_order SQL t_order

SELECT * FROM t_order

SELECT * FROM t_order_n

SQL

SQL SQL JDBC

SQL

t_ordert_order_nIDID

ID

IDIDIDID

9ID

SQL

6

API

XASeata

5 Seata +

Shadow Table

21Proxy

ShardingSphere5.x 2


Disclaimer: The content of this article is sourced from the internet. The copyright of the text, images, and other materials belongs to the original author. The platform reprints the materials for the purpose of conveying more information. The content of the article is for reference and learning only, and should not be used for commercial purposes. If it infringes on your legitimate rights and interests, please contact us promptly and we will handle it as soon as possible! We respect copyright and are committed to protecting it. Thank you for sharing.(Email:[email protected])

Mobile advertising space rental

Tag: rules for dividing databases and tables hold

Unite directoryCopyright @ 2011-2024 All Rights Reserved. Copyright Webmaster Search Directory System