資源描述:
《公司mysql部署(主主復(fù)制)》由會(huì)員上傳分享,免費(fèi)在線閱讀,更多相關(guān)內(nèi)容在教育資源-天天文庫(kù)。
1、使用環(huán)境:64位centos6.4數(shù)據(jù)庫(kù)Master主服務(wù)器(兩臺(tái)):Centos6(MySQL-Cluster-Master1)192.168.0.152,Centos6(MySQL-Cluster-Master2)192.168.0.153數(shù)據(jù)庫(kù)Slave從服務(wù)器(兩臺(tái),即sql及存儲(chǔ)節(jié)點(diǎn)):Centos6(MySQL-Cluster-Slave1)192.168.0.154,Centos6(MySQL-Cluster-Slave2)192.168.0.155MySQL-MGM管理服務(wù)器:C
2、entos6(MySQL-Cluster-MGM)192.168.0.156數(shù)據(jù)庫(kù)版本:mysql-cluster-gpl-7.4.11-linux-glibc2.5-x86_64.tar.gz數(shù)據(jù)庫(kù)Master-Master主主復(fù)制:Centos_6(MySQL-Master1)192.168.0.157Centos_6(MySQL-Master2)192.168.0.1581、將mysql-5.7.13-linux-glibc2.5-x86_64.tar.gz復(fù)制到157、158服務(wù)器的tm
3、p目錄下1、在157、158服務(wù)器中安裝mysql數(shù)據(jù)庫(kù):一:建立mysql群及mysql群下mysql用戶root#/usr/sbin/groupaddmysqlroot#/usr/sbin/useraddmysql-gmysql二:進(jìn)入壓縮文件目錄、解壓及復(fù)制到對(duì)于目錄下root#cd/tmp/(進(jìn)入tmp目錄)root#tarzxfmysql-5.7.13-linux-glibc2.5-x86_64.tar.gz(解壓mysql,同時(shí)建立相同名稱的目錄)root#mvmysql-5.7.1
4、3-linux-glibc2.5-x86_64/usr/local/mysql/(將解壓目錄復(fù)制到/usr/local/mysql目錄下)root#cd/usr/local/mysql/(進(jìn)入/usr/local/mysql/)mkdirdata(在usr/local/mysql目錄下建立data目錄)三:修改usr/local/mysql目錄下所有文件的權(quán)限chown-Rmysql:mysqlmysql(在usr/local下執(zhí)行)四:修改/etc/my.cnf文件vi/etc/my.cnf(
5、執(zhí)行,修改命令如下:)[mysqld]basedir=/usr/local/mysql/datadir=/usr/local/mysql/dataScket=/tmp/mysql.sockread_onlyrelay_log=/usr/local/mysql/log/relay_logs五:初始化數(shù)據(jù)進(jìn)入mysql安裝目錄cd/usr/local/mysql執(zhí)行:bin/mysqld--user=mysql--basedir=/usr/local/mysql/--datadir=/usr/loc
6、al/mysql/data/--secure-file-priv=/root/--initialize./bin/mysqld--user=mysql--basedir=/usr/local/mysql/--datadir=/usr/local/mysql/data--initial--initialize-insecure六:?jiǎn)?dòng)mysql添加開(kāi)機(jī)啟動(dòng):執(zhí)行命令cpsupport-files/mysql.server/etc/init.d/mysql把啟動(dòng)腳本放到開(kāi)機(jī)初始化目錄啟動(dòng)mysql服
7、務(wù):執(zhí)行命令servicemysqlstart七:登錄mysql./mysql-uroot-p(在bin下執(zhí)行)輸入密碼即可;修改密碼:SETPASSWORD=PASSWORD("123456');八:遠(yuǎn)程連接在cmd命令行中輸入mysql-h192.168.0.158-uroot-p123456出現(xiàn)Warning:Usingapasswordonthecommandlineinterfacecanbeinsecure.ERROR1130(HY000):Host"192.168.139.1'is
8、notallowedtoconnecttothisMySQLserver為了安全,默認(rèn)是不允許mysql本機(jī)以外的機(jī)器訪問(wèn)mysql數(shù)據(jù)庫(kù)服務(wù),因此需要重新授權(quán)root授權(quán):GRANTALLPRIVILEGESON*.*TOroot@'%'identifiedby'123456';非必要的步驟,如果遠(yuǎn)程連不上,估計(jì)是防火墻的問(wèn)題,關(guān)閉試試:[root@localhostmysql]#serviceiptablesstopsetenforce0iptables:將鏈設(shè)置為政策ACCEPT:filt