The SPIDER storage engine
Like the FEDERATEDX storage engine and the CONNECT MYSQL table type, SPIDER allows remote access to tables as if they were on the local server. However, the SPIDER storage engine has been specifically designed for data sharding. Its main function is to access data from a multitude of servers by querying a single local table.
Data sharding is implemented in SPIDER using table partitioning. If a SPIDER table is partitioned, each partition can be linked to a different remote table. The SPIDER storage engine is suitable with the RANGE and LIST partitioning methods, including RANGE COLUMNS and LIST COLUMNS.
The SPIDER storage engine supports both regular SQL transactions and XA transactions, if the remote tables support them ...
Get Mastering MariaDB now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
