# MySQL scaling horizontal and vertical

**URL:** https://forums.percona.com/t/mysql-scaling-horizontal-and-vertical/6613
**Category:** Other MySQL® Questions
**Created:** [October 4, 2018, 12:20pm UTC](https://forums.percona.com/t/mysql-scaling-horizontal-and-vertical/6613 "2018-10-04T12:20:43Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![shrenikp7](https://avatars.discourse-cdn.com/v4/letter/s/45deac/32.png) [@shrenikp7](https://forums.percona.com/u/shrenikp7)
#### Post date: [October 4, 2018, 12:20pm UTC](https://forums.percona.com/t/mysql-scaling-horizontal-and-vertical/6613/1 "2018-10-04T12:20:43Z")

</div>

Hell Everyone,

Good morning, how are you? I am wondering if someone can share options available to scale MySQL database horizontally and vertically for ETL load. I am searching for an options to shard table horizontally, each shards can be stored on different host, even though application can see all host as one host.

Thanks  
Shrenik

---

<div class="post-metadata">

### Author: ![przemek](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/przemek/32/3_2.png) [@przemek](https://forums.percona.com/u/przemek)
#### Post date: [October 14, 2018, 6:43am UTC](https://forums.percona.com/t/mysql-scaling-horizontal-and-vertical/6613/2 "2018-10-14T06:43:15Z")

</div>

Hello,

This is to broad topic I am afraid for a forum. In general, MySQL does not have built-in sharding functionality, but you may implement such using many of the available solutions or implement your own logic. Let me share some links which may help you:  
[url][https://www.percona.com/blog/2017/01/30/mysql-sharding-models-for-saas-applications/[/url]](https://www.percona.com/blog/2017/01/30/mysql-sharding-models-for-saas-applications/%5B/url%5D)  
[url][https://www.percona.com/blog/2009/08/06/why-you-dont-want-to-shard/[/url]](https://www.percona.com/blog/2009/08/06/why-you-dont-want-to-shard/%5B/url%5D)  
[url][https://www.percona.com/blog/2018/08/29/scaling-io-bound-workloads-mysql-cloud/[/url]](https://www.percona.com/blog/2018/08/29/scaling-io-bound-workloads-mysql-cloud/%5B/url%5D)  
[url][https://www.percona.com/blog/2016/08/30/mysql-sharding-with-proxysql/[/url]](https://www.percona.com/blog/2016/08/30/mysql-sharding-with-proxysql/%5B/url%5D)

If you are interested in assistance with full solution, you may check our [consulting services.](https://www.percona.com/services/consulting)
