[B! mysql5.6] k-holyã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

k-holy id:k-holy

mysql5.6ã«é–¢ã™ã‚‹k-holyã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (7)

${{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}}

ã¾ã MySQL 5.5ã§æ¶ˆè€—ã—ã¦ã‚‹ã®ï¼ŸMySQL 5.6ã§ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‚»ãƒ¼ãƒ•ãªãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’æ´»ç”¨ã—ã¦æž•ã‚’é«˜ãã—ã¦çœ ã‚Œã‚‹æ—¥ã€…ã‚’æº€å–«ã™ã‚‹æ–¹æ³•
MySQL 5.6ãŒç™»å ´ã—ã¦ã‹ã‚‰ã‹ãªã‚Šã®æœˆæ—¥ãŒéŽãŽãŸãŒã€ä»–ã®ã“ã¨ã§å¤šå¿™ã ã£ãŸã›ã„ã‹ã€MySQL 5.6ã«ã¤ã„ã¦ã¯ã‚ã¾ã‚Šãƒ–ãƒã‚°ã§æƒ…å ±ã‚’ç™ºä¿¡ã—ã¦ã„ãªã„ã“ã¨ã«æ°—ãŒã¤ã„ãŸã€‚ã“ã‚Œã¯ã‚¤ã‚«ãƒ³ï¼ï¼ã¨æ€ã„ã€MySQL Casual Advent Calendar 2014ã«åˆã‚ã›ã¦ã€MySQL 5.6ã‚’ä½¿ç”¨ã™ã‚‹ä¸Šã§æœ€ã‚‚ã‚ªã‚¹ã‚¹ãƒ¡ã—ãŸã„æ©Ÿèƒ½ã§ã‚ã‚‹ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‚»ãƒ¼ãƒ•ãªãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ã¤ã„ã¦è§£èª¬ã—ã‚ˆã†ã¨æ€ã†ã€‚ã“ã®è¨˜äº‹ã¯16æ—¥ç›®ã®è¨˜äº‹ã§ã‚ã‚‹ã€‚ ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‚»ãƒ¼ãƒ•ã¨ã¯ã©ã†ã„ã†ã“ã¨ã‹ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‚»ãƒ¼ãƒ•ã¨ã¯ã€ä½•ã‚‰ã‹ã®äº‹æƒ…ã«ã‚ˆã‚Šã€ãƒ—ãƒã‚»ã‚¹ãŒãƒ€ã‚¦ãƒ³ã—ãŸã‚Šãƒžã‚·ãƒ³ãŒé›»æºã”ã¨è½ã¡ãŸã‚Šï¼ˆã¤ã¾ã‚Šã‚¯ãƒ©ãƒƒã‚·ãƒ¥ï¼‰ã—ã¦ã‚‚ã€å†èµ·å‹•å¾Œã«ä»¥å‰ã®çŠ¶æ…‹ã«æˆ»ã£ã¦å‡¦ç†ã‚’å†é–‹ã§ãã‚‹ã¨ã„ã†ã“ã¨ã ã€‚ãƒ‡ãƒ¼ã‚¿ã®ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ãƒªã‚«ãƒãƒªã§ã‚ã‚Œã°ã¿ãªã•ã‚“æ—¢ã«ã‚ˆãã”å˜çŸ¥ã§ã‚ã‚ã†ã€‚ï¼ˆREDOã‚„UNDOã™ã‚‹ã‚¢ãƒ¬ã®ã“ã¨ã ã€‚æœ¬ç¨¿ã§ã¯é¢å€’è‡ã„ãƒ»ãƒ»ãƒ»ã§ã¯ãªã‹ã£ãŸã€æœ¬é¡Œã§ã¯ãªã„ãŸ
k-holy 2014/12/16
mysql5.6

