TiDB Syncer不同表名库名同步且支持pt-osc改表

TiDB Syncer不同表名库名同步且支持pt-osc改表

mysql端库名叫sysbench, 表名sbtest11
tidb端库名ptosc_sysbench,表名ptosc_sbtest11

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
[[replicate-do-table]]
db-name = "ptosc_sysbench"
tbl-name = "ptosc_sbtest11"
[[replicate-do-table]]
db-name = "ptosc_sysbench"
tbl-name = "~.*_sbtest11_new"
[[replicate-do-table]]
db-name = "ptosc_sysbench"
tbl-name = "~.*_sbtest11_old"
[[route-rules]]
pattern-schema = "sysbench"
pattern-table = "sbtest11"
target-schema = "ptosc_sysbench"
target-table = "ptosc_sbtest11"

阅读全文

MGR参数之group_replication_ip_whitelist

img

尝试将10.133.1.46加入192.168.2.224的集群失败

需要设置参数group_replication_ip_whitelist

此参数虽然是动态参数, 但是要使之生效需要节点重新加入集群

To specify a whitelist manually, use the group_replication_ip_whitelist option. You cannot change the whitelist on a server while it is an active member of a replication group. If the member is active, you must issue a STOP GROUP_REPLICATION statement before changing the whitelist, and a START GROUP_REPLICATION statement afterwards.

阅读全文

TiDB Binlog部署

TiDB Binlog部署

环境信息

中控机是10.152.x.133

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
[tidb_servers]
10.152.x.10
10.152.x.11
10.152.x.12
[tikv_servers]
10.152.x.10
10.152.x.11
10.152.x.12
[pd_servers]
10.152.x.10
10.152.x.11
10.152.x.12
## Monitoring Part
# prometheus and pushgateway servers
[monitoring_servers]
10.152.x.133
[grafana_servers]
10.152.x.133
# node_exporter and blackbox_exporter servers
[monitored_servers]
10.152.x.10
10.152.x.11
10.152.x.12
10.152.x.133
[alertmanager_servers]
10.152.x.133

阅读全文

ProxySQL平滑下线节点

ProxySQL平滑下线节点

因为MGR多主DDL和DML不能并发在不同节点执行, 而我们又存在即通过KO又通过ProxySQL访问的数据库的情况, 为了避免在发生故障, 我们决定将ProxySQL中配置的集群真实ip删除, 改为使用KO的vip.
本文介绍如何平滑下线ProxySQL节点, 从而做到对业务无感知.

KO我司自研php中间件

环境介绍

10.133.x.59 跑sysbench
10.133.x.52:3307 测试集群节点
10.133.x.53:3307 测试集群节点
10.133.x.54:3307 测试集群节点
VIP 访问类型 所在服务器
10.133.x.202 KO 10.133.x.202
10.133.x.203 ProxySQL 10.133.x.203

ProxySQL版本

1
2
3
4
5
6
7
admin@127.0.0.1 23:12:02 [(none)]> select version();
+-------------------+
| version() |
+-------------------+
| 2.0.8-67-g877cab1 |
+-------------------+
1 row in set (0.00 sec)

MySQL版本

1
2
3
4
5
6
7
root@localhost 23:17:56 [(none)]> select version();
+------------+
| version() |
+------------+
| 5.7.26-log |
+------------+
1 row in set (0.00 sec)

阅读全文


Powered by Hexo and Hexo-theme-hiker

Copyright © 2013 - 2019 Fan() All Rights Reserved.

访客数 : | 访问量 :

#