Skip to:

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

Handle multiple proxysql instances in proxysql-admin

Description

None

Environment

None

AFFECTED CS IDs

228487

Smart Checklist

Activity

Ramesh Sivaraman September 11, 2018 at 5:02 PM

Yes it is tested and implemented in 1.4.9 release.

David Bennett September 11, 2018 at 3:43 PM

   

What is the status of this feature?  Has it been tested?

Ramesh Sivaraman July 5, 2018 at 8:01 AM

Jericho Rivera June 5, 2018 at 11:38 PM

Quoting client comment:

1. We intend to run multiple proxysql on the same box, each proxysql monitoring only one PXC cluster.
2. In order to do this, each proxy sql will listen to a different admin port (6032 -> xxxx) and a different PXC connectivity port (6033 -> yyyy)
3. In such configuration, in order to have galera_checker and node_monitor tools running properly, they will have to be able to connect to different admin ports. This is not possible because sourcing proxysql-admin config file is hard coded in those tools to /etc/proxysql-admin.cnf. Are there any plans to make proxysql-admin-monitor-tools to be able to work in an environment where we have multiple proxy tasks listening on different ports and each monitoring only one PXC?

Done

Details

Assignee

Reporter

Time tracking

1d 6h 1m logged

Fix versions

Priority

Smart Checklist

Created January 23, 2018 at 10:16 AM
Updated March 6, 2024 at 5:49 PM
Resolved September 11, 2018 at 5:03 PM