replication
ãƒªãƒ³ã‚¯
MySQLã®my.cnfãƒ•ã‚¡ã‚¤ãƒ«ã‚µãƒ³ãƒ—ãƒ«
MySQLã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚ŒãŸMySQLã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ä»¥ä¸‹ã®ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ åå‰ ãƒãƒ¼ã‚¸ãƒ§ãƒ³ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰å…ƒ my.cnfã‚µãƒ³ãƒ—ãƒ« ä»¥ä¸‹ã®ã‚µãƒ³ãƒ—ãƒ«ã‚’å‚ç…§ã—ã¦ã€my.cnfãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½œæˆã—ã¦ãã ã•ã„ã€‚ # ã“ã®ãƒ•ã‚¡ã‚¤ãƒ«ã¯ MySQL 5.6ã‚’åŸºæº–ã¨ã—ã¦ä½œã‚‰ã‚Œã¦ã‚ã‚Šã¾ã™ã€‚ # http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html ã‚’å‚ç…§ã—ã¾ã—ãŸã€‚ [mysqld] ##-------------------------------------------------------------------- # mysqldã®åŸºæœ¬è¨å®š ##-------------------------------------------------------------------- # id ã¯ 1 ã‹ã‚‰ 2^
k-holy 2014/05/14
mysql5.6
ãƒªãƒ³ã‚¯
MySQL5.6é–¢é€£æƒ…å ±ã¾ã¨ã‚
5. ãƒã‚°æƒ…å ±ãªã© ï‚— GTIDæœ‰åŠ¹ã§ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ãŒé€”åˆ‡ã‚Œã‚‹ã¨ãƒ‡ãƒ¼ã‚¿æ¶ˆå¤±ã™ã‚‹ ï‚— InnoDBmemcacheAPIã®ãƒ¡ãƒ¢ãƒªãƒªãƒ¼ã‚¯ï¼ˆ #68530 ï¼‰ ï‚— GRANTæ–‡ç™ºè¡Œæ™‚ã€æ§‹æ–‡ã«ç‰¹å®šã®è¨˜è¼‰ãƒŸã‚¹ãŒã‚ã‚‹ã¨ãƒ¬ãƒ—ãƒª ã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒåœæ¢ã™ã‚‹ï¼ˆ # 68892ï¼‰ ï‚— ãƒžãƒƒãƒã—ãªã„ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ãŒãŸãã•ã‚“ã‚ã‚‹å ´åˆã€äºˆæƒ³ã‚¹ ã‚ãƒ£ãƒ³ä»¶æ•°ã‚’éŽå‰°ã«ä½Žãè¦‹ç©ã‚‚ã£ã¦ã—ã¾ã†ä¸å…·åˆ â€»ä¸Šè¨˜ã¯å‹‰å¼·ä¼šã§è¦‹ã‹ã‘ãŸæƒ…å ±ãªã©ã§ã™ åƒ•ã‚‰ã®MySQL5.6ç§»è¡Œè¨˜(ä»®) http://www.slideshare.net/conmame/mysql56-27565355 7. é‹ç”¨æ–¹æ³•ã®å¤‰åŒ–ã«ã¤ã„ã¦ ï‚— GTIDãŒæœ‰åŠ¹ã ã¨Slaveã§ã‚¯ã‚¨ãƒªã‚’ã‚¹ã‚ãƒƒãƒ—ã§ããªããªã£ã¦ç¢ºèª ï‚— ï‚— ï‚— ï‚— ï‚— ï‚— ã—ã¦ç©ºã‚³ãƒŸãƒƒãƒˆã—ãªã„ã¨ã„ã‘ãªããªã£ãŸï¼ˆå‰²ã¨æ‰‹é–“ï¼‰ MySQL Utilityã¨ã„ã†pythonãƒ„ãƒ¼ãƒ«ãŒä¾¿åˆ©ãã† ãƒãƒƒãƒ•ã‚¡ãƒ—ãƒ¼ãƒ«ã®ãƒ€ãƒ³ãƒ—ã¨ãƒªã‚¹ãƒˆ
k-holy 2014/05/14
mysql5.6
ãƒªãƒ³ã‚¯
MySQL5.6ã§GTIDãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®å°Žå…¥æ‰‹é †ã¨è§£é™¤æ‰‹é † - FAT47ã®åº•è¾ºã‚¤ãƒ³ãƒ•ãƒ©è°äº‹éŒ²
MySQL5.6GAãŒå‡ºã¦ã‹ã‚‰å¤§åˆ†çµŒã£ã¡ã‚ƒã„ã¾ã—ãŸãŒã€ çš†æ§˜ãƒ—ãƒãƒ€ã‚¯ãƒˆç’°å¢ƒã§ã‚¬ãƒ³ã‚¬ãƒ³ä½¿ã£ã¦ãŠã‚Šã¾ã™ã§ã—ã‚‡ã†ã‹ã€‚ ä»Šæ›´ãªãŒã‚‰æ‰‹é †ã‚’æ•´ç†ã—ãŸã®ã§è¨˜è¿°ã—ã¦ãŠãã¾ã™ã€‚ â– GTIDã¨ã¯ Global Transaction Identifiers ä»Šã¾ã§ã®MySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§è¡Œãªã£ã¦ã„ãŸã€ã€ŒMasterã®binlogãƒ•ã‚¡ã‚¤ãƒ«å + ãƒã‚¸ã‚·ãƒ§ãƒ³ç•ªå·ã€ã«ã‚ˆã‚‹æƒ…å ±ã§ã¯ãªãã€ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã”ã¨ã«GTIDã‚’æŒãŸã›ã‚‹äº‹ã§ç®¡ç†ã§ãã‚‹ã‚ˆã†ã«ãªã‚‹ã¨ã„ã†æ©Ÿèƒ½ã§ã™ã€‚ mysqlfailoverã‚’åˆ©ç”¨ã™ã‚‹ã¨ã€ãƒžã‚¹ã‚¿ãƒ¼éšœå®³æ™‚ã«å„ã‚¹ãƒ¬ãƒ¼ãƒ–ã§æœ€ã‚‚é€²ã‚“ã§ã„ã‚‹GTIDã‚’æŒã¤ã‚¹ãƒ¬ãƒ¼ãƒ–ãŒãƒžã‚¹ã‚¿ãƒ¼ã«è‡ªå‹•æ˜‡æ ¼ã—ã¾ã™ã€‚ ãƒ»ãƒ¡ãƒªãƒƒãƒˆ ãƒ»CHANGE MASTERæ–‡ã‚’æ‰“ã¤éš›ã«ãƒã‚¸ã‚·ãƒ§ãƒ³ç•ªå·ã‚’æŒ‡å®šã—ãªãã¦ã‚ˆããªã‚‹ ãƒ»MySQL-MHAã‚’åˆ©ç”¨ã—ãªãã¦ã‚‚GTID+mysqlfailoverã§SPOFã‚’ãªãã›ã‚‹ ãƒ»ãƒ‡ãƒ¡ãƒªãƒƒãƒˆ ãƒ»æ…£ã‚Œã‚‹ã®ãŒå¤§
k-holy 2013/08/22
mysql5.6

