---
title: "Discussion on \"System Design Drill Day 6: Sharding and Partitioning a MySQL Orders Table\" | Hashnode"
description: "Discussion on \"System Design Drill Day 6: Sharding and Partitioning a MySQL Orders Table\". How to split a MySQL orders table across shards: choosing a shard key, routing with logical shards, keeping reports off the shards and resharding."
url: "https://hashnode.com/posts/system-design-drill-day-6-sharding-and-partitioning-a-mysql-orders-table/6adc2274a893969df16ce51e"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [System Design Drill Day 6: Sharding and Partitioning a MySQL Orders Table](https://blog.anishansari.com.np/system-design-drill-day-6-sharding-and-partitioning-a-mysql-orders-table?utm_source=hashnode&utm_medium=feed)

How to split a MySQL orders table across shards: choosing a shard key, routing with logical shards, keeping reports off the shards and resharding.

Oct 24 · 7 min read · blog.anishansari.com.np  
Read the article

-   [#system-design](https://hashnode.com/tag/system-design)
-   [#mysql](https://hashnode.com/tag/mysql)
-   [#databases](https://hashnode.com/tag/databases)
-   [#scalability](https://hashnode.com/tag/scalability)
-   [#interview-preparation](https://hashnode.com/tag/interview-preparation)

## Written by

[Anish Ansari](https://hashnode.com/@anish78)

@anish78 · kathmandu, Nepal

  
[View profile](https://hashnode.com/@anish78)

Food,Code and Cloud Computing. You can support here :https://www.buymeacoffee.com/anishansari

## Responses

Markdown supported · ⌘↵ to post

No responses yet.