Spider: Sharding for the Masses

Giuseppe Maxia speaks about the Spider storage engine for MySQL in "Sharding for the Masses" at FrOSCon 2009.

From the event page at http://programm.froscon.org/2009/events/427.en.html :

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

Test driving the spider storage engine:
http://datacharmer.blogspot.com/2009/04/test-driving-spider-storage-engine.html

Blog post about sharding for the masses:
http://datacharmer.blogspot.com/2009/07/sharding-for-masses-spider-storage.html

Category:

Science & Technology

Tags:

• froscon
• mysql
• spider
• storage engine
• giuseppe maxia
• opensqlcamp