MySQL-部署練習-主從部署

1、MySQL 5619 基于 RHEL6.4主從模式部署手冊菜2021年8月文檔版本時間作者容版本2021-08菜創(chuàng)立Linux平臺下 MySQL5.6.19 主從安裝文檔手冊1.0目錄In stall MySQL 5.6.19 on Linuxl文檔版本2一、文檔簡介3二、安裝須知31. 操作系統(tǒng)版本32. 磁盤情況43. 網絡情況44. YUM源 65. 防火墻6三、cmake版本8四、MySQ安裝部署111. 部署方式112. 部署步驟113. MySQL初始化15Install MySQL 5.6.19 on Linux一、文檔簡介本文檔僅用于學習交流 MySQ主從部署相關技術，非商業(yè)性

2、文檔。該文檔容是關于Linux平臺下MySQ源碼包安裝方法、步驟與相關須知等容, 適用于研發(fā)人員、運維與現(xiàn)場實施人員參考。請全文通讀后，再進行MySQ安裝的相關操作，如安裝過程中遇到錯誤，請 先解決錯誤后，再按順序進行安裝。二、安裝須知在MySQl安裝前，請先以root用戶登錄操作系統(tǒng)，并確認效勞器的網絡、磁盤、 防火墻、YUM®等信息，以便于順利的開展安裝 MySQ的工作。本次部署為MySQ主從形式，需要在三臺效勞器上分別進行部署配置。本例如采 用兩臺虛擬機進行部署練習，主從機信息詳見下表：MasterSlave01Slave02IPID8184851. 操作系統(tǒng)版本演示安裝的操作

3、系統(tǒng)版本：Red Hat En terprise Li nux Server release 6.4 (Sa ntiago)查看操作系統(tǒng)版本命令： lsb_release - a 或 cat /etc/system-releaseLsb_release - a執(zhí)行結果如以下列圖所示：rootMySQL-K'Ol 蠱 lsb_r«Uase -aI SB Version:; txise-4.0-tnd64；base-4.0-noarth:core-4. &-®d64:core-4.0-noarch:gr<ptiics-4r0-anid64: graphi

4、cs-4.fr-noorch: print! rkg-4,0-amcl64: printing *4.0-noarchDistributor ID 二 Red I tattntfirp廣i seServrpe合trLptlon:Red HarTrtrprig Llmux Eervr r電lea昶 6.4 Saniio。Releosa:6,4Codentnc:5 anti agocat /etc/system-release執(zhí)行結果如以下列圖所示rootMySQL-W01 cat /etc/system-releaseped Hat Ent皂rpi.sm Linux 5Ervm rmlaciSQ

5、 6.孫(Eamticigo) |2. 磁盤情況查看磁盤使用要，MySQ需要至少2G的磁盤空間，假設有數(shù)據(jù)需要寫入，請按 實際業(yè)務量劃分存儲。硬盤使用情況查看命令：df - hdf - h執(zhí)行結果如以下列圖所示:rootSMy5QLM01 proc哪 df -hFilesystemSizeUsedAvailUse%MountEd on/dev/sda313G8.8G3"G73%/tmpfs495M0495M0S/dev/shm/dev/sdal194M28M15 6M16%/boot通過查詢結果得知在“ /目錄下，有8.8G的空間，可供使用，本次 MySQL將安裝在/usr/loca

6、l下。3. 網絡情況查看本地IP地址，以保證本機做為MySQH效勞器的情況下，其他用戶可以訪 問。查看本地IP命令：ifconifgIfconfig 執(zhí)行結果如以下列圖所示，本機的IP地址為192.168.1.81, Mask : rootWySQL-M01 -防 ifconfigethl LinK encap:tthernetHWaddr W):|in駐 addr：】92.1創(chuàng)丄81 Bs航：四2.丄陰.12巧 M貯K：衛(wèi)intG addr: ft?80: 20c:2qff e85:477S/64 Scope: I InkUP BROADCAST RUNNING MIJITTCAST 町Me

