Comments on: Setup ProxySQL for High Availability (not a Single Point of Failure) https://www.percona.com/blog/setup-proxysql-for-high-availability-not-single-point-failure/ Tue, 06 Feb 2024 00:58:59 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Mikael HOUNDEGNON GBAI https://www.percona.com/blog/setup-proxysql-for-high-availability-not-single-point-failure/#comment-10971331 Tue, 29 Oct 2019 16:56:03 +0000 https://www.percona.com/blog/?p=40291#comment-10971331 @Lina you have to implement proxysql Cluster more details here https://www.percona.com/blog/2018/06/11/proxysql-experimental-feature-native-clustering/

]]> By: Lina, DBA https://www.percona.com/blog/setup-proxysql-for-high-availability-not-single-point-failure/#comment-10970422 Thu, 07 Mar 2019 10:58:33 +0000 https://www.percona.com/blog/?p=40291#comment-10970422 Hello

How you will replicate the creation of new users on the 3 proxysql

]]> By: Ivan https://www.percona.com/blog/setup-proxysql-for-high-availability-not-single-point-failure/#comment-10969494 Tue, 31 Jul 2018 13:58:44 +0000 https://www.percona.com/blog/?p=40291#comment-10969494 Great article Marco. May I suggest removing the weight from check_proxy script? e.g.

vrrp_script check_proxy {
script “killall -0 proxysql”
interval 2
}

Not sure if there is another reason for having that, but I found keepalived behaviour a bit more straight forward this way. It will simply fail over if the script is not successful, otherwise it will substract the script weight you specify from the priority of the vrrp_instance and decide wether to failover based on that.

]]> By: Neo https://www.percona.com/blog/setup-proxysql-for-high-availability-not-single-point-failure/#comment-10968044 Mon, 01 May 2017 07:48:32 +0000 https://www.percona.com/blog/?p=40291#comment-10968044 Hi,

How do we address Split brains with keepalived in “A simple solution based on a single VIP” setup?

]]> By: Ryan https://www.percona.com/blog/setup-proxysql-for-high-availability-not-single-point-failure/#comment-10967766 Tue, 21 Feb 2017 21:27:17 +0000 https://www.percona.com/blog/?p=40291#comment-10967766 If the solution dictated the use of ProxySQL as part of a tile architecture.. What would you recommend as an orchestration tool to keep the ProxySQL config+users in sync?

]]> By: Okky Hendriansyah https://www.percona.com/blog/setup-proxysql-for-high-availability-not-single-point-failure/#comment-10967638 Mon, 30 Jan 2017 07:36:41 +0000 https://www.percona.com/blog/?p=40291#comment-10967638 Hi Marco,

Nice write up and experimentation. I understand the idea to simplify yet improve availability of ProxySQL. But I still do not understand how can multiple VIPs on your last case actually work for applications accessing ProxySQL? Isn’t an application will only point to just one of the VIPs?

Thank you.

Best regards,
Okky

]]>