ITPub博客
首页 博客 专栏 学院 社区 IT新媒体评选
发博

首页 > 数据库 > MySQL > 【MYsql】Maxscale中间件使用

【MYsql】Maxscale中间件使用

原创 MySQL 作者：小亮520cl 时间：2016-07-29 17:48:08 0 删除 编辑
背景：
  1. 规划
    192.168.6.114 mysql master
    192.168.6.115
    		 mysql salve1
    192.168.6.119 mysql slave2
    192.168.6.121 maxscale

    搭建114 115 119的一主两丛结构并开启半同步复制，和搭建mha一样
  2. 在搭建完主从后我们还需要在数据库建一个用于monitor的用户，同时建好后面测试的用户：
    mysql> grant all privileges on *.* to 'max'@'%' identified by 'ESBecs00';   ---为了省事就用这一个用户吧 




1安装maxscale

  1. 下载链接：https://downloads.mariadb.com/files/MaxScale/1.3.0-beta/centos/5/x86_64
  2. 本次博客安装的是
  3. maxscale-beta-1.3.0-1.centos5.x86_64.rpm 该版本

2 修改配置文件

  1. 安装完后会在/etc/目录下生成模板配置文件
  2. [root@localhost etc]# ls maxscale.cnf.template     
    maxscale.cnf.template
  3. 写一个配置文件（每个版本的配置文件不一样，最好是cp模板配置文件来修改）
    1. [root@localhost etc]# more maxscale.cnf
    2. # MaxScale documentation on GitHub:
    3. # https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Documentation-Contents.md

    5. # Global parameters
    6. #
    7. # Number of threads is autodetected, uncomment for manual configuration
    8. # Complete list of configuration options:
    9. # https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Getting-Started/Configuration-Guide.md

    11. [maxscale]
    12. threads=8

    14. # Server definitions
    15. #
    16. # Set the address of the server to the network
    17. # address of a MySQL server.
    18. #

    20. [server1]
    21. type=server
    22. address=192.168.6.114
    23. port=3306
    24. protocol=MySQLBackend

    26. [server2]
    27. type=server
    28. address=192.168.6.115
    29. port=3306
    30. protocol=MySQLBackend

    32. [server3]
    33. type=server
    34. address=192.168.6.119
    35. port=3306
    36. protocol=MySQLBackend

    38. # Monitor for the servers
    39. #
    40. # This will keep MaxScale aware of the state of the servers.
    41. # MySQL Monitor documentation:
    42. # https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Monitors/MySQL-Monitor.md

    44. [MySQL Monitor]
    45. type=monitor
    46. module=mysqlmon
    47. servers=server1,server2,server3
    48. user=max
    49. passwd=ESBecs00
    50. monitor_interval=10000

    52. # Service definitions
    53. #
    54. # Service Definition for a read-only service and
    55. # a read/write splitting service.
    56. #

    58. # https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Routers/ReadConnRoute.md

    60. [Read-Only Service]                       ###只读服务
    61. type=service
    62. router=readconnroute
    63. servers=server1,server2,server3
    64. user=max
    65. passwd=ESBecs00
    66. router_options=slave

    68. # https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Routers/ReadWriteSplit.md

    70. [Read-Write Service]                       ####写服务
    71. type=service
    72. router=readwritesplit
    73. servers=server1
    74. user=max
    75. passwd=ESBecs00
    76. max_slave_connections=100%

    78. # https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Reference/MaxAdmin.md

    80. [MaxAdmin Service]
    81. type=service
    82. router=cli


    85. [Read-Only Listener]
    86. type=listener
    87. service=Read-Only Service
    88. protocol=MySQLClient
    89. port=4008                                  ##读服务启动监听 端口4008

    91. [Read-Write Listener]
    92. type=listener
    93. service=Read-Write Service
    94. protocol=MySQLClient
    95. port=4006                                  ####写服务启动监听 端口

    97. [MaxAdmin Listener]
    98. type=listener
    99. service=MaxAdmin Service
    100. protocol=maxscaled
    101. port=6603                                   ###管理端口



