!/bin/bash

Date: 2020-04-10 11:35

export PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin
yum install ncurses-devel libaio-devel -y
mkdir /app -p &&\
mkdir /data/mysql/binlog -p &&\
useradd mysql -M -s /sbin/nologin
tar xf mysql-5.7.23-linux-glibc2.12-x8664.tar.gz &&\
mv mysql-5.7.23-linux-glibc2.12-x86_64 /app/mysql-5.7.23 &&\
ln -s /app/mysql-5.7.23 /app/mysql &&\
chown mysql.mysql /app/mysql-5.7.23 -R &&\
chown mysql.mysql /data/mysql -R &&\
sed -i ‘s@/usr/local/@/app/@g’ /app/mysql/bin/mysqld_safe &&\
echo “PATH=”/app/mysql/bin:$PATH”” >>/etc/profile
\cp /app/mysql/my.cnf /etc/my.cnf &&\
\cp /app/mysql/mysqld /etc/init.d/mysqld &&\
chmod +x /etc/init.d/mysqld

# ./mysqld —initialize —basedir=/app/mysql —datadir=/data/mysql/data —user=mysql
# alter user ‘root’@’localhost’ IDENTIFIED BY ‘13800138000’;
# flush privileges;
# create database bbs CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
# grant select,insert,update,delete on bbs. to ‘oldboy’@’127.0.0.1’;
# show grants for ‘oldboy’@’127.0.0.1’
# revoke insert on bbs. from “oldboy”@”127.0.0.1”;
# flush table with read lock;
# mysqldump -uroot -p123456 -A -B —events |gzip >rep_bak$(date +%F).sql.gz
# flush table with read lock;
# unlock table;
# SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;
# binlog_format=”MIXED”
# SET GLOBAL binlog_format = ‘MIXED’;

function cong ()
{
grant replication slave on . to rep@’%’ identified by ‘123456’;
CHANGE MASTER TO
MASTER_HOST=’192.168.0.90’,
MASTER_PORT=3306,
MASTER_USER=’rep’,
MASTER_PASSWORD=’123456’,
MASTER_LOG_FILE=’mysql-bin.0000001’,
MASTER_LOG_POS=154;
show slave status \G
}