7、tric；1RX packets: 162 rro rw:0 dropped: oyer runs :0 frame :：0TX packets:744 errors: dropped:® overruns:0 carrieriQ collisions:0 txqueuelen:1000RX Dytes: 14620 (HZ.9 Ki6) TX byte&:«4051駝衛(wèi) KiB)loI ink enrnpil oral Ioopbnckinet addr:127,0.0,1 Mask:255r0,0.einetG addr: :17128 Scope:HostUP

8、 LOOPBACK RUNNING MU:16436 ctric:lRX packets:0 errors:0 dropped ov總rruns:® frame:® TX packets:0 errors:0 dropped: 0 owe口訂、：0 curritar :0 rol 1isions:0 txqueuelen:0RX bytes:0 (0.3 b) IX bytes:0 (0.0 b)測試 、192.168.1.84 和 192.168.1.85 三臺效勞器是否可以 ping通，為后續(xù)部署做準備。執(zhí)行命令ping 192.168.1.81、ping 192.16

9、8.1.84 和執(zhí)行結果如以下列圖所示rooteMySQL-M01 肌他 19乙 16,1.81 PING 192.168.1.81 (192.168.1.81) 56(84) bytes of data.64 bytes from 192.168,1.81; icnp_seq=l ttl=64 time=0.022 its b4 bytes from 19Z. 158.1.81: icnp_seq=Z ttl=54 time=0,053 its ac192.168.1.81 ping statistics 2 packets t?ansr)ittedT 2 received T 036 pa

10、cket loss, time 1748ms rtt nniVag/inQX/maey 00230+陽770一0?3/0.血6 msrootMySQL-M01 #|ping PING 192.168.1.84 (192.168.1.84) 56(84) bytes of data.64 bytes from 192.168.1.84: icrip_£eq-l t:tl-64 time-©.468 nsAC-15乙1&8.1.84 ping statistics -1 pa匚kets transnitted, 1 receivedt 05K p口匸ket loss,

11、time 951ns rtt許 0_4陰丿0一4駅2一¥*皿 0胸 msrootMySQL-Mdl -# ping W. 160.1.85 |PING 192.16».1.85 (192.168*1*85) 5(84) bytes Of data.64 bytes from 19乙168.1.85: icnp_seq=l ttl=64 time=0.400 msAC192.168.1.85 ping statistics 1 packets transnittd, 1 received, packet loss, time 971ns rtt min/avg/max/mde

12、/ 二 9.400/0,400/0.400/0.000 ms rootMySQL-MOl T# |4. YUM源分別查看 、192.168.1.84 和 192.168.1.85 效勞器一下 YUM源 信息，以方便在安裝MySQL!關依賴包時，可以通過 YUM順利解決。通過查看YUM配置文件來確認YUMS信息，執(zhí)行命令：rootMySQL-M01 vim /etc/yun-repos,d/rhel-source,repoYUM源信息顯示，該源所指向本地/mnt文件夾(baseurl=file:/mnt)rhel-sour匚encmi它=Rd Hot Enterorise Linux Srele

13、asever - Sbasearch - Source bus eu rl=fil e: ZZ/inrit enabled=lgpgcheck-0查看/mnt是否有效，驗證命令 cd /mnt 或df - hdf - h執(zhí)行結果顯示/rhel6.4.iso 掛載在/mnt目錄下，即該源有效CrootlySQL-WOl 巧# df -hFilesystemSizeUsedAvailUseSK Mounted onZdev/sdu313G8.863.3G7336 /tmips495M0495M0% /dev/shm/dpv/sda11Q4M1砒 /hont3.5G3.5G010096 /mnt5.

14、 防火墻查看防火墻(iptables)狀態(tài)，防止因防火墻策略問題導致遠程無法本地MySQL 情況，本次部署中，、192.168.1.84 和 192.168.1.85 效勞器全 部選擇關閉防火墻。查看防火墻壯態(tài)命令/etc/init.d/iptables status執(zhí)行結果顯示iptables 正在工作rooty5QL-M01/etc/init .d/tptaislesstatuskhdin 1WT (policy ACCLPt)num targetgrot opt sourumdestirw ticn1ACCEPTall a. 45.0/0state RELAItD.ESUBLXSHED2

