ProxySQL 中间件

于 2021-07-13 00:17:02 发布
阅读量161 收藏
点赞数
分类专栏： 其它 数据库 文章标签： proxysql sql 中间件 数据库 读写分离
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/xchenhao/article/details/118686752
版权

ProxySQL 架构

ProxySQL

设置主机名 && 安装 MySQL Client && 启动 ProxySQL && 添加 MySQL 节点

$ hostnamectl --static set-hostname proxysql

$ cat >> /etc/hosts <<EOF
192.168.213.25 proxysql
192.168.213.26 mysql-master
192.168.213.27 mysql-slave-01
192.168.213.28 mysql-slave-02
EOF

# https://dev.mysql.com/downloads/mysql/5.7.html
$ rpm -ivh mysql-community-client-5.7.34-1.el7.x86_64.rpm  mysql-community-common-5.7.34-1.el7.x86_64.rpm  mysql-community-libs-5.7.34-1.el7.x86_64.rpm

$ tree
.
├── datadir
├── proxysql.cnf
└── start.sh

$ cat proxysql.cnf
datadir="/var/lib/proxysql"

admin_variables=
{
        admin_credentials="admin:admin;radmin:radmin"
        mysql_ifaces="0.0.0.0:6032"
}

$ cat start.sh
#!/bin/sh

docker run --rm -d -v $PWD/datadir:/var/lib/proxysql -v $PWD/proxysql.cnf:/etc/proxysql.cnf -p 6032:6032 -p 6033:6033 -p 6080:6080 docker.io/proxysql/proxysql

mysql -h127.0.0.1 -P6032 -uradmin -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.30 (ProxySQL Admin Module)

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select * from mysql_servers;
Empty set (0.00 sec)

mysql> insert into mysql_servers(hostgroup_id,hostname,port) values(10,'192.168.213.26',3306),(10,'192.168.213.27',3306),(10,'192.168.213.28',3306);
Query OK, 3 rows affected (0.00 sec)

mysql> load mysql servers to runtime;
Query OK, 0 rows affected (0.01 sec)

mysql> save mysql servers to disk;
Query OK, 0 rows affected (0.03 sec)

MySQL-Master

添加监控账号

mysql -h mysql-master -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 27
Server version: 5.7.34-log MySQL Community Server (GPL)

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create user monitor@'192.168.213.%' identified by '123456';
Query OK, 0 rows affected (0.00 sec)

mysql> grant replication client on *.* to  monitor@'192.168.213.%' ;
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

ProxySQL

配置监测账号 && 读写分组

mysql -h127.0.0.1 -P6032 -uradmin -p
Enter password:

mysql> update global_variables set variable_value = 'monitor' where variable_name = 'mysql-monitor_username';
Query OK, 1 row affected (0.00 sec)

mysql> update global_variables set variable_value = '123456' where variable_name = 'mysql-monitor_password';
Query OK, 1 row affected (0.00 sec)

mysql> load mysql variables to runtime;
Query OK, 0 rows affected (0.01 sec)

mysql> save mysql variables to disk;
Query OK, 140 rows affected (0.01 sec)

mysql> select * from mysql_server_connect_log;
+----------------+------+------------------+-------------------------+-------------------------------------------------------------------------+
| hostname       | port | time_start_us    | connect_success_time_us | connect_error                                                           |
+----------------+------+------------------+-------------------------+-------------------------------------------------------------------------+
| 192.168.213.26 | 3306 | 1624772997036566 | 0                       | Access denied for user 'monitor'@'192.168.213.25' (using password: YES) |
| 192.168.213.27 | 3306 | 1624773116084709 | 0                       | Access denied for user 'monitor'@'192.168.213.25' (using password: YES) |
| 192.168.213.28 | 3306 | 1624773117060762 | 0                       | Access denied for user 'monitor'@'192.168.213.25' (using password: YES) |
| 192.168.213.26 | 3306 | 1624773122005170 | 1844                    | NULL                                                                    |
| 192.168.213.27 | 3306 | 1624773122976601 | 3108                    | NULL                                                                    |
| 192.168.213.28 | 3306 | 1624773123947164 | 1855                    | NULL                                                                    |
+----------------+------+------------------+-------------------------+-------------------------------------------------------------------------+
18 rows in set (0.00 sec)

