severalnines/proxysql Docker 镜像 - 轩辕镜像 | Docker 镜像高效稳定拉取服务

ProxySQL Docker镜像

支持的标签

• 2, 2.5, 2.5.3, latest (2.5/Dockerfile)
• 2, 2.4, 2.4.8 (2.4/Dockerfile)
• 2, 2.3, 2.3.2 (2.3/Dockerfile)
• 2.2, 2.2.2 (2.2/Dockerfile)
• 2.1, 2.1.1, (2.1/Dockerfile)
• 2.0, 2.0.18 (2.0/Dockerfile)
• 1, 1.4, 1.4.16 (1.4/Dockerfile)

概述

ProxySQL是一款高性能SQL代理。详情请访问ProxySQL官网。

镜像描述

此镜像由Severalnines维护，并将尽最大努力定期更新。该镜像基于Debian 11（Bullseye），包含：

• mysql/mariadb客户端
• 适用于Debian 11的ProxySQL包

运行

要使用自定义ProxySQL配置文件运行ProxySQL容器：

bash
$ docker run -d \
--name proxysql2 \
--publish 6033:6033 \
--publish 6032:6032 \
--publish 6080:6080 \
--restart=unless-stopped \
-v /root/proxysql/proxysql.cnf:/etc/proxysql.cnf \
severalnines/proxysql

有关可用Docker镜像版本的列表，请参阅支持的标签部分。

配置示例：proxysql.cnf

对于Kubernetes，请查看以下博客文章了解说明和示例：

• MySQL on Docker: Running ProxySQL as a Helper Container on Kubernetes
• MySQL on Docker: Running ProxySQL as Kubernetes Service
• MySQL on Docker: ProxySQL Native Clustering with Kubernetes

以下是一些ProxySQL配置示例：

• Galera（ProxySQL 2.x）带Web统计端口6080
• Galera（ProxySQL 1.x）
• MySQL复制

有关更详细的说明，请查看如何在Docker上为MySQL Galera集群运行和配置ProxySQL 2.0。

您还可以在官方仓库中找到一些proxysql.cnf示例：[***]

Galera（ProxySQL 2.x）带Web统计端口6080

bash
datadir="/var/lib/proxysql"

admin_variables=
{
    admin_credentials="admin:admin"
    mysql_ifaces="0.0.0.0:6032"
    refresh_interval=2000
    web_enabled=true
    web_port=6080
    stats_credentials="stats:admin"
}

mysql_variables=
{
    threads=4
    max_connections=2048
    default_query_delay=0
    default_query_timeout=36000000
    have_compress=true
    poll_timeout=2000
    interfaces="0.0.0.0:6033;/tmp/proxysql.sock"
    default_schema="information_schema"
    stacksize=***
    server_version="5.1.30"
    connect_timeout_server=***
    monitor_history=60000
    monitor_connect_interval=200000
    monitor_ping_interval=200000
    ping_interval_server_msec=***
    ping_timeout_server=200
    commands_stats=true
    sessions_sort=true
    monitor_username="proxysql"
    monitor_password="proxysqlpassword"
    monitor_galera_healthcheck_interval=2000
    monitor_galera_healthcheck_timeout=800
}

mysql_galera_hostgroups =
(
    {
        writer_hostgroup=10
        backup_writer_hostgroup=20
        reader_hostgroup=30
        offline_hostgroup=9999
        max_writers=1
        writer_is_also_reader=2
        max_transactions_behind=30
        active=1
    }
)

mysql_servers =
(
    { address="db1.cluster.local" , port=3306 , hostgroup=10, max_connections=100 },
    { address="db2.cluster.local" , port=3306 , hostgroup=10, max_connections=100 },
    { address="db3.cluster.local" , port=3306 , hostgroup=10, max_connections=100 }
)

mysql_query_rules =
(
    {
        rule_id=100
        active=1
        match_pattern="^SELECT .* FOR UPDATE"
        destination_hostgroup=10
        apply=1
    },
    {
        rule_id=200
        active=1
        match_pattern="^SELECT .*"
        destination_hostgroup=30
        apply=1
    },
    {
        rule_id=300
        active=1
        match_pattern=".*"
        destination_hostgroup=10
        apply=1
    }
)

mysql_users =
(
    { username = "wordpress", password = "passw0rd", default_hostgroup = 10, transaction_persistent = 0, active = 1 },
    { username = "sbtest", password = "passw0rd", default_hostgroup = 10, transaction_persistent = 0, active = 1 }
)

