Shulou(Shulou.com)05/31 Report--

This article will explain in detail the case of building mysql 8.0.18 mgr and its switching function. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

I. system installation package

Yum-y install make gcc-c++ cmake bison-devel ncurses-devel readline-devel libaio-devel perl libaio wget lrzsz vim libnuma* bzip2 xz

2. Close the firewall and selinux

Sed-I's etc/rc.local'/ etc/selinux/configsetenforce 0/etc/init.d/iptables stopecho "/ etc/init.d/iptables stop" > / etc/rc.local

Third, modify the system limit parameters

Cat > > / etc/security/limits.conf > / etc/hosts / etc/sysctl.conf ~ / .bashrc / etc/ld.so.conf show global variables like'% gtid%' +-- + | Variable_name | Value | +- -- +-- + | binlog_gtid_simple_recovery | ON | | enforce_gtid_consistency | ON | | group_replication_gtid_assignment_block_size | 1000000 | | gtid_executed | 58f6e65e-9309-11e9-9d88-525400184a0a:1-946050 58f6e65e-9309 1000003 | | gtid_executed_compression_period | 1000 | gtid_mode | ON | | gtid_owned | | gtid_purged | | session_track_gtids | OFF | +-| -- +-+ rows in set (0.00 sec) # operate stop GROUP_REPLICATION in faulty slave library Reset master;set global gtid_purged='58f6e65e-9309-11e9-9d88-525400184a0a:1-946055 9d88 1000003mm start GROUP_REPLICATION;# add whitelist segment stop group_replication;set global group_replication_ip_whitelist= "127.0.0.1x 32172.16.60.0qq24172.16.50.0xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx; start group_replication;show variables like" group_replication_ip_whitelist " # Note: before configuring the whitelist, be sure to close Group Replication and execute "stop group_replication;" on the "mysql 8.0.18 mgr Building and switching function" article. I hope the above content will be helpful to you so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.