4æ11æ¥ããç±³ãµã³ã¿ã¯ã©ã©ã§è¡ããããMySQL Conference & Expo 2011ãããã®ã¤ãã³ãã§DeNAã®æ¾ä¿¡åç¯ï¼ã¾ã¤ã®ã¶ããã®ãï¼æ°ããå社ã®å¤§è¦æ¨¡ãªMySQLã®éç¨ãæ¯ãã¦ããæè¡ã¨ãã¼ã«ã«ã¤ãã¦ã®ã»ãã·ã§ã³ãAutomated, Non-Stop MySQL Operations and Failoverããè¡ãã¾ããã ãã¬ã¼ã³ãã¼ã·ã§ã³ã®ä¸ã§ã社å ã§å©ç¨ãã¦ãããã§ã¤ã«ãªã¼ãã¼ã®èªååãã¼ã«ããªã¼ãã³ã½ã¼ã¹åãããã¨ã«ã触ãã¦ãã¾ãï¼è±èªã®ããã¥ã¡ã³ããä½æä¸ã¨ã®ãã¨ï¼ã MySQLã®å¤§è¦æ¨¡éç¨ã«ãããèªåãã§ã¤ã«ãªã¼ãã¼ã¯ãç¹ã«ã¯ã©ã¦ãã§ã®MySQLã®å©ç¨ãå¢ããã«ã¤ãã¦ãã¼ãºãé«ã¾ãåéã¨æããã¾ããã»ãã·ã§ã³ã®ã¹ã©ã¤ããå ¬éããã¦ãã¾ãã®ã§ããã®ãã¤ã³ããç´¹ä»ãã¦ããã¾ãã èªååããããã³ã¹ããããªMySQLã®éç¨ ã½ã¼ã·ã£ã«ã²ã¼ã ã§ã¯é«å¯ç¨æ§ãå¼·ãæ±
ä½é¨ï¼ æ°ãããªã£ãLinux-HAï¼Heartbeatï¼Pacemakerï¼DRBDã§é«å¯ç¨Linuxï¼1/3 ãã¼ã¸ï¼ Linuxã§åä½ãããªã¼ãã³ã½ã¼ã¹ã½ããã¦ã§ã¢ãçµã¿åãããé«ãä¿¡é ¼æ§ãåããã·ã¹ãã ãå®ç¾ãããLinux-HAããæ°ãããªããããã«é«ãä¿¡é ¼æ§ãå®ç¾ããããã«ãªãã¾ãããææ°ã®Linux-HAã®ç¹å¾´ã¨ãå°å ¥ããè¨å®æ¹æ³ã¾ã§åºæ¬çãªç°å¢æ§ç¯ã解説ãã¾ãï¼ç·¨éé¨ï¼ æ°ãããªã£ãLinux-HA Linuxã§åä½ãããªã¼ãã³ã½ã¼ã¹ã½ããã¦ã§ã¢ï¼OSSï¼ã ãã§High Availabilityã¯ã©ã¹ã¿ï¼HAã¯ã©ã¹ã¿ï¼ç°å¢ãå®ç¾ããLinux-HAã¯ããµã¼ãã¹ã®å¯ç¨æ§ããã¼ã¿ã®ä¿åæ§ã«å¯¾ããè¦æ±ãé«ããªã£ããã®æ°å¹´ã§é常ã«æ³¨ç®ããã¦ããåéã§ãã Linux-HAã¨ã¯è¤æ°ã®OSSãçµã¿åãããç°å¢ã®ç·ç§°ã§ãHeartbeatãCorosyncãOpenAISãDRBDãªã©ã
The open-source high-availability cluster stack The ClusterLabs community provides a collection of free and open-source software projects related to high-availability clustering, including Corosync and Pacemaker. Benefits A high-availability cluster coordinates the start-up, monitoring, and recovery of services across a set of host machines, to minimize downtime while preserving data integrity. Un
確å®ã«å¤é¨ã¹ãã¬ã¼ã¸ã¸ã®æ¥ç¶ãè¡ããããå¤é¨ã¹ãã¬ã¼ã¸ãå©ç¨ããéã«ã¯è¤æ°ã®HBAã«ãããmultipathã使ãããã®ã ããCentOSãFedoraã«ãã¯ã©ã¤ã¢ã³ãå´ã®multipathã®æ©è½ãããã æ¢ã«openfiler ã使ã£ã¦ãiSCSI target ã使ããããã«ãªã£ã¦ããã®ã§ãFedora11 ããmultipathã使ã£ã¦ã¿ãã 大ã¾ããªä½¿ãæ¹ã¯ãã¡ãã¨åæ§ã«ãªãã http://www.redhat.com/docs/en-US/Red_Hat_Enterprise_Linux/5/html/DM_Multipath/index.html ã¾ããiSCSIã®ã¹ãã¬ã¼ã¸ã«è¤æ°ã®HBAãããç¶æ ã«ãããããopenfilerã«ãã°ã¤ã³ãã # ifconfig eth0:1 xx.xx.xx.xx ãªã©ã«ãããäºã¤ç®ã®IPãä»ä¸ãããå®éã«ã¯1ã¤ã®NICãããªããããåé·
Load Balancing in Amazon EC2 with HAProxy http://agiletesting.blogspot.com/2009/02/load-balancing-in-amazon-ec2-with.html å ¨ä½çã« â è¨å®ãã¡ã¤ã«ã®æ¸ãæ¹ ããªãæ®éãªæãã®æ¸ãæ¹ãmod_proxy_balancerã®æ¸ãæ¹ã¨é°å²æ°ã¯ä¼¼ã¦ããã¨ããããæ®éãªæãã â maxconnã®å¤ ããã©ã«ãã§2000ã«ãªã£ã¦ããã ãããè¶ ããã¨ãã¥ã¼ãããã 25,000ããããããã¨æãããã¨ã®ãã¨ã â ã ãããã®æ§è½ ããªãããã 20,000ã³ãã¯ã·ã§ã³ãããã®ã¢ã¯ã»ã¹ãæ¥ã¦ãã¨ããec2ã®smallã¤ã³ã¹ã¿ã³ã¹ã§CPU使ç¨çï¼ï¼ ãããã ãã以ä¸ã®ã¢ã¯ã»ã¹ãæ¥ãããHAProxy以å¤ã®é¨åãããã«ããã¯ã«ãªã£ã¦ãã ãããããããã§ååã ããã ã¡ã¢ï¼smallã¤ã³ã¹ã¿
ããã㪠Proxy ï¼ Load banalserã試ãã¦ã¿ããã¨æ©é ports/net/haproxy ãå°å ¥ããç´æ㧠/etc/rc.conf ã« haproxy_enable="YES" ã追å ãã¦çµäºãè¨å®ãã¡ã¤ã«ã examples/haproxy.cfg ãã /usr/local/etc/haproxy.conf ã«ã³ãã¼ãã¦é©å½ã«ã¨ãã£ããããããèµ·åããã...ã¨æã£ãã startup ã¹ã¯ãªããããã¾ãã¡ã§ haproxy_flags="-f /usr/local/etc/haproxy.conf -p /var/run/haproxy.pid" ãªãã¦ã®ã追å ããªãã¨ãã¡ã ã£ããports ã® version ãææ°ã® 1.2.14 ã§ã¯ãªã㦠1.1.32 ã ããããªï¼ ãã©ã³ã¹ãµã¤ãã® keep alive ãã§ãã¯ã«ä½¿ã URL ãè¨å®ã§ããã®ã¯é¢ç½
Quick News Feb, 26th, 2025 : HAProxyConf 2025 Early birds registration Early birds registration for HAProxy Conf 2025 is now available! Please check the link to book your tickets. Nov, 26th, 2024 : HAProxy 3.1.0 release This release brings a number of troubleshooting improvements. For example it offers new sample fetch methods to report information about last rule, termination states and syscall s
KOF2009ã«ã¦ããã¦ã§ããµã¼ãã¹ã®ããã©ã¼ãã³ã¹ã¨ã¹ã±ã¼ã©ããªãã£ãã¨é¡ãã¦çºè¡¨ãã¦ãã¾ãããçºè¡¨è³æã以ä¸ã«ç½®ãã¦ããã¾ãã Performance and Scalability of Web ServiceView more presentations from Shinji Tanaka. æ¦è¦ã¯ããã¦ã§ããµã¼ãã¹ã®ããã©ã¼ãã³ã¹ãåä¸ããã¹ã±ã¼ã©ããªãã£ãé«ããããã«ãã¯ã¦ãªã§ã¯æ§ã ãªåçµã¿ãè¡ã£ã¦ãã¾ããæ¬ã»ãã·ã§ã³ã§ã¯ãã¯ã¦ãªã§æ¡ç¨ãã¦ããå ·ä½çãªæè¡ããã¦ãã¦ãå¯è¦åææ³ã¨ããããã®å¹æã«ã¤ãã¦ç´¹ä»ãã¾ãããã¨ãããã®ã§ãã æè¿ã®ãInteropãã«ã¼ãã«èªæ¸ä¼ãããã§è©±ããå 容ãã¾ã¨ãã¤ã¤ãã¬ã¹ãã³ã¹ã¿ã¤ã ã®å¯è¦åã¨ããæè¿ã®åãçµã¿ã«ã¤ãã¦è©±ãã¾ããã æè¿ãã¬ã¹ãã³ã¹ã¿ã¤ã ã«ã¤ãã¦ã¯ã以ä¸ã®ãããªã°ã©ãã使ã£ã¦ãã¾ãã x軸ãã¬ã¹ãã³ã¹æéãy軸ããã®æéå ã«å
ã¬ããªã±ã¼ã·ã§ã³ãã¦ãMySQLã§ããã¹ã¿ãã¹ã¬ã¼ããé害åæ¢ããå ´åã®ãªã«ããªãã©ã³ ã§ãæ²ããã´ã¼ã«ã§ãããããã¹ã¿ãè½ã¡ã¦ããã¼ããå¯ã¦ããããããã«ãããããã»ã¼ã§ããã®ã§ãã»ã¨ãã©ãµã¼ãã¹ãåæ¢ãããã¨ãªãããã§ã¤ã«ãªã¼ãããæ§ãã¹ã¯ãªã¼ã³ãã£ã¹ãã«åãã¾ããã åãè¾¼ã¿ãã¬ã¤ã¤ã¼ã ã¨ãå°ããã¦ããããªãã¨æãã®ã§ããªã³ã¯ç´æ¥ã§ã¿ã¦ãã ããã http://www.irori.org/pub/mysql-mm.mov ç»å ´ãããã¹ã ç»å ´ãããã¹ãã¯2å°ãdb901ã¨db902ã§ãã æåã¯ãdb901ãæ´æ°ç³»ã¯ã¨ãªãåãããã©ã¤ããªã§db900ã®æµ®åIPã¢ãã¬ã¹ãæã£ã¦ãã¾ãã ç»é¢åå² ç»é¢ã¯5åå²ãã¦ãã¾ãã å·¦ä¸ = ãselect sysdate(),@@server_idããdb900ã«å¯¾ãã¦(sleep 1ããªãã)延ã ã¨å®è¡ãã¾ãããã å³ä¸ = ping -n
MySQLã§ãã¬ããªã±ã¼ã·ã§ã³ãã¼ã¹ã®HAãªæ§æã«ã¤ãã¦èããã¡ã¢ã§ãã 3å°(ã¨ããã2å°ï¼1å°)ãããããªãã¨æã£ã¦ãã¦ãååã¯ãã®çç±ããå¾åã§ã¯{ãã¹ã¿,ã¹ã¬ã¼ã}ã{åèµ·ä¸è½ã«ãªã£ã,ã¡ãã£ã¨ãã¦ã³ãã¦ãã復帰ãã}å ´åã®ãªã«ããªãã©ã³ã«ã¤ãã¦æ¸ãã¾ãã ä»ã®ã¨ããã¯ããããã¹ãããªã¨æã£ã¦ããã®ã§ããããããããã»ããããã¨æãï¼ãããããããããï¼ããªã©ãªã©ã®ãæè¦ã¯ã³ã¡ã³ããTBãªã©ã§ããã ããã¨ããããã§ãã ã´ã¼ã« ãã¹ã¿ãè½ã¡ã¦ããã¼ããå¯ã¦ããããããã«ããã ãªã«ããªã®ä½æ¥ã¯ã§ããã ãåç´ã«ããã¤ãçæéã§å®äºããããã«ããã ããã©ãããã®ã¯ãã åºæ¬æ§æãæ¹é 2å°ï¼1å° ãµã¼ãã¹ã§ä½¿ãã®ã¯2å° (db1, db2) ãã1å°ã¯ç®¡çç¨ (db3) ã¹ã¬ã¼ããå¤æ°ä¸¦ã¹ãæ§æã«ã¯ããªã å°æ°å¢ããã¨ç®¡çã³ã¹ããä¸ãã ãã¹ã¿ãã¦ã³æã®ãã§ã¤ã«ãªã¼ãã¨ãã®ãã§ã¤ã«ã
How To Build A Scalable Storage System with OSS at TLUG Meeting 2008/09/13 The document discusses Gosuke Miyashita's goal of building a scalable storage system for his company's web hosting service. He is exploring the use of several open source technologies including cman, CLVM, GFS2, GNBD, DRBD, and DM-MP to create a storage system that provides high availability, flexible I/O distribution, and
ååã¯ãHAã¯ã©ã¹ã¿ãæ§ç¯ã§ãããªã¼ãã³ã½ã¼ã¹ã½ããã¦ã§ã¢ãHeartbeatãã®ä¸»ãªæ©è½ãç´¹ä»ãã¾ããã第2åã¯ãHeartbeatã®ã¤ã³ã¹ãã¼ã«æ¹æ³ã解説ããããã«åºæ¬çãªè¨å®å 容ãç´¹ä»ãã¦ããã¾ããï¼ç·¨éé¨)
ã¯ããã« ä»åããæ°åã«ããã£ã¦ããªã¼ãã³ã½ã¼ã¹ã®HAï¼é«å¯ç¨æ§ï¼ã¯ã©ã¹ã¿æ§ç¯ã½ããã¦ã§ã¢ãHeartbeatããé¡æã«ãã¦ããã¯ã©ã¹ã¿ãªã³ã°ã¨ã¯ä½ãï¼ãã¨ããã¨ãããããHeartbeatèªä½ã®è§£èª¬ãHeartbeatãç¨ãã¦ã®HAã¯ã©ã¹ã¿ã®æ§ç¯ãã¢ãã¿ãªã³ã°ãªã©ã«ã¤ãã¦è§£èª¬ãã¦ããããã¨æãã¾ããçãããä»ãåãã®ã»ã©ããããããé¡ããããã¾ãã ã¯ã©ã¹ã¿ãªã³ã°ã£ã¦ä½ã ããï¼ ã¾ãããã¯ã©ã¹ã¿ãªã³ã°ã¨ã¯ä½ããã¨ããã¨ããããå§ãã¦ã¿ã¾ãããããã®è³ªåã«ç°¡åã«çãã¦ãã¾ãã¨ãããããã·ã§ã³ã«å¯¾ããè¤æ°ã®ã³ã³ãã¥ã¼ã¿ï¼ç¾¤ï¼ã¯ã©ã¹ã¿ï¼ããã£ã¦å¯¾å¦ããæ§æãã ã¨ããã¾ããã§ãããç¶æ³ã«å¿ãã¦ãã¾ãã¾ãªããã·ã§ã³ã®ã¿ã¤ããããã¾ããããããã«å¯¾ããã¯ã©ã¹ã¿ãªã³ã°ï¼æ§æï¼ãèªç¶ã¨å¤ãã£ã¦ãã¾ãã ãªããLinuxã§ã®ã¯ã©ã¹ã¿ãªã³ã°ã®æ´å²ã¯æå¤ã¨å¤ãã¾ã§ããã®ã¼ããã¨ãã§ãã¾ããç´åå¹´åã®éèªã§ãã§
repcachedåã®å ¬éãã¼ã¸ã§ã³ã¨ãªã1.0ãå ¬éãã¾ããã http://lab.klab.org/modules/mediawiki/index.php/Repcached (æ¥æ¬èª) http://repcached.lab.klab.org/ (è±èª) repcachedã¨ã¯ãmemcachedã«ä»¥ä¸ã®æ©è½ã追å ãããããã¯ãã§ãã ã¢ã¯ãã£ã/ããã¯ã¢ããæ§æã§ã®èªåçãªãã§ã¤ã«ãªã¼ã ç¡åæ¢ã®ãã§ã¤ã«ãã㯠ããã£ãã·ã¥ãµã¼ããªã®ã«åé·æ§æã£ã¦å¿ è¦ãªã®ï¼ãã¨æãããããã¾ãããããã®ãããã®éçºåæ©ãå«ããã¤ã³ã¹ãã¼ã«æ¹æ³ãªã©ã®ããã¥ã¡ã³ãã¯ä¸è¨ã®ããã¸ã§ã¯ããã¼ã¸ã«ããã¾ãã®ã§ã覧ãã ããã¾ãï¼ è¿½ã ããã®ããã°ã§ãæ´»ç¨äºä¾ãç´¹ä»ãã¦ããããã¨æã£ã¦ãã¾ãã
ãLinuxãã¼ããã©ã³ãµæ§ç¯ã»éç¨ãã¦ãã¦ããå ¬éãã¾ãï¼ ããã¯WEB+DB PRESS Vol.37ã®ç¹éè¨äºã¨ãã¦DSASãã¼ã ãå·çãããã®ã§ãæè¡è©è«ç¤¾æ§ã®è¨±å¯ãå¾ã¦ä»åå ¬éããã¯ãã³ã¨ãªãã¾ããã ä¸å£ã§ããã¨ããLinuxï¼IPVSï¼keepalivedã使ã£ã¦ãåé·æ§æ(Active/Backup)ã®ãã¼ããã©ã³ãµãä½ãã¾ã§ãã®è§£èª¬è¨äºã§ã ãµã¼ãè² è·åæ£ä¸è¬ã«ã¤ãã¦ã®ã¯ãªã Linuxã§ãã¼ããã©ã³ãµãä½ã£ã¦ã¿ã ãã¼ããã©ã³ãµãåé·å ã¨ãã£ãæ§æã«ãªã£ã¦ãã¾ãã ã¿ãªãããLinuxãã¼ããã©ã³ãµãå°å ¥ã»æ§ç¯ã»éç¨ããéã®ä¸å©ã«ãªãã°ãDSASãã¼ã ã¨ãã¦ãããããéãã§ãã®ã§ãæ¯éãã覧ã«ãªã£ã¦ãã ããï¼ ç¬¬1ç« ãµã¼ãè² è·åæ£æ¦è« ç¹éã®ã¯ããã« ãªããµã¼ãè² è·åæ£ãããã®ãï¼ ãµã¼ãè² è·åæ£ã®å®ç¾æ¹æ³ ãã¼ããã©ã³ãµã®ããæ§æ ãã¼ããã©ã³ãµã¯ãªã«ãå ã«åæ£ã
ããã«ã¡ã¯ã¹ã¨ããã§ãã ä»åã¯å¼ç¤¾ãæä¾ãã¦ããããã°ãµã¼ãã¹ãnowaã(ã㯠http://nowa.jp)ã®ä»çµã¿ããµã¼ãæ§æãä¸å¿ã«ç´¹ä»ãããã¨æãã¾ãã nowaã§ã¯ä¸è¬çãªããã°ãµã¼ãã¹è¦ç´ ã¨SNSè¦ç´ ã®æ©è½ãå®è£ ãã¦ãã¾ããå¼ç¤¾ã«ã¯å è¡ãã¦æä¾ãã¦ãããlivedoor Blogããããã¬ããã¨ãã£ã大è¦æ¨¡ãªãµã¼ãã¹ãããã¾ãã®ã§ããã¡ãã®éçºã»éç¨ã§åé¡ã«ãªã£ãç¹ãªã©ãåèã«ãã¤ã¤éçºãé²ãã¦ãã¾ããå ·ä½çã«ã¯ã¢ã¯ã»ã¹ã«ããè² è·ã¸ã®å¯¾çããã¼ã¿ãã¼ã¹ã®åæ£åãç»åã®ã¹ãã¬ã¼ã¸ã³ã°ãåé·æ§ãã¹ã±ã¼ã©ããªãã£ã¨ãã£ãç¹ã«ãªãã¾ãã - ãã¼ã¿ã«(nowa.jp)ãCMS(cms.nowa.jp) ã®ãµã¼ãæ§æ ãã¼ã¿ã«ãã¼ã¸(nowa.jp)ã¨CMSãã¼ã¸(cms.nowa.jp)ã¯ãéçãªãã¡ã¤ã«ã®ãªã¯ã¨ã¹ããæã+åçãªã³ã³ãã³ãã¸ã®ãªã¯ã¨ã¹ãããããã·ããããã³ããµã¼ã
ã´ã¼ã« è² è·åæ£ã®ããã¤ãã®æ¹æ³ã«é¢ãã¦ç解ãã mod_proxy_balancerã«ããè² è·åæ£ã¯ã©ã¹ã¿ãæ§ç¯ã§ãã åºç¤ç¥èç·¨ åºæ¬çãªè³æ 主ã«ã¯ã©ã¹ã¿ã«ããè² è·åæ£ã®è³æã - Apache ã¢ã¸ã¥ã¼ã« mod_proxy_balancer - mod_proxy_balancerã§ä¸?大è¦æ¨¡ãµã¼ãã¼éç¨ããã¨ãã®åæ - cyano ãã¨ç¤¾å¤ç§è³æã è² è·åæ£ï¼ è¤æ°å°ã®ãµã¼ãã«ã¢ã¯ã»ã¹ãåæ£ãã¦ãåã ã®ãµã¼ãã«ãããè² è·ãæ¸ãããå ¨ä½çã«å¦çã§ããã¢ã¯ã»ã¹ãå¢ãããã¨ã 以ä¸ã®ãããªã¢ããã¼ããããã DNSã©ã¦ã³ãããã³ DNSã§ã²ã¨ã¤ã®ãã¹ãåã«è¤æ°ã®IPã¢ãã¬ã¹ãå²ãå½ã¦ãæ¹æ³ ã·ã³ãã« ããããã¦ã³ãã¦ãããã¹ãã«ãã¢ã¯ã»ã¹ãæ¯ãåãããã¦ãã¾ã åé·åã¨ä½µç¨ã§ãªãã¨ããªãããªï¼ æ©è½ãã¨ã«ãã¹ããåå² ã¦ã§ããµã¼ãã¨DBãµã¼ãã®åå²ï¼åºæ¬éãããä¸å¿ãããè² è·åæ£ï¼
Kafka 101 This is a guest article by Stanislav Kozlovski, an Apache Kafka Committer. If you would like to connect with Stanislav, you can do so on Twitter and LinkedIn. Originally developed in LinkedIn during 2011, Apache Kafka is one of the most popular open-source Apache projects out there. So far it Capturing A Billion Emo(j)i-ons This blog post was written by Dedeepya Bonthu. This is a repost
Sunï¼ã¯ã©ã¹ã¿ãªã³ã°ã»ã½ãããSolaris ClusterãããOpen HA Clusterãã¨ãã¦OSSå ç±³Sun Microsystemsã¯ï¼ã¯ã©ã¹ã¿ãªã³ã°ã»ã½ããã¦ã¨ã¢ãSolaris Clusterãããªã¼ãã³ã½ã¼ã¹ã»ã½ããã¦ã¨ã¢ï¼OSSï¼ã®ãOpen High Availabilityï¼HAï¼Clusterãã¨ãã¦å ¬éãããSunãç±³å½æé6æ27æ¥ã«æããã«ãããã®ãåOSSã¯ï¼ãªã¼ãã³ã½ã¼ã¹ã»ã³ãã¥ããã£OpenSolarisã®Webãµã¤ãã§6ææ«ãã3段éã«åãï¼18ã«æããã¦é æ¬¡å ¬éãã¦ããã Open HA Clusterå ¬éã®ç¬¬1段éã§ã¯ï¼ã¯ã©ã¹ã¿å¯¾å¿ã¢ããªã±ã¼ã·ã§ã³ãåããã¨ã¼ã¸ã§ã³ãã®ã½ã¼ã¹ã³ã¼ããæä¾ãããç¨æããã¨ã¼ã¸ã§ã³ãã¯ãSolaris Containersãç¨ã®ã»ãï¼BEA WeblogicãPostgreSQLç¨ãOpen HA Cluste
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}