MYSQL服務(wù)安裝手冊(cè)

部署手冊(cè)

-相關(guān)軟件

以下安裝包在交接的一》核心語(yǔ)匯部署文檔一》安裝包內(nèi)

mysql-5.634.tar.gz

mysql-utilities-1.6.4.zip

cmake-3.7.1.tar.gz

二系統(tǒng)優(yōu)化

2.1優(yōu)化文件描述符

#sudovim/etc/security/limit.conf#在最后追加以下內(nèi)容

*softnofile102400

*hardnofile102400

*softnproc4096

*hardnproc4096

2.2優(yōu)化系統(tǒng)內(nèi)核參數(shù)

#sudovim/etc/sysctl.conf#追加以下內(nèi)容

net.core.somaxconn=4096#定義了系統(tǒng)中每一個(gè)端口最大的監(jiān)聽(tīng)隊(duì)列的長(zhǎng)

度，這是個(gè)全局的參數(shù)

：wq##保存退出

#sudosysctl-p#執(zhí)行sysctl-p使參數(shù)生效

三程序部署

3.1CMAKE安裝

#sudoyum-yinstallcmake

查看cmake安裝是否成功

[rootleomputecmake-3.7.1]#cmake-version

cmakeversion3.7.1

CMakesuitemaintainedandsupportedbyKitware(/cmake).

3.2MYSQL安裝

1,安裝

#sudoyum=yinstallmakegccgcc-c++

#sudogroupaddmysql#添力口mysql組

#sudouseradd-gmysqlmysql-s/bin/false#創(chuàng)建用戶(hù)mysql并加入到mysql

組，不允許mysql用戶(hù)直接登錄系統(tǒng)

#mkdir-p/home/zyyt/mysql/data#創(chuàng)建MySQL數(shù)據(jù)庫(kù)存放目錄

#sudochown-Rzyyt:mysql/home/zyyt/mysql#設(shè)置MySQL數(shù)據(jù)庫(kù)存放目錄

權(quán)限

#sudochmod-R775/home/zyyt/mysql

#tar-xzvfmysql-5.6.34.targz#加帛壓MYSQL安裝包

#cdmysql-5.6.34#進(jìn)入軟件包存放目錄

#sudocmake.-DCMAKEJNSTALL_PREFIX=/usr/local/mysql

-DMYSQL_DATADIR=/home/zyyt/mysql/data-DSYSCONFDIR=/etc#配置

#sudomake#編譯

#sudomakeinstall#安裝

#sudorm-rf/etc/f#刪除系統(tǒng)默認(rèn)的配置文件（如果默認(rèn)沒(méi)有就不用刪除）

#sudochmod-R775/usr/local/mysql

#sudochown-Rzyyt.mysql/usr/local/mysql

#cd/usr/local/mysql#進(jìn)入MySQL安裝目錄

#./senpts/mysql_instaIl_db-user=mysql-basedir=/usr/local/mysql

-datadir=/home/zyyt/mysql/data#生成mysql系統(tǒng)數(shù)據(jù)庫(kù)

#sudoIn-s/usr/local/mysql/f/etc/f#添加到/etc目錄的軟連接

#sudocp./support-files/mysqLserver/etc/rc.d/init.d/mysqld#把Mysql加入系

統(tǒng)啟動(dòng)

#sudochmod755/etc/init.d/mysqld#增加執(zhí)行權(quán)限

#sudochownzyyt.zyyt/etc/init.d/mysqld

#sudochkconfigmysqldon#加入開(kāi)機(jī)啟動(dòng)

#sudovi/etc/rc.d/init.d/mysqId#編輯

basedir=/usr/local/mysql#修改MySQL程序安裝路徑

datadir=/home/zyyt/mysql/data#修改MySQI數(shù)據(jù)庫(kù)存放目錄

user=zyyt#此行沒(méi)有，需要增加

$bindir/mysqld_safe-user=$user-datadir=',$datadirn#搜索此行，并增加紅

色部分

lockdir=7home/zyyt/lock/subsys'#修改lockdir■后的內(nèi)容為紅色部分

：wq#保存退出

#vi/etc/f#編輯

basedir=/usr/local/mysql#MySQL程序安裝路徑

datadir=/home/zyyt/mysql/data#MySQI數(shù)據(jù)庫(kù)存放目錄

init-connect="SETNAMESutf8mb4'

character-set-server=utf8mb4

：wq!#保存退出

#servicemysqldstart#啟動(dòng)

#sudovi/etc/profile#把mysql服務(wù)加入系統(tǒng)環(huán)境變量；在最后添加下面這一行

exportPATH=$PATH:/usr/local/mysql/bin

：wq!#保存退出

#source/etc/profile#使配置立刻生效

下面這兩行把myslq的庫(kù)文件鏈接到系統(tǒng)默認(rèn)的位置，這樣你在編譯類(lèi)似PHP等軟

