[B! MySQL] comeonlyã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

comeonly id:comeonly

MySQLã«é–¢ã™ã‚‹comeonlyã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

ããƒ¼ã ã„ãªã‚‹ã‚‰ããŒãå¸³: 2å¤§OSSãƒ†ã‚™ãƒ¼ã‚¿ãƒ˜ã‚™ãƒ¼ã‚¹ã®MySQLã¨PostgreSQLã®é•ã„ã«ã¤ã„ã¦è©±ã—ã¦ããŸ
ç¬¬32å›ž PostgreSQL å‹‰å¼·ä¼š(2015å¹´10æœˆ10æ—¥)ã§ç™»å£‡ã—ã¦ãã¾ã—ãŸã€‚ å†…å®¹ã¯å‰ã«æ›¸ã„ãŸã‚¨ãƒ³ãƒˆãƒªãƒ¼ã® MySQLä½¿ã„ãŒçŸ¥ã‚‹ã¹ãPostgreSQLã¨ã®é•ã„ã¨å¤‰ã‚ã‚‰ãªã„ä¸€ã¤ã®ã“ã¨ MySQLä½¿ã„ã®äººãŒPostgreSQLã‚’å§‹ã‚ã‚‹ã¨ãã®ç½ ã‚’ã¾ã¨ã‚ã¦ã¿ãŸ ã‚’å…ƒã«ç™ºè¡¨ã—ã¦ãã¾ã—ãŸã€‚ ã¨è¨€ã£ã¦ã‚‚ä»Šå›žã¯å‚åŠ è€…ãŒPostgresSQLã«è©³ã—ã„å‰æã ã£ãŸã®ã§MySQLã‚’ä¸å¿ƒã«è©±ã‚’ã—ã¾ã—ãŸã€‚ å®Ÿéš›ã®è³‡æ–™ã¯ä¸‹è¨˜ã®ã¨ãŠã‚Šã§ã™ã€‚ å½“æ—¥ã¯ãƒ“ãƒ‡ã‚ªæ’®å½±ãŒã‚ã£ãŸã®ã§ãã®ã†ã¡å‹•ç”»ãŒä¸ŠãŒã‚‹ã¨æ€ã„ã¾ã™ã€‚ ç¬¬32å›ž PostgreSQL å‹‰å¼·ä¼šã¾ã¨ã‚ ~ togetter ~ æµçŸ³ã«ï¼’æ™‚é–“ã¯ç–²ã‚Œã¾ã—ãŸã€‚ å†…å®¹ã¨ã—ã¦ã¯çœ ããªã‚‰ãªã„ã‚ˆã†ã«é¢ç™½ãŠã‹ã—ãä¼ãˆã‚ˆã†ã¨æ€ã£ãŸã®ã§ã™ãŒãªã‹ãªã‹é›£ã—ã‹ã£ãŸã§ã™ã€‚ å‰åŠã¯MySQLã¨PostgreSQLã®æ–¹å‘æ€§ã®é•ã„ã‚’ãƒ¡ã‚¤ãƒ³ã«ã—ã¾ã—ãŸã€‚ å¾ŒåŠã¯MySQLã¯åƒ•ãŒå®Ÿéš›ã«ãƒãƒžã£ãŸäº‹ãªã©ã‚’ãƒ¡ã‚¤
comeonly 2015/10/13
PostgreSQL

