Tag: Sharding

Installation, Troubleshooting

Spider for MySQL – Implementation

In a previous post, I wrote an overview about Spider for MySQL with its advantages and disadvantages. Now I’ll go through a simple example demonstrating how to implement Spider for MySQL. System information: MySQL instances information (shards): Spider instance information: Note: More information on how to install tar-ball binaries can be checked out here. Testing …


What is the default sharding key in MySQL Cluster?

MySQL Cluster does an automatic sharding/partitioning to the tables across data nodes, enabling databases to scale horizontally to serve read and write-intensive workloads, but what is the default sharding key used in partitioning the data? According to the recent update (Oct, 2016) of the MySQL Cluster white paper, primary key is the default sharding key: …