Partitions

MariaDB Enterprise Server provides several methods to segment data for enterprise workloads. Partitioning allows segmentation of data on disk on a single server. In contrast, sharding allows the segmentation of data in shards across multiple servers.

Benefits of partitioning include:

  • The ability to archive and purge unneeded data on a per-partition basis.

  • The ability to perform backup and restore of selective groups of tables.

  • The ability to optimize workloads to underlying disk capacity and storage performance.

Additional Resources

Information on this topic may be found in the MariaDB Public KB.