测试目标

• 验证MGR延迟(最终一致)
• 延迟后事物处理的影响
• 验证通过相关性能视图检查MGR的延迟

测试环境

3节点多主MGR集群,单线程复制(多线程并行复制，可以明显提升复制效率)

[root@localhost:sock3309.sock((none)) 11:39:57] select * from performance_schema.replication_group_members;
+---------------------------+--------------------------------------+--------------+-------------+--------------+-------------+----------------+
| CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | MEMBER_VERSION |
+---------------------------+--------------------------------------+--------------+-------------+--------------+-------------+----------------+
| group_replication_applier | 1e671483-c0fd-11ea-8609-005056944768 | perf-monitor | 3308 | RECOVERING | SECONDARY | 8.0.20 |
| group_replication_applier | 3728fa12-c0fd-11ea-9911-005056944768 | perf-monitor | 3309 | RECOVERING | SECONDARY | 8.0.20 |
| group_replication_applier | 4c944dd8-c0fc-11ea-a54f-005056944768 | perf-monitor | 3307 | ONLINE | PRIMARY | 8.0.20 |
+---------------------------+--------------------------------------+--------------+-------------+--------------+-------------+----------------+
3 rows in set (0.00 sec)

测试过程

使用自带mysqlslap 对节点1加压（insert） 并发为8,如果压力不够，可以多跑几次

mysql@perf-monitor ~$mysqlslap --host=133.96.183.241 --port=3307 --user=test --password=test --create-schema=test –-number-int-cols=5 \
--number-char-cols=20 -a –-auto-generate-sql --auto-generate-sql-add-autoincrement --auto-generate-sql-secondary-indexes=2 --number-of-queries=50000 --concurrency=8
mysqlslap: [Warning] Using a password on the command line interface can be insecure.

Benchmark
        Average number of seconds to run all queries: 26.798 seconds
        Minimum number of seconds to run all queries: 26.798 seconds
        Maximum number of seconds to run all queries: 26.798 seconds
        Number of clients running queries: 8
        Average number of queries per client: 6250