Advanced Sharding Techniques with Spider

Average rating: ***..
(3.00, 3 ratings)

Spider and Vertical Partitioning Storage Engine will be introduced by Giuseppe in this Conference.
In this session, I’ll introduce some additional tips for joinable database sharding using Spider and Vertical Partitioning.

I want to introduce some tips of Spider and Vertical Partitioning like following.

  • How to create joinable database shards without stopping the service.
  • How to re-shard joinable databese shards without stopping the service.
  • How to add an index on databese shards without stopping the service.
  • How to change schema on databese shards without stopping the service.
  • How to set up cluster for fault tolerance without stopping the service.
  • How to add new node after failover and preparing new server without stopping the service.
Photo of Kentoku SHIBA

Kentoku SHIBA


I am a Storage Engine Developer for MySQL in Japan, and the
original developer of the Spider Storage Engine and Vertical Partitioning Storage Engine.

Spider Storage Engine and Vertical Partitioning Storage Engine are being offered to the public by GPL.

Photo of Daniel Saito

Daniel Saito


Daniel has worked in the MySQL organization for the past 5 years, as he
was originally responsible for the launch and growth of the MySQL
organization in the Asia Pacific region. As the first employee in the
region, he played a key role in expanding both the business and
community efforts for MySQL. Currently residing in Tokyo, he is currently
responsible for sales, partner and community development around the
Asia Pacific region. He has engaged with several high profile Web
2.0, Enterprise and OEM customers in embracing MySQL. His ongoing efforts
have successfully fostered the growth and contributions of several
community and commercial developers in guiding and promoting open
source development surrounding MySQL technologies.

Comments on this page are now closed.


Picture of Sheeri K. Cabral
Sheeri K. Cabral
04/20/2010 11:30pm PDT

Video for this session is at

  • Oracle
  • Monty Program
  • Calpont
  • Facebook
  • Gear6
  • Infobright, Inc
  • JasperSoft
  • Joyent
  • Kickfire
  • NorthScale, Inc.
  • Percona
  • Schooner Information Technology
  • Solid Quality Mentors (SolidQ)
  • Intel
  • Pentaho
  • Linux Pro Magazine

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at

Download the O'Reilly MySQL Conference & Expo Sponsor/ Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@

Press and Media

For media-related inquiries, contact Maureen Jennings at

O'Reilly MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference newsletter (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference contacts.