froscon2009 - 1.0
FrOSCon
Free and Open Source Software Conference
Speakers | |
---|---|
Giuseppe Maxia |
Schedule | |
---|---|
Day | Day 1 (2009-08-22) |
Room | C120/OpenSQLCamp |
Start time | 10:00 |
Duration | 01:00 |
Info | |
ID | 427 |
Event type | Lecture |
Track | OpenSQLCamp |
Language used for presentation | English |
Feedback | |
---|---|
Did you attend this event? Give Feedback |
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