21 rules for dividing databases and tables, hold!
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
Preliminary Exploration of Data Heterogeneity in Canal (Tips)
NextHow to face the future of embryonic science: can global regulatory agencies keep up?
Guess you like
-
China's Mainland General Display Exports Continue to Grow, But at a Slower PaceDetail
2024-11-05 10:37:59 1
- Detail
-
The State of Cybersecurity in the Financial Services Industry: DDoS Attacks, API Threats, and Mitigation StrategiesDetail
2024-11-04 17:35:37 1
- Detail
-
Seres New Energy Vehicle Sales Surpass 30,000 Units in October, AITO M9 Receives Over 160,000 Pre-orders, Topping Luxury Vehicle Sales Above 500,000 Yuan for Six Consecutive MonthsDetail
2024-11-04 15:17:57 1
-
Shenzhou-18 Triumphantly Returns! Chinese Astronauts Successfully Return to Earth, Sparking Technological ReflectionsDetail
2024-11-04 14:37:46 1
- Detail
-
Why Did WeChat's "Shake" and "Drift Bottle" Disappear? Netizens Share: From Love, Opportunities to AnecdotesDetail
2024-11-02 10:12:09 1
-
Methane Hydrate: From High Hopes to Diminished Enthusiasm, Does It Have a Future?Detail
2024-11-01 20:50:31 1
- Detail
-
Microsoft Announces End of Support for Windows 10 on October 14, 2025, Strongly Recommends Migration to Windows 11Detail
2024-11-01 12:01:58 11
-
Unlocking Another Dimension of the World: From Urban Movement to Outdoor Nouveau RicheDetail
2024-11-01 11:41:06 21
- Detail
- Detail
-
Kuaishou Rural Ecology Conference Kicks Off, Joining Hands with New Farmers to Create a Better LifeDetail
2024-11-01 10:21:07 21
-
Didi Station Bus Empowers Passenger Transport Enterprises to Transform and Upgrade, Providing Convenient and Efficient Travel Services for PassengersDetail
2024-11-01 10:18:08 1
-
Amazon Battles Temu and SHEIN: Can Increased Essentials Sales Revitalize the Giant?Detail
2024-11-01 10:04:45 1
- Detail
-
Returning to Natural Interaction: Hanwang Technology's MOUNTAIN Series Handwritten Notebook Ushers in a New Era of "Native Office"Detail
2024-10-31 15:33:14 1
-
Vtrip Technology Completes Hundreds of Millions of Yuan Series A Financing, Accelerating the Application of VtripGPT Large ModelDetail
2024-10-30 09:40:59 1