參考文檔:
https://www.cnblogs.com/galengao/p/5755788.html
https://blog.csdn.net/beyondlpf/article/details/6996104
- 源碼包需求 將源碼包加入到/usr/local/package下
源碼包下載鏈接：
https://pan.baidu.com/s/1bBfG6z9TlErw5y58eGe8Hw 密碼：wlld
cmake-3.5.0.tar.gz
mysql-5.7.17.tar.gz
boost_1_59_0.tar.gz
yum安裝依賴包
yum -y install gcc gcc-c++ make cmake ncurses ncurses-devel man ncurses libxml2 libxml2-devel openssl-devel bison bison-devel解壓boost, 5.7需要boost
cd /usr/local/package/
tar zxvf boost_1_59_0.tar.gz
mv boost_1_59_0 ../解壓cmake, 并安裝
cd /usr/local/package/
tar -zxvf cmake-3.5.0.tar.gz && cd cmake-3.5.0/
./configure --prefix=/usr/local/cmake
gmake && make install使用cmake編譯安裝mysql
cd /usr/local/package/
tar -zxvf mysql-5.7.17.tar.gz && cd mysql-5.7.17/
/usr/local/cmake/bin/cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DWITH_BOOST=/usr/local/boost_1_59_0 -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci
make && make install
配置mysql
cp /etc/my.cnf /etc/my.cnf.bak
rm -rf /etc/my.cnf
mysql初始化
cd /usr/local/mysql
useradd -r mysql
chown -R mysql .
chgrp -R mysql .
創(chuàng)建數(shù)據(jù)目錄
mkdir -p /usr/local/mysql/data/
bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
bin/mysql_ssl_rsa_setup --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
chown -R root .
chown -R mysql data/
復(fù)制配置文件
cp support-files/my-default.cnf /etc/my.cnf
使用service管理
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
將mysql目錄加入到環(huán)境變量
vi /etc/profile
{
PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH
}
source /etc/profile
修改配置文件
vi /etc/my.cnf
{
datadir = /usr/local/mysql/data
}
service mysqld start
ps aux | grep mysqld
mysql -uroot -p
修改root密碼
grant all on . to 'root'@'%' identified by 'GfsdX1F8pYL@1s';
set password = password('GfsdX1F8pYL@1s');
mysql主從搭建(http://www.reibang.com/p/b8422c2fa80e)
主: 192.168.2.22
從: 192.168.2.23
1 修改主庫和從庫配置文件
主庫
$ vim /etc/my.cnf
# 啟用二進(jìn)制日志
log-bin=mysql-bin
# 服務(wù)器唯一ID
server-id=22
從庫:
$ vim /etc/my.cnf
# 啟用二進(jìn)制日志，可不配
log-bin=mysql-bin
# 服務(wù)器唯一ID
server-id=23
重啟
service mysqld restart;
在主庫建一個專用來備份的 MySQL 賬戶
grant replication slave,reload,super on *.* to 'repl'@'%' identified by 'repl';
flush privileges;
show master status;
mysql> show master status;
+------------------+----------+--------------+------------------+-------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+------------------+-------------------+
| mysql-bin.000001 | 154 | | | |
+------------------+----------+--------------+------------------+-------------------+
更改從庫配置; 指定主庫復(fù)制地址, 復(fù)制用戶, 密碼, 二進(jìn)制文件名稱以及位置
change master to master_host='192.168.2.22',master_user='repl',master_password='repl',master_log_file='mysql-bin.000001',master_log_pos=154;
開啟復(fù)制
start slave;
查看狀態(tài)
show slave status\G
以下兩項成功,即完成搭建
Slave_IO_Running: Connecting
Slave_SQL_Running: Yes