3 启动maxscale服务

  1.   [root@localhost etc]# /etc/init.d/maxscale start
    Starting MaxScale:  found maxscale (pid 
    14126) 正在运行...                                         [确定]
  2. 查看message日志
    1. [root@localhost ~]# tail -f /var/log/messages
    2. Jul 29 17:04:33 localhost maxscale[14035]: Configuration file: /etc/maxscale.cnf
    3. Jul 29 17:04:33 localhost maxscale[14035]: Log directory: /var/log/maxscale               ------日志目录
    4. Jul 29 17:04:33 localhost maxscale[14035]: Data directory: /var/lib/maxscale/data
    5. Jul 29 17:04:33 localhost maxscale[14035]: Module directory: /usr/lib64/maxscale
    6. Jul 29 17:04:33 localhost maxscale[14035]: Service cache: /var/cache/maxscale
    7. Jul 29 17:04:33 localhost maxscale[14035]: Initialise CLI router module V1.0.0.
    8. Jul 29 17:04:33 localhost maxscale[14035]: Loaded module cli: V1.0.0 from /usr/lib64/maxscale/libcli.so
    9. Jul 29 17:04:33 localhost maxscale[14035]: Initializing statemend-based read/write split router module.
    10. Jul 29 17:04:33 localhost maxscale[14035]: Loaded module readwritesplit: V1.0.2 from /usr/lib64/maxscale/libreadwritesplit.so
    11. Jul 29 17:04:33 localhost maxscale[14035]: Initialise readconnroute router module V1.1.0.
    12. Jul 29 17:04:33 localhost maxscale[14035]: Loaded module readconnroute: V1.1.0 from /usr/lib64/maxscale/libreadconnroute.so
    查看日志：
  3. [root@localhost maxscale]# tail -f maxscale1.log 
    1. MariaDB Corporation MaxScale    /var/log/maxscale/maxscale1.log Fri Jul 29 17:09:46 2016
      -----------------------------------------------------------------------
      2016-07-29 17:09:46   notice : Configuration file: /etc/maxscale.cnf
      2016-07-29 17:09:46   notice : Log directory: /var/log/maxscale
      2016-07-29 17:09:46   notice : Data directory: /var/lib/maxscale/data
      2016-07-29 17:09:46   notice : Module directory: /usr/lib64/maxscale
      2016-07-29 17:09:46   notice : Service cache: /var/cache/maxscale
      2016-07-29 17:09:46   notice : Initialise CLI router module V1.0.0.
      2016-07-29 17:09:46   notice : Loaded module cli: V1.0.0 from /usr/lib64/maxscale/libcli.so
      2016-07-29 17:09:46   notice : Initializing statemend-based read/write split router module.
      2016-07-29 17:09:46   notice : Loaded module readwritesplit: V1.0.2 from /usr/lib64/maxscale/libreadwritesplit.so
      2016-07-29 17:09:46   notice : Initialise readconnroute router module V1.1.0.
      2016-07-29 17:09:46   notice : Loaded module readconnroute: V1.1.0 from /usr/lib64/maxscale/libreadconnroute.so
      2016-07-29 17:09:46   notice : Initialise the MySQL Monitor module V1.4.0.
      2016-07-29 17:09:46   notice : Loaded module mysqlmon: V1.4.0 from /usr/lib64/maxscale/libmysqlmon.so
      2016-07-29 17:09:46   notice : MariaDB Corporation MaxScale beta-1.3.0 (C) MariaDB Corporation Ab 2013-2015
      2016-07-29 17:09:46   notice : MaxScale is running in process 14140
      2016-07-29 17:09:46   notice : Loaded 2 MySQL Users for service [Read-Only Service].
      2016-07-29 17:09:46   notice : Loaded module MySQLClient: V1.0.0 from /usr/lib64/maxscale/libMySQLClient.so
      2016-07-29 17:09:46   notice : Listening MySQL connections at 0.0.0.0:4008
      2016-07-29 17:09:46   notice : Loaded 2 MySQL Users for service [Read-Write Service].
      2016-07-29 17:09:46   notice : Listening MySQL connections at 0.0.0.0:4006
      2016-07-29 17:09:46   notice : Loaded module maxscaled: V1.0.0 from /usr/lib64/maxscale/libmaxscaled.so
      2016-07-29 17:09:46   notice : Listening maxscale connections at 0.0.0.0:6603
      2016-07-29 17:09:46   notice : Started MaxScale log flusher.
      2016-07-29 17:09:46   notice : MaxScale started with 8 server threads.
      2016-07-29 17:09:47   notice : A Master Server is now available: 192.168.6.114:3306

