Comments on: Horizontal Scaling in MySQL – Sharding Followup https://www.percona.com/blog/horizontal-scaling-in-mysql-sharding-followup/ Sat, 09 Oct 2021 15:34:16 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Ivan Baldo https://www.percona.com/blog/horizontal-scaling-in-mysql-sharding-followup/#comment-10973365 Sat, 09 Oct 2021 15:34:16 +0000 https://www.percona.com/blog/?p=78204#comment-10973365 Would be interesting a post on TiDB too.

]]> By: Michael Coburn https://www.percona.com/blog/horizontal-scaling-in-mysql-sharding-followup/#comment-10973354 Tue, 05 Oct 2021 20:09:21 +0000 https://www.percona.com/blog/?p=78204#comment-10973354 Hi @Neo thanks for your reply! You do highlight a very useful sharding tool for MySQL in Vitess, which is a product that Percona loves and often recommends and deploys as a solution for our Customers. We don’t dispute that there is great value in Vitess. What we like to do on the blog is to highlight many options, and in our opinion ProxySQL is easier to deploy given it is less invasive to your database stack (at least compared to Vitess, which is really a lift-and-shift operation).

Again we appreciate your feedback, and this has led Michael and I to consider doing (another) followup post where we explore more complex solutions such as Vitess!

]]> By: Neo https://www.percona.com/blog/horizontal-scaling-in-mysql-sharding-followup/#comment-10973343 Sun, 03 Oct 2021 17:27:17 +0000 https://www.percona.com/blog/?p=78204#comment-10973343 With all due respect, Vitess is the solution for sharding MySQL, it supports increase and decrease of shards without downtime and also supports changing sharding key. The scatter gather SQL pattern is also supported.

In my opinion ProxySQL is an inferior sharding solution Vitess.

]]>