froscon2009 - 1.0
FrOSCon
Free and Open Source Software Conference
Referenten | |
---|---|
![]() |
Giuseppe Maxia |
Programm | |
---|---|
Tag | Day 1 (2009-08-22) |
Raum | C120/OpenSQLCamp |
Beginn | 10:00 |
Dauer | 01:00 |
Info | |
ID | 427 |
Veranstaltungstyp | Vortrag |
Track | OpenSQLCamp |
Sprache der Veranstaltung | englisch |
Feedback | |
---|---|
Haben Sie diese Veranstaltung besucht? Feedback abgeben |
Sharding for the masses
Introducing the spider storage engine

Everybody needs sharding. Which is not easy to maintain. Being tied to the application layer, sharding is hard to export and to interact with. The Spider storage engine, a plugin for MySQL 5.1 and later, solves the problem in a transparent way.
The Spider storage engine, a plugin for MySQL 5.1 and later, is an extension of partitioning. Using this engine, the user can deal transparently with multiple backends in the server layer. This means that the data is accessible from any application without code changes. This lecture will briefly introduce MySQL partitioning, and then shows how to create and use the Spider engine, with some practical examples. This talk covers the latest version of the Spider engine, which includes a condition pushdown feature that increases performance significantly