MySQL
ãƒªãƒ³ã‚¯
MySQL ã‚’ MHA + HAProxy ã§å†—é•·åŒ–ã—ã¦ã¿ã‚ˆã†
æ–Žè—¤ã§ã™ã€‚ã“ã‚“ã«ã¡ã¯ã€‚ ä»Šæ—¥ã¯ã€MySQLã«ã¦ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ§‹æˆã«ãŠã„ã¦ã€ãƒžã‚¹ã‚¿ã‚µãƒ¼ãƒã®ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ã‚’å¸ã‚‹mysql-master-ha(ä»¥ä¸‹ã€MHA)ã‚’ç”¨ã„ã‚‹éš›ã€ãƒžã‚¹ã‚¿ã‚µãƒ¼ãƒæŽ¥ç¶šå…ˆã®åˆ‡ã‚Šæ›¿ãˆã«HAProxyã‚’ä½¿ã£ã¦ã¿ã‚ˆã†ã¨ã„ã†ãŠè©±ã§ã™ã€‚ â€»MHAã¯0.53.0(å…¬å¼ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸)ã€MySQLã¯5.5.25a(Oracleå…¬å¼ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸)ã€HAProxyã¯1.4.22(CentOS6æ¨™æº–ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸)ã€OSã¯CentOS 6.3 x86_64ã‚’ç”¨ã„ã¾ã—ãŸã€‚ â€»MHAã«ã‚ˆã‚‹å†—é•·åŒ–ãŠã‚ˆã³HAProxyã«ã‚ˆã‚‹MySQLã®è² è·åˆ†æ•£ã®è¨å®šã‚’çµŒé¨“ã•ã‚ŒãŸäº‹ãŒã‚ã‚‹å‰æã§è¨˜è¿°ã—ã¾ã™ã€‚ æœ¬è¨˜äº‹ã§ã¯ã€æ¬¡ã®æµã‚Œã§è©±é¡Œã‚’å±•é–‹ã—ã¾ã™ã€‚ ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼æ™‚ã®æŽ¥ç¶šå…ˆåˆ‡ã‚Šæ›¿ãˆæ–¹æ³• æ§‹æˆ(å‚è€ƒ) ãªãœHAProxyãªã®ã‹ åˆ‡ã‚Šæ›¿ãˆæ–¹ 2å°æ§‹æˆã®å•é¡Œç‚¹ ãã®ä»– ã‚³ãƒ„ è¨å®š(å‚è€ƒ) ä¸»ã«MHA+HAProxyã«ã‚ˆã‚‹ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼
comeonly 2013/10/28
MySQL

å†—é•·åŒ–

haproxy

aws
ãƒªãƒ³ã‚¯
FacebookãŒä½•åƒå°ã‚‚ã®MySQLã‚’äººæ‰‹ã‚’ä½¿ã‚ãšè‡ªå¾‹ç®¡ç†ã™ã‚‹ä»•çµ„ã¿ã€ŒMySQL Pool Scannerï¼ˆMPSï¼‰ã€
ãŠãã‚‰ãä¸–ç•Œã§ã‚‚ã£ã¨ã‚‚å¤§è¦æ¨¡ã«MySQLã®ã‚¯ãƒ©ã‚¹ã‚¿ã‚’å±•é–‹ã—ã€é‹ç”¨ã—ã¦ã„ã‚‹ã®ãŒFacebookã§ã—ã‚‡ã†ã€‚è¤‡æ•°ã®ãƒ‡ãƒ¼ã‚¿ã‚»ãƒ³ã‚¿ãƒ¼ã«ã¾ãŸãŒã‚Šä½•åƒå°ã‚‚ã®MySQLã‚µãƒ¼ãƒã‚’é‹ç”¨ã™ã‚‹ãŸã‚ã«ã€è‡ªå‹•åŒ–ã®ä»•çµ„ã¿ã¯æ¬ ã‹ã›ã¾ã›ã‚“ã€‚ ãã®è‡ªå‹•åŒ–ãŒã©ã®ã‚ˆã†ãªä»•çµ„ã¿ã«ãªã£ã¦ã„ã‚‹ã®ã‹ã€‚Facebookã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã‚ã‚‹Shlomo Priymakæ°ãŒã€Under the hood: MySQL Pool Scanner (MPS)ã¨ã„ã†è¨˜äº‹ã‚’Facebookã§å…¬é–‹ã—ã¦ã„ã¾ã™ã€‚ ã‹ãªã‚Šé•·ã„è¨˜äº‹ãªã®ã§ã€ã“ã“ã§ã¯ãã®ãƒã‚¤ãƒ³ãƒˆã‚’ã¾ã¨ã‚ã¦è§£èª¬ã—ã¦ã¿ã¾ã—ãŸã€‚è©³ç´°ã¯ãœã²åŽŸæ–‡ã‚’ã‚ãŸã£ã¦ã¿ã¦ãã ã•ã„ã€‚ MPSã®ãŠã‚‚ãª3ã¤ã®æ©Ÿèƒ½ Facebookã§ç¨¼åƒã—ã¦ã„ã‚‹MySQLã¯ã€ã¤ãã«1ã¤ã®ãƒžã‚¹ã‚¿ãƒ¼ã¨ãã“ã‹ã‚‰ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã•ã‚ŒãŸè¤‡æ•°ã®ã‚¹ãƒ¬ãƒ¼ãƒ–ã«ã‚ˆã‚‹ãƒ¬ãƒ—ãƒªã‚«ã‚»ãƒƒãƒˆã‚’æ§‹æˆã—ã¦ã„ã¾ã™ã€‚ã“ã®ãƒ¬ãƒ—ãƒªã‚«ã‚»ãƒƒãƒˆã®æ§‹é€ ã‚’ç¶æŒã—ç¶šã‘ã‚‹ã“ã¨ã§ã€å¯ç”¨æ€§ã¨
comeonly 2013/10/28
MySQL