15、ACCEPTic«p - .3/03 ACCEPTuu 氛氛億0F04ACCfPTtrp 0/0stntp NFW trp dpt:?5REJECTqll f)壽用&阿fj.ft.ft. 0/0rpjort 'flii-h if up hast prahibi tdChain FDRHIAM)Cpolicy ACCEPT)luffi targetprot opt sourcedfistirwtion1REJECTait -馭era用彷reject-with R-host-prohibited:hain OUTPUT(policy ACCEPT)nun to rgetp

16、rat oot source(testinotian關閉防火墻指令 /etc/init.d/iptables stop執(zhí)行結果如以下列圖所示rootWySQL-Myi -J# /etc/i mt, d/iptables stopiptables: Flushing firewall rules;rOK iptubles: Setting chains to policy ACCEPT: filterOK iptables: Unloading modules:I _ . OK 再次執(zhí)行 /etc/init.d/iptables status執(zhí)行結果顯示防火墻當前已關閉。go媲y5QL-M0j.

17、三I# /點/in匕 d/ipp嘰es status Lptables: Firewall is not: running.為了防止防火墻開機自啟動，執(zhí)行命令chkc onfig iptables -list執(zhí)行結果顯示防火墻為開機啟動rootMySQL-M01 T# chkconfig iptables -listiptables0:off l：off 2: on 3:on 4ion5: on6: off關閉防火墻開機啟動命令chkconfig iptables off ，如執(zhí)行正確沒有信息反再次查看檢查防火墻開機啟動狀態(tài)，執(zhí)行命令chkconfig iptables - list執(zhí)行結果顯

18、示，已完全關閉開機防火墻自啟動策略routMySQL-M01 *# chkconfig iptables -listiptables9:off l:off2:off3:off 4:off 5:off 6:off三、cmake版本cmake是MySQ安裝時所需要的軟件，該軟件一定要在MySQ前安裝。本次使用的cmake版本為cmake-3.0.0.tar.gz 。1. 解壓 cmake-3.0.0.tar.gz，執(zhí)行命令：rootWyQI ridta# rm ciakerm： raov電 regular file 'crake-3.0,tar.GZ,? yLroottySQL Mwi d

19、ato# ll total 記4944-irw-r-r-. 1 root root57M714 Jul 29 財；鋤 e h >：j t*- ：,krw-r-r-.1 root rnct関lul 03:40-rw-r-r-, 1 root rnot中H弗0 Tul 咼常5:輛解壓后得到文件夾rootWySQL Mfli datajfr lltotul Z5494BLrtt-r- r -.1rwtroot5珀1C4Jul2803:40i顧ml_iE-r-1r*cHiirr»ot闌4lul/牯功S:4fthrk一Ehirifxr-xr-ji.9rootroot4OT6Jul珊0i;

20、4iS-n<-r-r-.1rootroot64«)8ZJ1JulZ50J;4W-nr-r-r-.1rootrwt341955Jul前83:40keanlived1.72. 進入 cmake-2.8.12.2 文件夾，執(zhí)行 以下列圖為文件夾中容rootNySQL-Mftl onake-?.8.1?,2Jt lltotal 3055 rwxr xr k -rw-r-一 * rw-r-r -rw-rrnw r r-rw-rr-rw-rr-rw-r-r -rwxr-Kr-K rw r - r- -rw-rr -rw-r-r-rw-r-r-rw-r - r- drwxr-xr-xdrwx

