Summary

In this chapter, we discussed how to spread some files over multiple disks to obtain better performance when the I/O operations are the system's bottleneck. Both table files and logs can be moved to different storage devices. Particularly, moving some InnoDB tables and logs out of the system tablespace can be very beneficial.

We also discussed how to distribute data over multiple servers to balance the workload. MariaDB is distributed with three storage engines that provide these functionalities:

  • FEDERATEDX
  • CONNECT
  • SPIDER

The FEDERATEDX storage engine is designed to access a single remote table. The CONNECT storage engine is used to access external data in a wide variety of formats, and among other data sources, it supports remote servers. ...

Get Mastering MariaDB now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.