• Detailed explanation of MySQL 5.7 Mgr single master determining master node method


    Mgr of our bank will be online at the end of the year. We have to read official documents every day to learn, do tests, and write a little knowledge every day. Do you want to learn together~ MySQL 5.7 Mgr single master determines which primary node is. We can judge by member ID, and […]

  • MySQL 8.0.18 using clone plugin to rebuild Mgr


    Assuming that a node of three node Mgr is abnormal, you need to add this node to the Mgr cluster again. The specific operation process is as follows: Contributor side execution ( DROP USER ‘donor_clone_user’@’’; CREATE USER ‘donor_clone_user’@’’ IDENTIFIED BY ‘password’; GRANT BACKUP_ADMIN on *.* to ‘donor_clone_user’@’’; INSTALL PLUGIN clone SONAME ‘mysql_clone.so’; Receiver side execution( […]

  • MySQL 8.0.18 Mgr building and switching function


    1、 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、 Turn off firewall and SELinux sed -i ‘s/SELINUX=enforcing/SELINUX=disabled/’ /etc/selinux/config setenforce 0 /etc/init.d/iptables stop echo “/etc/init.d/iptables stop”>>/etc/rc.local 3、 Modify system limit parameters cat >> /etc/security/limits.conf << EOF # ###custom # * soft nofile […]