21、r-xr-x drwKr->r-x rw -f*r - drwxr-str-x drwKr-xr-x drwxr''xr-x drwKr-xr-x15(11gomesS3974Jan1?2(514bootstrap1501genes25473bJan1/014ClmngtLog.nranijaL1501partiesZ&03523Jan172&WChangeLog.txt1501gonitfs5465Jan172021CMukeCPackxmuke151gemes3+36Jan172&14CMakeCPackOptions ake.in15

22、1;1gores153Jan172021CMakcGrapnVizOptions akeL501254JgJan172亦CMakeLists.txt1591genes4481Jan172021OfakeLogD.gif1個gejms押Inn17?Q14cnakp uni nstnll . nrok. i n15«1gomes2515Jan172614Cofflpileriags ake1501qcmesJan172&14configure15機genes2冏Jan172021Copynght.txt1501gmi的1050Jon172021CTe&tConfia ak

23、e13338'uri17?B14it Custom . cmukp. i n1麗145Jan17苗14CTestCustom.匚test.i n1501gomes809Jan172S14DartConfig ake1沁gores4144Jan172叫1DartLOCdL.conf.in3rootroot*1096Jul賀Ql：181501屮in電警28046Jun172021duxyytn.config斗rootroot40%Jul北01:4S9rootroot20480Jul3C01:481沁194bin17214Recichi 電.txt7rootroct32768Jul01：幅?

24、rootrootJul01:48169routroot12788Jul30 01:4815rootroot4096Jul30 $1:483.安裝cmake相關依賴包，執(zhí)行命令:yum -y in stall n curses n curses-devel ope nssl-devel bis on gcc gcc-c+ make4.在 cmake-2.8.12.2 文件夾中，執(zhí)行./bootstrap 命令 執(zhí)行結果局部截圖如以下列圖所示rTDutlySjl M451 cmukt?- 2. B. 12. /txjottrutJ<Muke 2.8.12.2, Copyr-iglvt 240

25、0-21012 kiIric .FouHfl GNU toolchuinC c<xnoilftr on this system 1 t)cc<->-+ compiler on this system is: g+Moke-File processor on this systejm is: ymckejji is GNU conpilcr<i-k+ bus sutonvgi hub unsctcnvnot have cnviron in stcTLib-hg h* has STL In &td: namespacehns ANSI ?;tmods幻f* hcis

26、 strearns in std t : ncimrsprirc<jr+ ns sstrpa»啰十*ape.rotor<-<st-ri rig, c>iar*5<jk+ hns sfrl itrryt-nr_+rfli+s<)* hns stflndnrd tempi at til locator<j*+ hns al iocntor-c> :nd<>q+ dnes not hovp non-stand cirri nl locntaro； :nax :si?斤 a 廠七仲+ hns st 1 rnntaini?：r5 su

27、pport 1 nq al 1 orator ohifictshriR hpndr cstddpfcn requires tenplate friends to use o<jiniefnb>cr ttnDlat亡55. 編譯cmake源碼，執(zhí)行命令：make執(zhí)行結果局部截圖如以下列圖所示root«*ySQL M01 cnaice-2.Sr12.2> rrakeScanning dependencies of target cirIHL.test 溝 Building C ct>ject Utilitie5/KWI*flL/t5t/C*rtakeFiles/m

28、rl-test.dir/t«l r.g(1%J Bui I dir g C object Uti U tt es/KWIML/test/C'flalteFiles/cnlL-test. di r/test_ABI_C, c,oi 11 Building C obj«t Uti1111 ei/lOllML/test/CMakeFiBil_te£t. d.oL UfeJ Bui Ldintj C 9t>ject Uti LlJtLf!1/KJdMLyttr!it/twcikEl"LLES/ti 閔 Building CXX object UtL

29、lLties/KWlMVtest/CkukeFiles/cirlML 閔 Building CXX object JtiLities/KWIF*L/test/OakeFiIes/arIL test.dir/test sq Building CKX abject Utilities/l®lML/test/CMakeFilei/c>IML_test.dir/test_include.CKX.m.a I inking CXX pxscutatJl p cmJMl_test?% Built target rwiIHL.testScanning dependencies of targe

30、t ersys閔3%J 戰(zhàn) 異Ik譏ninp C otject Source/k*sys/CMcker譏藥/an呂溝.dir/PrxsLiMDCc.o Bmlturg object 5owrce/k>sys/tMok; les/cmsys dir/KaseW. c q 8uiIding C object Sdurce/lcn5.ysyiMak4»FLLpi/cnsys.ciLr/MLi.L.o bUi lUing t obj已匸t SouTl已/khsys/LMakebLles/cinisys-clLr/1 亡rrrinciL-匚-口31 Builtiirit) CSuurce

