-- ·|­û / µù¥U -- ¡@
¡@±b¸¹¡G
¡@±K½X¡G
¡@ | µù¥U | §Ñ°O±K½X
3/26 ·s®Ñ¨ì¡I 3/19 ·s®Ñ¨ì¡I 3/14 ·s®Ñ¨ì¡I 12/12 ·s®Ñ¨ì¡I
ÁʮѬyµ{¡EQ & A¡E¯¸°È¯d¨¥ª©¡E«ÈªA«H½c
¢x 3ds Max¢x Maya¢x Rhino¢x After Effects¢x SketchUp¢x ZBrush¢x Painter¢x Unity¢x
¢x PhotoShop¢x AutoCad¢x MasterCam¢x SolidWorks¢x Creo¢x UG¢x Revit¢x Nuke¢x
¢x C#¢x C¢x C++¢x Java¢x ¹CÀ¸µ{¦¡¢x Linux¢x ´O¤J¦¡¢x PLC¢x FPGA¢x Matlab¢x
¢x Àb«È¢x ¸ê®Æ®w¢x ·j¯Á¤ÞÀº¢x ¼v¹³³B²z¢x Fluent¢x VR+AR¢x ANSYS¢x ²`«×¾Ç²ß¢x
¢x ³æ´¹¤ù¢x AVR¢x OpenGL¢x Arduino¢x Raspberry Pi¢x ¹q¸ô³]­p¢x Cadence¢x Protel¢x
¢x Hadoop¢x Python¢x Stm32¢x Cortex¢x Labview¢x ¤â¾÷µ{¦¡¢x Android¢x iPhone¢x
¥i¬d®Ñ¦W,§@ªÌ,ISBN,3dwoo®Ñ¸¹
¸Ô²Ó®ÑÄy¤ÀÃþ

MySQL¤ýªÌ®Ê¯Å¤§¸ô

( ²Åé ¦r)
§@ªÌ¡G±iµdÃþ§O¡G1. -> ¸ê®Æ®w -> MySQL
ĶªÌ¡G
¥Xª©ªÀ¡G¹q¤l¤u·~¥Xª©ªÀMySQL¤ýªÌ®Ê¯Å¤§¸ô 3dWoo®Ñ¸¹¡G 48712
¸ß°Ý®ÑÄy½Ð»¡¥X¦¹®Ñ¸¹¡I

¡i¦³®w¦s¡j
NT°â»ù¡G 395 ¤¸

¥Xª©¤é¡G2/1/2018
­¶¼Æ¡G344
¥úºÐ¼Æ¡G0
¯¸ªø±ÀÂË¡G
¦L¨ê¡G¶Â¥Õ¦L¨ê»y¨t¡G ( ²Åé ª© )
¥[¤JÁʪ«¨® ¢x¥[¨ì§Úªº³Ì·R
(½Ð¥ýµn¤J·|­û)
ISBN¡G9787121336799
§@ªÌ§Ç¡@|¡@ĶªÌ§Ç¡@|¡@«e¨¥¡@|¡@¤º®e²¤¶¡@|¡@¥Ø¿ý¡@|¡@§Ç
(²Åé®Ñ¤W©Ò­z¤§¤U¸ü³sµ²¯Ó®É¶O¥\, ®¤¤£¾A¥Î¦b¥xÆW, ­YŪªÌ»Ý­n½Ð¦Û¦æ¹Á¸Õ, ®¤¤£«OÃÒ)
§@ªÌ§Ç¡G

ĶªÌ§Ç¡G

«e¨¥¡G

§ä¨ì¤@¥÷¦X¾Aªº¤u§@¡A´N¹³¦b¤u§@ªº¤K¤p®É¤§¤º¦³¤F¤@­Ó¤ß»öªºÅʤH¡XMySQL¼Æ¾Ú®w´N¬O§Úªº²¢»e·RÅÊ¡C
§Ú¤W¾Ç®É¯S§O¤£·R¾Ç²ß¡A¤]±q¨Ó¨S¦³·Q¹L¡A¤]¤£´±·Q¡A¦³¤@¤Ñ¦Û¤v·|¼g¥»®Ñ¡C§@¬°¤@­Ó¦b¼Æ¾Ú®w»â°ìºNª¦ºu¥´ªñ¤Q¦~ªº¡§¦Ñ¥q¾÷¡¨¡A±q¤@­Ó¤°¤\³£¤£·|ªºµæ³¾¡A°µ¨ì¤½¥qªº°ªºÞ­Ý¸ê²`¼Æ¾Ú®wÁ¿®v¡A§Ú«Ü§Æ±æ§â¦Û¤v³o¨Ç¦~¿n²Ö¤U¨Óªº¹ê¾Ô¸gÅç©M¤@¨Ç¾Ç²ßMySQL¼Æ¾Ú®wªº¤ß±oÅé·|¤À¨Éµ¹¤j®a¡C§Ú«Ü¯à²z¸Ñ¨º¨Ç­è¶i¤J¼Æ¾Ú®w»â°ìªº¦P¾Çªº§x´b¡A¦]¬°¦Û¤v­è¾Ç²ßMySQLªº®É­Ô¡A´N¸òµLÀY»aÃǤ@¼Ë¡A¹J¨ì³ø¿ù¦Z¦bºô¤W¨ì³B§ä¸ê®Æ¡AÃöÁä¬O¬Ý§¹¸ê®Æ¦Z¦³¨Ç°ÝÃD¥i¯àÁÙ¬O¸Ñ¨M¤£¤F¡A¦]¬°¤£ª¾¹D­þºØ³B²z¤èªk¬O¹ïªº¡C·í®É«Ü±Y¼ì¡A¯u¤ß¤£ª¾¹D¸Ó±q­þ¨½¤U¤â¾Ç²ß¤~¦n¡C§O¤HÁÙ¸g±`±ÀÂˤ@¨Ç¹L¤_°¾¦V·§©À©Ê±Ô­zªº¼Æ¾Ú®w®ÑÄy¡A¶V¬Ý¶V·w¡C§Ú·í®É´N·Q¬°¤°¤\«D­n§â¼Æ¾Ú®wªºª¾ÃÑÂI»¡±o³o¤\·Ðº¾¡B²`¶ø¡AÅý§O¤H¬Ý¤£À´¡B²z¸Ñ¤£¤F©O¡H
¼g§@¥»®Ñªº¥Øªº
§Ú¥­±`³ßÅw¼g¤@¨Ç§Þ³N³Õ«È¡A¦b51CTO¤W­±¼g¤F¤@½g¡§«C»É¨ì¤ýªÌ¡A§Ö³t´£°ªMySQL¼Æ¾Ú®w¬q¦ì¡¨ªº¤å³¹¡A³o½g¤å³¹«ü©ú¤FMySQL¼Æ¾Ú®wªº¤@­Ó¾Ç²ß¤è¦V¡A¦ý¨S¦³²`¤J®i¶}Á¿¸Ñ¨½­±ªº®Ö¤ßª¾ÃÑÂI¡C¦³ÅªªÌµo¨p«H©M¯d¨¥»¡¡A¯à¤£¯à§ó¨ãÅé¦a®i¶}Á¿¸Ñ©O¡C©Ò¥H§Ú¨M©w§â¨½­±©Ò¦³®Ö¤ßªº§Þ³N¤z³f¼g¦¨®Ñ¡A²@µL«O¯d¦a¤À¨Éµ¹¤j®a¡C§Æ±æ¥»®Ñ¹ï¤j®a¦b¥Í²£¤¤¹ê½îMySQL®É¦³À°§U¡A¥i¥HÅý¦³¤@©w°ò¦ªº¡B¦³¤u§@¸gÅ窺¹Bºû¤H­û©MDBA§ó¥[²`¤J¦a¤F¸ÑMySQL¡A¨Ï¥Î©MºûÅ@°_¨Ó§ó¥[±o¤ßÀ³¤â¡A§ó§Æ±æ¥i¥HÅý­è½ñ¤J¼Æ¾Ú®w»â°ìªºÅªªÌ§Ö³t´x´¤MySQL¼Æ¾Ú®wªº®Ö¤ßª¾ÃÑÅé¨t¡Aµ¹¨º¨Ç·Q¾Ç²ßMySQL¼Æ¾Ú®wªº¤JªùªÌ«ü©ú¤@­Ó¥¿½T¤è¦V¡A¤Ö¨«¤@¨ÇÅs¸ô¡CÅý§Ú­Ì¤@°_´ÂµÛ§Þ³N»â°ìª÷¦r¶ðªº¶ð¦y¤j¨B«e¦æ¡C
¦p¦ó¾\Ū¥»®Ñ
¥»®Ñ¦bª¾Ãѵ²ºc¤W¤À¬°7³¡¤À¡C
²Ä1³¡¤À¡@­Ï±j«C»É½g¡]²Ä1¡ã8³¹¡^¡C¥]¬AMySQL²¤¶¡B¥D¬y¤À¤äª©¥»¡B¼Æ¾Ú®w¦w¸Ë/±Ò°Ê/Ãö³¬¡BÅv­­ºÞ²z¡BMySQL¼Æ¾Ú®wªº¤º¦s¦Àµ²ºc¡B¦sÀx¤ÞÀº¡B½uµ{§@¥Î¡B¨ê·s¾÷¨î¡B¼Æ¾Ú®w¤å¥ó¡BªíºÞ²z¡B¦r²Å¶°¡B²Î­p«H®§»P¼Æ¾Ú¸H¤ù¾ã²zªº¤èªk¡CÁÙ¥]¬A¹ï¯Á¤Þªº¸Ô²Ó¸ÑŪ¡A°õ¦æ­p¹ºªº¤ÀªR¡BÀ£¤O´ú¸Õªº®i²{¡B¨Æ°Èªº¤¶²Ð¡A¥H¤Î¹ï¹jÂ÷¯Å§Oªº²`«×Á¿¸Ñ¡A¦}µ²¦XÂê¤@°_®i¶}¾Ç²ß¡C
²Ä2³¡¤À¡@¯´§Ç¥Õ»È½g¡]²Ä9³¹¡^¡C¤¶²Ð¥Í²£Àô¹Ò¤¤±`¥Îªº³Æ¥÷¤èªk¡BÅÞ¿è³Æ¥÷©M»r¤å¥ó³Æ¥÷¡C°w¹ïmysqldump¡Bselect¡Kinto outfile¡Bmydumper©Mxtrabackupµ¥³Æ¥÷«ì´_¤u¨ãªº­ì²z®i¶}¸Ô¸Ñ¤Î¹ê½îºt½m¡C
²Ä3³¡¤À¡@ºaÄ£¶Àª÷½g¡]²Ä10¡ã11³¹¡^¡C¤¶²Ð¥D±q´_¨îªº­ì²z¡A¹ï´_¨î°Ñ¼Æ¶i¦æ¸Ô²ÓÁ¿¸Ñ¡A¹ï¥b¦P¨B´_¨î¡B¦h·½´_¨î¡BGTID´_¨î¶i¦æ¥þ­±¸ÑŪ»P¹ê½î¡A¹ï´_¨î¼Æ¾Ú¤@­P©Êªº®ÕÅç©M´_¨îºÞ²z§Þ¥©¶i¦æ¤¶²Ð¡A¦}¸ÑŪ¥D±q´_¨î¤¤ªº¦UºØ³ø¿ù¬G»Ù¡C
²Ä4³¡¤À¡@´L¶Q¹`ª÷½g¡]²Ä12¡ã15³¹¡^¡C¤¶²Ð¤¬Ápºô¥D¬yªºMySQL°ª¥i¥Î¶°¸s¬[ºc¡A¹ïMHA¡BKeepalived¡BPXC­ì²zªº¸ÑªR¡BºûÅ@ºÞ²z»P¹ê½î¡A³Ì¦Z¤¶²ÐProxySQL³o­Ó±j¤jªºMySQL¤¤¶¡¥N²z¼hªºÀ³¥Î¡C
²Ä5³¡¤À¡@¥ÃùÚ๥۽g¡]²Ä16¡ã17³¹¡^¡C¤¶²ÐMySQL 5.7ª©¥»ªº·s¯S©Ê¡A¥H¤Î³q¹Lµw¥ó¡B¾Þ§@¨t²Î¡B¼Æ¾Ú®w¡Bµ{§Ç³]­p³o¥|­Óºû«×¨Ó¥þ­±¤¶²ÐMySQL¼Æ¾Ú®wªºÀu¤Æ¡C
²Ä6³¡¤À¡@¦Ü´L¬PÄ£½g¡]²Ä18¡ã19³¹¡^¡C¾Ç²ß³¡¸pLepus¡AºÊ±±MySQL»Pª©¥»¤É¯Å¡C
²Ä7³¡¤À¡@³Ì±j¤ýªÌ½g ²Ä20³¹¡CMySQL­±¸ÕÁ`µ²¡C
­PÁÂ
¦b§Ú±q¨Æ¼Æ¾Ú®w¤u§@ªñ¤Q¦~ªº¹D¸ô¤W¡A§Ú­n·PÁ¨º¨Ç´¿¸gÀ°§U¹L§Úªº«e½ú­Ì¡A·í§Ú¹J¨ì§xÃø·Q­n©ñ±ó³o­Ó¦æ·~®É¡A¬O§A­Ì­@¤ßªº¶}¾É»P«ü¤Þ¡A¤~¨Ï§Ú¨S¦³¥¢¥h¤è¦V¡A¤@ª½°í«ù¨ì¤µ¤Ñ¡C§Ú¤]­n·PÁÂ51CTO³o­Ó¥­»O¡AÅý§Ú¥i¥H§â¦Û¤v¤u§@¤¤ªº¸gÅç¤À¨Éµ¹¤j®a¡A·PÁÂ51CTOªº¹BÀç¸g²z°ª¶§¡A¤£¹½¨ä·Ð¦aÀ°§Ú¾ã²z³Õ«È¤¤ªº¤@¨Ç¯À§÷¡A¤~¯àÅý§Úªº¤å³¹¥H«Ü¦nªº¤è¦¡§e²{µ¹¤j®a¡C³Ì¦ZÁÙ­n·PÁ¹q¤l¤u·~¥Xª©ªÀªº³¯¾å²r½s¿è¡A·PÁ§Aªº¿W¨ã¼z²´©M¹ï§ÚµL±ø¥óªº¤ä«ù»P¹ªÀy¡AÅý§Ú¥i¥H«D±`¶¶§Q¦a§¹¦¨¼g§@¡C
§Þ³NµL°ê¬É¡AÅý§Ú­Ì¤@°_¼ö·R§Þ³N¡B¤À¨Éª¾ÃÑ¡A¥´³y¥XÄݤ_¦Û¤vªº¤@¤ù¼sÁï¤ÑªÅ¡C¦¹®ÑÄmµ¹©Ò¦³³ßÅw§Þ³NªºªB¤Í­Ì¡I
Áp¨t¤è¦¡
Åwªï¤j®a»P§Ú¤¬°Ê¡C
±iµd
¤º®e²¤¶¡G

