# Spider

- [Spider Storage Engine Overview](/docs/server/server-usage/storage-engines/spider/spider-storage-engine-overview.md): 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.
- [Spider Storage Engine Introduction](/docs/server/server-usage/storage-engines/spider/spider-storage-engine-introduction.md): 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.
- [MariaDB Enterprise Spider Schema Design](/docs/server/server-usage/storage-engines/spider/spider-storage-engine-introduction/mariadb-enterprise-spider-schema-design.md): Learn about the schema design of the Spider storage engine.
- [MariaDB Enterprise Spider Operations](/docs/server/server-usage/storage-engines/spider/spider-storage-engine-introduction/mariadb-enterprise-spider-operations.md): Learn about Spider operations in MariaDB Enterprise Server. This section covers advanced configurations, management, and best practices for leveraging Spider in enterprise environments.
- [Federated MariaDB Enterprise Spider Topology Operations](/docs/server/server-usage/storage-engines/spider/spider-storage-engine-introduction/mariadb-enterprise-spider-operations/federated-mariadb-enterprise-spider-topology-operations.md): This section covers operational guides for managing a Federated Spider topology, including migrating tables and performing backup and restore.
- [Spider Federated Overview](/docs/server/server-usage/storage-engines/spider/spider-storage-engine-introduction/mariadb-enterprise-spider-operations/federated-mariadb-enterprise-spider-topology-operations/spider-federated-overview.md): An overview of the federated topology for Spider, where a single Spider node aggregates data from multiple remote data nodes, acting as a unified access point.
- [Federated MariaDB Enterprise Spider Topology Backup and Restore](/docs/server/server-usage/storage-engines/spider/spider-storage-engine-introduction/mariadb-enterprise-spider-operations/federated-mariadb-enterprise-spider-topology-operations/federated-mariadb-enterprise-spider-topology-backup-and-restore.md): Procedures for performing consistent backups and restores in a federated Spider topology using MariaDB Backup and MariaDB Dump, ensuring data synchronization.
- [Federated MariaDB Enterprise Spider Topology Migrate Tables](/docs/server/server-usage/storage-engines/spider/spider-storage-engine-introduction/mariadb-enterprise-spider-operations/federated-mariadb-enterprise-spider-topology-operations/federated-mariadb-enterprise-spider-topology-migrate-tables.md): A guide on how to migrate tables from a standard MariaDB deployment to a Federated Spider topology, distributing data across multiple backend nodes.
- [ODBC MariaDB Enterprise Spider Topology Operations](/docs/server/server-usage/storage-engines/spider/spider-storage-engine-introduction/mariadb-enterprise-spider-operations/odbc-mariadb-enterprise-spider-topology-operations.md): Learn about ODBC operations in MariaDB Enterprise Spider topology. This section covers configuring and managing ODBC connections to distributed Spider environments for seamless data access.
- [Use Spider ODBC to Connect to Oracle](/docs/server/server-usage/storage-engines/spider/spider-storage-engine-introduction/mariadb-enterprise-spider-operations/odbc-mariadb-enterprise-spider-topology-operations/use-spider-odbc-to-connect-to-oracle.md): This guide details how to configure Spider to connect to an Oracle database via ODBC, enabling data migration and federated access to Oracle tables.
- [Sharded MariaDB Enterprise Spider Topology Operations](/docs/server/server-usage/storage-engines/spider/spider-storage-engine-introduction/mariadb-enterprise-spider-operations/sharded-mariadb-enterprise-spider-topology-operations.md): Learn about ODBC operations in MariaDB Enterprise Spider topology. This section covers configuring and managing ODBC connections to distributed Spider environments for seamless data access.
- [Spider Sharded Overview](/docs/server/server-usage/storage-engines/spider/spider-storage-engine-introduction/mariadb-enterprise-spider-operations/sharded-mariadb-enterprise-spider-topology-operations/spider-sharded-overview.md): Provides an overview of using Spider for sharding in MariaDB Enterprise Server, allowing data distribution across multiple nodes for horizontal scalability.
- [Sharded MariaDB Enterprise Spider Topology Add a Shard](/docs/server/server-usage/storage-engines/spider/spider-storage-engine-introduction/mariadb-enterprise-spider-operations/sharded-mariadb-enterprise-spider-topology-operations/sharded-mariadb-enterprise-spider-topology-add-a-shard.md): Instructions on how to expand a sharded Spider topology by adding new data nodes (shards) and rebalancing the data distribution.
- [Sharded MariaDB Enterprise Spider Topology Backup and Restore](/docs/server/server-usage/storage-engines/spider/spider-storage-engine-introduction/mariadb-enterprise-spider-operations/sharded-mariadb-enterprise-spider-topology-operations/sharded-mariadb-enterprise-spider-topology-backup-and-restore.md): Guidelines for backing up and restoring a sharded Spider topology, ensuring consistency across multiple shards using tools like MariaDB Backup.
- [Spider Differences Between SpiderForMySQL and MariaDB](/docs/server/server-usage/storage-engines/spider/spider-differences-between-spiderformysql-and-mariadb.md): This page outlines the differences between the standalone SpiderForMySQL distribution and the version integrated into MariaDB Server, including version correspondence and feature availability.
- [Spider Feature Matrix](/docs/server/server-usage/storage-engines/spider/spider-feature-matrix.md): A matrix listing the features supported by Spider, including sharding, partitioning, XA transactions, and support for various SQL statements and functions.
- [Spider Use Cases](/docs/server/server-usage/storage-engines/spider/spider-use-cases.md): Describes common use cases for Spider, such as horizontal sharding for scalability, consolidating data from multiple sources, and migrating data between servers.
- [Spider Installation](/docs/server/server-usage/storage-engines/spider/spider-installation.md): A guide to installing the Spider storage engine on Debian/Ubuntu and other Linux distributions, including loading the plugin and configuring data nodes.
- [Spider Cluster Management](/docs/server/server-usage/storage-engines/spider/spider-cluster-management.md): Covers advanced management topics like executing direct SQL on backends, copying tables between nodes, and monitoring the cluster using status variables.
- [Spider Case Studies](/docs/server/server-usage/storage-engines/spider/spider-case-studies.md): A list of real-world companies and projects using Spider for high-volume data handling, gaming, and analytics, illustrating its scalability.
- [Spider Benchmarks](/docs/server/server-usage/storage-engines/spider/spider-benchmarks.md): Performance benchmark results for Spider, demonstrating its throughput and latency characteristics under various workloads compared to other configurations.
- [Information Schema SPIDER\_WRAPPER\_PROTOCOLS Table](/docs/server/server-usage/storage-engines/spider/information-schema-spider_wrapper_protocols-table.md): Describes the SPIDER\_WRAPPER\_PROTOCOLS table, which lists the available foreign data wrappers (like \`mysql\`) that Spider can use to connect to remote servers.
- [Spider Storage Engine Core Concepts](/docs/server/server-usage/storage-engines/spider/spider-storage-engine-core-concepts.md): Explains the fundamental concepts behind Spider, including its architecture as a proxy storage engine, sharding capabilities, and support for XA transactions across data nodes.
- [Spider System Variables](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md): Comprehensive list of system variables to configure Spider globally or per session, affecting connection timeouts, buffering, and query pushdown strategies.
- [Spider Table Parameters](/docs/server/server-usage/storage-engines/spider/spider-table-parameters.md): 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.
- [Spider Functions](/docs/server/server-usage/storage-engines/spider/spider-functions.md): 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.
- [SPIDER\_BG\_DIRECT\_SQL](/docs/server/server-usage/storage-engines/spider/spider-functions/spider_bg_direct_sql.md): This UDF allows you to execute SQL statements on remote data nodes in the background, enabling concurrent processing and non-blocking operations.
- [SPIDER\_COPY\_TABLES](/docs/server/server-usage/storage-engines/spider/spider-functions/spider_copy_tables.md): Learn how to use this function to copy table data from one Spider link ID to another, useful for migrating data or rebalancing shards without stopping the service.
- [SPIDER\_DIRECT\_SQL](/docs/server/server-usage/storage-engines/spider/spider-functions/spider_direct_sql.md): This function executes an SQL string directly on a specified remote backend server, allowing for maintenance tasks or queries that bypass local parsing.
- [SPIDER\_FLUSH\_TABLE\_MON\_CACHE](/docs/server/server-usage/storage-engines/spider/spider-functions/spider_flush_table_mon_cache.md): Use this UDF to refresh the cache used by Spider's monitoring threads, ensuring that the status of remote tables and connections is up to date.
- [Spider FAQ](/docs/server/server-usage/storage-engines/spider/spider-faq.md): Frequently asked questions about Spider, covering troubleshooting common errors, configuration best practices, and architectural questions regarding HA and sharding.