Skip to content
logo
Percona ProxySQL admin tools
ProxySQL 2.4.3 and ProxySQL admin tools (2022-08-31)
Initializing search
    percona/proxysql-admin-tool-doc
    percona/proxysql-admin-tool-doc
    • Home
      • Use ProxySQL 1.x.x with ProxySQL Admin
      • Install ProxySQL 1.x.x
      • Install ProxySQL 1.X from a binary tarball
      • Configure ProxySQL 1.x.x
        • Download locations for ProxySQL 2.x.x and ProxySQL admin utilities
        • Install ProxySQL 2.x.x and the admin utilities
        • Install ProxySQL 2.x.x binary tarball
        • Build the pxc_scheduler_handler tool
        • Start and stop ProxySQL
        • Upgrade ProxySQL
        • Uninstall ProxySQL 2.x.x
          • ProxySQL Admin tool changes
          • ProxySQL 2.x and proxysql-admin utility
          • The proxysql-admin functions
          • ProxySQL 2.x.x and pxc_scheduler_handler tool
          • pxc-scheduler-handler configuration
          • pxc_scheduler_handler statements
          • pxc-scheduler-handler options
          • Known issues in pxc_scheduler_handler
      • Release notes index
      • ProxySQL 2.4.8 and ProxySQL admin tools (2023-03-15)
      • ProxySQL 2.4.7 and ProxySQL admin tools (2023-02-14)
      • ProxySQL 2.4.4-1.2 and ProxySQL admin tools (2022-11-08)
      • ProxySQL 2.4.4 and ProxySQL admin tools (2022-10-04)
      • ProxySQL 2.4.3 and ProxySQL admin tools (2022-08-31)
        • Release highlights
        • Bug fixes
        • Useful links
      • ProxySQL 2.4.2 and proxysql admin tools (2022-08-10)
      • ProxySQL 2.3.2-1.2, proxysql-admin, and percona-scheduler-admin (2022-06-15)
      • ProxySQL 2.3.2 and proxysql-admin (2021-11-03)
      • ProxySQL 2.2.0 and proxysql-admin (2021-08-10)
      • ProxySQL 2.1.1 and proxysql-admin (2021-07-09)
      • ProxySQL 2.0.18 and proxysql-admin (2021-04-19)
      • ProxySQL 2.0.17 and proxysql-admin (2021-04-06)
      • ProxySQL 2.0.15 and proxysql-admin (2020-11-17)
      • ProxySQL 2.0.14 and proxysql-admin (2020-09-24)
      • ProxySQL 2.0.13 and proxysql-admin (2020-08-05)
      • ProxySQL 2.0.12 and proxysql-admin (2020-06-11)
      • ProxySQL 2.0.7 and proxysql-admin (2019-10-23)
      • ProxySQL 2.0.6 and proxysql-admin (2019-08-21)
      • ProxySQL 2.0.5 and proxysql-admin (2019-11-23)
      • ProxySQL 2.0.4 and proxysql-admin (2019-05-28)
      • ProxySQL 2.0.3 and proxysql-admin (2019-05-07)
      • ProxySQL 1.4.16 and proxysql-admin (2020-02-11)
      • ProxySQL 1.4.12 and proxysql-admin (2018-11-13)
      • ProxySQL 1.4.8 and proxysql-admin (2018-05-22)
      • ProxySQL 1.4.7 and proxysql-admin (2018-04-16)
      • ProxySQL 1.4.6 and proxysql-admin (2018-03-12)
      • ProxySQL 1.4.5 and proxysql-admin (2018-02-15)
      • ProxySQL 1.4.4 and proxysql-admin (2018-01-18)
    • Release highlights
    • Bug fixes
    • Useful links

    ProxySQL 2.4.3 and ProxySQL admin tools (2022-08-31)¶

    ProxySQL is a high-performance proxy for MySQL and MySQL-compatible database servers such as Percona Server for MySQL and MariaDB. It acts as an intermediary for client requests seeking resources from the database. ProxySQL was created for the database administrator as a solution for complex replication topology issues.

    You can download the original ProxySQL from GitHub. The ProxySQL documentation provides information on installing and running ProxySQL.

    The ProxySQL Admin (proxysql-admin) tool simplifies the configuration of Percona XtraDB Cluster nodes with ProxySQL. ProxySQL Admin 1.x.x requires custom Bash scripts to track the status of a Percona XtraDB Cluster. ProxySQL Admin 2.x.x supports Percona XtraDB Cluster without custom scripts.

    The Percona Scheduler Admin (percona-scheduler-admin) tool can automatically perform a failover due to node failures, service degradation, or maintenance.

    Note

    Percona Scheduler admin has different features and capabilities than ProxySQL admin. Do not use the options from one tool in the other tool. Mixing the options may cause unintended results.

    Release highlights¶

    This release includes all features and bug fixes available in ProxySQL 2.4.3. The improvements and bug fixes introduced by ProxySQL and included in this release are:

    • Updated to OpenSSL 3.0.5
    • Added an error message, PMC-10003 about the invalid use of mysql-init-connect
    • Fixed the processing of escaped string delimiters for digests

    For more information on these items and other improvements and bug fixes, see the ProxySQL 2.4.3 release notes.

    Note

    An upgrade from ProxySQL 1.x.x to ProxySQL 2.x.x requires the removal of the ProxySQL 1.x.x packages. You can upgrade to ProxySQL 2.x.x after completing the removal.

    Bug fixes¶

    • psqladm-402: The proxysql-status command did not work as intended. The script had a requirement to pass the .cnf file but this requirement is no longer needed.

    • psqladm-419: The CVE-2021-38561 was found in a library used by pxc_scheduler_handler. The appropriate patch was applied.

    Useful links¶

    • The ProxySQL and proxysql-admin installation instructions and the Percona Scheduler admin installation instructions

    • The Percona Software downloads

    • The ProxySQL and ProxySQL admin tools GitHub location

    • To contribute to the documentation, review the Documentation Contribution Guide

    Contact us

    For free technical help, visit the Percona Community Forum.

    To report bugs or submit feature requests, open a JIRA ticket.

    For paid support and managed or consulting services , contact Percona Sales.

    Last update: 2023-03-24
    Percona LLC and/or its affiliates, © 2023
    Made with Material for MkDocs

    Cookie consent

    We use cookies to recognize your repeated visits and preferences, as well as to measure the effectiveness of our documentation and whether users find what they're searching for. With your consent, you're helping us to make our documentation better.