replication
ãƒªãƒ³ã‚¯
conma.me
This domain may be for sale!
k-holy 2013/08/22
mysql5.6

replication
ãƒªãƒ³ã‚¯
MySQl 5.6æ–°æ©Ÿèƒ½è§£èª¬ï¼ ç¬¬ä¸€å›ž ä¸å›½åœ°æ–¹DBå‹‰å¼·ä¼š
1. MySQL 5.6MySQL 5.6 æ–°æ©Ÿèƒ½è§£èª¬æ–°æ©Ÿèƒ½è§£èª¬ å¥¥é‡Ž å¹¹ä¹Ÿ @nippondanji mikiya (dot) okuno (at) gmail (dot) com ï¼ ç¬¬ä¸€å›žã€€ä¸å›½åœ°æ–¹ DB å‹‰å¼·ä¼š 3. è‡ªå·±ç´¹ä»‹ â— MySQL ã‚µãƒãƒ¼ãƒˆã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ â€“ 2000 å¹´ã«ã‚µãƒ³ãƒ»ãƒžã‚¤ã‚¯ãƒã‚·ã‚¹ãƒ†ãƒ ã‚ºå…¥ç¤¾ â— ä¸»ã«ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã®ã‚µãƒãƒ¼ãƒˆã‚’æ‹…å½“ â€“ 2007 å¹´ã« MySQL KK ã¸è»¢è· â— æ°—ä»˜ãã¨ã¾ãŸã‚µãƒ³ãƒ»ãƒžã‚¤ã‚¯ãƒã‚·ã‚¹ãƒ†ãƒ ã‚ºã«ãƒ»ãƒ»ãƒ» â€“ ç¾åœ¨ã¯æ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«ã«åœ¨å¸ã€‚ â€“ ã‚µãƒãƒ¼ãƒˆä¸€ç‹ 13 å¹´ â— æ—¥ã€…ã®ã—ã”ã¨ â€“ MySQL ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°å…¨èˆ¬ â€“ Q&A å›žç” ãªã©
k-holy 2013/08/07
mysql5.6
ãƒªãƒ³ã‚¯
é–‹ç™ºã‚¹ãƒ”ãƒ¼ãƒ‰ã‚¢ã‚¯ã‚»ãƒ«å…¨é–‹ã¶ã£ã¡ãŽã‚Šï¼æ—¥æœ¬ã‚ˆã€ã“ã‚ŒãŒMySQL 5.6ã ãƒƒï¼ï¼
ç±³å›½ã§è¡Œã‚ã‚Œã¦ã„ã‚‹MySQL Connectã¨ã„ã†ã‚¤ãƒ™ãƒ³ãƒˆã§ã€ã¤ã„ã«MySQL 5.6 RCï¼ˆãƒªãƒªãƒ¼ã‚¹å€™è£œç‰ˆï¼‰ãŒç™ºè¡¨ã•ã‚ŒãŸã€‚ãƒªãƒªãƒ¼ã‚¹å€™è£œç‰ˆã¨ã„ã†ã“ã¨ã¯ã€ã“ã‚ŒãŒæ¬¡ã®æ£å¼ç‰ˆã«ãªã‚‹ã¨ã„ã†ã“ã¨ã ã€‚MySQL 5.5ã¯5.1ã‹ã‚‰å‡„ã¾ã˜ã„é€²åŒ–ã‚’é‚ã’ãŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã‚ã£ãŸã€‚ã ãŒã€MySQL 5.6ã¯ã•ã‚‰ã«ãã‚Œã‚’ä¸Šå›žã‚‹é€²åŒ–ã‚’é‚ã’ã¦ã„ã‚‹ï¼æ£ç›´ã“ã“ã¾ã§ã®é€²åŒ–ã‚’èª°ãŒäºˆæƒ³ã—ãŸã ã‚ã†ã‹ã€ã„ã‚„èª°ã‚‚å‡ºæ¥ãªã‹ã£ãŸã§ã‚ã‚ã†ã€‚ã“ã‚Œã¾ã§ã€Î±ç‰ˆãŒå‡ºãŸã¨ãã‹ã‚‰ä½•åº¦ã‹æ–°æ©Ÿèƒ½ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¦ããŸãŒã€ä»Šå›žæ”¹ã‚ã¦MySQL 5.6ã®æ–°æ©Ÿèƒ½ã‚’æŒ¯ã‚Šè¿”ã£ã¦ã¿ã‚ˆã†ã¨æ€ã†ã€‚ã™ã¹ã¦ã¾ã¨ã‚ã‚‹ã¨ã‚‚ã®å‡„ã„å†…å®¹ã ã€‚èˆˆå¥®ã—ã¦å¤œã‚‚çœ ã‚Œãªããªã‚‹ã“ã¨è«‹ã‘åˆã„ã ã€‚MySQLã®é€²åŒ–ãŒæ¢ã¾ã‚‹ã®ã§ã¯ï¼Ÿãªã©ã¨ã„ã†å¿ƒé…ã¯å¹ãé£›ã³ã€ã‚‚ã¯ã‚„ã‚‚ã†ã¡ã‚‡ã£ã¨å°å‡ºã—ã«ã—ãªãã¦è‰¯ã‹ã£ãŸã®ã‹ï¼Ÿã¨å¿ƒé…ã—ã¦ã—ã¾ã†ãƒ¬ãƒ™ãƒ«ã§ã‚ã‚‹ã€‚ ãã‚Œã§ã¯MySQL 5.6ã®æ–°æ©Ÿèƒ½ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¦ã„ã“ã†ã€‚ InnoDB
k-holy 2012/10/01
FULLTEXTã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ã„ã„ãªã‚

mysql5.6
ãƒªãƒ³ã‚¯
1