Tag:mgr

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

    Time:2020-11-28

    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

    Time:2020-5-19

    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 (192.168.1.11) DROP USER ‘donor_clone_user’@’192.168.1.12’; CREATE USER ‘donor_clone_user’@’192.168.1.12’ IDENTIFIED BY ‘password’; GRANT BACKUP_ADMIN on *.* to ‘donor_clone_user’@’192.168.1.12’; INSTALL PLUGIN clone SONAME ‘mysql_clone.so’; Receiver side execution( […]

  • MySQL 8.0.18 Mgr building and switching function

    Time:2020-5-18

    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 […]