mysql> select * from mysql_server_ping_log;
+----------------+------+------------------+----------------------+-------------------------------------------------------------------------+
| hostname       | port | time_start_us    | ping_success_time_us | ping_error                                                              |
+----------------+------+------------------+----------------------+-------------------------------------------------------------------------+
| 192.168.213.26 | 3306 | 1624772948655044 | 0                    | Access denied for user 'monitor'@'192.168.213.25' (using password: YES) |
| 192.168.213.27 | 3306 | 1624772956494083 | 0                    | Access denied for user 'monitor'@'192.168.213.25' (using password: YES) |
| 192.168.213.28 | 3306 | 1624772964512596 | 0                    | Access denied for user 'monitor'@'192.168.213.25' (using password: YES) |
| 192.168.213.26 | 3306 | 1624773170228688 | 1552                 | NULL                                                                    |
| 192.168.213.27 | 3306 | 1624773170443246 | 1557                 | NULL                                                                    |
| 192.168.213.28 | 3306 | 1624773178317173 | 570                  | NULL                                                                    |
+----------------+------+------------------+----------------------+-------------------------------------------------------------------------+
228 rows in set (0.00 sec)

mysql> select * from mysql_server_read_only_log;
Empty set (0.00 sec)

mysql>  select * from mysql_server_replication_lag_log;
Empty set (0.00 sec)

mysql> select * from mysql_servers\G
*************************** 1. row ***************************
       hostgroup_id: 10
           hostname: 192.168.213.26
               port: 3306
          gtid_port: 0
             status: ONLINE
             weight: 1
        compression: 0
    max_connections: 1000
max_replication_lag: 0
            use_ssl: 0
     max_latency_ms: 0
            comment:
*************************** 2. row ***************************
       hostgroup_id: 10
           hostname: 192.168.213.27
               port: 3306
          gtid_port: 0
             status: ONLINE
             weight: 1
        compression: 0
    max_connections: 1000
max_replication_lag: 0
            use_ssl: 0
     max_latency_ms: 0
            comment:
*************************** 3. row ***************************
       hostgroup_id: 10
           hostname: 192.168.213.28
               port: 3306
          gtid_port: 0
             status: ONLINE
             weight: 1
        compression: 0
    max_connections: 1000
max_replication_lag: 0
            use_ssl: 0
     max_latency_ms: 0
            comment:
3 rows in set (0.00 sec)

mysql> insert into mysql_replication_hostgroups(writer_hostgroup, reader_hostgroup) values(10,20);
Query OK, 1 row affected (0.00 sec)

mysql> load mysql servers to runtime;
Query OK, 0 rows affected (0.00 sec)

mysql>  save mysql servers to disk;
Query OK, 0 rows affected (0.03 sec)

mysql> select * from mysql_servers\G
*************************** 1. row ***************************
       hostgroup_id: 10
           hostname: 192.168.213.26
               port: 3306
          gtid_port: 0
             status: ONLINE
             weight: 1
        compression: 0
    max_connections: 1000
max_replication_lag: 0
            use_ssl: 0
     max_latency_ms: 0
            comment:
*************************** 2. row ***************************
       hostgroup_id: 20
           hostname: 192.168.213.28
               port: 3306
          gtid_port: 0
             status: ONLINE
             weight: 1
        compression: 0
    max_connections: 1000
max_replication_lag: 0
            use_ssl: 0
     max_latency_ms: 0
            comment:
*************************** 3. row ***************************
       hostgroup_id: 20
           hostname: 192.168.213.27
               port: 3306
          gtid_port: 0
             status: ONLINE
             weight: 1
        compression: 0
    max_connections: 1000
max_replication_lag: 0
            use_ssl: 0
     max_latency_ms: 0
            comment:
3 rows in set (0.00 sec)