4测试
  1. 读负载均衡测试
    1. [root@localhost etc]# mysql -umax -pESBecs00 -h192.168.6.121 -P4008 -e "show tables" chenliang;
    2. Warning: Using a password on the command line interface can be insecure.
    3. +---------------------+
    4. | Tables_in_chenliang |
    5. +---------------------+
    6. | test115 |
    7. +---------------------+
    8. [root@localhost etc]# mysql -umax -pESBecs00 -h192.168.6.121 -P4008 -e "show tables" chenliang;
    9. Warning: Using a password on the command line interface can be insecure.
    10. +---------------------+
    11. | Tables_in_chenliang |
    12. +---------------------+
    13. | test119 |
    14. +---------------------+
    15. [root@localhost etc]# mysql -umax -pESBecs00 -h192.168.6.121 -P4008 -e "show tables" chenliang;
    16. Warning: Using a password on the command line interface can be insecure.
    17. +---------------------+
    18. | Tables_in_chenliang |
    19. +---------------------+
    20. | test115 |
    21. +---------------------+
    22. [root@localhost etc]# mysql -umax -pESBecs00 -h192.168.6.121 -P4008 -e "show tables" chenliang;
    23. Warning: Using a password on the command line interface can be insecure.
    24. +---------------------+
    25. | Tables_in_chenliang |
    26. +---------------------+
    27. | test119 |
    28. +---------------------+

  2. 写测试
    1. [root@localhost etc]# mysql -umax -pESBecs00 -h192.168.6.121 -P4006 -e "create table tt as select * from mysql.user" chenliang;    --创建一个表
    2. Warning: Using a password on the command line interface can be insecure.
    3. [root@localhost etc]# mysql -umax -pESBecs00 -h192.168.6.121 -P4008 -e "show tables" chenliang;                                     ---同步到slave1
    4. Warning: Using a password on the command line interface can be insecure.
    5. +---------------------+
    6. | Tables_in_chenliang |
    7. +---------------------+
    8. | test115 |
    9. | tt |
    10. +---------------------+
    11. [root@localhost etc]# mysql -umax -pESBecs00 -h192.168.6.121 -P4008 -e "show tables" chenliang;                                     ---同步到slave2了，很明显写在了主库上，可以开generlog去验证
    12. Warning: Using a password on the command line interface can be insecure.
    13. +---------------------+
    14. | Tables_in_chenliang |
    15. +---------------------+
    16. | test119 |
    17. | tt |
    18. +---------------------+


5 后台管理

  1. [root@localhost ~]# maxadmin -pmariadb
  2. MaxScale>
  3. MaxScale>
  4. MaxScale> list servers
  5. Servers.
  6. -------------------+-----------------+-------+-------------+--------------------
  7. Server | Address | Port | Connections | Status
  8. -------------------+-----------------+-------+-------------+--------------------
  9. server1 | 192.168.6.114 | 3306 | 0 | Master, Running
  10. server2 | 192.168.6.115 | 3306 | 0 | Slave, Running
  11. server3 | 192.168.6.119 | 3306 | 0 | Slave, Running
  12. -------------------+-----------------+-------+-------------+--------------------
  13. MaxScale> list services
  14. Services.
  15. --------------------------+----------------------+--------+---------------
  16. Service Name | Router Module | #Users | Total Sessions
  17. --------------------------+----------------------+--------+---------------
  18. Read-Only Service | readconnroute | 1 | 3
  19. Read-Write Service | readwritesplit | 1 | 1
  20. MaxAdmin Service | cli | 5 | 5
  21. --------------------------+----------------------+--------+---------------

