> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/server-usage/storage-engines/spider.md).

# Spider

{% columns %}
{% column %}
{% content-ref url="/pages/7p6U31qB1fv3Gjt9ZWrq" %}
[Spider Storage Engine Overview](/docs/server/server-usage/storage-engines/spider/spider-storage-engine-overview.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
An introduction to the Spider storage engine, which provides built-in sharding by linking to tables on remote MariaDB servers, supporting partitioning and XA transactions.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/4fcgvhDI3GjC4filFc8e" %}
[Spider Storage Engine Introduction](/docs/server/server-usage/storage-engines/spider/spider-storage-engine-introduction.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Explains the architecture of Spider, where a "Spider node" processes queries and distributes them to one or more "Data nodes" that actually store the data.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/ubmjbWst3seQgBnb8uyW" %}
[Spider Differences Between SpiderForMySQL and MariaDB](/docs/server/server-usage/storage-engines/spider/spider-differences-between-spiderformysql-and-mariadb.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This page outlines the differences between the standalone SpiderForMySQL distribution and the version integrated into MariaDB Server, including version correspondence and feature availability.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/lzgEfhWcrICKeRURAhRQ" %}
[Spider Feature Matrix](/docs/server/server-usage/storage-engines/spider/spider-feature-matrix.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
A matrix listing the features supported by Spider, including sharding, partitioning, XA transactions, and support for various SQL statements and functions.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/KN9oThNhalTcPg5DOZgs" %}
[Spider Use Cases](/docs/server/server-usage/storage-engines/spider/spider-use-cases.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Describes common use cases for Spider, such as horizontal sharding for scalability, consolidating data from multiple sources, and migrating data between servers.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/69xiEwlc8CurBz7GqYeg" %}
[Spider Installation](/docs/server/server-usage/storage-engines/spider/spider-installation.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
A guide to installing the Spider storage engine on Debian/Ubuntu and other Linux distributions, including loading the plugin and configuring data nodes.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/JZABp5Ho3khHlOeV0Rdf" %}
[Spider Cluster Management](/docs/server/server-usage/storage-engines/spider/spider-cluster-management.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Covers advanced management topics like executing direct SQL on backends, copying tables between nodes, and monitoring the cluster using status variables.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/zPZStTUme7CmAHFz2Cra" %}
[Spider Case Studies](/docs/server/server-usage/storage-engines/spider/spider-case-studies.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
A list of real-world companies and projects using Spider for high-volume data handling, gaming, and analytics, illustrating its scalability.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/FWPRqyZpOOtrbXVkCzjp" %}
[Spider Benchmarks](/docs/server/server-usage/storage-engines/spider/spider-benchmarks.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Performance benchmark results for Spider, demonstrating its throughput and latency characteristics under various workloads compared to other configurations.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/ahQQEBGNuebmDMzTPCBN" %}
[Information Schema SPIDER\_WRAPPER\_PROTOCOLS Table](/docs/server/server-usage/storage-engines/spider/information-schema-spider_wrapper_protocols-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Describes the SPIDER\_WRAPPER\_PROTOCOLS table, which lists the available foreign data wrappers (like `mysql`) that Spider can use to connect to remote servers.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/agpCPmiIHPpXcd7jh1gJ" %}
[Spider Storage Engine Core Concepts](/docs/server/server-usage/storage-engines/spider/spider-storage-engine-core-concepts.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Explains the fundamental concepts behind Spider, including its architecture as a proxy storage engine, sharding capabilities, and support for XA transactions across data nodes.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/ABOdCKob0UwLMooeye6Z" %}
[Spider System Variables](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Comprehensive list of system variables to configure Spider globally or per session, affecting connection timeouts, buffering, and query pushdown strategies.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/ZT7OXFXSCRZfzf8azJJM" %}
[Spider Table Parameters](/docs/server/server-usage/storage-engines/spider/spider-table-parameters.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
A reference for table-level parameters in Spider, which can be set via the COMMENT or CONNECTION string to control connection settings, monitoring, and query behavior.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/B5uFm1tFK5AQSgIAiXln" %}
[Spider Functions](/docs/server/server-usage/storage-engines/spider/spider-functions.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Explore Spider functions in MariaDB Server. Learn about the specialized functions that enhance data access and manipulation across sharded and distributed databases using the Spider storage engine.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/TZBTtV3eqzQVPwe6H10L" %}
[Spider FAQ](/docs/server/server-usage/storage-engines/spider/spider-faq.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Frequently asked questions about Spider, covering troubleshooting common errors, configuration best practices, and architectural questions regarding HA and sharding.
{% endcolumn %}
{% endcolumns %}