mysql> select * from mysql_server_read_only_log;
+----------------+------+------------------+-----------------+-----------+-------+
| hostname       | port | time_start_us    | success_time_us | read_only | error |
+----------------+------+------------------+-----------------+-----------+-------+
| 192.168.213.26 | 3306 | 1624773780357419 | 1237            | 0         | NULL  |
| 192.168.213.27 | 3306 | 1624773780369101 | 1215            | 1         | NULL  |
| 192.168.213.28 | 3306 | 1624773780379679 | 1243            | 1         | NULL  |
+----------------+------+------------------+-----------------+-----------+-------+
81 rows in set (0.00 sec)

MySQL-Master

添加代理账号

$ mysql -h mysql-master -uroot -p

mysql> grant all on *.* to proxysql@'192.168.213.%' identified by '123456';

ProxySQL

配置代理账号 && 测试读写分离 && Web UI && 定时调度

$ mysql -h127.0.0.1 -uradmin -P6032 --prompt='proxysql>' -pradmin

proxysql>insert into mysql_users(username, password, default_hostgroup) values('proxysql', '123456', 10);

proxysql>select * from mysql_users\G
*************************** 1. row ***************************
              username: proxysql
              password: 123456
                active: 1
               use_ssl: 0
     default_hostgroup: 10
        default_schema: NULL
         schema_locked: 0
transaction_persistent: 1
          fast_forward: 0
               backend: 1
              frontend: 1
       max_connections: 10000
            attributes:
               comment:
1 row in set (0.00 sec)

proxysql>update mysql_users set transaction_persistent=1 where username='proxysql';

proxysql> load mysql users to runtime;

proxysql> save mysql users to disk;

$ mysql -h127.0.0.1 -uproxysql -P6033 -p123456 -e 'SELECT @@server_id;'
+-------------+
| @@server_id |
+-------------+
|           1 |

+-------------+

$ mysql -h127.0.0.1 -uproxysql -P6033 -p123456 -e 'SELECT * FROM demo_proxysql.table01'  
+----+------+
| id | name |
+----+------+
|  1 | A    |
|  2 | B    |
|  3 | C    |
|  4 | D    |
|  5 | E    |
|  6 | F    |
+----+------+

$ mysql -h127.0.0.1 -uproxysql -P6033 -p123456 -e 'INSERT INTO demo_proxysql.table01(name)values("G"),("H");'

$ mysql -h127.0.0.1 -uproxysql -P6033 -p123456 -e 'SELECT * FROM demo_proxysql.table01'                      
+----+------+
| id | name |
+----+------+
|  1 | A    |
|  2 | B    |
|  3 | C    |
|  4 | D    |
|  5 | E    |
|  6 | F    |
|  7 | G    |
|  8 | H    |
+----+------+

$ mysql -h127.0.0.1 -uradmin -P6032 -pradmin --prompt='proxysql>'

proxysql>insert into mysql_query_rules(rule_id,active,match_digest,destination_hostgroup,apply)values(1,1,'SELECT.*FOR UPDATE$',10,1),(2,1,'^SELECT',20,1);

proxysql>load mysql query rules to runtime;

proxysql>save mysql query rules to disk;

$ mysql -h127.0.01 -P6033 -uproxysql -p123456 -e 'SELECT @@server_id;'
+-------------+
| @@server_id |
+-------------+
|           2 |
+-------------+

$ mysql -h127.0.01 -P6033 -uproxysql -p123456 -e 'SELECT @@server_id;'
+-------------+
| @@server_id |
+-------------+
|           3 |
+-------------+

$ mysql -h127.0.01 -P6033 -uproxysql -p123456 -e 'START TRANSACTION; SELECT @@server_id; COMMIT; SELECT @@server_id;'
+-------------+
| @@server_id |
+-------------+
|           1 |
+-------------+
+-------------+
| @@server_id |
+-------------+
|           2 |
+-------------+

$ mysql -h127.0.01 -P6033 -uproxysql -p123456 -e 'START TRANSACTION; SELECT @@server_id; COMMIT; SELECT @@server_id;'
+-------------+
| @@server_id |
+-------------+
|           1 |
+-------------+
+-------------+
| @@server_id |
+-------------+
|           3 |
+-------------+


