Skip to content
logo
Percona ProxySQL admin tools
Install ProxySQL 2.x.x and the admin utilities
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
          • Verify the pxc_scheduler_handler installation
          • Run Docker
        • 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)
      • 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)
    • Verify the pxc_scheduler_handler installation
    • Run Docker

    Install ProxySQL 2.x.x and the admin utilities¶

    Select the same package installer used to install Percona XtraDB Cluster or other Percona software.

    If you used APT to install Percona software, run the following command as sudo or as root:

    $ sudo apt install proxysql2
    
    Expected output
    Reading package lists... Done
    Building dependency tree
    Reading state information... Done
    The following additional packages will be installed:
      debconf-utils logrotate
    The following NEW packages will be installed:
      debconf-utils logrotate proxysql2
    0 upgraded, 3 newly installed, 0 to remove and 3 not upgraded.
    Need to get 7259 kB of archives.
    ...
    

    If you used YUM to install Percona software, run the following command:

    $ sudo yum install proxysql2
    
    Expected output
    Last metadata expiration check: 0:01:47 ago on Wed Oct  5 14:42:00 2022.
    Dependencies resolved.
    =========================================================================================================================
    Package                  Architecture          Version                        Repository                           Size
    =========================================================================================================================
    Installing:
    proxysql2                x86_64                2.4.4-1.1.el8                  tools-release-x86_64                 21 M
    Installing dependencies:
    logrotate                x86_64                3.14.0-4.el8                   baseos                               85 k
    
    Transaction Summary
    =========================================================================================================================
    Install  2 Packages
    
    Total download size: 21 M
    Installed size: 88 M
    Is this ok [y/N]: y
    Downloading Packages:
    (1/2): logrotate-3.14.0-4.el8.x86_64.rpm                                                 371 kB/s |  85 kB     00:00
    (2/2): proxysql2-2.4.4-1.1.el8.x86_64.rpm                                                3.6 MB/s |  21 MB     00:05
    -------------------------------------------------------------------------------------------------------------------------
    Total                                                                                    3.3 MB/s |  21 MB     00:06
    ...
    

    Verify the pxc_scheduler_handler installation¶

    If you have installed ProxySQL 2.3.2-2.1 or later, verify the Percona_Scheduler_Admin installation with the following command:

    $ percona-scheduler-admin --debug
    

    Running this command without the pxc_scheduler_handler configuration file generates an error.

    Error message
    ERROR : The --config-file option is required but is missing from the command.
    

    Run Docker¶

    To run ProxySQL2 in Docker, download the latest image at percona/proxysql2.

    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.