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

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