MySQL scaling horizontal and vertical

MySQL & MariaDB Other MySQL® Questions
1

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

2

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.