一、MySQL安裝
1、安裝依賴
#yum -y install make gcc-c++ cmake bison-devel ncurses-devel
# yum groupinstall -y "Development tools"
2、編譯安裝
#mkdir -pv /app/mysql
#mkdir -pv /data/mysql
#mkdir /root/src
#wget https://mirrors.tuna.tsinghua.edu.cn/mysql/downloads/MySQL-5.5/mysql-5.5.60.tar.gz
#tar -axvf mysql-5.5.60.tar.gz
#cd mysql-5.5.60
#cmake -DCMAKE_INSTALL_PREFIX=/app/mysql -DMYSQL_DATADIR=/data/mysql/ -DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=gbk,gb2312,utf8,ascii -DENABLED_LOCAL_INFILE=ON -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 -DWITHOUT_PARTITION_STORAGE_ENGINE=1 -DWITH_FAST_MUTEXES=1 -DWITH_ZLIB=bundled -DENABLED_LOCAL_INFILE=1 -DWITH_READLINE=1 -DWITH_EMBEDDED_SERVER=1 -DWITH_DEBUG=0
#make
#make install
3、創(chuàng)建mysql用戶組
#groupadd -r mysql
#useradd -g mysql -r -s /sbin/nologin mysql
#chown -R mysql.mysql /app/mysql/
#chown -R mysql.mysql /data/mysql/
#mkdir /var/lib/mysql
#chown -R mysql.mysql /var/lib/mysql
4、配置mysql
#/app/mysql/scripts/mysql_install_db --basedir=/app/mysql --datadir=/data/mysql --user=mysql
#echo "export PATH=/app/mysql/bin:$PATH" > /etc/profile.d/mysql.sh
#source /etc/profile.d/mysql.sh
#cp /app/mysql/support-files/my-medium.cnf /etc/my.cnf
添加下列兩行指定安裝路徑和數(shù)據(jù)庫存放路徑
basedir = /app/mysql
datadir = /data/mysql
#cp /app/mysql/support-files/mysql.server /etc/init.d/mysqld #添加啟動腳本
#chkconfig --add mysqld #設(shè)置開機啟動
#echo "/app/mysql/lib" > /etc/ld.so.conf.d/mysql.conf #導(dǎo)出庫文件
#ldconfig -v #建立庫文件緩存
#ln -sv /usr/local/mysql/include/ /usr/include/mysql #導(dǎo)出頭文件
#/etc/init.d/mysqld start
#/app/mysql/bin/mysqladmin -u root password 'cdae123456'
>create user 'cdae'@'%' identified by '7qKv1zse+rw='; #創(chuàng)建cdae賬號
> create database cdae character set utf8; #創(chuàng)建cdae庫
> grant all privileges on cdae.* to 'cdae'@'%'; #授權(quán)cdae賬號最大權(quán)限訪問cdae庫
> drop user ''@'localhost.domain';
> drop user ''@'localhost';
> drop user 'root'@'::1';
>flush privileges;
>set GLOBAL max_connections=5000; #調(diào)整查詢連接數(shù)
>show variables like 'max_connections'; #查詢連接數(shù)
二、主從配置
1、mater配置
#vim /etc/my.cnf 插入
[mysqld]
log-bin=mysql-bin #開啟二進制日志
server-id=1 #設(shè)置server-id
binlog-do-db =cdae #只同步cdae庫
2、創(chuàng)建同步賬號
# mysql -uroot -p
> create user 'slaveuser'@'192.168.10.82' identified by 'EfY0Gz/IMks=';
> grant replication slave on *.* to 'slaveuser'@'192.168.10.82';
> flush privileges;
> show master status;
3、slave配置
#vim /etc/my.cnf 插入
[mysqld]
server-id=2#設(shè)置server-id
打開mysql會話，執(zhí)行同步SQL語句(需要主服務(wù)器主機名，登陸憑據(jù)，二進制文件的名稱和位置)
>mysql -uroot -p
>change master to master_host='192.168.10.81',master_user='slaveuser',master_password='EfY0Gz/IMks=',master_log_file='mysql-bin.000007',master_log_pos=445;
>start slave; #啟動slave進程
> show slave status\G;
