BestHub
search
Sign in
Tag

Global Table

1 views collected around this technical thread.

Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 29, 2020 · Databases

Why Mycat Fails and DBLE Succeeds in Global Table Left Join with Sharded Tables

This article analyzes a community‑raised issue where a left join between a global table and a sharded table produces incorrect results in Mycat but works as expected in DBLE, explaining the underlying execution‑plan differences and how DBLE correctly merges results to avoid duplicate data.

DBLEDistributed DatabaseGlobal Table
0 likes · 5 min read
Why Mycat Fails and DBLE Succeeds in Global Table Left Join with Sharded Tables
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 13, 2019 · Databases

Understanding Global Tables in DBLE: Configuration and Join Operations

This article explains what Global tables are in DBLE, how to configure them in schema.xml, and demonstrates their behavior during various JOIN operations across sharded databases, highlighting benefits and performance considerations for low‑change, low‑concurrency dictionary data.

DBLEDatabase MiddlewareGlobal Table
0 likes · 7 min read
Understanding Global Tables in DBLE: Configuration and Join Operations