31、/khsys/CMckeFLles/cfnsys.dir/Svstem.c.043t Building C object Scurce/khsys/CMokeFi 1 es/cusys.dir/Stringx. dBu譏ding CXX ohjertFluilcinq CXX ob-jnetBuilding CKX abject4幻佝 佝Building CXX otijuctBu ilUiriy CXX cbjecthource/kihys/CMGkFi' ss/cnsys . tJi r/Cirrtcry.rxx. oSourrn/kbsys/tMflkf F11 ns/rnsys

32、 . ri' r/Dyna-nicl nudpr. rxx. nSotircfi/kiN sys/f MnkrF i I es/cisy. di r/Glob gxx . oSource/kiNiysAMukeF i les/cnsys. di r/Regul ar Express ion. exx .0Sou r(_ B/k» sy 5/CMuker i les/cnsys. di r/SystffliTiMjls .cxx.o6. 安裝 cmake 執(zhí)行命令：make in stall執(zhí)行結果局部截圖如以下列圖所示IL Toothy SQL - M01 onake-2.S

33、.muke mstdlLC 2幻 據(jù) l珈 r can r刑 c閃 塔幻 t嗣 c坨切 期 陶 L芒幻C 260 他 4S9&J 561 r翻 839G VV 95%95幻 藐幻 網 L卿 98幻Built Built BULlt Built Euilt Built Ruilt Built Built &ULlt Built Blit It 0u.lt Built Built11 Bmlt Built Built Built Bunt Built Built Built BULlttarget turqmt target tarpt target target target t

34、arget target turgut target target tat get tarqet torget tarqpt torqfft target tar target target tdrLgut target tafgut tur yetCilML .testcisys cpssreitJynlDGd cnsys c.osysTeitPr-cKESsl sysTf SntSna rsdFor* flr1 cnsysTestsC cnSysTtistiCKX ozlib cn curlIIBCURL cicump r 亡 ss cnbzip2 cull bardirve c tjcp

