Brussels / 1 & 2 February 2014


Spider Storage Engine

The sharding plugin for MySQL/MariaDB

Spider is a storage engine for database sharding for MySQL/MariaDB. Spider is already bundled in MariaDB 10.0. I will introduce Spider and new topics.

Database sharding is the technique of splitting huge datas, a horizontal partition a database or search engine. Each individual partition is referred to as a shard or database shard. Spider Storage Engine enables tables of different MySQL instances to be treated like a table of a same instance. Because XA transaction and partitioning is supported, it can do decentralized arrangement to two or more servers of data of same table. If your database is growing, you need considering to make sharding into multiple servers for splitting data and request. This session is for introducing database sharding especially database level sharding. In addition, some other plugins are convenient by combination with Spider. Spider is a unique and useful plugin of MySQL for database sharding such as a Storage Engine.


St├ęphane Varoqui
Colin Charles