HAProxy 㧠MySQL ã®ãƒ˜ãƒ«ã‚¹ãƒã‚§ãƒƒã‚¯ã‚’ã¡ã‚‡ã£ã¨ä¾¿åˆ©ã«ã™ã‚‹ - 酒日記 ã¯ã¦ãªæ”¯åº—MySQL 㧠slave を複数å°ç«‹ã¦ã¦å‚照分散ã™ã‚‹ã«ã¯ã€HAProxy を利用ã—ã¦ãƒãƒ¼ãƒ‰ãƒãƒ©ãƒ³ã‚¹ã¨åˆ‡ã‚Šé›¢ã—ã‚’è¡Œã†ã¨æ‰‹è»½ã«ä½¿ãˆã¦ä¾¿åˆ©ã§ã™ã€‚ option mysql-check ã¨ã„ã†è¨å®šã§ã€HAProxy 自身㌠mysqld ã«æŽ¥ç¶šã—ã¦ãƒ˜ãƒ«ã‚¹ãƒã‚§ãƒƒã‚¯ãŒå¯èƒ½ã§ã™ã€‚ listen mysql-slave bind 127.0.0.1:3307 mode tcp option mysql-check user haproxy balance roundrobin server slave1 192.168.1.11 check server slave2 192.168.1.12 check server slave3 192.168.1.13 checkãªã®ã§ã™ãŒã€ã“ã®è¨å®šã ã¨ä»¥ä¸‹ã®ã‚ˆã†ã«å°‘々ä¸ä¾¿ãªã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ mysqldã«æŽ¥ç¶šã§ãã‚‹ã‹ã©ã†ã‹ã®ã¿ã‚’æ»æ´»ã®åˆ¤æ–ã«ã—ã¦ã„ã‚‹ã®ã§ã€ãƒ¬ãƒ—リケ
{{#tags}}- {{label}}
{{/tags}}