MySQL scaling horizontal and vertical

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

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]
[url]https://www.percona.com/blog/2009/08/06/why-you-dont-want-to-shard/[/url]
[url]https://www.percona.com/blog/2018/08/29/scaling-io-bound-workloads-mysql-cloud/[/url]
[url]https://www.percona.com/blog/2016/08/30/mysql-sharding-with-proxysql/[/url]

If you are interested in assistance with full solution, you may check our consulting services.