MySQL-部署练习-主从部署

1、MySQL 5619 基于 RHEL6.4主从模式部署手册菜2021年8月文档版本时间作者容版本2021-08菜创立Linux平台下 MySQL5.6.19 主从安装文档手册1.0目录In stall MySQL 5.6.19 on Linuxl文档版本2一、文档简介3二、安装须知31. 操作系统版本32. 磁盘情况43. 网络情况44. YUM源 65. 防火墙6三、cmake版本8四、MySQ安装部署111. 部署方式112. 部署步骤113. MySQL初始化15Install MySQL 5.6.19 on Linux一、文档简介本文档仅用于学习交流 MySQ主从部署相关技术，非商业性

2、文档。该文档容是关于Linux平台下MySQ源码包安装方法、步骤与相关须知等容, 适用于研发人员、运维与现场实施人员参考。请全文通读后，再进行MySQ安装的相关操作，如安装过程中遇到错误，请 先解决错误后，再按顺序进行安装。二、安装须知在MySQl安装前，请先以root用户登录操作系统，并确认效劳器的网络、磁盘、 防火墙、YUM®等信息，以便于顺利的开展安装 MySQ的工作。本次部署为MySQ主从形式，需要在三台效劳器上分别进行部署配置。本例如采 用两台虚拟机进行部署练习，主从机信息详见下表：MasterSlave01Slave02IPID8184851. 操作系统版本演示安装的操作

3、系统版本：Red Hat En terprise Li nux Server release 6.4 (Sa ntiago)查看操作系统版本命令： lsb_release - a 或 cat /etc/system-releaseLsb_release - a执行结果如以下列图所示：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执行结果如以下列图所示rootMySQL-W01 cat /etc/system-releaseped Hat Ent皂rpi.sm Linux 5Ervm rmlaciSQ

5、 6.孙(Eamticigo) |2. 磁盘情况查看磁盘使用要，MySQ需要至少2G的磁盘空间，假设有数据需要写入，请按 实际业务量划分存储。硬盘使用情况查看命令：df - hdf - h执行结果如以下列图所示: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 执行结果如以下列图所示，本机的IP地址为192.168.1.81, Mask : rootWySQL-M01 -防 ifconfigethl LinK encap:tthernetHWaddr W):|in驻 addr：】92.1创丄81 Bs航：四2.丄阴.12巧 M貯K：卫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駝卫 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通，为后续部署做准备。执行命令ping 192.168.1.81、ping 192.16

9、8.1.84 和执行结果如以下列图所示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信息，执行命令：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执行结果显示/rhel6.4.iso 挂载在/mnt目录下，即该源有效CrootlySQL-WOl 巧# df -hFilesystemSizeUsedAvailUseSK Mounted onZdev/sdu313G8.863.3G7336 /tmips495M0495M0% /dev/shm/dpv/sda11Q4M1砒 /hont3.5G3.5G010096 /mnt5.

14、 防火墙查看防火墙(iptables)状态，防止因防火墙策略问题导致远程无法本地MySQL 情况，本次部署中，、192.168.1.84 和 192.168.1.85 效劳器全 部选择关闭防火墙。查看防火墙壮态命令/etc/init.d/iptables status执行结果显示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执行结果如以下列图所示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 再次执行 /etc/init.d/iptables status执行结果显示防火墙当前已关闭。go媲y5QL-M0j.

17、三I# /点/in匕 d/ipp叽es status Lptables: Firewall is not: running.为了防止防火墙开机自启动，执行命令chkc onfig iptables -list执行结果显示防火墙为开机启动rootMySQL-M01 T# chkconfig iptables -listiptables0:off l：off 2: on 3:on 4ion5: on6: off关闭防火墙开机启动命令chkconfig iptables off ，如执行正确没有信息反再次查看检查防火墙开机启动状态，执行命令chkconfig iptables - list执行结果显

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，执行命令：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 文件夹，执行 以下列图为文件夹中容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相关依赖包，执行命令:yum -y in stall n curses n curses-devel ope nssl-devel bis on gcc gcc-c+ make4.在 cmake-2.8.12.2 文件夹中，执行./bootstrap 命令 执行结果局部截图如以下列图所示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源码，执行命令：make执行结果局部截图如以下列图所示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 战 異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 执行命令：make in stall执行结果局部截图如以下列图所示IL Toothy SQL - M01 onake-2.S

33、.muke mstdlLC 2幻 据 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版本，执行命令： cmake - version执行结果显示，cmake安装成功rootMySQL-M01 cmake-Z.8,12*2# cmake -version8. 数据库版本四、MySQL安装部署1. 部署方式本次MySQ采用主从部署方式2. 部署步骤1. 创立 mysql 组，执行命令：groupadd mysqlrootMySQL-W01 cmake-2.8.12.2# g

36、roupadd mysql2. 创立mysql用户，并参加到mysql组中，执行命令: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 压缩包，执行命令：4. 进入 mysql-5.6.19 文件夹，执行命令：r oo t e>My SQL * M01 data# cd mysql-5.6-195. 通过cmake工具来编译MySQL源码，在编译项中添加相关参数。

37、MySQ安装路径为/usr/local/mysql ，数据文件路径为/usr/local/mysql/data ，监听端 口为3306,字符集为utf8等。执行命令：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执行命令示如以下列图所示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|执行结果局部截图如以下列图所示: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源码，执行命令：make执行结果局部截图如以下列图所示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 执行命令：make in stall执行结果局部截图如以下列图所示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工作目录所属，执行命令：chow n -R mysql:mysql /usr/local/mysqlrootMySQL-M01 mysql# chown -R mysql:mysql /usr/local/mysql2. 进入MySQ工作目录，执行命令：cd /usr/local/mysqlrootMySQL-M01 mysql-5.6.19# cd /usr/local/mysql/3. 初始化MySQ数据，并指定数据文件位置，执行命令:./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执行结果局部截图如以下列图所示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执行成功/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的系统配置文件，执行命令: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-