1. Art Of MySQL Replicaton ã 10 å¹´ã®æ´å²ãèªãã¬ããªã±ã¼ã·ã§ã³ã®å¦æã 奥é å¹¹ä¹ @nippondanji mikiya (dot) okuno (at) gmail (dot) com 2. å 責äºé â æ¬ãã¬ã¼ã³ãã¼ã·ã§ã³ã«ããã¦ç¤ºããã¦ããè¦è§£ã¯ã ç§èªèº«ã®è¦è§£ã§ãã£ã¦ããªã©ã¯ã«ã»ã³ã¼ãã¬ã¼ã·ã§ã³ ã®è¦è§£ãå¿ ãããåæ ãããã®ã§ã¯ããã¾ããããäº æ¿ãã ããã 3. èªå·±ç´¹ä» â ä»æ¥ã¯å人ã¨ãã¦æ¥ã¦ãã¾ãã â http://nippondanji.blogspot.com/ â Twitter: @nippondanji â ç¾è·ã¯ MySQL ãµãã¼ãã¨ã³ã¸ãã¢ã â 2000 å¹´ã«ãµã³ã»ãã¤ã¯ãã·ã¹ãã ãºå ¥ç¤¾ â 2007 å¹´ã« MySQL KK ã¸è»¢è· â æ°ä»ãã¨ã¾ããµã³ã»ãã¤ã¯ãã·ã¹ãã ãºã«ã»ã»ã» â ç¾å¨ã¯æ¥æ¬ãªã©ã¯ã«ã«å¨å¸ã â
MySQL ã¬ããªã±ã¼ã·ã§ã³ã®è¨å® æä¾ï¼maruko2 Note. 移åï¼ æ¡å , æ¤ç´¢ ç®æ¬¡ 1 MySQL ã¬ããªã±ã¼ã·ã§ã³ã®ç¹å¾´ 2 MySQL ã¬ããªã±ã¼ã·ã§ã³ã®åä½æ¦è¦ 3 ã¬ããªã±ã¼ã·ã§ã³ã®ã»ããã¢ãã 3.1 ã¬ããªã±ã¼ã·ã§ã³ç¨ã® my.cnf è¨å® 3.2 ãã¹ã¿ã¼ã«ã¬ããªã±ã¼ã·ã§ã³å°ç¨ã®ã¦ã¼ã¶ã¼ãç»é²ãã 3.3 ãã¹ã¿ã¼ãµã¼ãã®ã¹ãããã·ã§ãããä½æãã 3.4 ãã¹ã¿ã¼ãµã¼ãã®ã¹ãããã·ã§ãããå ã«ãã¹ã¬ã¼ããä½æãã 4 ã¬ããªã±ã¼ã·ã§ã³ãæ£å¸¸ã«è¡ããã¦ããã確èªããæ¹æ³ 5 ãã¹ã¿ã¼ã®ãã¤ããªãã°ã®åé¤ 6 åèãã¼ã¸ 7 MySQL é¢é£ã®ãã¼ã¸ MySQL ã¬ããªã±ã¼ã·ã§ã³ã®ç¹å¾´ MySQL ã®ã¬ããªã±ã¼ã·ã§ã³ã¯éåæã 1ã¤ã®ãã¹ã¿ã¼ã«å¯¾ãã¦ã1ã¤ä»¥ä¸ã®ã¹ã¬ã¼ããå¯è½ã æ´æ°ç³»ã®ã¯ã¨ãªã¯ãã¹ã¿ã¼ã®ã¿ã§å®è¡ããªããã°ãªãããæ´æ°ç³»ã¯ã¨ãªãã¹ã¬ã¼ãã§å®è¡ããã¨
1.2 ã¬ããªã±ã¼ã·ã§ã³ã®åä½ã¬ããªã±ã¼ã·ã§ã³ã§ã¯æåã«DBã®å 容ãåæãããå¾ãMasterãµã¼ãã¼ã§å®è¡ãããæ´æ°ç³»ã®ã¯ã¨ãª(UPDATEã¨ã)ãSlaveã«æ¸¡ãã¦Slaveã§ãåãã¯ã¨ãªãå®è¡ãã¦ãããã¨ã§ãDBãåæããã¦ãã(å³1)ã Masterå´ã§å®è¡ãããæ´æ°ç³»ã¯ã¨ãªã¯ãã¤ããªãã°ã«èãããã¦ãããSlaveå´ãæ¥ç¶ãã¦ããããååã®æ¥ç¶ããã®å¤æ´åãSlaveå´ã«éä¿¡ãããSlaveå´ã¯åãåã£ãã¯ã¨ãªãä¸æ¦ãªã¬ã¼ãã°ã«èãã¦é 次ã¯ã¨ãªãå®è¡ãã¦DBãåæããã¦ããããªããªã±ã¼ã·ã§ã³åä½ã«ã¯BinlogDump,I/O,SQLã®3ã¤ã®ã¹ã¬ãããé£æºãã¦åä½ããã 2.è¨å®æé (Master-Slaveæ§æ) 2.1 Masterå´ã®è¨å®ã®ç¢ºèªMasterå´ã§ã¯ãã¤ããªãã°ãæ¡åãã¦ããå¿ è¦ãããã®ã§ãMasterå´ã®my.cnfã«log-binã®è¨å®ãå ¥ã£ã¦ãããã¨ã確
ã½ã¼ã¹ã§ããã¤ããªãã®ã³ã°ãæå¹ã«ãªã£ã¦ãããã¨ã確èªããä¸æã®ãµã¼ãã¼ ID ãæ§æããå¿ è¦ãããã¾ãã ããã«ã¯ããµã¼ãã¼ã®åèµ·åãå¿ è¦ã¨ãªãå ´åãããã¾ãã ã»ã¯ã·ã§ã³17.1.2.1ãã¬ããªã±ã¼ã·ã§ã³ã½ã¼ã¹æ§æã®è¨å®ããåç §ãã¦ãã ããã ã½ã¼ã¹ã«æ¥ç¶ããåã¬ããªã«ã§ãä¸æã®ãµã¼ãã¼ ID ãæ§æããå¿ è¦ãããã¾ãã ããã«ã¯ããµã¼ãã¼ã®åèµ·åãå¿ è¦ã¨ãªãå ´åãããã¾ãã ã»ã¯ã·ã§ã³17.1.2.2ãã¬ããªã«æ§æã®è¨å®ããåç §ãã¦ãã ããã å¿ è¦ã«å¿ãã¦ãã¬ããªã±ã¼ã·ã§ã³ç¨ã®ãã¤ããªãã°ãèªã¿åãã¨ãã«ãã½ã¼ã¹ã¨ã®èªè¨¼ä¸ã«ã¬ããªã«ã§ä½¿ç¨ããå¥ã®ã¦ã¼ã¶ã¼ãä½æãã¾ãã ã»ã¯ã·ã§ã³17.1.2.3ãã¬ããªã±ã¼ã·ã§ã³ç¨ã¦ã¼ã¶ã¼ã®ä½æããåç §ãã¦ãã ããã ãã¼ã¿ã¹ãããã·ã§ãããä½æããããã¬ããªã±ã¼ã·ã§ã³ããã»ã¹ãéå§ãããããåã«ãã½ã¼ã¹ã§ç¾å¨ã®ä½ç½®ããã¤ããªãã°ã«è¨é²ããããã«ãã¦
I'm happy to announce that MHA for MySQL (Master High Availability Manager and tools for MySQL) version 0.52 has been released. Downloads are available here. This is a stable release. I have been using MHA on our(DeNA's) cross-datacenter environments. We had tens of failover opportunities and MHA worked successfully in all cases. Here are release notes. * multi-master configuration is supported Se
ãææ§ã«é ¼ããããªãã²ã¼ã è¨è¨ã¨ããã®ãå¿ããã¦ããããä¼ç»ã»éçºã¯ãã¡ããã®ãã¨ãåæãäºæ¥æ¦ç¥ã¾ã§æãåºãã¤ã¤ãã£ã¦ããããªã©ãããã¾ã§ã®ã²ã¼ã ä½ãã®æ¹æ³è«ãè¦ãã¨ããå¶ä½ä½å¶ãã¨ã£ã¦ããGREEãå½¼ãã¯ã©ã®ããã«ãã¦æ°ã ã®ãããã»ã¼ã«ã¹ãèªããããã¯ããä½ãä¸ãã¦ããã®ã§ããããï¼ æ¥æ¬æ大ã®ã²ã¼ã éçºè åãã«ã³ãã¡ã¬ã³ã¹ãCEDEC2011ãã«ã¦ãããã¾ã§ã®ã²ã¼ã æ©æ¥çã§ã®ææ³ã¨ã®å¯¾æ¯ã交ããªããGREEããã»ã¼ã«ã¹ã©ã³ãã³ã°No.1ãããã¯ãã®ä½ãæ¹ãã¨ããã¿ã¤ãã«ã§ãã½ã¼ã·ã£ã«ã²ã¼ã ã®æªæ¥ã¸ã®å±æã«ã¤ãã¦è¬æ¼ãè¡ãã¾ããã è¬å¸«ã¯éå»ã«ããã³ãããã·ã§ã³ã·ãªã¼ãºãFFã·ãªã¼ãºãªã©ãæãããä»å¹´ã¹ã¯ã¦ã§ã¢ã»ã¨ããã¯ã¹ãé社ãã¦GREEã«å ¥ç¤¾ããåç°ä¿éæ°ãããã¦ã½ã¼ã·ã£ã«ã²ã¼ã åæã®åä½ãé£ãâ ã¹ã¿ãã®ãããã¯ãããã¼ã¸ã£ã¼ãåªãã岸ç°å´å¿æ°ã®ä¸¡åã§ãããã¡ãã®æ¿å¯ãªè¬æ¼ã®å ¨å 容
â»ããã¯ãã·ã¹ãã ã¨ã³ã¸ãã¢ã®Namikawaãããåªç§è³ãåè³ãã第6åç 究課é¡ã¬ãã¼ã(2011å¹´3ææåº)ããã®æç²ã§ãã ã¯ãã㫠大æãããªãã¯ã¯ã©ã¦ããµã¼ãã¹ã®1ã¤ã«Amazon Web ServicesããããAmazon Web Servicesã¯ãä»®æ³ãµã¼ãã1æéåä½èª²éã®å¾éå¶ã§å©ç¨ã§ããAmazon EC2ããé«ä¿¡é ¼æ§ã®ãªã³ã©ã¤ã³ã¹ãã¬ã¼ã¸ã1GBåä½ããã®å¾éå¶èª²éã§å©ç¨ã§ããAmazon S3ãªã©ãä¸å¿ã¨ãããIaaS(Infrastructure as a Service)ã®ä»£è¡¨æ ¼ã§ããã ç¾å¨ãå®æçã«ç¶ã ã¨æ°ãããµã¼ãã¹ãæ©è½ãçºè¡¨ããAmazon Web Servicesã¯æ¥æ¬ã§ãçã 注ç®ãéããåå¨ã§ãããæ¬ç¨¿ã§ã¯ããã®Amazon Web Servicesã®ä¸ã§ããç¹ã«ä»®æ³ãµã¼ãé¨åã§ããAmazon EC2ã«ã¤ãã¦ã主ã«æ§è½ã«é¢ãã調æ»çµæãè¨ãã
ããã¾ã§å®¶åºç¨ã²ã¼ã æ©åãã«ã½ãããéçºãã¦ããã¨ã³ã¸ãã¢ãã¡ããã½ã¼ã·ã£ã«ã²ã¼ã ã®å°é ã«æ¸æã£ã¦ãããã²ã¼ã éçºã®æ¹æ³ã大ããå¤ãããã¢ã¤ãã 課éãªã©åçãå¾ãä»çµã¿ãæ§å¤ãããã¦ãã¾ãããã ã9æ6ï½8æ¥ã«æ¨ªæµã§éå¬ãããæ¥æ¬ã®ã²ã¼ã éçºè åãæè¡ã«ã³ãã¡ã¬ã³ã¹ãCEDECãã§ã¯ãããããéçºè ã®å§¿ãç®ç«ã£ãã200è¿ãè¡ãããè¬æ¼ã¯ãã²ã¼ã å¸å ´ã®å¤åã®å½±é¿ãç´æ¥åãã¦æ§å¤ãããããããã¾
売ãæå´ã«ãããªãæ å ±ãå¤æ°ãããããæ ã«ä¾¡æ ¼ãé«æ¢ã¾ããããã¼ã±ãããæè»æ§ã失ãããããããæ å ±ã®é対称æ§ããçã¾ãã¦ããåéãçãã®ã¯ãå¤ããããã³ãã£ã¼ä¼æ¥ã®å®ç³ã ãä¸å¤è»ãæ è¡ã¨ãã£ãæ¥çã§å¾çºãªãã大æã«æé·ããä¼æ¥ã¯ãããã¾ã§æ¶è²»è ãç¥ãå¾ãªãã£ãæ å ±ããªã¼ãã³ã«ãã¦æ å ±ã®é対称æ§ã解æ¶ããæ°ããªä¾¡å¤ãæä¾ãã¦ãæ¥æ¿ãªæé·ãéãã¦ããã æã ã®èº«è¿ã«ã¯ã巨大ãªæ å ±ã®é対称æ§ãæ®ããã¦ããåéãã¾ã ã¾ã ããããã®ä»£è¡¨ä¾ã¨ããããã®ãããã©ã¤ãã«æ¥çã ããä¾ãã°ãã±ã¼ãå ¥åã§ä½¿ããã¤ãã«ä»ãããªãã³ãããã¼ãã«ã¯ãã¹ãæ¤ åã®ã«ãã¼ãããå¥æéã®å ´åãããããããªãã¨ã¯çµå©å¼ãæããåã«ã¯ç¥ãç±ããªãããããèªãã®ã¯ããã¿ããªã®ã¦ã§ãã£ã³ã°ãåµæ¥è ã»ç¤¾é·ã®é£¯å°¾æ ¶ä»æ°ããã«ããã«ã§çµå©å¼å ´ã®ä¸è¦ã«è¡ãã¨ããä»®äºç´ã§ããã®ã§ãã¨èª¬æããã10ä¸åç¨åº¦ã¨ãã£ãä½ãæéã§ã¾ãã¯äºç´ãããã
2011å¹´9æ15æ¥ããéå¬ä¸ã®æ±äº¬ã²ã¼ã ã·ã§ã¦2011ãéå¬2æ¥ç®ã¨ãªã2011å¹´9æ16æ¥ã«è¡ãããTGSãã©ã¼ã©ã 2011ã«ããã¦ããã£ã¼ã»ã¨ãã»ã¨ã¼ã®ã¹ãã³ãµã¼ã»ãã·ã§ã³âDeNAã®ã½ã¼ã·ã£ã«ã²ã¼ã ãã©ãããã©ã¼ã æ¦ç¥âã¨é¡ããã»ãã·ã§ã³ãå®æ½ãããã 2011å¹´9æ15æ¥ããéå¬ä¸ã®æ±äº¬ã²ã¼ã ã·ã§ã¦2011ãéå¬2æ¥ç®ã¨ãªã2011å¹´9æ16æ¥ã«è¡ãããTGSãã©ã¼ã©ã 2011ã«ããã¦ããã£ã¼ã»ã¨ãã»ã¨ã¼ã®ã¹ãã³ãµã¼ã»ãã·ã§ã³âDeNAã®ã½ã¼ã·ã£ã«ã²ã¼ã ãã©ãããã©ã¼ã æ¦ç¥âã¨é¡ããã»ãã·ã§ã³ãå®æ½ãããããã®ã»ãã·ã§ã³ã«ãâMobageâãéå¶ãããã£ã¼ã»ã¨ãã»ã¨ã¼ããå°æ賢治æ°ï¼åç· å½¹ ã½ã¼ã·ã£ã«ã²ã¼ã äºæ¥æ¬é¨ï¼ãåºå¸ããã½ã¼ã·ã£ã«ã²ã¼ã ãã¸ãã¹ããã©ãããã©ã¼ã æ¦ç¥ã«ã¤ãã¦èªã£ãã æ¨ä»ãå¸å ´å ¨ä½ãçãä¸ãããè¦ãã¦ããã½ã¼ã·ã£ã«ã²ã¼ã æ¥çãâã½ã¼ã·ã£ã«ã²ã¼ã ã¯å²ããâã¨ã
ã©ã³ãã³ã°
ã©ã³ãã³ã°
ã©ã³ãã³ã°
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}