$ mysql -h127.0.0.1 -P6032 -uproxysql -p123456 --prompt='proxysql>'

proxysql>select hostgroup, count_star, digest_text from stats_mysql_query_digest;          
+-----------+------------+------------------------------------------------------+
| hostgroup | count_star | digest_text                                          |
+-----------+------------+------------------------------------------------------+
| 10        | 4          | START TRANSACTION                                    |
| 10        | 4          | COMMIT                                               |
| 20        | 18         | SELECT @@server_id                                   |
| 10        | 1          | INSERT INTO demo_proxysql.table01(name)values(?),(?) |
| 10        | 9          | SELECT @@server_id                                   |
| 10        | 1          | SELECT * FORM demo_proxysql.table01                  |
| 10        | 27         | select @@version_comment limit ?                     |
| 10        | 2          | SELECT * FROM demo_proxysql.table01                  |
+-----------+------------+------------------------------------------------------+
8 rows in set (0.00 sec)


proxysql>SELECT 1 FROM stats_mysql_query_digest_reset LIMIT 1;
+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.00 sec)

proxysql>select hostgroup, count_star, digest_text from stats_mysql_query_digest;
Empty set (0.01 sec)

$ mysql -h 127.0.0.1 -P6033 -uproxysql -p123456 -e 'INSERT INTO demo_proxysql.table01(name)VALUES("H"),("I"),("J");'

$ mysql -h 127.0.0.1 -P6033 -uproxysql -p123456 -e 'DELETE FROM demo_proxysql WHERE id = 4;'

$ mysql -h mysql-master -uroot -p123456 -e 'SELECT * FROM demo_proxysql.table01;'
+----+------+
| id | name |
+----+------+
|  1 | A    |
|  2 | B    |
|  3 | C    |
|  5 | E    |
|  6 | F    |
|  7 | G    |
|  8 | H    |
|  9 | I    |
| 10 | J    |
+----+------+

$ mysql -h mysql-slave-01 -uroot -p123456 -e 'SELECT * FROM demo_proxysql.table01;'       
+----+------+
| id | name |
+----+------+
|  1 | A    |
|  2 | B    |
|  3 | C    |
|  5 | E    |
|  6 | F    |
|  7 | G    |
|  8 | H    |
|  9 | I    |
| 10 | J    |
+----+------+

$ mysql -h mysql-slave-02 -uroot -p123456 -e 'SELECT * FROM demo_proxysql.table01;'
+----+------+
| id | name |
+----+------+
|  1 | A    |
|  2 | B    |
|  3 | C    |
|  5 | E    |
|  6 | F    |
|  7 | G    |
|  8 | H    |
|  9 | I    |
| 10 | J    |
+----+------+

$ mysql -h 127.0.0.1 -P6032 -uradmin -pradmin --prompt='proxysql>'          

*************************** 3. row ***************************
  hostgroup: 20
count_star: 2
digest_text: SELECT * FROM `demo_proxysql`.`table01` WHERE `id` = ?
*************************** 4. row ***************************
  hostgroup: 10
count_star: 3
digest_text: SHOW CREATE TABLE `demo_proxysql`.`table01`
*************************** 5. row ***************************
  hostgroup: 10
count_star: 3
digest_text: SHOW COLUMNS FROM `demo_proxysql`.`table01`
*************************** 7. row ***************************
  hostgroup: 10
count_star: 3
digest_text: SET NAMES utf8mb4
*************************** 8. row ***************************
  hostgroup: 20
count_star: 1
digest_text: select * from hostgroup,count_star,digest_text from stats_mysql_query_digest
*************************** 9. row ***************************
  hostgroup: 20
count_star: 1
digest_text: SELECT SCHEMA_NAME,DEFAULT_CHARACTER_SET_NAME,DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA
*************************** 10. row ***************************
  hostgroup: 10
count_star: 2
digest_text: SHOW VARIABLES LIKE ?
*************************** 11. row ***************************
  hostgroup: 20
