Comments on: Is MySQL Router 8.2 Any Better? https://www.percona.com/blog/is-mysql-router-8-2-any-better/ Sat, 13 Jan 2024 01:56:42 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: RP.S https://www.percona.com/blog/is-mysql-router-8-2-any-better/#comment-10974248 Sat, 13 Jan 2024 01:56:42 +0000 https://www.percona.com/blog/?p=93350#comment-10974248 Every product has barriers, and we should not only evaluate the good or bad of a product from one angle.

]]> By: hcymysql https://www.percona.com/blog/is-mysql-router-8-2-any-better/#comment-10974245 Fri, 12 Jan 2024 01:31:21 +0000 https://www.percona.com/blog/?p=93350#comment-10974245 The performance of HAProxy has been proven to be the best in production environments. Currently, there is little significance in using proxy solutions like MySQL Router, ProxySQL, MaxScale, etc. for implementing read-write separation, as it can be easily achieved in Java programs.

]]> By: hechunyang https://www.percona.com/blog/is-mysql-router-8-2-any-better/#comment-10974244 Fri, 12 Jan 2024 01:30:08 +0000 https://www.percona.com/blog/?p=93350#comment-10974244 The performance of HAProxy has been proven to be the best in production environments. Currently, there is little significance in using proxy solutions like MySQL Router, ProxySQL, MaxScale, etc. for implementing read-write separation, as it can be easily achieved in Java programs.

]]> By: Frederic Descamps https://www.percona.com/blog/is-mysql-router-8-2-any-better/#comment-10974243 Thu, 11 Jan 2024 23:14:01 +0000 https://www.percona.com/blog/?p=93350#comment-10974243 Ciao Marco !

Since the beginning of the new MySQL Architecture Solutions (InnoDB Cluster, ReplicaSet, ClusterSet, Read Replicas) MySQL Router has been presented as an extension of the MySQL Connector (driver for the programming language used on the application servers). So we always have recommended to have MySQL Router installed on each application servers and, in the case of MySQL InnoDB Cluster for example we also advise to use the Group Replication notification, meaning that all the Routers subscribe to the cluster and the router-farm doesn’t need to poll all the time the MySQL instances, but in case of a membership change, MySQL will send a push notification to the Router. This allow to reduce the amount of queries made by the routers, it’s recommended to keep the check every minute.
And of course, we keep working on Router’s features and Performance.

Cheers,

]]>