O'Reilly logo

Mastering MariaDB by Federico Razzoli

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required