Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

proxysql-admin does not pick up changes from configuration file on restart of proxysql

Description

Hi, I was trying to switch a PXC cluster from loabal to singlewrite.

  1. Updated /etc/proxysql-admin.cnf MODE entry

  2. Tailed /var/lib/proxysql/proxysql_galera_check.log . no change

  3. restarted proxysql

  4. Tailed /var/lib/proxysql/proxysql_galera_check.log . no change

  5. dropped proxysql-admin configuration and added it back

  6. Tailed /var/lib/proxysql/proxysql_galera_check.log . change is visible

Is this really how it is supposed to work? Why can't we have proxysql-admin pick up configuration changes every time it runs (every 3s by default)?  Anything less than that means downtime for the app while either daemon is restarting or actual configuration is disappearing..

Environment

None

Smart Checklist

Activity

Ramesh Sivaraman August 7, 2017 at 4:34 PM

sure, I will create one doc ticket for that.

Michael Coburn August 7, 2017 at 3:47 PM

- Perhaps that should be called out with more emphasis in the documentation, that this tool is for initial setup only?  Until you have a decision and code that supports multiple-execution with --enable that actually renders a change in ProxySQL.

Ramesh Sivaraman August 7, 2017 at 5:27 AM

Yes by default proxysql restart doest not change any configuration settings from proxysql-admin.cnf. proxysql-admin is initial configuration tool. To change any settings we have to re-run proxysql-admin tool.

I will check wether we can change this behaviour.

Done

Details

Assignee

Reporter

Components

Fix versions

Affects versions

Priority

Smart Checklist

Created August 4, 2017 at 7:29 PM
Updated December 2, 2024 at 12:29 PM
Resolved July 29, 2024 at 2:17 PM