# Spider - [Spider Storage Engine Overview](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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. --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://mariadb.com/docs/server/server-usage/storage-engines/spider.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.