May 30, 2019
 Percona Live Open Source Database Conference 2019
  Jason Terpko, Antonios Giannopoulos

In a sharded MongoDB cluster, scale and data distribution are defined by your shard keys. Even when choosing the correct shards key, ongoing maintenance and review can still be required to maintain optimal performance.

This presentation will review shard key selection and how the distribution of chunks can create scenarios where you may need to manually move, split, or merge chunks in your sharded cluster. Scenarios requiring these actions can exist with both optimal and sub-optimal shard keys. Example use cases will provide tips on selection of shard key, detecting an issue, reasons why you may encounter these scenarios, and specific steps you can take to rectify the issue.



About the Authors

Jason Terpko

Jason has over 10 years working on various database technologies, which include relational, columnar, and NoSQL platforms. He is currently focused on MongoDB at ObjectRocket by Rackspace supporting customers with existing MongoDB implementations or those just entering the NoSQL space. Before that, Jason worked as a MySQL and Vertica DBA for various firms in Manhattan that were in the financial reporting/investment management industries. He enjoys solving complex problems that involve data distribution, chunk management, and scripting in both Python and Javascript. When not busy with databases, he also spending time outdoors.
 

Antonios Giannopoulos

I am working as Senior NoSQL Database Administrator at ObjectRocket supporting thousands of MongoDB installations over the past 4 years. I have 16 years experience in databases and system engineering. I really enjoy challenges in sharding and schema design and love migrations from Relational to NoSQL world.