故障测试之：一台slave，stop
  1. 原始状态
    1. MaxScale> list servers
    2. Servers.
    3. -------------------+-----------------+-------+-------------+--------------------
    4. Server | Address | Port | Connections | Status
    5. -------------------+-----------------+-------+-------------+--------------------
    6. server1 | 192.168.6.114 | 3306 | 0 | Master, Running
    7. server2 | 192.168.6.115 | 3306 | 0 | Slave, Running
    8. server3 | 192.168.6.119 | 3306 | 0 | Slave, Running
    9. -------------------+-----------------+-------+-------------+--------------------

    停掉119的slave，stop slave；查看状态
  2. MaxScale> list servers
    Servers.
    -------------------+-----------------+-------+-------------+--------------------
    Server             | Address         | Port  | Connections | Status              
    -------------------+-----------------+-------+-------------+--------------------
    server1            | 192.168.6.114   |  3306 |           0 | Master, Running
    server2            | 192.168.6.115   |  3306 |           0 | Slave, Running
    server3            | 192.168.6.119   |  3306 |           0 | Running
    -------------------+-----------------+-------+-------------+--------------------
  3. 此时读负载测试：全部落到正常的那台slave
    1. [root@node4 ~]# mysql -umax -pESBecs00 -h192.168.6.121 -P4008 -e "show tables" chenliang;
      +---------------------+
      | Tables_in_chenliang |
      +---------------------+
      | test115             | 
      | tt                  | 
      | tt2                 | 
      +---------------------+
      [root@node4 ~]# mysql -umax -pESBecs00 -h192.168.6.121 -P4008 -e "show tables" chenliang;
      +---------------------+
      | Tables_in_chenliang |
      +---------------------+
      | test115             | 
      | tt                  | 
      | tt2                 | 
      +---------------------+
      [root@node4 ~]# mysql -umax -pESBecs00 -h192.168.6.121 -P4008 -e "show tables" chenliang;
      +---------------------+
      | Tables_in_chenliang |
      +---------------------+
      | test115             | 
      | tt                  | 
      | tt2                 | 
      +---------------------+


    5. 恢复119 在测试：负载均衡正常了
    1. MaxScale> list servers
    2. Servers.
    3. -------------------+-----------------+-------+-------------+--------------------
    4. Server | Address | Port | Connections | Status
    5. -------------------+-----------------+-------+-------------+--------------------
    6. server1 | 192.168.6.114 | 3306 | 0 | Master, Running
    7. server2 | 192.168.6.115 | 3306 | 0 | Slave, Running
    8. server3 | 192.168.6.119 | 3306 | 0 | Slave, Running
    9. -------------------+-----------------+-------+-------------+--------------------
    [root@node4 ~]# mysql -umax -pESBecs00 -h192.168.6.121 -P4008 -e "show tables" chenliang;
    +---------------------+
    | Tables_in_chenliang |
    +---------------------+
    | test119             | 
    | tt                  | 
    | tt2                 | 
    +---------------------+
    [root@node4 ~]# mysql -umax -pESBecs00 -h192.168.6.121 -P4008 -e "show tables" chenliang;
    +---------------------+
    | Tables_in_chenliang |
    +---------------------+
    | test115             | 
    | tt                  | 
    | tt2                 | 
    +---------------------+




故障测试之：两台slave全部stop
  1. 停掉1156，119的slave;stop slave
  2. 查看状态
    1. MaxScale> list servers
    2. Servers.
    3. -------------------+-----------------+-------+-------------+--------------------
    4. Server | Address | Port | Connections | Status
    5. -------------------+-----------------+-------+-------------+--------------------
    6. server1 | 192.168.6.114 | 3306 | 0 | Running
    7. server2 | 192.168.6.115 | 3306 | 0 | Running
    8. server3 | 192.168.6.119 | 3306 | 0 | Running
    9. -------------------+-----------------+-------+-------------+--------------------

  3. 负载测试：此时负载就出问题，会报错，起码得保持一台slave，存活才行
    1. [root@node4 ~]# mysql -umax -pESBecs00 -h192.168.6.121 -P4008 -e "show tables" chenliang;
    2. ERROR 1045 (28000): failed to create new session

    说明从服务器全部失效后，会导致 master 也无法识别，使整个数据库服务都失效了。


    对于 slave 全部失效的情况，能否让 master 还可用？这样至少可以正常提供数据库服务。


    这需要修改 MaxScale 的配置，告诉 MaxScale 我们需要一个稳定的 master。

    处理过程


    先恢复两个 slave，让集群回到正常状态，登陆两个 slave 的MySQL。

    mysql> start slave;


    修改 MaxScale 配置文件，添加新的配置。

    vi /etc/maxscale.cnf


    找到 [MySQL Monitor] 部分，添加：

    detect_stale_master=true


    保存退出，然后重启 MaxScale。


    验证


    停掉两台 slave ，查看 MaxScale 服务器状态。

    1. MaxScale> list servers
    2. Servers.
    3. -------------------+-----------------+-------+-------------+--------------------
    4. Server | Address | Port | Connections | Status
    5. -------------------+-----------------+-------+-------------+--------------------
    6. server1 | 192.168.6.114 | 3306 | 0 | Master, Stale Status, Running
    7. server2 | 192.168.6.115 | 3306 | 0 | Running
    8. server3 | 192.168.6.119 | 3306 | 0 | Running
    9. -------------------+-----------------+-------+-------------+--------------------


    负载测试：
    1. [root@node4 ~]# mysql -umax -pESBecs00 -h192.168.6.121 -P4008 -e "show tables" chenliang;
    2. +---------------------+
    3. | Tables_in_chenliang |
    4. +---------------------+
    5. | test114 |
    6. | tt |
    7. | tt2 |
    8. +---------------------+
    9. [root@node4 ~]# mysql -umax -pESBecs00 -h192.168.6.121 -P4008 -e "show tables" chenliang;
    10. +---------------------+
    11. | Tables_in_chenliang |
    12. +---------------------+
    13. | test114 |
    14. | tt |
    15. | tt2 |
    16. +---------------------+
    17. [root@node4 ~]# mysql -umax -pESBecs00 -h192.168.6.121 -P4008 -e "show tables" chenliang;
    18. +---------------------+
    19. | Tables_in_chenliang |
    20. +---------------------+
    21. | test114 |
    22. | tt |
    23. | tt2 |
    24. +---------------------+




