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 and the Vertical Partition engines, including the related technology of UDFs that come with the engines. Practical instructions of how to install and use these technologies will be provided during the session.
Giuseppe Maxia, a.k.a. “The Data Charmer” is the MySQL community team lead at Sun Microsystems.
He’s an active member of the MySQL community and long timer open source enthusiast. During the past 23 years he has worked in various IT related fields, with focus on databases, object oriented programming, system administration. Fluent in Italian, English, Perl, SQL, Lua, C, Bash, and good speaker of C++, French, Spanish, Java. Works in cyberspace, with a virtual team.
Comments on this page are now closed.
For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at scordesse@oreilly.com
Download the OSCON Sponsor/Exhibitor Prospectus
Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com
For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the OSCON Newsletter (login required)
Have an idea for OSCON to share? oscon-idea@oreilly.com
View a complete list of OSCON contacts
Comments
The slides are available at tinyurl.com/mass-sharding. Also, my blog has an article that describes the installation. tinyurl.com/mass-sharding-blog
Giuseppe,
Would you mind posting the slides from your talk? It’d be really helpful. Thanks!
Very informative and helpful solution to a common problem. Not much information about real-world problems and solutions.