¥Ø«e¤j³¡¤À³n¥ó¶}µo¥­»O³£°ò¤_Linux¡A«Ü¦h¤¬Ápºô¤½¥q³£§âMySQL§@¬°¦ZºÝ¼Æ¾Ú¦sÀxªº¼Æ¾Ú®w¡C¦pªG§âMySQL¤ñ³ë¦¨¼Æ¾Ú®w¬Éªº¤@±ø¥¨Às¡A«h¥»®Ñ²[»\ªº©Ò¦³ª¾ÃÑÂI´N¬O³o±ø¥¨Àsªº²Õ¦¨³¡¤À¡C¥»®Ñ²`¤J­åªRMySQL¼Æ¾Ú®wÅé¨tµ²ºc¡A¹ê¾Ôºt½m³Æ¥÷«ì´_¡B¥D±q´_¨î¡A¸Ô¸Ñ°ª¥i¥Î¶°¸s¬[ºcªº³]­p»P¹ê½î¹Lµ{¡A¸Ô²Ó®Þ²zÀu¤Æ«ä¸ô¡A®i²{·sª©¥»ªº¯S©Ê¡A¦}»P¯u¹ê¥Í²£®×¨Ò¬Ûµ²¦X¡A³q¹L®Ö¤ß­ì²z¨ì¡§¤ýªÌ¡¨¹ê¾Ô¡A¥þ­±Âл\MySQL¼Æ¾Ú®wªºª¾ÃÑÂI¡C

¥Ø¿ý¡G

²Ä1³¡¤À¡@­Ï±j«C»É½g
²Ä1³¹¡@MySQL²¤¶»P¥D¬y¤À¤äª©¥»
1.1¡@MySQL²¤¶
1.2¡@MySQL¥D¬yªº¤À¤äª©¥»
1.2.1¡@©x¤èª©¥»ªºMySQL
1.2.2¡@Percona Server
1.2.3¡@MariaDB
²Ä2³¹¡@MySQL¼Æ¾Ú®wªº¦w¸Ë¡B±Ò°Ê©MÃö³¬
2.1¡@¤U¸üMySQL¤G¶i¨î³n¥ó¥]
2.2¡@¦w¸Ë«e¨t²ÎÀô¹ÒÀË´ú
2.3¡@MySQL 5.6ª©¥»ªº¦w¸Ë¹Lµ{
2.4¡@³Ð«Ø±K½X
2.5¡@Ãö³¬MySQL¼Æ¾Ú®w
2.6¡@°ò¦¼Æ¾Ú®wªº¦WºÙ
2.7¡@MySQL 5.7ª©¥»ªº¦w¸Ë
2.8¡@MySQL¼Æ¾Ú®wroot±K½X¥á¥¢ªº°ÝÃD
2.9¡@MySQL¼Æ¾Ú®wªº³s±µ¤è¦¡
2.10¡@¥Î¤áÅv­­ºÞ²z
²Ä3³¹¡@MySQLÅé¨tµ²ºc»P¦sÀx¤ÞÀº
3.1¡@MySQLÅé¨tµ²ºc
3.2¡@Query Cache¸Ô¸Ñ
3.3¡@¦sÀx¤ÞÀº
3.4¡@InnoDBÅé¨tµ²ºc
3.4.1¡@¼Æ¾Ú®w©M¼Æ¾Ú®w¹ê¨Ò
3.4.2¡@InnoDB¦sÀxµ²ºc
3.4.3¡@¤º¦sµ²ºc
3.4.4¡@Bufferª¬ºA¤Î¨äÃìªíµ²ºc
3.4.5¡@¦U¤j¨ê·s½uµ{¤Î¨ä§@¥Î
3.4.6¡@¤º¦s¨ê·s¾÷¨î
3.4.7¡@InnoDBªº¤T¤j¯S©Ê
²Ä4³¹¡@¼Æ¾Ú®w¤å¥ó
4.1¡@°Ñ¼Æ¤å¥ó
4.2¡@°Ñ¼ÆÃþ«¬
4.3¡@¿ù»~¤é§Ó¤å¥ó¡]error log¡^
4.4¡@¤G¶i¨î¤é§Ó¤å¥ó¡]binary log¡^
4.5¡@ºC¬d¸ß¤é§Ó¡]slow log¡^
4.6¡@¥þ¶q¤é§Ó¡]general log¡^
4.7¡@¼f­p¤é§Ó¡]audit log¡^
4.8¡@¤¤Ä~¤é§Ó¡]relay log¡^
4.9¡@Pid¤å¥ó
4.10¡@Socket¤å¥ó
4.11¡@ªíµ²ºc¤å¥ó
4.12¡@InnoDB¦sÀx¤ÞÀº¤å¥ó
²Ä5³¹¡@ªí
5.1¡@¾ã«¬
5.2¡@¯BÂI«¬
5.3¡@®É¶¡Ãþ«¬
5.4¡@¦r²Å¦êÃþ«¬
5.5¡@¦r²Å¶°
5.6¡@ªí¸H¤ù²£¥Íªº­ì¦]
5.7¡@¸H¤ù­pºâ¤èªk¤Î¾ã²z¹Lµ{
5.8¡@ªí²Î­p«H®§
5.9¡@²Î­p«H®§ªº¦¬¶°¤èªk
5.10¡@MySQL®wªí±`¥Î©R¥OÁ`µ²
²Ä6³¹¡@¯Á¤Þ
6.1¡@¤G¤e¾ðµ²ºc
6.2¡@¥­¿Å¤G¤e¾ðµ²ºc
6.3¡@B-treeµ²ºc
6.4¡@B+tree
6.4.1¡@»E¶°¯Á¤Þ©M´¶³q¯Á¤Þ
6.4.2¡@ICP¡BMRR©MBKA
6.4.3¡@¥DÁä¯Á¤Þ©M°ß¤@¯Á¤Þ
6.4.4¡@Âл\¯Á¤Þ
6.4.5¡@«eºó¯Á¤Þ
6.4.6¡@Áp¦X¯Á¤Þ
6.5¡@«¢§Æ¯Á¤Þ
6.6¡@¯Á¤ÞªºÁ`µ²
²Ä7³¹¡@¨Æ°È
7.1¡@¨Æ°Èªº¯S©Ê
7.2¡@¨Æ°È»y¥y
7.3¡@truncate©Mdeleteªº°Ï§O
7.4¡@¨Æ°Èªº¹jÂ÷¯Å§O
7.5¡@²Ó»¡Å¦Åª¡B¤£¥i­«´_Ū¡B¤ÛŪ¡B¥i­«´_Ū²{¶H
7.5.1¡@ŦŪ
7.5.2¡@¤£¥i­«´_Ū»P¤ÛŪ
7.5.3¡@¥i­«´_Ū
²Ä8³¹¡@Âê
8.1¡@InnoDBªºÂêÃþ«¬
8.1.1¡@ŪÂê
8.1.2¡@¼gÂê
8.1.3¡@MDLÂê
8.1.4¡@·N¦VÂê
8.2¡@InnoDB¦æÂêºØÃþ
8.2.1¡@³æ­Ó¦æ°O¿ýªºÂê
8.2.2¡@¶¡»ØÂê¡]GAP lock¡^
8.2.3¡@Next-key Locks
8.3¡@Âêµ¥«Ý©M¦ºÂê
8.4¡@Âê°ÝÃDªººÊ±±

²Ä2³¡¤À¡@¯´§Ç¥Õ»È½g
²Ä9³¹¡@³Æ¥÷«ì´_
9.1¡@MySQLªº³Æ¥÷¤è¦¡
9.2¡@§N³Æ¤Î«ì´_
9.3¡@¼ö³Æ¤Î«ì´_
9.3.1¡@mysqldumpªº³Æ¥÷»P«ì´_
9.3.2¡@select ¡Kinto outfile
9.3.3¡@load data»Pinsertªº´¡¤J³t«×¹ï¤ñ
9.3.4¡@mydumper
9.3.5¡@»r¤å¥ó³Æ¥÷XtraBackup
9.4¡@¬y¦¡¤Æ³Æ¥÷
9.4.1¡@«DÀ£ÁY¼Ò¦¡ªº³Æ¥÷
9.4.2¡@À£ÁY¼Ò¦¡ªº³Æ¥÷
9.4.3¡@»·µ{³Æ¥÷
9.5¡@ªíªÅ¶¡¶Ç¿é
9.6¡@§Q¥Îbinlog2sql¶i¦æ°{¦^
9.7¡@binlog server
9.8¡@Á`µ²

²Ä3³¡¤À¡@ºaÄ£¶Àª÷½g
²Ä10³¹¡@¥D±q´_¨î·§­z
10.1¡@±`¨£ªº´XºØ¥D±q¬[ºc¼Ò¦¡¹Ï
10.2¡@¥D±q´_¨î¥\¯à
10.3¡@¥D±q´_¨î­ì²z
10.4¡@´_¨î¤¤ªº­«ÂI°Ñ¼Æ¸Ô¸Ñ
²Ä11³¹¡@´_¨î­ì²z¤Î¹ê¾Ôºt½m
11.1¡@²§¨B´_¨î
11.2¡@¥D±q´_¨î¬G»Ù³B²z
11.3¡@¥b¦P¨B´_¨î
11.4¡@¥b¦P¨B´_¨î©M²§¨B´_¨î¼Ò¦¡ªº¤Á´«
11.5¡@GTID ´_¨î
11.5.1¡@GTID­ì²z¤¶²Ð
11.5.2¡@GTID¦s¦bªº»ù­È
11.5.3¡@¥D±q´_¨î¤¤GTIDªººÞ²z»PºûÅ@
11.5.4¡@GTID´_¨î»P¶Ç²Î´_¨îªº¤Á´«
11.5.5¡@GTID¨Ï¥Î¤¤ªº­­¨î±ø¥ó
11.6¡@¦h·½´_¨î
11.7¡@¥D±q©µ¿ðªº¸Ñ¨M¤è®×¤Î¦}¦æ´_¨î
11.8¡@¥D±q´_¨îªº¼Æ¾Ú®ÕÅç
11.9¡@Á`µ²

²Ä4³¡¤À¡@´L¶Q¹`ª÷½g
²Ä12³¹¡@MHA
12.1¡@MHA²¤¶
12.1.1¡@MHA³¡¸p
12.1.2¡@MHA­ì²z
12.1.3¡@MHAªºÀu¯ÊÂI
12.1.4¡@MHA¤u¨ã¥]ªº¥\¯à
12.2¡@¹ê¾Ôºt½m
²Ä13³¹¡@Keepalived+Âù¥D¬[ºc
13.1¡@Keepalived¤¶²Ð
13.2¡@¶°¸s·f«Ø«ä¸ô¤Î«Øij
13.3¡@¹êÅ糡¸pºt½m
²Ä14³¹¡@PXC
14.1¡@PXC­ì²z
14.2¡@PXC¬[ºcªºÀu¯ÊÂI
14.3¡@PXC¤¤­«­n·§©À©M­«ÂI°Ñ¼Æ
14.4¡@PXC¬[ºc·f«Ø¹ê¾Ô
14.5¡@PXC¶°¸sª¬ºAªººÊ±±
14.6¡@±q¸`ÂI¦b½uÂà¤Æ¬°PXC¸`ÂI
²Ä15³¹¡@ProxySQL
15.1¡@ProxySQLªº¦w¸Ë»P±Ò°Ê
15.2¡@°t¸mProxySQLºÊ±±
15.3¡@ProxySQLªº¦h¼h°t¸m¨t²Î
15.4¡@°t¸mProxySQL¥D±q¤À²Õ«H®§
15.5¡@°t¸mŪ¼g¤ÀÂ÷µ¦²¤
15.6¡@´ú¸ÕŪ¼g¤ÀÂ÷
15.7¡@Á`µ²

²Ä5³¡¤À¡@¥ÃùÚ๥۽g
²Ä16³¹¡@MySQL 5.7·s¯S©Ê
16.1¡@InnoDB¦sÀx¤ÞÀºªº¼W±j
16.2¡@¨ä¥L¤è­±ªº¼W±j
²Ä17³¹¡@MySQL¥þ­±Àu¤Æ
17.1¡@µw¥óÀu¤Æ
17.2¡@°t¸m°Ñ¼ÆÀu¤Æ
17.3¡@±qLinux¾Þ§@¨t²Î¼h­±¨Ó½Í¹ïMySQLªºÀu¤Æ
17.4¡@ªí³]­p¤Î¨ä¥LÀu¤Æ
17.5¡@¾ãÅéºÞ²zÀu¤ÆÁ`µ²

²Ä6³¡¤À¡@¦Ü´L¬PÄ£½g
²Ä18³¹¡@Lepus¤§MySQLºÊ±±
18.1¡@Lepus²¤¶
18.2¡@¹ê¾Ô³¡¸p
18.3¡@ºÊ±±MySQLªA°È¾¹
18.4¡@³¡¸pLepusºC¬d¸ß¤ÀªR¥­»O¹ê¾Ô
18.5¡@ºÊ±±Á`µ²
²Ä19³¹¡@MySQLª©¥»¤É¯Å
19.1¡@¤É¯Å¤è¦¡
19.2¡@¹ê¾Ôºt½m

²Ä7³¡¤À¡@³Ì±j¤ýªÌ½g
²Ä20³¹¡@MySQL­±¸ÕÄ_¨å
20.1¡@¦Û§Ú¤¶²Ð
20.2¡@§Þ³N°Ýµª
§Ç¡G