原始碼mysql5.6
上傳mysql安裝包到服務器（虛擬機）
1.安裝依賴和編譯工具
yum -y install gcc gcc-c++ cmake ncurses-devel autoconf
2.解壓MySQL原始碼安裝包
tar zxf mysql-5.6.10.tar.gz
cd mysql-5.6.10
3.檢測、配置
cmake .
4.編譯
make
5.安裝
make install
6.配置
cd /usr/local/mysql/support-files/
6.1 準備組態檔
cp my-default.cnf /etc/my.cnf
6.2 準備啟動mysql腳本
cp mysql.server /etc/init.d/mysqld
6.3 初始化mysql
useradd mysql
chown -R mysql.mysql /usr/local/mysql
cd /usr/local/mysql/scripts
./mysql_install_db --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql
6.4 給mysql的命令做一個軟連接
ln -s /usr/local/mysql/bin/* /usr/local/sbin/
6.5 復制啟動檔案到/etc/init.d/mysql
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
7.啟動mysql
service mysqld start
8.更改組態檔，啟用二進制日志，在[mysqld]下面增加如下配置
vim /etc/my.cnf
9.給從授權用戶（主操作）
mysql> reset master;
mysql> grant replication slave on *.* to 'tom'@'192.168.59.%' identified by '123';
mysql> flush privileges;
10.查看二進制日志（主操作）
show master status;
+------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000001 | 331 | | |
+------------------+----------+--------------+------------------+
11.登錄mysql，執行同步master操作
停止slave，停止同步，開始修改資訊
stop slave;
寫master的資訊
change master to
-> master_host='192.168.189.161', \\master的ip地址
-> master_user='tom', \\登錄master使用的用戶
-> master_password='123', \\登錄master使用密碼
-> master_log_file='mysql-bin.000001', \\master當前寫入的二進制日志檔案
-> master_log_pos=331; \\當前二進制日志最新的位置
開啟從，開始同步
start slave;
12.查看slave狀態，查看時候成功開始同步
show slave status \G;
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/160031.html
標籤：其他
上一篇：MySQL——主從復制與讀寫分離