count_star: 1
digest_text: SELECT TABLE_SCHEMA,TABLE_NAME,TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? ORDER BY TABLE_SCHEMA,TABLE_TYPE
*************************** 12. row ***************************
  hostgroup: 20
count_star: 1
digest_text: SELECT COUNT(*) FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? UNION SELECT COUNT(*) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = ? UNION SELECT COUNT(*) FROM information_schema.ROUTINES WHERE ROUTINE_SCHEMA = ?
*************************** 13. row ***************************
  hostgroup: 20
count_star: 3
digest_text: SELECT * FROM `demo_proxysql`.`table01` LIMIT ?,?
*************************** 14. row ***************************
  hostgroup: 20
count_star: 1
digest_text: SELECT TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME,COLUMN_TYPE FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = ? ORDER BY TABLE_SCHEMA,TABLE_NAME
*************************** 15. row ***************************
  hostgroup: 10
count_star: 1
digest_text: DELETE FROM `demo_proxysql`.`table01` WHERE `id` = ?
*************************** 17. row ***************************
  hostgroup: 10
count_star: 2
digest_text: INSERT INTO `demo_proxysql`.`table01`(`name`) VALUES (?)
19 rows in set (0.00 sec)

proxysql>update global_variables set variable_value='true' where variable_name='admin-web_enabled';

proxysql>update global_variables set variable_value = '6080' where variable_name = 'admin-web_port';

proxysql>load admin variables to runtime;

proxysql>save admin varibles to disk;

proxysql>select * from global_variables where variable_name LIKE 'admin-web%' or variable_name LIKE 'admin-stats%';
+----------------------------------------+----------------+
| variable_name                          | variable_value |
+----------------------------------------+----------------+
| admin-stats_credentials                | stats:stats    |
| admin-stats_mysql_connections          | 60             |
| admin-stats_mysql_connection_pool      | 60             |
| admin-stats_mysql_query_cache          | 60             |
| admin-stats_mysql_query_digest_to_disk | 0              |
| admin-stats_system_cpu                 | 60             |
| admin-stats_system_memory              | 60             |
| admin-web_enabled                      | true           |
| admin-web_port                         | 6080           |
| admin-web_verbosity                    | 0              |
+----------------------------------------+----------------+
10 rows in set (0.00 sec)

proxysql>LOAD ADMIN VARIABLES TO RUNTIME;

proxysql>SAVE ADMIN VARIABLES TO DISK;

[root@proxysql proxysql]# firewall-cmd --query-port=6080/tcp
[root@proxysql proxysql]# firewall-cmd --add-port=6080/tcp --permanent
[root@proxysql proxysql]# firewall-cmd --reload

# https://192.168.213.25:6080/

$ mysql -h127.0.0.1 -P6032 -uradmin -pradmin --prompt='proxysql>'
proxysql> save mysql servers to disk;
proxysql> save mysql users to disk;
proxysql> save mysql query rules to disk;
proxysql> save mysql variables to disk;
proxysql> save global variables to disk;
proxysql> save admin variables to disk;     
proxysql> save scheduler to disk;

$ vim health-check.sh
#!/bin/sh

DATE=`date "+%Y-%m-%d %H:%M:%S"`
echo "{\"dateTime\":\"$DATE\",\"status\":\"running\"}" >> /var/lib/proxysql/proxysql-health.log

$ chmod +x heath-check.sh

$ tree
.
├── datadir
│   ├── proxysql-ca.pem
│   ├── proxysql-cert.pem
│   ├── proxysql.db
│   ├── proxysql-key.pem
│   └── proxysql_stats.db
├── health-check.sh
├── proxysql.cnf
└── start.sh

2 directories, 9 files

$ docker stop fbc2

$ sh start.sh

$ mysql -h127.0.0.1 -uradmin -pradmin -P6032 --prompt='proxysql>'

proxysql> insert into scheduler(active,interval_ms,filename) values (1,5000,'/proxysql/health-check.sh');
proxysql> load scheduler to runtime;
proxysql> save scheduler to disk;

