May 2, 2017 · Databases

How Spider Engine Enables Transparent Sharding and XA Transactions in MySQL/MariaDB

Spider is a MariaDB storage engine that adds built‑in sharding, table linking, XA‑compatible distributed transactions, and a pluggable architecture, allowing MySQL queries to be transparently routed to multiple backend nodes while preserving compatibility and offering performance‑optimised DirectSQL execution.

MariaDBPluggable EngineSpider

0 likes · 16 min read

How Spider Engine Enables Transparent Sharding and XA Transactions in MySQL/MariaDB

Architecture Digest

Jun 25, 2016 · Databases

Understanding MySQL Logical Architecture and the Pluggable Storage Engine API

This article explains MySQL's overall logical architecture, details each component such as connectors, connection management, parser, optimizer, caches, and the pluggable storage engine framework, and provides examples of the storage engine API functions for creating, opening, scanning, indexing, and handling transactions, plus guidance on building a custom engine.

APIBackend DevelopmentDatabase Architecture

0 likes · 10 min read

Understanding MySQL Logical Architecture and the Pluggable Storage Engine API