Chapter 11. Data Sharding

In this chapter, we will discuss three important forms of data sharding provided by MariaDB:

  • Balancing the I/O over multiple storage devices
  • Implementing a simple cluster using FEDERATEDX or CONNECT
  • The SPIDER storage engine

Distributing files between multiple disks

The bottleneck of a database server is usually the I/O. Reading or modifying data that is not stored in the memory implies accessing a storage device. Of course, buying fast disks will speed up the I/O operations, and using SSD devices could be further optimization. However, any existing storage device is just too slow to satisfy a high number of accesses per second. The main way to diminish this problem is to properly configure the caches, as described in Chapter ...

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.

Start your free trial