ProxySQL - 图1
镜像拉取

  1. ## 官方的镜像（里面不带MySQL Client）
  2. docker pull proxysql/proxysql:2.0.8
  3. # severalnines的镜像（里面带了MySQL Client）
  4. docker pull severalnines/proxysql:2.0.8

创建配置文件 proxysql.cnf

  1. datadir="/var/lib/proxysql"
  3. admin_variables=
  4. {
  5.     admin_credentials="admin:admin;radmin:radmin"
  6.     mysql_ifaces="0.0.0.0:6032"
  7.     refresh_interval=2000
  8.     web_enabled=true
  9.     web_port=6080
  10.     stats_credentials="stats:admin"
  11. }
  13. mysql_variables=
  14. {
  15.     threads=4
  16.     max_connections=2048
  17.     default_query_delay=0
  18.     default_query_timeout=36000000
  19.     have_compress=true
  20.     poll_timeout=2000
  21.     interfaces="0.0.0.0:6033"
  22.     default_schema="information_schema"
  23.     stacksize=1048576
  24.     server_version="5.5.30"
  25.     connect_timeout_server=3000
  26.     monitor_username="monitor"
  27.     monitor_password="monitor"
  28.     monitor_history=600000
  29.     monitor_connect_interval=60000
  30.     monitor_ping_interval=10000
  31.     monitor_read_only_interval=1500
  32.     monitor_read_only_timeout=500
  33.     ping_interval_server_msec=120000
  34.     ping_timeout_server=500
  35.     commands_stats=true
  36.     sessions_sort=true
  37.     connect_retries_on_failure=10
  38. }
  40. mysql_replication_hostgroups =
  41. (
  42.     { writer_hostgroup=0 , reader_hostgroup=1 , comment="host groups" }
  43. )
  45.  mysql_servers =
  46.  (
  47.   {
  48.     address="mysql"
  49.     port=3306
  50.     hostgroup=0
  51.     max_connections=2048
  52.   },
  53.   {
  54.     address="mysql1"
  55.     port=3306
  56.     hostgroup=1
  57.     max_connections=2048
  58.   },
  59.   {
  60.     address="mysql2"
  61.     port=3306
  62.     hostgroup=1
  63.     max_connections=2048
  64.   }
  65.  )
  67.  mysql_query_rules =
  68. (
  69.     {
  70.         rule_id=100
  71.         active=1
  72.         match_pattern="^SELECT .* FOR UPDATE"
  73.         destination_hostgroup=0
  74.         apply=1
  75.     },
  76.     {
  77.         rule_id=200
  78.         active=1
  79.         match_pattern="^SELECT .*"
  80.         destination_hostgroup=1
  81.         apply=1
  82.     },
  83.     {
  84.         rule_id=300
  85.         active=1
  86.         match_pattern=".*"
  87.         destination_hostgroup=0
  88.         apply=1
  89.     }
  90. )
  92. mysql_users:
  93.  (
  94.   {
  95.     username = "proxysql"
  96.     password = "proxysql"
  97.     default_hostgroup = 0
  98.     max_connections=1000
  99.     default_schema="information_schema"
  100.     active = 1
  101.   }
  102.  )

端口号说明：

  • 6032 ：服务端的端口
  • 6033 ：MySQL连接的端口

  • 6080 ：前台UI的端口


    容器创建

    1. docker run -d \
    2. -p 16032:6032 \
    3. -p 16033:6033 \
    4. -p 16034:6080 \
    5. -v proxysql.cnf:/etc/proxysql.cnf \
    6. -name proxysql
    7. severalnines/proxysql:2.0.8
  1. mysql -u admin -padmin -h 127.0.0.1 -P6032 --prompt='Admin> '

参考

MGR单主模式和ProxySQL