Facebook

è‡ªå‹•åŒ–
ãƒªãƒ³ã‚¯
MySQL Bootcamp â€” MySQL Bootcamp 2013 documentation
MySQL BootcampÂ¶ This document is for programmers new to MySQL. Contents:
comeonly 2013/06/20
MySQL

tutorial
ãƒªãƒ³ã‚¯
Rails ã§ã€Controller ã«å®šç¾©ã•ã‚Œã¦ã„ã‚‹ action ã‚’ä¸€åº¦ã«å–å¾—ã™ã‚‹æ–¹æ³•ã¯ã‚ã‚Šã¾ã™ã‹ï¼Ÿ - QA@IT
å¹³ç´ ã‚ˆã‚ŠQAï¼ ITã‚’ã”åˆ©ç”¨ã„ãŸã ãã€èª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ QAï¼ ITã¯ã€Œè³ªå•ã‚„å›žç”ã‚’ã€Žå…±æœ‰ã€ã—ã€Žç·¨é›†ã€ã—ã¦ã„ãã“ã¨ã§ãƒ™ã‚¹ãƒˆãªQAã‚’è“„ç©ã§ãã‚‹ã€IT ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã®å•é¡Œè§£æ±ºã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ã€ã¨ã—ã¦ç´„7å¹´é–“é‹å–¶ã‚’ã—ã¦ãã¾ã—ãŸã€‚ã“ã‚Œã¾ã§ã‚µãƒ¼ãƒ“ã‚¹ã‚’ç¶šã‘ã‚‹ã“ã¨ãŒã§ããŸã®ã¯ã€QAï¼ ITã®ã‚³ãƒ³ã‚»ãƒ—ãƒˆã«å…±æ„Ÿã‚’ã„ãŸã ãã€é©åˆ‡ãªè³ªå•ã‚„å›žç”ã‚’ãŠå¯„ã›ã„ãŸã ã„ãŸçš†ã•ã¾ã®ã”æ”¯æ´ãŒã‚ã£ãŸã‹ã‚‰ã“ãã¨è€ƒãˆã¦ãŠã‚Šã¾ã™ã€‚é‡ãã¦å¾¡ç¤¼ç”³ã—ä¸Šã’ã¾ã™ã€‚ ã—ã‹ã—ãªãŒã‚‰ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æƒ…å ±å…¥æ‰‹æ–¹æ³•ã®å¤šæ§˜åŒ–ã‚„QAã‚µãƒ¼ãƒ“ã‚¹å¸‚å ´ã®çŠ¶æ³ã€ï¼ ITã®ä»Šå¾Œã®ãƒ¡ãƒ‡ã‚£ã‚¢é‹å–¶æ–¹é‡ãªã©ã‚’æ¤œè¨Žã—ãŸçµæžœã€2020å¹´2æœˆ28æ—¥ï¼ˆé‡‘ï¼‰15:00ã‚’ã‚‚ã¡ã¾ã—ã¦QAï¼ ITã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã™ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ã“ã‚Œã¾ã§ã”åˆ©ç”¨ã‚’ã„ãŸã ãã¾ã—ãŸçš†ã•ã¾ã«ã¯æ®‹å¿µãªãŠçŸ¥ã‚‰ã›ã¨ãªã‚Šã€èª ã«å¿ƒè‹¦ã—ãæ€ã£ã¦ãŠã‚Šã¾ã™ã€‚ä½•ã¨ãžã€ã”ç†è§£ã‚’ã„ãŸã ã‘ã¾ã™ã¨å¹¸ã„ã§ã™ã€‚ QAï¼ ITã®7å¹´é–“ã§çš†ã•ã¾ã®çŸ¥è˜
comeonly 2012/09/13
PostgreSQL

MySQL

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
1