补充：可将读写分离配置在一个port上

  1. 配置文件
    1. [maxscale]
    2. threads=80

    4. [server1]
    5. type=server
    6. address=192.168.6.114
    7. port=3306
    8. protocol=MySQLBackend

    10. [server2]
    11. type=server
    12. address=192.168.6.115
    13. port=3306
    14. protocol=MySQLBackend

    16. [server3]
    17. type=server
    18. address=192.168.6.119
    19. port=3306
    20. protocol=MySQLBackend


    23. [MySQL Monitor]
    24. type=monitor
    25. module=mysqlmon
    26. servers=server1,server2,server3
    27. user=max
    28. passwd=ESBecs00
    29. monitor_interval=10000
    30. detect_stale_master=true


    33. #[Read-Only Service]
    34. #type=service
    35. #router=readconnroute
    36. #servers=server1,server2,server3
    37. #user=max
    38. #passwd=ESBecs00
    39. #router_options=slave


    42. [Read-Write Service]
    43. type=service
    44. router=readwritesplit
    45. servers=server1,server3,server2      -----都配置在这即可
    46. user=max
    47. passwd=ESBecs00
    48. max_slave_connections=100%


    51. [MaxAdmin Service]
      type=service
      router=cli




      #[Read-Only Listener]
      #type=listener
      #service=Read-Only Service
      #protocol=MySQLClient
      #port=4008


      [Read-Write Listener]
      type=listener
      service=Read-Write Service
      protocol=MySQLClient
      port=4006


      [MaxAdmin Listener]
      type=listener
      service=MaxAdmin Service
      protocol=maxscaled
      port=6603
    52. #####只需要将 read-only 读负载均衡的部分注释掉，只保留read-write部分即可
    重启测试
    1. 写操作
    2. [root@node4 ~]# mysql -uchenliang -pESBecs00 -h192.168.6.121 -P4006  -e "create table tt3 as select * from tt" chenliang;
    3. 检查114，115，119都存在
    4. mysql> show tables;
      +---------------------+
      | Tables_in_chenliang |
      +---------------------+
      | test119             |
      | tt                  |
      | tt2                 |
      | tt3                 |
      +---------------------+
      4 rows in set (0.00 sec)
     读测试：落在了slave上
    1. [root@node4 ~]# mysql -uchenliang -pESBecs00 -h192.168.6.121 -P4006 -e "show tables" chenliang;
    2. +---------------------+
    3. | Tables_in_chenliang |
    4. +---------------------+
    5. | test115 |
    6. | tt |
    7. | tt2 |
    8. | tt3 |
    9. +---------------------+
    10. [root@node4 ~]# mysql -uchenliang -pESBecs00 -h192.168.6.121 -P4006 -e "show tables" chenliang;
    11. +---------------------+
    12. | Tables_in_chenliang |
    13. +---------------------+
    14. | test115 |
    15. | tt |
    16. | tt2 |
    17. | tt3 |
    18. +---------------------+








对比：
实验一：实现了读写分离，和读的负载均衡，但是需要连接两个不同的端口，不方便
实验二：实现了读写分离，但读负载均衡不能实现，只需要链接一个端口即可，比较方便



