您好,登錄后才能下訂單哦!
下文內(nèi)容主要給大家?guī)?a title="Mysql" target="_blank" href="http://www.kemok4.com/mysql/">Mysql8主從復(fù)制安裝方法,這里所講到的知識(shí),與書籍略有不同,都是億速云專業(yè)技術(shù)人員在與用戶接觸過程中,總結(jié)出來的,具有一定的經(jīng)驗(yàn)分享價(jià)值,希望給廣大讀者帶來幫助。
1、下載安裝包
https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.18-el7-x86_64.tar.gz
rpm -qa |grep mysql rpm -qa |grep mariadb rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64
3、修改配置文件
cat /etc/my.cnf [mysql] default-character-set=utf8 [mysqld] skip-name-resolve port = 3306 basedir=/usr/local/mysql datadir=/usr/local/mysql/data max_connections=200 character-set-server=utf8 default-storage-engine=INNODB lower_case_table_names=1 max_allowed_packet=16M log-bin=master-bin #master是master-bin,slave的是slave-bin server-id=1 #master為1,slave2 gtid_mode=ON enforce_gtid_consistency=ON binlog_checksum=NONE
4、初始化數(shù)據(jù)庫
groupadd mysql useradd -r -g mysql -s /bin/false mysql cd /usr/local tar xvf mysql-8.0.18-el7-x86_64.tar.gz ln -s mysql-8.0.18-el7-x86_64 mysql cd mysql mkdir mysql-files chown mysql:mysql mysql-files chmod 750 mysql-files bin/mysqld --initialize --user=mysql bin/mysql_ssl_rsa_setup bin/mysqld_safe --user=mysql & cp support-files/mysql.server /etc/init.d/mysql.server
記住數(shù)據(jù)庫的隨機(jī)密碼
#關(guān)閉命令
bin/mysqladmin -u root -p shutdown
#啟動(dòng)命令
bin/mysqld_safe --user=mysql &
5、設(shè)置環(huán)境變量:
cat /etc/profile.d/msyql MYSQL_HOME=/usr/local/mysql/ export PATH=$PATH:$MYSQL_HOME/bin
6、修改隨機(jī)密碼:
mysql -u root -p #輸入初始化隨機(jī)生成的密碼
ALTER USER 'root'@'localhost' IDENTIFIED BY 'hello123';
show master status; #查看master狀態(tài)
7、為主從復(fù)制創(chuàng)建用戶
CREATE USER 'econage'@'%' IDENTIFIED BY 'hello123';
GRANT REPLICATION SLAVE ON *.* TO econage@'%';
#mysql8 之前的版本中加密規(guī)則是mysql_native_password,而在mysql8之后,加密規(guī)則是caching_sha2_password,把mysql用戶登錄密碼加密規(guī)則還原成mysql_native_password. 不然會(huì)報(bào)錯(cuò)如下
#error connecting to master 'econage@192.168.0.56:3306' - retry-time: 60 retries: 1 message: Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection.
ALTER USER 'econage'@'%' IDENTIFIED WITH mysql_native_password BY 'hello123'; #添加這一條命令即可
FLUSH PRIVILEGES;
8、查看連接是否正確:
mysql -ueconage -phello123 -h292.168.0.56 -e 'status;'
9、在slave進(jìn)行連接master:
CHANGE MASTER TO
MASTER_HOST='192.168.0.56', #master主機(jī)ip
MASTER_USER='econage', #上面創(chuàng)建的用戶
MASTER_PASSWORD='hello123', #用戶密碼
MASTER_LOG_FILE='master-bin.000002', #master的file文件名
MASTER_LOG_POS=474; # master的Position號(hào)
查看
show slave status\G #可能會(huì)狀態(tài)不對(duì),執(zhí)行下面命令
stop slave;
start slave;
10、驗(yàn)證
#分別在master和slave查看
show databases;
#在master去創(chuàng)建一個(gè)庫
create database hello
#會(huì)發(fā)現(xiàn)slave上也有一個(gè)hello的庫
對(duì)于以上關(guān)于Mysql8主從復(fù)制安裝方法,如果大家還有更多需要了解的可以持續(xù)關(guān)注我們億速云的行業(yè)推新,如需獲取專業(yè)解答,可在官網(wǎng)聯(lián)系售前售后的,希望該文章可給大家?guī)硪欢ǖ闹R(shí)更新。
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。