Port configuration to proxysql tables

Description

ProxySQL-Admin has it's configuration split across multiple files on disk. As 1.4.7:

proxysql-admin.cnf - stores initial config and credentials to connect to admin interface

host_priority.conf - stores the list in which failover should happen

CLUSTER_NAME_reload - stores a flag to control when tables should be load to runtime

CLUSTER_NAME_mode - stores the mode in which the cluster is running at the moment.

 

Those configurations should be stored inside proxysql admin database. This makes maintenance and upgrade process from version to version easier.

For example, while troubleshooting an issue, we need to ask a customer to dump the config and separately send the various disk files just to know their config.

Environment

None

Smart Checklist

Activity

Show:

Marcelo Altmann July 9, 2018 at 11:54 AM

yes, closing.

Ramesh Sivaraman July 9, 2018 at 4:53 AM

Can we close this ticket with  ?

Duplicate

Details

Assignee

Reporter

Fix versions

Priority

Smart Checklist

Created April 17, 2018 at 9:57 PM
Updated March 6, 2024 at 5:49 PM
Resolved July 9, 2018 at 11:55 AM