思考：

  1. 1.假设程序用户是chenliang  对 chengliang业务库具有所有权，通过chenliang 这个角色能否做到读写分离呢？

    1. 直接使用
    2. [root@localhost etc]# mysql -uchenliang -pESBecs00 -h192.168.6.121 -P4006  -e "create table tt2 as select * from tt" chenliang;
    [root@localhost etc]# mysql -uchenliang -pESBecs00 -h192.168.6.121 -P4008  -e "show tables" chenliang;
    Warning: Using a password on the command line interface can be insecure.
    +---------------------+
    | Tables_in_chenliang |
    +---------------------+
    | test119             |
    | tt                  |
    | tt2                 |
    +---------------------+
    [root@localhost etc]# mysql -uchenliang -pESBecs00 -h192.168.6.121 -P4008  -e "show tables" chenliang;                                         
    Warning: Using a password on the command line interface can be insecure.
    +---------------------+
    | Tables_in_chenliang |
    +---------------------+
    | test115             |
    | tt                  |
    | tt2                 |
    +---------------------+
  2. 完美

2 若直接将程序用户写到配置文件的读写分离部分可以吗？

  1. [Read-Only Service]
  2. type=service
  3. router=readconnroute
  4. servers=server1,server2,server3
  5. user=chenliang
  6. passwd=ESBecs00
  7. router_options=slave

  9. # https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Routers/ReadWriteSplit.md

  11. [Read-Write Service]
  12. type=service
  13. router=readwritesplit
  14. servers=server1
  15. user=chenliang
  16. passwd=ESBecs00
  17. max_slave_connections=100%

重新启动观察日志会报错：
  1. or table 'user'
  2. 2016-07-29 17:40:44 warning: Read-Only Service: User 'chenliang' is missing SELECT privileges on mysql.db table. Database name will be ignored in authentication. MySQL error message: SELECT command denied to user 'chenliang'@'192.168.6.121' for table 'db'
  3. 2016-07-29 17:40:44 error : Read-Only Service: Inadequate user permissions for service. Service not started.
  4. 2016-07-29 17:40:44 error : Failed to start service 'Read-Only Service'.
  5. 2016-07-29 17:40:44 error : Read-Write Service: User 'chenliang' is missing SELECT privileges on mysql.user table. MySQL error message: SELECT command denied to user 'chenliang'@'192.168.6.121' for table 'user'
  6. 2016-07-29 17:40:44 warning: Read-Write Service: User 'chenliang' is missing SELECT privileges on mysql.db table. Database name will be ignored in authentication. MySQL error message: SELECT command denied to user 'chenliang'@'192.168.6.121' for table 'db'
  7. 2016-07-29 17:40:44 error : Read-Write Service: Inadequate user permissions for service. Service not started.
  8. 2016-07-29 17:40:44 error : Failed to start service 'Read-Write Service'.
  9. 2016-07-29 17:40:44 notice : Loaded module maxscaled: V1.0.0 from /usr/lib64/maxscale/libmaxscaled.so

  11. 很明显：读写分离的配置用户需要对mysql.user表具有查询权限
建议：为了省事就将[Read-Only Service][Read-Write Service][MySQL Monitor]部分用同一个账户算了（非应用程序user），可以加密处理，让别人看不到明文密码








通过二进制包安装，源码包安装，密码加密等参考文章
http://www.zhdba.com/zhangyue/2014/07/11/maxscale初探/
http://blog.sina.com.cn/s/blog_534360f50102ver7.html

优酷土豆资深工程师：MySQL高可用之MaxScale与MHA

http://dbaplus.cn/news-11-558-1.html

MaxScale：实现MySQL读写分离与负载均衡的中间件利器

http://mp.weixin.qq.com/s?__biz=MzI4NTA1MDEwNg==&mid=2650756387&idx=1&sn=c0dce4a24c85307cd4c64c8183bffa36&scene=0#wechat_redirect





来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29096438/viewspace-2122737/ ，如需转载，请注明出处，否则将追究法律责任。

1
0
上一篇： 【MHA】mha日常维护命令
下一篇： 【Mysql】pt工具之-pt-kill
请登录后发表评论 登录
全部评论
小亮520cl
专家姓名：陈亮
毕业以后专业任职数据库工程师职位，itpub一直作为自己的笔记记录的地方,blog写的不详细，草书笔记，仅供参考！

注册时间：2013-09-12

  • 博文量
    529
  • 访问量
    1126931

最新文章

支持我们 作者招募 用户协议 FAQ Contact Us

北京盛拓优讯信息技术有限公司. 版权所有  京ICP备16024965号-8 北京市公安局海淀分局网监中心备案编号：11010802021510 niuxiaotong@pcpop.com 17352615567 未成年人举报专区

广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员

违法和不良信息举报电话:18101376593