$ tail -f ./datadir/proxysql-health.log
{"dateTime":"2021-06-27 07:40:19","status":"running"}
{"dateTime":"2021-06-27 07:40:24","status":"running"}
{"dateTime":"2021-06-27 07:40:29","status":"running"}
{"dateTime":"2021-06-27 07:40:34","status":"running"}

参考

  • MySQL ProxySQL介绍 https://www.modb.pro/db/28841
  • ProxySQL 配置详解及读写分离(+GTID)等功能说明 (完整篇) https://www.cnblogs.com/kevingrace/p/10329714.html
陈挨踢
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
专栏目录
MySQL-第十一章-读写分离（ProxySQL）
因上努力，果上随缘。但行好事，莫问前程。
06-02 788
目录 1. ProxySQL介绍 2. ProxySQL结构 3. 安装配置 4. ProxySQL中管理结构自带系统库 5. ProxySQL管理接口的多层配置关系 6. 在不同层次间移动配置 6.1 user相关配置 6.2 server 相关配置 6.3 mysql query rules配置 6.4 MySQL variables配置 6.5 总结 7. ProxySQL应用—基于SQL的读写分离 7.0从库设定read_only参数 7.1 在mysql_rep..
mysql中间件proxysql实现mysql读写分离
weixin_44437026的博客
03-13 957
proxysql1. mysql实现读写分离的方式2. ProxySQL简介3. ProxySQL安装ySQL的Admin管理接口5. 和admin管理接口相关的变量5.1 admin-admin_credentials5.2 admin-stats_credentials5.3 admin-mysql_ifaces6. 多层配置系统6.1 proxysql中的库6.2 ProxySQL多层配置系...
mysql中间件ProxySQL
weixin_47726353的博客
08-13 234
mysql实现读写分离的方式 mysql 实现读写分离的方式有以下几种： 1.程序修改mysql操作，直接和数据库通信，简单快捷的读写分离和随机的方式实现的负载均衡，权限独立分配，需要开发人员协助。 2.amoeba，直接实现读写分离和负载均衡，不用修改代码，有很灵活的数据解决方案，自己分配账户，和后端数据库权限管理独立，权限处理不够灵活。 3.mysql-proxy，直接实现读写分离和负载均衡，不用修改代码，master和slave用一样的帐号，效率低 4.mycat中间件 5.proxysql中间件（推
MySQL-ProxySQL中间件（一）
老叶茶馆
06-20 972
ProxySQLProxySQL作为一款强大的中间件为MySQL的架构提供了有力的支持。目前可以很好的支持 Master Slave\ MGR \ PXC等，并提供连接池...
mysql集群中间件proxysql
liu4031的博客
08-31 671
mysql集群我用的percona，详细内容见percona官网。 点击打开链接 集群中间件使用percona官网推荐的proxysql 点击打开链接
OnePascal中间件
最新发布
04-23
OnePascal简介: OneDelphi是基于Delphi IDE开发的三层中间件， oneLaz是基于Lazaus IDE开发的三层中间件， OneUniApp是基于HBuilderX IDE开发的多端合一app 中间件支持MVC及传统DataSet框架，这个版本是在源码的基础...
中创中间件window安装包
09-14
中创中间件（InforSuite-AS-StE-10.0.1.3），免安装解压即可
rocketmq中间件
02-12
中间件rocketmq的三个版本压缩包，还有它的控制台jar包
中创中间件ARM安装包
09-14
含有linux、windows、ARM、mips平台的安装包，以及部署手册，用户使用手册等文档
Django 中间件
12-20
Django 中间件 Django 中间件是修改 Django request 或者 response 对象的钩子，可以理解为是介于 HttpRequest 与 HttpResponse 处理之间的一道处理过程。 浏览器从请求到响应的过程中，Django 需要通过很多中间件...
关于MySQL绕过授予information_schema中对象时报ERROR 1044（4200）错误
12-14
这个问题是微信群中网友关于MySQL权限的讨论，有这么一个业务需求（下面是他的原话）： 因为MySQL的很多功能都依赖主键，我想用zabbix用户，来监控业务数据库的所有表，是否都建立了主键。 监控的语句是： FROM information_schema.tables t1 LEFT OUTER JOIN information_schema.table_constraints t2 ON t1.table_schema = t2.table_schema AND t1.table_name = t2.table_name
MySQL-ProxySQL中间件（二）| Admin Schemas介绍
06-04 324
目录 MySQL-ProxySQL中间件（一）| ProxySQL基本概念：　https://www.cnblogs.com/SQLServer2012/p/10972593.html MySQL-ProxySQL中间件（二）| Admin Schemas介绍：https://www.cnblogs.com/SQLServer2012/p/10972761.h...
MySQL-ProxySQL中间件（一）| ProxySQL基本概念
06-04 235
目录 MySQL-ProxySQL中间件（一）| ProxySQL基本概念：　https://www.cnblogs.com/SQLServer2012/p/10972593.html MySQL-ProxySQL中间件（二）| Admin Schemas介绍：https://www.cnblogs.com/SQLServer2012/p/10972761.html ...
(强大的)mysql代理中间件proxysql
qq_35916684的博客
02-28 3149
mysql代理中间件的需求 业务中需要做到: 读写分离 主从配置 主从选举 分表分库 缓存 那么就开始选型了 多家mysql代理的性能比较 ProxySQL之性能测试对比 MySQL ProxySQL读写分离使用初探 个人总结 目前的mysql代理有很多家，上面的文章也对比了多家，proxysql算是综合性能比较好的一个，而且许多工具已经停止更新。目前看来proxysql还在维护，也受到p...
MySQL中间件之ProxySQL总结
davetobe的专栏
12-17 1082
MySQL中间件之ProxySQL总结 1、ProxySQL简介 ProxySQL为MySQL的中间件，其有两个版本，官方版和percona版，percona版是基于官方版基础上修改而来。ProxySQL是用C++语言开发的，虽然也是一个轻量级产品，但性能很好(据测试，能处理千亿级的数据)，功能也足够，能满足中间件所需的绝大多数功能，包括： 1)最基本的读/写分离，且方式有...
mysql代理中间件_MySQL中间件之ProxySQL安装部署篇
weixin_36155267的博客
01-20 378
1.前言最近和搞中间件的同事聊了聊，他感叹了几句，如今最大的难处在于中间件太多了，不知道用哪个。社区有几款不错的中间件，mycat算是影响力比较大的吧(以前听一位哥们儿说他认为mycat是java写的，效率很低，然后就对mycat狂轰滥炸)，oneproxy是我们楼教主的扛鼎巨著，还有mariadb社区那个延迟开源的收费软件maxscale。好咯，今天我们不讲这些高大上的中间件，今天我们说的这个中...
ProxySQL 基础篇
山有山的高度，海有海的胸怀。
02-10 582
1、ProxySQL 介绍 ProxySQL 是基于 MySQL 的一款开源的中间件的产品，是一个灵活的 MySQL 代理层，可以实现读写分离，支持 Query 路由功能，支持动态指定某个 SQL 进行缓存，支持动态加载（无需重启 ProxySQL 服务），故障切换和一些 SQL 的过滤功能。介绍：相关 ProxySQL 的网站 https://www.proxysql.com/ ht...
ProxySQL快速上手
cug_jiang126com的专栏
06-13 6923
安装并登陆管理界面 1 wgethttps://github.com/sysown/proxysql/releases/download/v1.3.6/proxysql-1.3.6-1-centos67.x86_64.rpm 2 yum install perl-DBD-MySQL 3 rpm -ivh proxysql-1.3.6-1-centos67.x86_64.rpm 4 ser
springboot 中间件
08-18
Spring Boot提供了丰富的中间件支持，方便开发人员快速集成各种功能和服务。以下是一些常见的Spring Boot中间件： 1. 数据库中间件：Spring Boot可以集成多种数据库中间件，如MySQL、PostgreSQL、MongoDB等。你可以...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

陈挨踢

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值