MySQL + Railsã§å¤§è¦æ¨¡ãµã¤ãæ§ç¯å®é¨ããããã大詰ãã§ãã ååã¾ã§ã¯ã DB : Active-Active LB : Active-Passive æ§æãæ³å®ãã¦æ§ç¯ãã¦ãã¾ããã ã¾ããã¬ããªã±ã¼ã·ã§ã³ã®é ãã«ããæ´æ°ã®è¡çªãé¿ããããã®è§£ãããã¤ãç´¹ä»ãã¾ããã ã ãActive-Activeæ§æã«ããã³ã¹ãã大ããï¼ï¼ ãããããActive-Activeæ§æã§çµãå¿ è¦ãããã®ãã©ããï¼ãã¨ãã£ãçåã沸ãã¦ãã¾ããã 調æ»ãé²ããã¨ãããDBã®Active-Activeæ§æã«ããã³ã¹ãã«å¯¾ãã¦ãã¡ãªãããå°ãªããã¨ãå¤æã [Active-Activeæ§æãçµãã¡ãªãã] ç¬éçãªã³ãã¯ã·ã§ã³å¢ã¸ã®å¯¾å¿ãå¯è½ã ã³ãã¯ã·ã§ã³ã®è² è·åæ£ã®ã¿å¯è½ã(I/Oã®è² è·åæ£ã¯ã§ããªã) [Active-Activeæ§æãçµããã¡ãªãã] æ´æ°ç³»ã¯ã¨ãªã®è² è·åæ£ã¯ä¸å¯ã ã¬ããªã±
vol2ã§ãå¼ãç¶ããè² è·åæ£ã»é«å¯ç¨æ§ãåããDBã¨WEBã¢ããªã±ã¼ã·ã§ã³ãã¬ã¼ã ã¯ã¼ã¯(以ä¸AF)ã®ã»ããã¢ãããç®æãã¾ãã ãã¥ã¢ã«ãã¹ã¿æ§æã«è¤æ°å°ã®ã¹ã¬ã¼ããã¶ãä¸ãã£ã¦ãã¾ãã ããå°ãã詳ããä»èãã¦ããã¢ã¼ããã¯ããè¦ã¦ããããã¨æãã¾ãã æå°æ§æ: ãã¹ã¿2å°, ã¹ã¬ã¼ã1å° æä½3å°ã®DBãç¨æãã¾ãã ãªã3å°ãï¼ã¹ã¬ã¼ãã追å ããéã«ã¯ããã¹ã¿ã®ã¹ãããã·ã§ããåå¾ã®ããã«ãã¹ã¿ã¸ã®æ´æ°ãåæ¢ããå¿ è¦ãããã¾ãããã¼ã¿éãå¢ããã¨ããã¹ã¿ãåæ¢ãã¦ã¹ãããã·ã§ãããåå¾ããã«ã¯ãé·æéãè¦ãããããããã¯ç¾å®çãªè§£ã§ã¯ãªãã ããã§ãã¹ã¬ã¼ãããã¹ã¿ã®ã¹ãããã·ã§ããã¨ãã¦èããã¹ã¬ã¼ãã¸ã®ã¬ããªã±ã¼ã·ã§ã³ãä¸æåæ¢ããã¹ã¬ã¼ãã®ã¹ãããã·ã§ãããæ°è¦ã«ç¨æããã¹ã¬ã¼ãã«ã³ãã¼ãã¬ããªã±ã¼ã·ã§ã³ãè¨å®ããã ã¹ã¬ã¼ãã1å°ããåå¨ããªãå ´åã§ã®ã¹ã¬ã¼ãåæ¢æã¯ã
ï¼ï¼ï¼ä¸ãã¦ã³ãã¼ãã¦ã¼ã¶ã«å¯¾å¿ããMySQL Clusterã·ã¹ãã ï¼MySQL Cluster + UltraMonkeyï¼ Acorn Software Technologies社ã¯ãä»åãMySQL Clusterã使ã£ãWebã·ã¹ãã ã®è² è·åæ£ã¨é«å¯ç¨æ§ãå®ç¾ããæ©ä¼ã«æµã¾ããã®ã§ããã®æ§ç¯ã®èæ¯ãæ§ç¯ä½æ¥ãçµæã«ã¤ãã¦ç´¹ä»ããã æ°ããªæºå¸¯åããµã¼ãã¹ã®ããã¸ã§ã¯ãã®ç«ã¡ä¸ãã«æºããæ©ä¼ãå¾ããä»ã¾ã§ã®çµé¨ãããéç¨éå§å¾ã®ãã³ã¹ãããæ§ã¨å¦çè½åã®ã¹ã±ã¼ã©ããªãã£ï¼ã¦ã¼ã¶æ°å¢å ã¨å¦çã®è¤éæ§å¢å¤§ã«å¯¾ããèã¬ã¹ãã³ã¹ã¿ã¤ã å£åæ§ï¼ãéè¦ãMySQL Clusterãé¸æããã MySQL Clusterã¯ãIn-memoryã®ãã¼ã¿ãã¼ã¹ãªã®ã§ãã¼ã¿ãã¼ã¹ã®å®¹éã«å¶éãããããå½è©²ãµã¼ãã¹ã§ã¯å¤§ããªå®¹éãå¿ è¦ã¨ããªããã¨ããåé¡ã¨ã¯ãªããªãã£ããè² è·åæ£ã·ã¹ãã ã«é¢ãã¦ã¯
ãã¼ããã©ã³ã·ã³ã°ã£ã¦ãã¤ã§ãããä¿ã«è¨ãã¨ããã®ã How To Set Up A Load-Balanced MySQL Cluster | HowtoForge - Linux Howtos and Tutorials http://www.howtoforge.com/loadbalanced_mysql_cluster_debian æ£ç¢ºã«ã¯ãMySQL Clusterãã¨å¼ã¶ãããã ä¸è¨ãµã¤ãã«è©³ããããæ¹ã解説ããã¦ãã¾ããããªããªãåªç§ãªããã§ã MySQL AB :: MySQL Cluster http://www-jp.mysql.com/products/database/cluster/ MySQLãã¯ã©ã¹ã¿ã¼æè¡ãMySQL Clusterããçºè¡¨ãæ£å¼çã¯ä»å¹´3Q http://enterprise.watch.impress.co.jp/cda/forei
製åæ¦è¦ ã-ãuni/cluster for MySQLã-ã ãuni/cluster for MySQLãã¯ãMySQLãã¼ã¿ãã¼ã¹ã®è¦æ¨¡æ¡å¤§ã«æé©ãªã½ããã¦ã§ã¢ã§ãã GUIãã¼ã«ï¼ç®¡çç»é¢ï¼ã¨ããã¥ã¢ã«ãæ¥æ¬èªåããã¦ãã¾ãã®ã§ãå¾æ¥ã®è£½åãããåããããããªã£ã¦ãã¾ãã ãuni/cluster for MySQLãã®ç¹å¾´ ã»ééæ§ã®é«ããã¼ã¿ãã¼ã¹ã¯ã©ã¹ã¿ãªã³ã° ã«ãããMySQL4.0.xã5.0.x ããµãã¼ã ã»ã·ã¹ãã ã®äºéåã«ããé«å¯ç¨æ§ ã»JavaãPerlãPHPãC/C++ã®å°ç¨ãã©ã¤ãã¨ã¯ã©ã¹ã¿ã®ã³ã³ããã¼ã©ã«ããè² è·åæ£ ã»16å°ã¾ã§ãã¼ã¿ãã¼ã¹ã追å ã§ããã¹ã±ã¼ã©ããªã㣠ã»é害çºçæã®èªåãã§ã¤ã«ãªã¼ãã¼ãå®ç¾ ã»2ãã¼ãããã®ã¯ã©ã¹ã¿ãªã³ã°ãå®ç¾ ã»ä»®æ³ãã¼ã¿ãã¼ã¹æ©è½ã«ããã¯ã©ã¤ã¢ã³ãã«åä¸ã®ãã¥ã¼ãæä¾ ã»ã¯ã©ã¹ã¿ã®ã³ã³ããã¼
Intelã®XeonãAMDã®Opteronã¨ãã£ã64ãããã¢ã¼ããã¯ãã£ãå®ç¨çã«ãªãã«ä¼´ã£ã¦ãå¾æ¥ã¡ã¤ã³ãã¬ã¼ã ãRISCãµã¼ããæ ã£ã¦ãã大è¦æ¨¡ãªã¨ã³ã¿ã¼ãã©ã¤ãºã·ã¹ãã ããã¯ã©ã¹ã¿åãããIAãµã¼ãã§ç½®ãæããåããæ´»çºåãããããããã°ãªããã»ã³ã³ãã¥ã¼ãã£ã³ã°ãã¸ã®ç§»è¡ãé²ã¿ã¤ã¤ãããä¸è¬çã«ãæ å ±ã·ã¹ãã ã®ä¿¡é ¼æ§ãé«ããããã«ã¯ã2ã¤ã®ã¢ããã¼ãããããã¾ããã·ã¹ãã ãæ§æãããã¼ãã¦ã§ã¢ãã½ããã¦ã§ã¢èªä½ã®å質ãé«ãããã¨ãã²ã¨ã¤ã ããä¸å®ã®æ°´æºä»¥ä¸ã®å質åä¸ã¯ãã©ããã¦ãé«ã³ã¹ãã«ãªããããã®ãé£ç¹ã ãããã§ãç¾å®çãªé¸æè¢ã¨ãã¦éè¦ã¨ãªãã®ãããã°ãªããããã¯ã©ã¹ã¿ãã¨ãã£ãåé·åã®æè¡ã§ãããåç¬ã®ã·ã¹ãã ã§ã¯æ§è½ãä¿¡é ¼æ§ãè¦æ±ã«æºããªãã¨ãã¦ããè¤æ°ã®ã·ã¹ãã ã®éåã¨ãã¦åé·åãããã°ãªãããã¯ã©ã¹ã¿ã§ã¯ãåæ§æã·ã¹ãã ãç¸äºã«è£å®ããããªããå ¨ä½ã¨ãã¦é«ãä¿¡é ¼æ§
ã¯ã¦ã¶ã§äººæ°ã¨ã³ããªã¼ã«ãªã£ã¦ããã http://kokoromo.jugem.cc/?eid=195 [MySQLï¼ï¼å°ãããªãç°å¢ã§è² è·åæ£] ããã¯è² è·åæ£ï¼ã¹ã±ã¼ã«ã¢ã¦ãã¨ããããã¯ä¸å°ã§ã¹ã±ã¼ã«ã¢ãããã¦ãã®ãæ段ãæ¸ãã¦ãã ã ããè² è·åæ£ã¨ããè¨èã¯å¿ ãããæ£ãããªãã®ã ããä¸ã¤ã®ãã¼ãã«ã¸ã®ä»å éä¸ãåæ£ãããã¨ããäºãªã®ã ããã ããã§ä½ãã¿ã¼ã³ãããMySQLã®è² è·åæ£ãç°¡åã«ã¾ã¨ãã¦ã¿ãã 1. å¯è±ªçåæ£ åç¨ã®ã¯ã©ã¹ã¿ã¼è£½åã使ãã æè¿ã¯MySQLå°éã®ã¯ã©ã¹ã¿ã¼è£½åãåºã¦ãã¦ããã http://www.continuent.jp/pro.html ãªããã¯è¯ãããªã¨æãã é·æï¼ ããã°ã©ã å´ã§ã¯ã¯ã©ã¹ã¿ç¶æ ãä½ã®æèããããä¸ã¤ã®ã¿ã¼ã²ããã«å¯¾ãã¦ã¯ã¨ãªã¼ãçºè¡ããã°è¯ãã ã¿ã¼ã²ãããè¤æ°å°ããäºã¯æèããäºã¯ç¡ãã ä¸å ·åããããã¼ãã«çããå ´åãä»
â ä¸äºä½åéè¡ããé¨ãã©ãããã風åããããã§æ¤ç´¢ã®ãã¬ãåºåã§ä¾¿ä¹ãã£ãã·ã³ã°ã®å±æ©ï¼è¢«å®³é²æ¢ç¨ã¨ã³ããªï¼ ä¸äºä½åéè¡ã®ãã¬ãCMã§ããé¨ãã©ãããã風åããããã§æ¤ç´¢ãããã·ã¼ã³ãæ¾æ ããã¦ãããããããç¾æç¹ã§ãæ¤ç´¢çµæã®ä¸ä½ã«ç»å ´ãããµã¤ãã¯ãé¨ãã©ãããã風åããããã®ã©ã¡ããä¸äºä½åéè¡ã®æ¬ç©ãµã¤ãã§ã¯ãªãããé¨å®¿ããããã¾ãã©ãããã風åä¸ãããããµããããããåæ§ã ã Googleã§ãé¨ãã©ããã§æ¤ç´¢ãã1çªç®ã¯ãç¾å¨ã®ã¨ãããé²éª¨ãªæ§æåãå«ãäºæ¬¡å å ç«¥æ§æåé¯ã²ã¼ã *1ã®ãµã¤ãã«ãªã£ã¦ããã2çªç®ä»¥ä¸ããã¤ãã¼ãªãã¼ã¸ã°ããã ãã¡ãã£ã¨ãããã¡ã¤ã³ã®ãã¼ã¸ã«ä¸äºä½åéè¡ãè£ ã£ãå½ãµã¤ããä½æãããã¨ããããä¸ä½ã«åºã¦ããããªãããã®ãããªå½ãµã¤ãã«ããè©æ¬ºã®å±éºæ§ãä½æ¸ããããããã®æ¥è¨ãå ã«èªã¾ãããã¨ãæå¾ ãã次ã®ã¨ããæ¸ãã¦ããã åãã¦è¨ªãããµã¤ãããã©ãã
Webãµã¤ããè¨è¨ããéï¼ãè²ãã¯æ§ã ãªåé¡ãèµ·ããã¾ããéçºè ããããã®æ³ããè¾¼ããããããã®ããããã¾ãããéçºæ«æã«ãªã£ã¦ããï¼è²ã®å¤æ´æ示ã§ä¸ç éçºã«ãªãã¨ãã話ã¯ï¼ãã¾ã æ話ã«ã¯ãªã£ã¦ãã¾ããã è²ã®åé¡ã解決ããããã«ã¯ï¼è²ã«ã¤ãã¦ã®ç¥èããã£ãã»ããå©ããã¾ãããã ãï¼è²èªä½ã®è¬éãããã§ã¯ãã¾ãããè²ã決ãã¦ããéç¨ã®åèã«ãªããããªãã¨ãè¨ãã¾ãã å·ãè¾¼ã¾ãã¦ããè²/åºå®ã¤ã¡ã¼ã¸ã®ããè² ç§ãã¡ã¯æ§ã ãªè²ã«å²ã¾ãã¦çæ´»ãã¦ãã¾ãããã®ä¸ã§ï¼è²ã¨è¡åãä¸çªå¯æ¥ã«ãããããæã¤ã®ã¯ãä¿¡å·ãã§ããæã ã®åãã¹ãè¡åãè²ãæ示ãã¾ããããã¯ãã¾ãã«ä¸è¬çã«ãªãããã¦ï¼æã ã¯ç¡æèã®ãã¡ã«ãããã®è²ã«å¯¾ãã¦åæ§ã®è¡åãã¿ã¼ã³ãåãããããªã£ã¦ãã¾ãã ä¾ãã°ï¼èµ¤è²ãè¦ãã¨ä½ãå±éºãªãã¨ããã°ã«ããã®ãããããªãã¨è¦æãããï¼é»è²ã®æ¨èãç®ã«ããã¨å¨å²ã«å¯¾ãã¦å°ã注æåãã¯ãã£ãã
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}