[B! mysql] pero1ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

pero1 id:pero1

mysqlã«é–¢ã™ã‚‹pero1ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (63)

${{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 8.1ã‚·ãƒªãƒ¼ã‚ºã«ãŠã‘ã‚‹InnoDB Clusterã¨ãƒªãƒ¼ãƒ‰ãƒ¬ãƒ—ãƒªã‚«ã®èžåˆï¼ˆãŸã ã—MySQL Serverã¯8.0ã§OKï¼‰
MySQL æœ¬ä½“ã®æ–°æ©Ÿèƒ½ã§ã¯ãªã„ã®ã ãŒã€MySQL Shellã¨MySQL Routerã®ã‚¤ãƒŽãƒ™ãƒ¼ã‚·ãƒ§ãƒ³ãƒªãƒªãƒ¼ã‚¹ï¼ˆãƒãƒ¼ã‚¸ãƒ§ãƒ³8.1ï¼‰ã«ã‚ˆã‚ŠInnoDB Clusterã«å¯¾ã—ã¦ãƒªãƒ¼ãƒ‰ãƒ¬ãƒ—ãƒªã‚«ã‚’è¿½åŠ ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã‚ˆã†ã«ãªã£ãŸã®ã§ã€ä»Šå›žã¯ãã®ã“ã¨ã«ã¤ã„ã¦è§£èª¬ã‚’ã—ã¦ã„ã“ã†ã¨æ€ã†ã€‚ InnoDB Clusterã¨ã¯ ã“ã®ãƒ–ãƒã‚°ã§ã¯InnoDB Clusterã¨ã¯ä½•ã‹ã¨ã„ã†ã“ã¨ã‚’ãã‚‚ãã‚‚ã¾ã è§£èª¬ã—ã¦ã„ãªã‹ã£ãŸã‚ˆã†ã«æ€ã†ã€‚è©³ã—ã„ã“ã¨ã¯ãŠã„ãŠã„åˆ¥ã®æŠ•ç¨¿ã§è§¦ã‚ŒãŸã„ã¨æ€ã†ãŒã€InnoDB Clusterã¨ã„ã†ã®ã¯MySQL Serverã®ã‚°ãƒ«ãƒ¼ãƒ—ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’æ ¸ã«ã—ãŸã‚¯ãƒ©ã‚¹ã‚¿ãƒªãƒ³ã‚°æ©Ÿèƒ½ã®ã“ã¨ã ã€‚MySQL Shellã‚’ç”¨ã„ã¦ã‹ã‚“ãŸã‚“ã«æ§‹ç¯‰ã§ãã€ãªãŠã‹ã¤MySQL Routerã‚’ä»‹ã—ã¦æŽ¥ç¶šã™ã‚‹ã“ã¨ã«ã‚ˆã‚Šã€ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹éšœå®³ãŒç”Ÿã˜ãŸã¨ãã«è‡ªå‹•çš„ã«æŽ¥ç¶šå…ˆã‚’æŒ¯ã‚Šæ›¿ãˆã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ã‚¤ãƒ¡ãƒ¼ã‚¸çš„ã«ã¯ã“ã‚“ãªæ„Ÿã˜ã€‚ ã‚°ãƒ«ãƒ¼
pero1 2023/11/09
mysql

db
ãƒªãƒ³ã‚¯
MySQLã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—é‹ç”¨ã«ã¤ã„ã¦è‰²ã€…
12. ã‚¹ãƒ†ãƒƒãƒ—çš„ãªã‚‚ã® ã‚µã‚¤ã‚º ä½¿ã„ã©ã“ã‚ ã‚³ãƒžãƒ³ãƒ‰ä¾‹ ãƒ•ãƒ«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— ã§ã‹ã„ å¿…ãšå¿…è¦ tar, rsync, mysqldump, XtraBackup å·®åˆ†ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— â¼©ã•ã„ ãƒ•ãƒ«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã® é–“éš”ãŒçŸã‘ã‚Œã°è¦ã‚‰ ãªã„ mysqldump(ã‚¹ã‚ãƒ¼ ãƒžã«åˆ¶ç´„) XtraBackup å¢—åˆ†ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— æ›´æ–°é‡ã«ä¾å˜ ã»ã¼é–“é•ã„ãªãå¿…è¦ cp, rsync, mysqlbinlog 11/58 14. ãƒ•ãƒ«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®é¸æŠžè‚¢ ã‚³ãƒžãƒ³ãƒ‰ ã‚¨ãƒ³ã‚¸ãƒ³ ã‚¢ãƒ—ãƒªå½±éŸ¿ â½…å¼ ã‚µã‚¤ã‚º tar, rsync MyISAM Ã— åœâ½Œã¾ãŸã¯ãƒãƒƒ ã‚¯ ç‰©ç† â¼¤ãã‚ tar, rsync InnoDB Ã— mysqldåœâ½Œ ç‰©ç† â¼¤ãã‚ LVMã‚¹ãƒŠãƒƒãƒ— ã‚·ãƒ§ãƒƒãƒˆ MyISAM InnoDB â–³ æ€§èƒ½åŠ£åŒ–ãŒã²ã© ã„ ç‰©ç† â¼¤ãã‚ mysqldump MyISAM Ã— ãƒãƒƒã‚¯ è«–ç† â¼©ã•ã‚ mysqldum
pero1 2015/03/02
mysql
ãƒªãƒ³ã‚¯
MySQLãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é‹ç”¨ãŒåŠ‡çš„å¤‰åŒ–ï¼ï¼GTIDã«ã¤ã„ã¦ä»•çµ„ã¿ã‹ã‚‰ç†è§£ã™ã‚‹
ãƒ¡ãƒªãƒ¼ã‚¯ãƒªã‚¹ãƒžã‚¹ï¼ï¼ã‚„ã‚ã€è‰¯ã„åã®ã¿ã‚“ãªï¼ï¼ã‚µãƒ³ã‚¿ã‚¯ãƒãƒ¼ã‚¹ãƒ»ãƒ»ãƒ»ã§ã¯ãªãã€ãƒ’ã‚²ãƒ¢ã‚¸ãƒ£ã‚®ãƒ¼ã‚¯ã‹ã‚‰ã®ã‚¯ãƒªã‚¹ãƒžã‚¹ãƒ—ãƒ¬ã‚¼ãƒ³ãƒˆã ã‚ˆï¼ï¼ ã¨ã„ã†ã‚ã‘ã§ã€MySQL Casual Advent Calendarã®25æ—¥ç›®ã§ã‚ã‚‹ã€‚ä»ŠæœAdvent Calendarã‚’è¦—ã„ã¦ã¿ã‚‹ã¨ã€æœ¬æ—¥åˆ†ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ãŒç„¡ã‹ã£ãŸã®ã§ã€æ€¥é½æ›¸ãã“ã¨ã«ã—ãŸã€‚Advent Calendaræœ€å¾Œã®æ—¥ã€ã‚¯ãƒªã‚¹ãƒžã‚¹ã‚’é£¾ã‚‹è¨˜äº‹ã®ãƒ†ãƒ¼ãƒžã¯GTIDã ã€‚ å‰å›žã®æŠ•ç¨¿ã§ã¯ã€MySQL 5.6ã®ç›®çŽ‰æ©Ÿèƒ½ã¨ã—ã¦ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‚»ãƒ¼ãƒ•ã«ãªã£ãŸã“ã¨ã‚’æŒ™ã’ãŸã€‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¾ã‚ã‚Šã§è¨€ãˆã°ã€ã‚‚ã†ã²ã¨ã¤å¤–ã›ãªã„ç›®çŽ‰æ©Ÿèƒ½ãŒã‚ã‚‹ã€‚ãã‚ŒãŒGTIDï¼ˆGlobal Transaction IDï¼‰ã§ã‚ã‚‹ã€‚ GTIDã¯è‰¯ãã‚‚æ‚ªãã‚‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é‹ç”¨ã‚’å¤‰åŒ–ã•ã›ã‚‹ã€‚GTIDã‚’ä½¿ã†ã“ã¨ã«ã‚ˆã£ã¦å¾—ã‚‰ã‚Œã‚‹æœ€å¤§ã®ãƒ¡ãƒªãƒƒãƒˆã¯ã€CHANGE MASTER TOã§ãƒã‚¤ãƒŠãƒªãƒ
pero1 2014/12/31
mysql
ãƒªãƒ³ã‚¯
SQLã®è¦³ç‚¹ã‹ã‚‰ã€ŒOracle Databaseã€ã€ŒPostgreSQLã€ ã€ŒMySQLã€ã®ç‰¹å¾´ã‚’æ•´ç†ã—ã‚ˆã†ï¼
EnterpriseZineï¼ˆã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºã‚¸ãƒ³ï¼‰ç·¨é›†éƒ¨ã§ã¯ã€æƒ…å ±ã‚·ã‚¹ãƒ†ãƒ æ‹…å½“ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£æ‹…å½“ã®æ–¹ã€…å‘ã‘ã«ã€EnterpriseZine Dayã€Security Online Dayã€DataTechã¨ã„ã†ã€3ã¤ã®ã‚¤ãƒ™ãƒ³ãƒˆã‚’é–‹å‚¬ã—ã¦ãŠã‚Šã¾ã™ã€‚ãã‚Œãžã‚Œç·¨é›†éƒ¨ç‹¬è‡ªã®åˆ‡ã‚Šå£ã§ã€æ¥ç•Œãƒˆãƒ¬ãƒ³ãƒ‰ã‚„æœ€æ–°äº‹ä¾‹ã‚’ç¶²ç¾…ã€‚æœ€æ–°ã®å‹•å‘ã‚’çŸ¥ã‚‹ã“ã¨ãŒã§ãã‚‹å ´ã¨ã—ã¦ã€å¥½è©•ã‚’å¾—ã¦ã„ã¾ã™ã€‚
pero1 2014/10/07
db

mysql

postgresql
ãƒªãƒ³ã‚¯
Open database life
æœ€è¿‘ç™ºå£²ã•ã‚ŒãŸæŠ€è¡“è©•è«–ç¤¾ã®ãƒ ãƒƒã‚¯ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å¾¹åº•æ”»ç•¥ã€ã«å¯„ç¨¿ã—ã¾ã—ãŸã€‚ ã“ã®æœ¬ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãŸã‚ã®æœ¬ã¨ã„ã†ã“ã¨ã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã€SQLã€MySQLã€Redisã€Mongo DBã€Redshiftã¨ã„ã†ä»£è¡¨çš„ãªè¦ç´ æŠ€è¡“ã«ã¤ã„ã¦ã®ã¾ã¨ã‚ã¨ãªã£ã¦ã„ã¾ã™ã€‚å„ãƒ—ãƒãƒ€ã‚¯ãƒˆ(MySQLã€Redisã€Mongo DBã€Redshift)ã«ã¤ã„ã¦ã¯ã€ç¾å ´ã§å®Ÿéš›ã«æœ¬æ ¼çš„ã«ä½¿ã‚ã‚Œã¦ã„ã‚‹æ–¹ã€…ã«ã‚ˆã‚‹è¨˜äº‹ãªã®ã§å¤§ã„ã«å‚è€ƒã«ãªã‚‹ã¨æ€ã„ã¾ã™ã€‚ ç§ã¯å†’é ã®ã¾ã¨ã‚è¨˜äº‹ã‚’å¯„ç¨¿ã—ã¾ã—ãŸã€‚è©³ç´°ã¯ãœã²ãŠæ‰‹ã«å–ã£ã¦èªã‚“ã§ãã ã•ã‚Œã°ã¨æ€ã„ã¾ã™ã€‚ã“ã“ã§ã‚‚è‡ªåˆ†ãŒå„æŠ€è¡“ã‚’ç¾æ™‚ç‚¹ã§ã©ã®ã‚ˆã†ã«ã¨ã‚‰ãˆã¦ã„ã‚‹ã‹ã€æœ¬ã§ã¯ã„ã•ã•ã‹æ›¸ãã¥ã‚‰ã„å†…å®¹ã«ã¤ã„ã¦ã€æœ€è¿‘æµè¡Œã‚Šã®è¨€è‘‰ã§ã‚‚ã‚ã‚‹ã€ŒæŠ€è¡“çš„è² å‚µã€ã¨ã„ã†è¦³ç‚¹ã‚‚è¸ã¾ãˆã¦æ›¸ã„ã¦ãŠã“ã†ã¨æ€ã„ã¾ã™ã€‚ ãƒ»MySQL (RDBMS) ç§ã¯MySQLã®ä¸ã®äººã§ã‚‚ã‚ã‚Šã¾ã—ãŸã—ã€ã“ã‚Œã¾ã§è‡³ã‚‹ã¨ã“ã‚ã§è©±ã—ã¦ããŸã®ã§çœç•¥ã—ã¾ã™
pero1 2014/09/23
mysql
ãƒªãƒ³ã‚¯
CentOSã§MySQL5.5ã„ã‚Œã¦ãƒžãƒ«ãƒãƒžã‚¹ã‚¿ãƒ¼ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³çµ„ã‚€ã¾ã§ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
pero1 2014/05/17
linux

centos

mysql
ãƒªãƒ³ã‚¯
MySQLã§å‡¦ç†ã«é•·æ™‚é–“ã‹ã‹ã£ã¦ã„ã‚‹è¤‡æ•°ã‚¯ã‚¨ãƒªã‚’ã¾ã¨ã‚ã¦æ®ºã™æ–¹æ³• | Basicinc Enjoy Hacking!
ã‚ã¾ã‚Šã«ã‚‚å‡¦ç†ã«æ™‚é–“ãŒã‹ã‹ã‚‹ã‚ˆã†ãªSQLã‚’å®Ÿè¡Œã—ã¦ã—ã¾ã„ã€MySQLãŒã†ã‚“ã¨ã‚‚ã™ã‚“ã¨ã‚‚è¨€ã‚ãªããªã£ã¦ã—ã¾ã†ã‚ˆã†ãªçŠ¶æ³ã€ã‚ˆãã‚ã‚Šã¾ã™ã‚ˆãã€‚ã£ã¦ã„ã†ã‹ã€ã¾ããã‚“ãªçŠ¶æ³ã‚ã£ã¦ã¯ãªã‚‰ãªã„ã‚“ã§ã™ãŒã€æ™‚ãŸã¾ã‚ã‚Šã¾ã™ã€‚ãã‚“ãªæ™‚ã€å•é¡Œã¨ãªã£ã¦ã„ã‚‹ã‚¯ã‚¨ãƒªã®å‡¦ç†ã‚’æ¢ã‚ãŸã„ã‚ã‘ã§ã™ã€‚ ç‰¹å®šã®ã‚¯ã‚¨ãƒªã‚’æ¢ã‚ã‚‹æ–¹æ³• MySQLã§å®Ÿè¡Œä¸ã®ã‚¯ã‚¨ãƒªä¸€è¦§ã‚’è¦‹ã¦ã€SQLã‚’å¼·åˆ¶çµ‚äº†ã™ã‚‹æ–¹æ³• ã“ã¡ã‚‰ã‚’è¦‹ã¦ã‚‚ã‚‰ãˆã‚Œã°ã‚„ã‚Šæ–¹ã¯åˆ†ã‹ã‚Šã¾ã™ã€‚å˜ç´”ã«MySQLã«å…¥ã£ã¦ã€show processlist;ã§å•é¡Œã®ã‚ã‚‹ã‚¯ã‚¨ãƒªã‚’ç™ºè¦‹ã—ã€ãƒ—ãƒã‚»ã‚¹IDã‚’ kill ã™ã‚‹ã ã‘ã€‚ã¨ã¦ã‚‚ç°¡å˜ã€‚ è¤‡æ•°ã®ã‚¯ã‚¨ãƒªã‚’ä¸€æ‹¬ã§æ¢ã‚ã‚‹æ–¹æ³• ä»Šå›žã¯å•é¡Œã®ã‚ã‚‹ã‚¯ã‚¨ãƒªãŒ100å€‹ã‚ã£ãŸã‚‰ã©ã†ã™ã‚‹â€¦ï¼Ÿçš„ãªã®ã‚’è§£æ±ºã™ã‚‹ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã§ã™ã€‚ã¾ãã€å•é¡Œã‚ã‚‹ã‚¯ã‚¨ãƒª100å€‹ã‚ã‚‹çŠ¶æ³ã¯ã€ã‚¢ãƒ—ãƒªçš„ã«å•é¡Œã‚ã‚‹ã‚“ã˜ã‚ƒãï¼Ÿã£ã¦ã„ã†ãƒ¬ãƒ™ãƒ«ã§ã™ãŒã€‚ 1å€‹ãšã¤ãƒ—ãƒã‚»ã‚¹IDã‚’ã‚³ãƒ”ãƒšã—ã¦â€¦ãªã‚“ã¦ã‚„ã£ã¦ã‚‰ã‚Œãªã„ã§ã™
pero1 2014/04/27
mysql

db
ãƒªãƒ³ã‚¯
DBè¨è¨ˆã®é›£ã—ã•
ä»Šæ—¥ã¯å¾’ç„¶ãªã‚‹ã¾ã¾ã«DBè¨è¨ˆã«ã¤ã„ã¦æ€ã£ã¦ã„ã‚‹ã“ã¨ã‚’ä¸¦ã¹ã¦ã¿ã‚ˆã†ã¨æ€ã†ã€‚ ã‚ˆã†ã‚„ãWEB+DB Pressã®æ¬¡å·ã®åŽŸç¨¿ã‚’æ›¸ãçµ‚ãˆãŸã€‚2å¹´é–“ã®é€£è¼‰ã§ã‚ã‚‹ãŒã€æ¥å¹´ã¯ãƒ—ãƒ©ã‚¤ãƒ™ãƒ¼ãƒˆãŒå¿™ã—ããªã‚‹äºˆå®šãªã®ã§ã€é€£è¼‰ã¯ã“ã‚Œã«ã¦çµ‚äº†ã¨ã•ã›ã¦ã‚‚ã‚‰ã†ã¤ã‚‚ã‚Šã§ã‚ã‚‹ã€‚ ã€Œãªãœäººã¯ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ã„ã“ãªã›ãªã„ã®ã‹ã€ ã“ã®ã¨ã“ã‚åŸ·ç†ã‚„è¬›æ¼”ã‚’é€šã˜ã¦ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã«ã¤ã„ã¦èª¬æ˜Žã™ã‚‹æ©Ÿä¼šã‚’è‰²ã€…é ‚ã„ã¦ã„ã‚‹ãŒã€ãã‚Œã‚‰ã®æ´»å‹•ã®æ ¹æºã¨ãªã£ã¦ã„ã‚‹ã®ãŒã€ã“ã®ç´ æœ´ãªç–‘å•ã§ã‚ã‚‹ã€‚ãã®ç–‘å•ã‚’ãƒ‘ãƒ¯ãƒ¼ã«ã—ã¦ã“ã‚Œã¾ã§æ´»å‹•ã‚’è¡Œãªã£ã¦ããŸã€‚ ç¾æ™‚ç‚¹ã§ã®è‡ªåˆ†ã®å›žç”ã¯ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆãŒé›£ã—ã„ã‹ã‚‰ã€ã§ã‚ã‚‹ã€‚ã‚‚ã¡ã‚ã‚“ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ãã®ã‚‚ã®ã®é›£ã—ã•ã¨ã„ã†ã®ã‚‚ã‚ã‚‹ãŒã€ãã‚Œã‚ˆã‚Šã¯ã€Œé©åˆ‡ãªä½¿ã„åˆ†ã‘ãŒã§ãã¦ã„ãªã„ã€ã¨ã„ã†ã“ã¨ãŒå¤§ãã„ã‚ˆã†ã«æ€ã†ã€‚è¨€è‘‰ã‚’å¤‰ãˆã‚‹ã¨ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã‚’é©ç”¨ã™ã¹ããƒ‡ãƒ¼ã‚¿ã¨ãã†ã§ãªã„ãƒ‡ãƒ¼ã‚¿ã®åˆ¤æ–ãŒã§ãã¦ã„ãªã„ã‹ã‚‰DBè¨
pero1 2014/04/18
db

mysql
ãƒªãƒ³ã‚¯
[HA]MySQL5.1.52 + Heartbeat3.0.5ã§ã‚¯ãƒ©ã‚¹ã‚¿ã‚’çµ„ã‚€ | Share Technical Blogs
ãƒžã‚¹ã‚¿ãƒ¼ã‚µãƒ¼ãƒã®è¨å®š â‘ ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ç”¨ãƒ¦ãƒ¼ã‚¶ã®ä½œæˆ GRANT REPLICATION SLAVE ON *.* to â€˜replicationâ€™@â€™10.10.0.20â€™ IDENTIFIED BY â€˜replicationâ€™; â‘¡my.cnfã®è¨å®š [mysqld] # ãƒã‚¤ãƒŠãƒªãƒã‚°ã‚’å‡ºåŠ›ã™ã‚‹ log-bin # è˜åˆ¥ç”¨IDã€‚ server-id=10 ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚µãƒ¼ãƒã®è¨å®š â‘ my.cnfã®è¨å®š server-id=20 ãƒ‡ãƒ¼ã‚¿ç§»è¡Œ ï¼† ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³è¨å®š â‘ ãƒžã‚¹ã‚¿ãƒ¼ã‚µãƒ¼ãƒã«å¯¾ã—ã¦æ›´æ–°ãŒã‹ã‹ã‚‰ãªã„ã‚ˆã†ã«ãƒãƒƒã‚¯ã‚’ã‹ã‘ã¾ã™ mysql > FLUSH TABLES WITH READ LOCK; â‘¡ãƒžã‚¹ã‚¿ãƒ¼ã‚µãƒ¼ãƒã®ãƒ‡ãƒ¼ã‚¿ã‚’ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚µãƒ¼ãƒã«ã‚³ãƒ”ãƒ¼ã™ã‚‹ ãƒ»/var/lib/mysqlé…ä¸‹ã®ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚³ãƒ”ãƒ¼ã—ã¾ã™ â‘¢ãƒžã‚¹ã‚¿ãƒ¼ã‚µãƒ¼ãƒã®ãƒã‚¤ãƒŠãƒªãƒã‚°ã®çŠ¶æ…‹ã‚’ç¢ºèªã—ã¾ã™ mysql > SH
pero1 2014/01/24
mysql

pacemaker
ãƒªãƒ³ã‚¯
percona-pacemaker-agents/doc/PRM-setup-guide.rst at master Â· percona/percona-pacemaker-agents Â· GitHub
pero1 2014/01/23
mysql

pacemaker
ãƒªãƒ³ã‚¯
Linux-HA Manual Pages
pero1 2014/01/22
mysql

pacemaker
ãƒªãƒ³ã‚¯
MySQL (resource agent) - Linux-HA
The MySQL resource agent (ocf:heartbeat:mysql in CRM shell syntax) manages a MySQL database as a highly available cluster resource. It supports multiple instances of MySQL in the cluster of which, if configured correctly, several may run concurrently on one node. Reference information about this resource agent is contained in its manual page (man ocf_heartbeat_mysql); an on-line version is availab
pero1 2014/01/22
mysql

pacemaker
ãƒªãƒ³ã‚¯
Adding MySQL resources to PacemakerÂ -Â OpenStack High Availability Guide Â -Â master
pero1 2014/01/22
mysql

pacemaker
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®masterã¨slaveã®ä½¿ã„åˆ†ã‘ã®è©±ã€‚2014å¹´ç‰ˆ - Hateburo: kazeburo hatenablog
ç¤¾å†…ã§å°‘ã—è©±é¡Œã«ãªã£ãŸã®ã§ã€‚ é‹ç”¨ä¸Šã®è©±ã¯fujiwaraã•ã‚“ã® MySQLã‚’master:slave=1:1æ§‹æˆã«ã—ã¦å‚ç…§ã‚’slaveã«å‘ã‘ã‚‹ã®ãŒãªãœè‰¯ããªã„ã‹ - é…’æ—¥è¨˜ ã¯ã¦ãªæ”¯åº— MySQLã§å‚ç…§ã®è² è·åˆ†æ•£ã‚’è¡Œã†slaveã¯3å°ã‹ã‚‰æ§‹æˆã™ã‚‹ã®ãŒã‚ˆã„ã®ã§ã¯ - é…’æ—¥è¨˜ ã¯ã¦ãªæ”¯åº— ã‚’ã¿ã¦ãã ã•ã„ã€‚ æœ€è¿‘ã€æ–°ã—ãã‚µãƒ¼ãƒ“ã‚¹ãŒã§ããŸã‚Šã€æ–°è¦æ©Ÿèƒ½ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’è¿½åŠ ã™ã‚‹éš›ã«ã¯å¿…ãšå…¨ã¦ã®å‚ç…§ã‚’masterã«å‘ã‘ã¦ã‚‚ã‚‰ã£ã¦ã„ã¾ã™ã€‚ç†ç”±ã¯ä¸Šè¨˜ã®ã‚¨ãƒ³ãƒˆãƒªã‚’èªã‚“ã§ãã ã•ã„ã€‚ã“ã®ã‚ˆã†ãªæ§‹æˆãŒå–ã‚Œã‚‹ã®ã¯ã‚‚ã¡ã‚ã‚“æ€§èƒ½çš„ã«ãã‚Œã§å•é¡Œãªã„ã‹ã‚‰ã§ã™ã€‚ æ–°ã—ã„ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã«ã€è¨å®šã•ã‚ŒãŸMySQLã€å•é¡Œã®ãªã„ã‚ˆã†ã«æ›¸ã‹ã‚ŒãŸSQLã§ã‚ã‚Œã°ã€æ•°åƒQPSã¯ä½™è£•ã«ã€ã¾ãŸå°‘ã—é ‘å¼µã‚Œã°æ•°ä¸‡QPSã‚’ä¸€å°ã§è³„ãˆã¾ã™ã€‚ãªã®ã§å¤§ä½“ã®ã‚µãƒ¼ãƒ“ã‚¹ã¯masterä¸€å°ã§ååˆ†ã§ã™ã€‚ ã•ã‚‰ã«ã“ã®è€ƒãˆæ–¹ã‚’é€²ã‚ã¦ã€Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ä¸ã§ sub d
pero1 2014/01/21
mysql

replication
ãƒªãƒ³ã‚¯
Mysql toranomaki
ã‚«ã‚¸ãƒ¥ã‚¢ãƒ«ã«MySQL Clusterã‚’ä½¿ã£ã¦ã¿ã‚ˆã†@MySQL Cluster Casual Talks 2013.09Mikiya Okuno
pero1 2014/01/21
mysql
ãƒªãƒ³ã‚¯
MySQL 5.6ã®ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‚»ãƒ¼ãƒ•ãªãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ä»•çµ„ã¿
MySQL 5.6ã®nutshellã‚’èªã‚€ã¨ã€`ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‚»ãƒ¼ãƒ•ãªãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’å®Ÿç¾ã™ã‚‹ãŸã‚ã«ã¯master_info_repositoryã¨relay_log_info_repositoryã‚’TABLEã«è¨å®šã—ãªï¼ ãŠã£ã¨ã€relay_log_recoveryã‚‚1ã«ã—ã¦ãŠãã‚“ã ãœ'ã¿ãŸã„ã“ã¨ãŒæ›¸ã„ã¦ã‚ã‚‹ã€‚ ã§ã€ã“ã®ãƒã‚°ãƒ¬ãƒãƒ¼ãƒˆã‚’è¦‹ãŸæ™‚ã‹ã‚‰ãšã£ã¨ã€sync_master_infoã®æš—é»™ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆ10000ã®ã¾ã‚“ã¾ã˜ã‚ƒã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‚»ãƒ¼ãƒ•ã˜ã‚ƒãªããï¼Ÿ sync_master_info= 1å¿…é ˆï¼Ÿ ãã‚Œã¯ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹çš„ã«æ»ãã‚‹ã€‚ã¨ã„ã†æ„Ÿã˜ã§ãƒ¢ãƒ¤ãƒ¢ãƒ¤ã—ã¦ã„ãŸã®ã ãŒã€ã‚„ã£ã¨åˆç‚¹ãŒã„ã£ãŸã®ã§ãƒ¡ãƒ¢ã—ã¨ãã¾ã™ã€‚ master_info_repository FILEã®å ´åˆã€å¾“æ¥ã©ãŠã‚Šmaster.infoãƒ•ã‚¡ã‚¤ãƒ«ã«æ›¸ãã€‚ ãƒ•ã‚¡ã‚¤ãƒ«åã¯master_info_fileã«ã‚ˆã‚Šå¯å¤‰ã€‚ æ›´æ–°ãŒã‚ã‚‹ãŸã³(ãƒã‚¤
pero1 2014/01/21
mysql
ãƒªãƒ³ã‚¯
MySQLã§å‚ç…§ã®è² è·åˆ†æ•£ã‚’è¡Œã†slaveã¯3å°ã‹ã‚‰æ§‹æˆã™ã‚‹ã®ãŒã‚ˆã„ã®ã§ã¯ - é…’æ—¥è¨˜ ã¯ã¦ãªæ”¯åº—
å‰å›žã®è¨˜äº‹ MySQLã‚’master:slave=1:1æ§‹æˆã«ã—ã¦å‚ç…§ã‚’slaveã«å‘ã‘ã‚‹ã®ãŒãªãœè‰¯ããªã„ã‹ ã®ç¶šãã§ã™ã€‚ master : slave = 1 : 1 ã§å‚ç…§ã‚’ slave ã«åˆ†æ•£ã—ã¦ã‚‚ã¾ã£ãŸãç¾Žå‘³ã—ããªã„ã‚ã‘ã§ã™ãŒã€ã§ã¯å‚ç…§ã®è² è·åˆ†æ•£ã‚’è¡Œã„ãŸã„å ´åˆã® slave ã¯ä½•å°ã§æ§‹æˆã™ã‚‹ã¨ã‚ˆã„ã®ã‹è€ƒå¯Ÿã—ã¦ã¿ã¾ã™ã€‚å…·ä½“çš„ã«ã¯ slave 2å°ã®å ´åˆã¨ 3å°ã®å ´åˆã§ã©ã¡ã‚‰ãŒãŠå¾—ã‹ã€‚ å°æ•°ã‚’å¢—ã‚„ã™ã¨ã„ã†ã“ã¨ã¯ã€ã©ã“ã‹ã«éšœå®³ãŒç™ºç”Ÿã™ã‚‹ç¢ºçŽ‡ãŒé«˜ã¾ã‚‹ã€ã¨ã„ã†ã“ã¨ã§ã™ã€‚1å°ã® slave ã«éšœå®³ãŒç™ºç”Ÿã—ã¦ãƒ€ã‚¦ãƒ³ã—ãŸå ´åˆã®ã“ã¨ã‚’è€ƒãˆã¦ã¿ã¾ã™ã€‚ slave * 2 â†’ æ®‹ã‚Š 1å°ã§å‡¦ç†ç¶™ç¶š ç”Ÿãæ®‹ã£ãŸ1å°ã‚ãŸã‚Šã®å‡¦ç†ãŒ 2å€ã«ãªã‚‹ slave * 3 â†’ æ®‹ã‚Š 2å°ã§å‡¦ç†ç¶™ç¶š ç”Ÿãæ®‹ã£ãŸ1å°ã‚ãŸã‚Šã®å‡¦ç†ãŒ 1.5å€ã«ãªã‚‹ ãŸã¨ãˆã° 1å°ã‚ãŸã‚Šæœ€å¤§ 1000qps ã®å‡¦ç†èƒ½åŠ›ãŒã‚ã‚‹ã¨ã—ã¾ã™ã€‚sla
pero1 2013/12/31
mysql

operation
ãƒªãƒ³ã‚¯
MySQLã‚’master:slave=1:1æ§‹æˆã«ã—ã¦å‚ç…§ã‚’slaveã«å‘ã‘ã‚‹ã®ãŒãªãœè‰¯ããªã„ã‹ - é…’æ—¥è¨˜ ã¯ã¦ãªæ”¯åº—
MySQLã®masterã¨slave 1:1ã«ã—ã¦å‚ç…§ã‚’slaveå‘ã‘ã‚‹ã®ã£ã¦ã‚„ã‚ŠãŸãŒã‚‹äººå¤šã„ã¿ãŸã„ã ã‘ã©ã€æ€§èƒ½ãŸã„ã—ã¦ä¸ŠãŒã‚‰ãªã„å‰²ã«å¯ç”¨æ€§è½ã¡ã‚‹ã ã‘ã ã‹ã‚‰ã‚„ã‚ã‚ˆã†ã‚ãƒ£ãƒ³ãƒšãƒ¼ãƒ³ 2011-06-19 00:16:30 via YoruFukurou MySQL ã¯ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒç°¡å˜ã«æ§‹æˆã§ãã‚‹ã®ã§ã™ãŒã€æ™‚æŠ˜ master 1å° ã«å¯¾ã—ã¦ slave 1å°ã€æ›´æ–°å‡¦ç†ã¯ master ã«ã€å‚ç…§ã¯ slave ã«ã€ã¨ã„ã†æ§‹æˆã‚’ç›®ã«ã—ã¾ã™ã€‚ å€‹äººçš„ã«ã¯ã“ã®æ§‹æˆã¯ãŠå‹§ã‚ã§ãªã„ã¨æ€ã£ã¦ã„ã‚‹ã®ã§ã€ãã®ç†ç”±ã‚’è€ƒå¯Ÿã—ã¦ã¿ã¾ã™ã€‚ 1. å¯ç”¨æ€§ãŒè½ã¡ã‚‹ å½“ç„¶ã§ã™ãŒã€master, slave ã®ã©ã¡ã‚‰ãŒè½ã¡ã¦ã‚‚å½±éŸ¿ã‚’å—ã‘ã‚‹ãŸã‚ã«å¯ç”¨æ€§ãŒä½Žä¸‹ã—ã¾ã™ã€‚ 2. å…¨ä½“ã®æ€§èƒ½ãŒã»ã¨ã‚“ã©ä¸ŠãŒã‚‰ãªã„ master 1å°ã§ã™ã¹ã¦ã®ã‚¯ã‚¨ãƒªã‚’å‡¦ç†ã™ã‚‹å ´åˆã¨æ¯”ã¹ã¦ã€å¯ç”¨æ€§ãŒè½ã¡ã‚‹å¼•ãæ›ãˆã¨ã—ã¦è¦‹åˆã£ãŸæ€§èƒ½å‘ä¸ŠãŒå¾—ã‚‰ã‚Œã‚‹ã‹ã€ã¨ã„ã†
pero1 2013/12/31
mysql

replication
ãƒªãƒ³ã‚¯
naoyaã®ã¯ã¦ãªãƒ€ã‚¤ã‚¢ãƒªãƒ¼ - ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã®è©±
ã‹ãªã‚ŠãªãŒãƒ¼ã„ã‚¨ãƒ³ãƒˆãƒªã«ãªã‚‹äºˆå®šãªã®ã§,çµè«–ã ã‘æœ€åˆã«æ›¸ãã¨ã“ã‚“ãªæ„Ÿã˜. ã“ã®è©±é¡Œã«ã¤ã„ã¦ã¯è‡ªåˆ†ã‚‚ ã‚ã¨ã§æ›¸ã ã¨è¨€ã£ã¦æ›¸ã„ã¦ãªã‹ã£ãŸã®ã§æ›¸ã„ã¦ã¿ã¾ã™ã‚ˆã€‚2006å¹´ã®ä¸‹æœŸã«ã‚‚ãªã£ã¦ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã‹ã‚ˆã¨ã„ã†ãƒ„ãƒƒã‚³ãƒŸã‚‚ã‚ã‚Šãã†ã§ã™ãŒã€ã‚ã¨ã§æ›¸ãã¨ã„ã£ãŸã‚‰æ›¸ãã®ã€‚ã‚ã¨ã§èªã‚€ã¨ã„ã£ãŸã‚‰èªã‚€ã€‚ æ™®é€šã€Œã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã€ã¨è¨€ã£ãŸã‚‰ã€ä¸»ã«äºŒã¤ã®å½¹å‰²ãŒã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚è©±ã‚’ç°¡å˜ã«ã™ã‚‹ãŸã‚ã«ã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«é™å®šã—ã¦è¨€åŠã—ã¾ã™ã€‚ ã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‹ã‚‰ DB ã¸ã®æŽ¥ç¶šã‚’é–‹ã‘ã£æ”¾ã—ã«ã—ã¦ã€æŽ¥ç¶šã«å¿…è¦ã¨ã•ã‚Œã‚‹ã‚ªãƒ¼ãƒãƒ¼ãƒ˜ãƒƒãƒ‰ã‚’ã‚«ãƒƒãƒˆã—ã¦åŒæ–¹ã®è² è·ã‚’ä¸‹ã’ã‚‹ã€‚ ã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ DB ã¸ã®æŽ¥ç¶šã‚’ã€Œä½¿ã„ã¾ã‚ã™ã€ã“ã¨ã§ã€åŒæ™‚æŽ¥ç¶šæœ¬æ•°ã‚’ç¯€ç´„ã™ã‚‹ã€‚ ã¨ã„ã†ã‚‚ã®ã€‚ mod_perl ã§ DB ã¨æŽ¥ç¶šç¶æŒã™ã‚‹ã¨ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³æ•°å¢—ãˆã¦äº‘ã€…ã¨ã„ã†è©±ã¯ä¸»ã«å‰è€…ã®ã¿ã«ã¤ã„ã¦ã®è©±ã«ãªã‚Šã¾ã™ã€‚Apache::DB
pero1 2013/12/29
db

mysql

connection pool
ãƒªãƒ³ã‚¯
MySQLã®ãŸã‚ã®Linuxãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒ’ãƒ³ãƒˆ | Yakst
Linuxã®MySQLã‚µãƒ¼ãƒã§æœ€ä½Žé™ã‚„ã£ã¦ãŠã‹ãªãã¦ã¯ãªã‚‰ãªã„ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã€ãƒ¡ãƒ¢ãƒªã€CPUã«é–¢ã™ã‚‹è¨å®šã®ãƒ¡ãƒ¢ã€‚ December 7, 2013 By Alexander Rubin æã‚‰ãã»ã¨ã‚“ã©ã®MySQL æœ¬ç•ªç’°å¢ƒã¯Linuxä¸Šã§å‹•ã„ã¦ã„ã‚‹ã“ã¨ã ã‚ã†ã€‚ãªã®ã§ã€MySQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’ä¸Šã’ã‚‹ã®ã«æœ‰ç”¨ãªã€æœ€ã‚‚é‡è¦ãªLinuxã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãŸã‚ã®ãƒ’ãƒ³ãƒˆã«ã¤ã„ã¦æ›¸ã“ã†ã¨æ±ºã‚ãŸã€‚ç‰¹ã«æ–°ã—ã„æƒ…å ±ã¯ãªãã¦ã€ã©ã‚Œã‚‚ã‚ˆãçŸ¥ã‚‰ã‚Œã¦ã„ã‚‹ã‚‚ã®ã§ã¯ã‚ã‚‹ãŒã€ãƒ–ãƒã‚°è¨˜äº‹ã«ã¾ã¨ã‚ã¦ã¿ã‚‹ã€‚ ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ext4 (ã¾ãŸã¯xfs) ã‚’noatimeã‚ªãƒ—ã‚·ãƒ§ãƒ³ä»˜ãã§ãƒžã‚¦ãƒ³ãƒˆ ã‚¹ã‚±ã‚¸ãƒ¥ãƒ¼ãƒ©ã¯deadlineã‹noop # echo deadline >/sys/block/sda/queue/scheduler grub.confã«"elevator=deadline"ã‚’è¿½åŠ (è©³ç´°ã¯Linuxã‚¹ã‚±ã‚¸ãƒ¥ãƒ¼ãƒ©ã¨
pero1 2013/12/21
linux

mysql

numa
ãƒªãƒ³ã‚¯
1 2 3 4 æ¬¡ã®ãƒšãƒ¼ã‚¸