件時(shí)可以不用指定mysql的庫(kù)文件地址.

#sudoIn-s/usr/local/mysql/lib/mysql/usr/lib/mysql

#sudoIn-s/usr/local/mysql/include/mysql/usr/include/mysql

#sudomkdir/var/lib/mysql#創(chuàng)建目錄

#sudoIn-s/tmp/mysql.sock/var/lib/mysql/mysql.sock#添加軟鏈接

#mysql_secure_installation#安全配置向?qū)?

第一步：默認(rèn)密碼為空，直接回車(chē)即可

[root@computeinstall]#mysql_secure_installation

NOTE:RUNNINGALLPARTSOFTHISSCRIPTISRECOMMENDEDFORALLMySQL

SERVERSINPRODUCTIONUSE!PLEASEREADEACHSTEPCAREFULLY!

InordertologintoMySQLtosecureit,we'llneedthecurrent

passwordfortherootuser.Ifyou'vejustinstalledMySQL,and

youhaven'tsettherootpasswordyet,thepasswordwillbeblank,

soyoushouldjustpressenterhere.

Entercurrentpasswordforroot(enterfornone):|

第二部：是否配置root密碼,安全起見(jiàn),選擇“Y"進(jìn)行密碼配置,輸入兩次密碼

SettingtherootpasswordensuresthatnobodycanlogintotheMySQL

rootuserwithouttheproperauthorisation.

Setrootpassword?[Y/n]|

Setrootpassword?[Y/n]y

Newpassword:

Re-enternewpassword:|

第三部：是否刪除匿名用戶(hù)，安全起見(jiàn)，選擇"Y"

Bydefault,aMySQLinstallationhasananonymoususer,allowinganyone

tologintoMySQLwithouthavingtohaveauseraccountcreatedfor

them.Thisisintendedonlyfortesting,andtomaketheinstallation

goabitsmoother.Youshouldremovethembeforemovingintoa

productionenvironment.

Removeanonymoususers?[Y/n]|

第四部：是否禁止root用戶(hù)遠(yuǎn)程登錄,安全起見(jiàn),選擇"Y"

Normally,rootshouldonlybeallowedtoconnectfrom'localhost'.This

ensuresthatsomeonecannotguessattherootpasswordfromthenetwork.

Disallowrootloginremotely?[Y/n]|

第五步：是否刪除“test”數(shù)據(jù)庫(kù),安全起見(jiàn),選擇"Y"

Bydefault,MySQLcomeswithadatabasenamed'test'thatanyonecan

access.Thisisalsointendedonlyfortesting,andshouldberemoved

beforemovingintoaproductionenvironment.

Removetestdatabaseandaccesstoit?[Y/n]|

第六步：是否更新操作,選擇“Y"

Reloadingtheprivilegetableswillensurethatallchangesmadesofar

willtakeeffectimmediately.

Reloadprivilegetablesnow?(Y/n]|

將服務(wù)加入開(kāi)機(jī)啟動(dòng)

#sudovim/etc/rc.local

suzyyt-c7etc/init.d/mysqldstart"

3.2MYSQL主備同步

1、設(shè)置同步master(172.17.0,50)

編輯配置文件/etc/f確保有如下行，如沒(méi)有請(qǐng)參照增加。

#sudovim/etc/f

server-id=1

log-bin=mysql-bin

創(chuàng)建一個(gè)mysql的賬號(hào)為同步專(zhuān)用

#mysql-uroot-p

mysql>grantreplicationslaveon*.*to,backuser,@,172.17,0.51,identifiedby

'TzKQ%OnA46C-yd';

my$ql>flushprivileges;#刷新權(quán)限

重啟mastermysql

#servicemysqldrestart

查看master狀態(tài)

mysql>showmasterstatus\G

mysql>showmasterstatus\G

I*************************Lrow***************************

File：mysql-bin.000003

Position:728

Binlog_Do_DB:

Binlog_Ignore_DB；

Executed_Gtid_Set:

1rowinsetTo.66sec)

mysql>|

3、設(shè)置同步slave(172.17,0,51)

編輯配置文件

#sudovim/etc/f

server-id=2

relay_log=mysqld-relay-bin

read-only=on

log_bin_trust_function_creators=l

配置完成后，重啟服務(wù)

#servicemysqldrestart

登錄Slave(1)，然后執(zhí)行下面命令:

mysql>stopslave;

mysql>changemasterto

master_host='0,,master_user=,backuser,,master_password='TzKQ%OnA

46C~yd';

mysql>startslave;

mysql>showslavestatus\G

查看這兩項(xiàng)是否為YES,yes為正常。

Slave_IO_Running;Yes

Slave_SQL_Running;Yes

*************************■*].row***************************

Slave_IO_Sta