Galera（ProxySQL 1.x）

bash
datadir="/var/lib/proxysql"

admin_variables=
{
    admin_credentials="admin:admin"
    mysql_ifaces="0.0.0.0:6032"
    refresh_interval=2000
}

mysql_variables=
{
    threads=4
    max_connections=2048
    default_query_delay=0
    default_query_timeout=36000000
    have_compress=true
    poll_timeout=2000
    interfaces="0.0.0.0:6033;/tmp/proxysql.sock"
    default_schema="information_schema"
    stacksize=***
    server_version="5.1.30"
    connect_timeout_server=***
    monitor_history=60000
    monitor_connect_interval=200000
    monitor_ping_interval=200000
    ping_interval_server_msec=***
    ping_timeout_server=200
    commands_stats=true
    sessions_sort=true
    monitor_username="proxysql"
    monitor_password="proxysqlpassword"
}

mysql_servers =
(
    { address="db1.cluster.local" , port=3306 , hostgroup=10, max_connections=100 },
    { address="db2.cluster.local" , port=3306 , hostgroup=10, max_connections=100 },
    { address="db3.cluster.local" , port=3306 , hostgroup=10, max_connections=100 },
    { address="db1.cluster.local" , port=3306 , hostgroup=20, max_connections=100 },
    { address="db2.cluster.local" , port=3306 , hostgroup=20, max_connections=100 },
    { address="db3.cluster.local" , port=3306 , hostgroup=20, max_connections=100 }
)

mysql_query_rules =
(
    {
        rule_id=100
        active=1
        match_pattern="^SELECT .* FOR UPDATE"
        destination_hostgroup=10
        apply=1
    },
    {
        rule_id=200
        active=1
        match_pattern="^SELECT .*"
        destination_hostgroup=20
        apply=1
    },
    {
        rule_id=300
        active=1
        match_pattern=".*"
        destination_hostgroup=10
        apply=1
    }
)

scheduler =
(
    {
        id = 1
        filename = "/usr/share/proxysql/tools/proxysql_galera_checker.sh"
        active = 1
        interval_ms = 2000
        arg1 = "10"
        arg2 = "20"
        arg3 = "1"
        arg4 = "1"
        arg5 = "/var/lib/proxysql/proxysql_galera_checker.log"
    }
)

mysql_users =
(
    { username = "sbtest" , password = "passw0rd" , default_hostgroup = 10 , active = 1 }
)

MySQL复制

bash
datadir="/var/lib/proxysql"

admin_variables=
{
    admin_credentials="admin:admin"
    mysql_ifaces="0.0.0.0:6032"
    refresh_interval=2000
}

mysql_variables=
{
    threads=4
    max_connections=2048
    default_query_delay=0
    default_query_timeout=36000000
    have_compress=true
    poll_timeout=2000
    interfaces="0.0.0.0:6033;/tmp/proxysql.sock"
    default_schema="information_schema"
    stacksize=***
    server_version="5.1.30"
    connect_timeout_server=***
    monitor_history=60000
    monitor_connect_interval=200000
    monitor_ping_interval=200000
    ping_interval_server_msec=***
    ping_timeout_server=200
    commands_stats=true
    sessions_sort=true
    monitor_username="proxysql"
    monitor_password="proxysqlpassword"
}

mysql_replication_hostgroups =
(
    { writer_hostgroup=10 , reader_hostgroup=20 , comment="host groups" }
)

mysql_servers =
(
    { address="master.replication.local" , port=3306 , hostgroup=10, max_connections=100 , max_replication_lag = 5 },
    { address="slave1.replication.local" , port=3306 , hostgroup=20, max_connections=100 , max_replication_lag = 5 },
    { address="slave2.replication.local" , port=3306 , hostgroup=20, max_connections=100 , max_replication_lag = 5 }
)

mysql_query_rules =
(
    {
        rule_id=100
        active=1
        match_pattern="^SELECT .* FOR UPDATE"
        destination_hostgroup=10
        apply=1
    },
    {
        rule_id=200
        active=1
        match_pattern="^SELECT .*"
        destination_hostgroup=20
        apply=1
    },
    {
        rule_id=300
        active=1
        match_pattern=".*"
        destination_hostgroup=10
        apply=1
    }
)

mysql_users =
(
    { username = "sbtest" , password = "password" , default_hostgroup = 10 , active = 1 }
)