# Storage Engines

{% columns %}
{% column %}
{% content-ref url="storage-engines/storage-engines-storage-engines-overview" %}
[storage-engines-storage-engines-overview](https://mariadb.com/docs/server/server-usage/storage-engines/storage-engines-storage-engines-overview)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
An introduction to MariaDB's pluggable storage engine architecture, highlighting key engines like InnoDB, MyISAM, and Aria for different workloads.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/choosing-the-right-storage-engine" %}
[choosing-the-right-storage-engine](https://mariadb.com/docs/server/server-usage/storage-engines/choosing-the-right-storage-engine)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
A guide to selecting the appropriate storage engine based on data needs, comparing features of general-purpose, columnar, and specialized engines.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/archive" %}
[archive](https://mariadb.com/docs/server/server-usage/storage-engines/archive)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The Archive storage engine is optimized for high-speed insertion and compression of large amounts of data, suitable for logging and auditing.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/aria" %}
[aria](https://mariadb.com/docs/server/server-usage/storage-engines/aria)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Learn about the Aria storage engine in MariaDB Server. Understand its features, advantages, and use cases, particularly for crash-safe operations and transactional workloads.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/blackhole" %}
[blackhole](https://mariadb.com/docs/server/server-usage/storage-engines/blackhole)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The BLACKHOLE storage engine discards all data written to it but records operations in the binary log, useful for replication filtering and testing.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/connect" %}
[connect](https://mariadb.com/docs/server/server-usage/storage-engines/connect)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The CONNECT storage engine has been deprecated.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/csv" %}
[csv](https://mariadb.com/docs/server/server-usage/storage-engines/csv)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The CSV storage engine stores data in text files using comma-separated values format, allowing easy data exchange with other applications.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/federatedx-storage-engine" %}
[federatedx-storage-engine](https://mariadb.com/docs/server/server-usage/storage-engines/federatedx-storage-engine)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
FederatedX is a storage engine that allows access to tables on remote MariaDB or MySQL servers as if they were local tables.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/innodb" %}
[innodb](https://mariadb.com/docs/server/server-usage/storage-engines/innodb)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Discover InnoDB, the default storage engine for MariaDB Server. Learn about its transaction-safe capabilities, foreign key support, and high performance for demanding workloads.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/memory-storage-engine" %}
[memory-storage-engine](https://mariadb.com/docs/server/server-usage/storage-engines/memory-storage-engine)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The MEMORY storage engine stores tables in RAM for fast access, but data is lost upon server restart.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/merge" %}
[merge](https://mariadb.com/docs/server/server-usage/storage-engines/merge)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The MERGE storage engine allows a collection of identical MyISAM tables to be treated as a single logical table, useful for managing large datasets.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/mroonga" %}
[mroonga](https://mariadb.com/docs/server/server-usage/storage-engines/mroonga)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Mroonga (formerly named Groonga Storage Engine) is a storage engine that provides fast CJK-ready full text searching using column store.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/myisam-storage-engine" %}
[myisam-storage-engine](https://mariadb.com/docs/server/server-usage/storage-engines/myisam-storage-engine)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Explore the MyISAM storage engine in MariaDB Server. Understand its characteristics, including suitability for read-heavy workloads, and its role in specific use cases.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/myrocks" %}
[myrocks](https://mariadb.com/docs/server/server-usage/storage-engines/myrocks)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Learn about the MyRocks storage engine in MariaDB Server. Discover its advantages for flash storage, high write throughput, and compression efficiency in modern database deployments.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/oqgraph-storage-engine" %}
[oqgraph-storage-engine](https://mariadb.com/docs/server/server-usage/storage-engines/oqgraph-storage-engine)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Explore the OQGRAPH storage engine in MariaDB Server. Learn how to efficiently manage hierarchical and complex graph data structures, perfect for social networks and bill of materials.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/performance\_schema-storage-engine" %}
[performance\_schema-storage-engine](https://mariadb.com/docs/server/server-usage/storage-engines/performance_schema-storage-engine)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
While technically a storage engine, PERFORMANCE\_SCHEMA provides a way to inspect internal server execution details at a low level.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/sequence-storage-engine" %}
[sequence-storage-engine](https://mariadb.com/docs/server/server-usage/storage-engines/sequence-storage-engine)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The Sequence engine generates virtual tables of number sequences on the fly, useful for generating series of integers without storing data.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/s3-storage-engine" %}
[s3-storage-engine](https://mariadb.com/docs/server/server-usage/storage-engines/s3-storage-engine)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Integrate MariaDB Server with Amazon S3 using the S3 Storage Engine. Learn how to store and retrieve data directly from cloud object storage for scalability and cost efficiency.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/sphinx-storage-engine" %}
[sphinx-storage-engine](https://mariadb.com/docs/server/server-usage/storage-engines/sphinx-storage-engine)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Integrate MariaDB Server with Sphinx for advanced full-text search. The Sphinx storage engine allows you to query external Sphinx indexes directly from your database.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/spider" %}
[spider](https://mariadb.com/docs/server/server-usage/storage-engines/spider)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Explore the Spider storage engine in MariaDB Server. Learn how to shard data across multiple MariaDB and MySQL servers, enabling horizontal scaling and distributed database solutions.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/videx-storage-engine" %}
[videx-storage-engine](https://mariadb.com/docs/server/server-usage/storage-engines/videx-storage-engine)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The VIDEX storage engine is an aggregated, extensible engine suitable for what-if analyses in MariaDB. The name is derived from \[VI]rtual in\[DEX].
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/converting-tables-from-myisam-to-innodb" %}
[converting-tables-from-myisam-to-innodb](https://mariadb.com/docs/server/server-usage/storage-engines/converting-tables-from-myisam-to-innodb)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This guide outlines the benefits and process of migrating tables from MyISAM to InnoDB, highlighting key differences like transaction support and foreign keys.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/machine-learning-with-mindsdb" %}
[machine-learning-with-mindsdb](https://mariadb.com/docs/server/server-usage/storage-engines/machine-learning-with-mindsdb)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Learn how to integrate MindsDB with MariaDB to train and query machine learning models directly using standard SQL commands.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/legacy-storage-engines" %}
[legacy-storage-engines](https://mariadb.com/docs/server/server-usage/storage-engines/legacy-storage-engines)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Explore legacy storage engines in MariaDB Server. This section provides information on older engines, their historical context, and considerations for migration or compatibility.
{% endcolumn %}
{% endcolumns %}