35、at <nFor>CVakeLib CPackLlU CTestLib canoke cnakr CplKk ctestGDCumeri tatiw (MakeLibTestS7. 查看 cmake版本，執(zhí)行命令： cmake - version執(zhí)行結果顯示，cmake安裝成功rootMySQL-M01 cmake-Z.8,12*2# cmake -version8. 數(shù)據(jù)庫版本四、MySQL安裝部署1. 部署方式本次MySQ采用主從部署方式2. 部署步驟1. 創(chuàng)立 mysql 組，執(zhí)行命令：groupadd mysqlrootMySQL-W01 cmake-2.8.12.2# g

36、roupadd mysql2. 創(chuàng)立mysql用戶，并參加到mysql組中，執(zhí)行命令:useradd -M -g mysql -s /sb in/no log in mysqlroot6MySQL-M0L cmoke-2.8.12.2# useradd -M -g mysql s /sbin/nologin my&ql3. 解壓 mysql5.6.19 壓縮包，執(zhí)行命令：4. 進入 mysql-5.6.19 文件夾，執(zhí)行命令：r oo t e>My SQL * M01 data# cd mysql-5.6-195. 通過cmake工具來編譯MySQL源碼，在編譯項中添加相關參數(shù)。

37、MySQ安裝路徑為/usr/local/mysql ，數(shù)據(jù)文件路徑為/usr/local/mysql/data ，監(jiān)聽端 口為3306,字符集為utf8等。執(zhí)行命令：cmake -DCMAKEN STALL_PREFIX=/usr/local/mysql -DSYSCONFDIR=/etc -DMYSQL_DATADIR=/usr/local/mysql/data -DINSTALL_MANDIR=/usr/share/man -DMYSQL_TCP_PORT=33O6 -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DDEFAULT_CHARSET=utf8 -DEXT

38、RA_CHARSETS=all -DDEFAULT_COLLATION=utf8_ge neral_ci -DWITH_READLINE=1 -DWITH_SSL=system -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1執(zhí)行命令示如以下列圖所示rooWMySQL-M01 mysql-5.6* 19# cmake a -DCMAKE_INSTALL_PREFIX=/usr/locaI/mysql > -DSYSCONFDIR=/etc > -DMYSQL_DAiR

39、=/usr/local/mysql/data > -DINSTALL_MANDIR=/usr/share/man a -DMYSQL_TC P_PORT= 3 306 > -DMYSQL_UNIX_ADDR=/tmp/mysql.soc k > -DDEFAULT_CHARSET-Utf8 a -DEXTRA_CHARSETS=aU a -DDEFAULT_COLLATION=utf8_general_ci > -DWITH_READLINE=1 > -DWITH55L=sy5ter a -WITH.EMBEDDED_SERVER=1 a -DENABLED_LO

40、CAL_INFILE=1 > -DWirH_INNOBASE._STORAGE_ENGINE-l|執(zhí)行結果局部截圖如以下列圖所示:CrootWySQL-MOl mysql-5.6.19 saK電 =-DCMAKE _I5 TALL _PR£ F EX=/u r/Loco l/nysql > -DSYSCONFDIR=/etc a -CMY岡L OATADIR-/usr/locaX/mysql/data A -DINSTALL MANUIWusr/share/mqr> ，-LHYSQL TCP_PORT-3306 X. -DHY5QL_UIX_ADDR-/tnp/my

41、sql.so<k > -DDLrAULT CHAItSET-Uirg ，-DEXTRA_CHAIt5ETS-all X> -DDEFAUL7 COLLATIOK-utf8_gen*ral_ci a -DWITH_READLThlf-l > -DWITH.S5L-system > -DWrTH_FME5FDOFO SERVER- > -IDIFMABI FD IOCAI INFTlf-l > CWIIB JN'JOfMSf. S7QRAGt_ENGrNf-1- Running cniiike wrsion 2.0.12.?-MySQL 5歷均-P

42、ockaging ns: nysql-5,1 I inux-x86_64-KAVE_VlSIBlLiir_HlDO-OPEMSSLJNCHICEJOIH - /usr/includeOPfNSSL.LrBRARY - Zusr/libM/1 bssl.so-CRYPTO_LIERAIIV _ /usr71ibcrypto.sc-QPFMSSL_MAJOft_VfRSTON - 1-5SIIBRARTF4 - /u&r/l ib64/liIsssl .so;/usr/libM/libcrypto. sc;cll-Nat buildiruj ND6Ltbrcir'y ny|Lcli

43、&nt ckpmith on OS LIBS -lpthreud;«rt;/usr/l ib647libail.so;/usr/libb+/l ibtryp .sc3；dL6. 編譯MySQ源碼，執(zhí)行命令：make執(zhí)行結果局部截圖如以下列圖所示rootWySQL-M01 mysql-5,6.19# makeSeaming dependencies of target INFO_BIN 05Q Built target INFO.BINSeeming dependencies of target INFO_SRC0%： Built target INFO.SRCScanning

44、 dependencies of target d?i_check0% Built target abi_checkSeeming dependencies of target zlitiE C EE05Q Building C objectBuilding C object 03Q Building C object 0的 Building C object 05Q Building C object 0% Building C objectzli b/CMake Fi1es/zli b.dir/adler32.c.o zlib/CMakeFiles/zlib.dir/compress.c.

45、o zli b/CMake F iles/zli b-dir/crc3乙 o zlib/CMakeFiles/zlib.dir/deflate.c-o zlib/CMakeFiles/zlib* dir/gzio.匚.o zli b/CMakeFiles/zli b.dir/infback,jo7. 安裝 MySQL 執(zhí)行命令：make in stall執(zhí)行結果局部截圖如以下列圖所示rootMySQL-M01 mysql-5.6.19# make install03f| Bu譏七 target 0% Built target 0?d Built target 1刼 Built target 4

46、9£| Built target 7X1 Built target 14% Built target 14% Built target 15% Built target 153g Built target 15% Built target 19% Built target 23% Built target 23% Built target 233Q Built targetINFOJIN INFO_5RC abi.check zlib edit strings mysys dbug mysys_ssl cofnp_e rr GerError myisam myisam.embedde

47、d myisam_ftdurn p myisamchk3. MySQ初始化1. 改變MySQ工作目錄所屬，執(zhí)行命令：chow n -R mysql:mysql /usr/local/mysqlrootMySQL-M01 mysql# chown -R mysql:mysql /usr/local/mysql2. 進入MySQ工作目錄，執(zhí)行命令：cd /usr/local/mysqlrootMySQL-M01 mysql-5.6.19# cd /usr/local/mysql/3. 初始化MySQ數(shù)據(jù)，并指定數(shù)據(jù)文件位置，執(zhí)行命令:./scripts/mysql_i nstall_db -use

48、r=mysql -basedir=/usr/local/mysql/ -datadir=/usr/local/mysql/datarootPMySQL-M&l mysql# ./scrtpts/oysqL_LnstalI_dt> -user=»ys<l -basedir=/usrAocol/iysqL/ da ta d i r=/us r/1 ocal/nv sql/dtit al執(zhí)行結果局部截圖如以下列圖所示rootMySQL-M01 aysqlj* ./scrijJtt/irysql_inEtall_db -user-aysql -basedir>/u&

49、amp;r/local/aysq 1/ -do tadLr/usr/lucuL/mysql/datuion for mare rtetails)r2021-07-30 02：42:0Q 2S626 Nat町 InnoOR: 2021-0Z-30 02:42:09 囲&26 fNotel ItinoOB: 2021 初“為 82； 42;卿 2肺西Nate InnoDB: 7(314-«7-Hots TnnnOR: Z0H W 圖花：42：腫 ZB&Z& Nate InnoDB; 2021 腫 錮尅2:42:溯 28626 NtA町 IrincOB: 2W14

50、如 應：42:的 凸 b比 L Note J IrirwCB: 2021-07-30 02:42:09 28626 NoteJ InnoDS： a new catabuse to be Created>Iristulliny M>SQL systen tdblei. .2021-07-30 ®2:42iM 0 IrttJrriirig TIMESTAMP with LmplLcit DEFALI value is deprecated. Please use -explicit.defaults for_timestamp server option (see dacun

51、entotUirq atomics to rst count huf+er pool poqes The InnoOB me«ory hwp is di sabRdMutexes andi rw locks use CCC otomu bu訂tinsCowprfissftd tnbl ps ljsp 71.ib 1. Z. 3U5wg CPU <rc32 InstructionsInitial izirg buf-fcr poolT su<a - 128-鋼CuiipLctud LriLtmLizatiofi u* txjtfer paaLThe first specif

52、ied <ldta file Vlbdatal did not xistt執(zhí)行成功/usr/(acain/niysoi_s«c u 廣電-installationwhich will also flive you the option of rwvi no the test databases anti anonyinous user created by default. This is strcinglyr recaraiendled for piroduction servers.See the rrtonuai for 電 intructlori.Yau can sta

53、rt triv MySQl daemon wi th:cd 箱 Zus rZlQcalZmiysq L/Tbi tn/raysql d_ so Fe &Yau can test the MySQL dae»on with nysql-teat-run,pIcd Mysql-t$s.t : psrl snysql-t&s-t-run t plPlease report any prot>l«n& ot : Z/bufli% t iiysql, ccxw/The latest in-FoimaitiCin atwiJt MySQL is avail

54、able on th* «elb at :/w#w.mysal-conSupport MySQL txjyi hq sjupport/l lcense& at ：/shop mysqi. cwtNew cie-Faul t 匚 on Fig file was created 口弓 /os r/1 oca I /ray sq I /Zrwy. enf ciricl will be use<J by default by the server when you start it.You may e<llt tnts if Ilia to chcng server se

55、ttings4. 將my-defaultf文件復制到/etc目錄下，并命名為myf，該文件做為MySQL的系統(tǒng)配置文件，執(zhí)行命令:cp support-files/my-defaultf /etc/myfrooteMySQL-MOl mysql# cp support-files/my-default.enf /etc/my f主機(192.168.1.81 )更改/etc/myf 配置，要末尾處添加log-b in=mysql-b inserver-id=81編輯容如以下列圖所示1og-hinmysql-hi n server-id-8 /etc/my + enfh, 35Lt 1.159C wr itten從機01 (192.168.1.84 )更改/etc/myf 配置，要末尾處添加log-b in=mysql-b inserver-