The Spider Storage Engine
← Back to MySQL University main page
[edit] The Spider Storage Engine
- Date and time: November 26, 2009 (rescheduled from October 15)
- To attend, point your browser to this address. Note that the meeting room will open only 15 minutes before the hour. (This line can be removed after the session.)
- Presenter: Giuseppe Maxia
- Host: Paul DuBois
- Abstract: 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 show 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. - Presentation slides: The spider storage engine
- Session recording: (stream) (download)
- Chat transcript