Spider Storage Engine for the sharding

Tuesday 5:25PM-5:50PM

@ Room 203

SHIBA

25 minutes conference

Intermediate

Tracks:
Developer

Spider is a Storage Engine of MySQL and MariaDB for database sharding. This Storage Engine is 10 years old and bundled in MariaDB 10.0 and later. Spider supports the following things.
- Dividing a huge data into multiple servers. (sharding)
- Dividing a lot of accesses into multiple servers. (sharding)
- Joining tables on multiple servers. (cross shard join)
- Parallel processing on multiple servers. (parallel processing)
- Use bunch of databases as a database. (federating)
- Design and control data redundancy per table and partition. (redundancy)
- Design and control fault tolerance per table and partition. (fault tolerance)
- Parallel fulltext search on multiple servers. (fulltext searching)
- Parallel spacial search on multiple servers. (spacial searching)
- Dividing NoSQL access into multiple servers. (NoSQL)

In this session, I will introduce Spider and the latest Spider 3.3(GA) features.


Speakers

Kentoku SHIBA

Kentoku SHIBA (Spiral Arms LLC)

CEO

Biography:

Storage Engine Developer. His main works are creating and improving Spider Storage Engine for database sharding, Vertical Partitioning Storage Engine for column base table partitioning. And also he is a developer of "Mroonga Storage Engine" for fast full-text searching especially for CJK languages. He has experience interacting with the MySQL RDBMS as a developer, administrator, and sometimes also application developer. He has deployed MySQL in a variety of different environments, including corporate intranets, high-traffic web sites, and mission-critical applications, and is a vocal advocate of MySQL in his role as a software consultant. All his experiences have got involve to focus on developing his Spider. He has focus on both MariaDB and MySQL. Recently, his storage engine Spider has bundle on MariaDB 10.0.


Slides



  Download Slides  

Connect with Percona

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863