Dynamic proxysql configuration for pxc cluster

Description

Before, pxc cluster was working as a regular one and everything was ok. Now, when we  implemented the cross cluster replication, we have to set one of pxc cluster as read only(with SET GLOBAL READ_ONLY=0), which causes the proxysql to crash and fall to crash loop.
We need some mechanism in proxysql-admin to tell to proxysql without restart that cluster read-only state is changed.

Currently, we have the following error

As we discussed yesterday on the call, it's possible to avoid this situation with fix in proxysql-admin tool, without changing or implementing the scheduler

Environment

None

Smart Checklist

Activity

Show:
Done

Details

Assignee

Reporter

Time tracking

1d 3h 15m logged

Fix versions

Priority

Smart Checklist

Created September 2, 2021 at 9:23 AM
Updated March 6, 2024 at 5:32 PM
Resolved October 22, 2021 at 11:13 AM