MySQL安装

数据库安装

1、新建数据库用户mysql
/usr/sbin/groupadd mysql
/usr/sbin/useradd -g mysql -s /sbin/nologin mysql

2、MySQL安装
解压软件至/usr/local/
tar zxvf mysql-5.6.34-linux-glibc2.5-x86_64.tar.gz -C /usr/local/
cd /usr/local/
创建mysql目录软连接
ln -s mysql-5.6.34-linux-glibc2.5-x86_64/ mysql
创建数据库目录
mkdir -p /data/mysql/mysql3306/{data,logs,tmp}
修改目录权限
cd /data/mysql/
chown -R mysql.mysql ./*
chmod -R 700 ./*
初始化端口
cd /usr/local/mysql
./scripts/mysql_install_db -defaults-file=/data/mysql/mysql3306/my.cnf

3、配置主从(GTID)
新建复制用户repl
GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'repl'@'10.10.10%.%' IDENTIFIED BY 'xxxx';
执行
change master to master_host='10.10.X.X',
                             master_user='repl',
                             master_password='xxxx',
                             master_auto_position=1;

start slave;
传统模式：
change master to master_host='192.168.3.155', 
                                master_port=3306,
                                master_user='repl', 
                                master_password='repl', 
                                master_log_file='mysql-bin.000036', 
                                master_log_pos=1083764;

数据库运维工具安装

安装percona-xtrabackup
tar xvf percona-xtrabackup-2.4.3-Linux-x86_64.tar.gz
cd percona-xtrabackup-2.4.3-Linux-x86_64/bin/
yum install perl-IO-Socket-SSL
yum install perl-Time-HiRes
cp innobackupex xtrabackup /usr/bin/

安装percona-toolkit
tar xvf percona-toolkit_2.2.16-1.tar.gz
cd percona-toolkit-2.2.16/
perl Makefile.PL
make
make install

MySQL链接
https://downloads.mysql.com/archives/community/
XtraBackup
https://www.percona.com/downloads/XtraBackup/LATEST/
percona-toolkit
https://www.percona.com/downloads/percona-toolkit/