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

yuanying id:yuanying

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

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

gh-ostï¼šGitHubã®MySQLå‘ã‘ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒ»ã‚¹ã‚ãƒ¼ãƒžãƒ»ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãƒ„ãƒ¼ãƒ« | POSTD
æœ¬æ—¥ã€ gh-ost ã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ãƒªãƒªãƒ¼ã‚¹ã‚’ç™ºè¡¨ã—ã¾ã™ã€‚GitHubã®ã€ãƒˆãƒªã‚¬ãƒ¼ãƒ¬ã‚¹ãªMySQLå‘ã‘ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒ»ã‚¹ã‚ãƒ¼ãƒžãƒ»ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãƒ»ãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ gh-ost ã¯ã€MySQLãƒ†ãƒ¼ãƒ–ãƒ«ã®ä¿®æ£ãŒå¿…è¦ãªã€é€²è¡Œä¸ã®ç¶™ç¶šçš„ãªãƒ—ãƒãƒ€ã‚¯ã‚·ãƒ§ãƒ³å¤‰æ›´ã«ä¼´ã£ã¦ç§ãŸã¡ãŒç›´é¢ã™ã‚‹å•é¡Œã«ç”ãˆã‚‹ãŸã‚ã«ã€ã“ã“æ•°ãƒ¶æœˆã§é–‹ç™ºã•ã‚Œã¾ã—ãŸã€‚ gh-ost ã¯ã€è² æ‹…ãŒå°ã•ãã€åˆ¶å¾¡ã—ã‚„ã™ãã€ç›£æŸ»ã—ã‚„ã™ãã€æ“ä½œãŒç°¡å˜ãªã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã‚’æä¾›ã™ã‚‹ã“ã¨ã«ã‚ˆã£ã¦ã€ç¾åœ¨ã®ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒ»ãƒ†ãƒ¼ãƒ–ãƒ«ãƒ»ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒ‘ãƒ©ãƒ€ã‚¤ãƒ ã‚’æ§˜å¤‰ã‚ã‚Šã•ã›ã¾ã™ã€‚ MySQLãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã¯ã€ã‚ˆãçŸ¥ã‚‰ã‚ŒãŸå•é¡Œã§ã€2009å¹´ã‹ã‚‰ã¯ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒ»ã‚¹ã‚ãƒ¼ãƒžå¤‰æ›´ãƒ„ãƒ¼ãƒ«ã«ã‚ˆã£ã¦å¯¾å‡¦ã•ã‚Œã¦ãã¾ã—ãŸã€‚ãƒã‚¤ãƒšãƒ¼ã‚¹ã§æˆé•·ã™ã‚‹ãƒ—ãƒãƒ€ã‚¯ãƒˆã«ä¼´ã£ã¦ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ§‹é€ ã®å¤‰æ›´ãŒå¿…è¦ã«ãªã‚Šã¾ã™ã€‚åˆ—ã‚„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãªã©ã®è¿½åŠ ãƒ»å¤‰æ›´ãƒ»å‰Šé™¤ã¯ã€ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®MySQLã®å‹•ä½œã‚’å¦¨ã’ã‚‹
yuanying 2016/08/30
mysql
ãƒªãƒ³ã‚¯
hansode.orgÂ -Â ã“ã®ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã¯è²©å£²ç”¨ã§ã™ï¼Â -Â hansode ãƒªã‚½ãƒ¼ã‚¹ãŠã‚ˆã³æƒ…å ±
ã“ã®ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã¯è²©å£²ç”¨ã§ã™ï¼ hansode.org ã¯ã€ã‚ãªãŸãŒãŠæŽ¢ã—ã®æƒ…å ±ã®å…¨ã¦ã®æœ€æ–°ã‹ã¤æœ€é©ãªã‚½ãƒ¼ã‚¹ã§ã™ã€‚ä¸€èˆ¬ãƒˆãƒ”ãƒƒã‚¯ã‹ã‚‰ã“ã“ã‹ã‚‰æ¤œç´¢ã§ãã‚‹å†…å®¹ã¯ã€hansode.orgãŒå…¨ã¦ã¨ãªã‚Šã¾ã™ã€‚ã‚ãªãŸãŒãŠæŽ¢ã—ã®å†…å®¹ãŒè¦‹ã¤ã‹ã‚‹ã“ã¨ã‚’é¡˜ã£ã¦ã„ã¾ã™ï¼
yuanying 2014/03/31
postfix

mysql

dovecot

postfixadmin
ãƒªãƒ³ã‚¯
Dockerã§MySQLã‚’å‹•ã‹ã™ - cpw's diary
Dockerã§ãƒ‡ãƒ¼ãƒ¢ãƒ³ã‚’å‹•ã‹ãã†ã¨ã™ã‚‹ã¨initctlãŒã†ã¾ãå‹•ã‹ãªã„ã®ã§ã€service start mysqlã¨ã‹å‡ºæ¥ãªã„ã‚“ã§ã™ã€‚ã ã‹ã‚‰ç›´æŽ¥mysqld_safeã‚’èµ·å‹•ã™ã‚‹ã®ã§ã™ãŒã€baseã‚¤ãƒ¡ãƒ¼ã‚¸ã‹ã‚‰Dockerfileã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã¨ã€ç°¡å˜ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã§ããªã„ã€‚ã¨ã„ã†ã®ã‚‚ã€apt-get install mysql-serverã—ãŸã¨ãã«ã„ã‚ã„ã‚ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’å¯¾è©±çš„ã«å…¥åŠ›ã—ã‚ã¨ã„ã‚ã‚Œã‚‹ã®ã§ã€Dockerfileã§ç´ ç›´ã«ã¯å‡ºæ¥ãªã„ã‚“ã§ã™ã€‚ ã„ã‚ã„ã‚èª¿ã¹ã¦ã¿ã‚‹ã¨ã€ãã†ã„ã£ãŸãƒ‘ãƒ©ãƒ¡ã‚¿ã‚’ã‚ã‚‰ã‹ã˜ã‚è¨å®šã—ã¦ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹æ–¹æ³•ãŒã‚ã£ã¦ã€debconf-set-selectionsã¨ã„ã†ã‚³ãƒžãƒ³ãƒ‰ãŒãã‚Œã«ç›¸å½“ã™ã‚‹ã¿ãŸã„ã§ã™ã€‚ã‚‚ã£ã¨ç°¡å˜ã«ã§ãã‚‹æ–¹æ³•ã‚’ id:nkwhr ã•ã‚“ã«æ•™ãˆã¦ã‚‚ã‚‰ã„ã¾ã—ãŸã€‚DEBIAN_FRONTEND=noninteractiveã¨ç’°å¢ƒå¤‰æ•°ã«è¨å®šã™ã‚Œã°ã„ã„ã¿ãŸã„ã§ã™ã€‚ä¸‹è¨˜
yuanying 2013/08/22
mysql
ãƒªãƒ³ã‚¯
Djangoã‹ã‚‰MySQLã«COMMITã—ãŸãƒ‡ãƒ¼ã‚¿ãŒåˆ¥ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‹ã‚‰è¦‹ãˆãªã„ - orangain flavor
ã¯ã˜ã‚ã« Djangoã‚’ä½¿ã£ãŸã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã€2ã¤ã®ãƒãƒƒãƒå‡¦ç†ç”¨ãƒ—ãƒã‚»ã‚¹Aã€Bã‚’åŒæ™‚ã«ç«‹ã¡ä¸Šã’ãŸã¨ãã«ã€Aã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã§save & commitã—ãŸå€¤ã‚’Bã§ã¯èªã¿å–ã‚Œãªã„ã¨ã„ã†å•é¡Œã«ç›´é¢ã—ã¾ã—ãŸã€‚ å•é¡Œã®ç®‡æ‰€ã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã¯ã“ã®ã‚ˆã†ãªæ„Ÿã˜ã§ã™ã€‚ å®Ÿè¡Œé † ãƒ—ãƒã‚»ã‚¹A ãƒ—ãƒã‚»ã‚¹B 1 with commit_on_success(): p = Post(id=1) p.save() 2 # saveã—ãŸãƒ‡ãƒ¼ã‚¿ãŒè¦‹ãˆã‚‹ Post.objects.get(id=1) 3 with commit_on_success(): p = Post(id=2) p.save() 4 # saveã—ãŸãƒ‡ãƒ¼ã‚¿ãŒè¦‹ãˆãšä¾‹å¤–ç™ºç”Ÿ Post.objects.get(id=2) Djangoã§ã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§è‡ªå‹•ã‚³ãƒŸãƒƒãƒˆãŒæœ‰åŠ¹ãªã®ã§ã€Aã§ã‚³ãƒŸãƒƒãƒˆã—ãŸå€¤ã‚’Bã§èªã¿å–ã‚Œã‚‹ã¯ãšã¨æ€ã£ã¦ã„ãŸã®ã§ã™ãŒã€ã“ã‚Œã¯é–“é•ã„ã§ã—
yuanying 2013/07/11
django

mysql
ãƒªãƒ³ã‚¯
é–‹ç™ºã‚¹ãƒ”ãƒ¼ãƒ‰ã‚¢ã‚¯ã‚»ãƒ«å…¨é–‹ã¶ã£ã¡ãŽã‚Šï¼æ—¥æœ¬ã‚ˆã€ã“ã‚ŒãŒ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
yuanying 2012/10/01
mysql

database
ãƒªãƒ³ã‚¯
MySQL Clusteræ§‹ç¯‰ãƒ»é‹ç”¨ãƒã‚¤ãƒ–ãƒ«ã€ç™ºåˆŠã®ãŠã—ã‚‰ã›ã€‚
å…¥é‚æ›¸ç±ç¬¬äºŒå¼¾ã§ã‚ã‚‹MySQL Clusteræ§‹ç¯‰ãƒ»é‹ç”¨ãƒã‚¤ãƒ–ãƒ«ãŒç™ºå£²ã¨ãªã£ãŸã€‚ä¸€éƒ¨æ›¸åº—ã§ã¯å…ˆè¡Œç™ºå£²ã—ã¦ã„ã‚‹ãŒã€æœ¬æ—¥ãŒæ£å¼ãªç™ºå£²æ—¥ã§ã‚ã‚‹ã€‚Amazonã§ã‚‚ä»Šæ—¥ã‹ã‚‰è³¼å…¥å¯èƒ½ã ã€‚ã‚µãƒ–ã‚¿ã‚¤ãƒˆãƒ«ã¯ã€Œä»•çµ„ã¿ã‹ã‚‰ã‚ã‹ã‚‹åŸºç¤Žã¨å®Ÿè·µã®ãƒŽã‚¦ãƒã‚¦ã€ã§ã‚ã‚Šã€MySQLçµŒé¨“è€…ã«ã¨ã£ã¦MySQL Clusterã‚’ä¸€ã‹ã‚‰ç†è§£ã—ã¦é ‚ã‘ã‚‹ã‚ˆã†ãªå†…å®¹ã«ãªã£ã¦ã„ã‚‹ã€‚ä»Šã§ã¯ä¸€ç«¯ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢æ°—å–ã‚Šã®ç†è€…ã§ã‚ã‚‹ãŒã€MySQL Clusterã«æ‰‹ã‚’æŸ“ã‚ãŸã°ã‹ã‚Šã®å½“æ™‚ã¯çµæ§‹è‹¦åŠ´ã—ãŸã‚‚ã®ã ã£ãŸã€‚ã©ã®ã‚ˆã†ãªç‚¹ãŒåˆ†ã‹ã‚Šã¥ã‚‰ã‹ã£ãŸã‹ã¨ã„ã†çµŒé¨“ã‚’æ´»ã‹ã—ã€MySQL Clusterã®ã‚³ãƒ³ã‚»ãƒ—ãƒˆã‚„ä½¿ã„æ–¹ã‚’ã§ãã‚‹ã ã‘ã‚ã‹ã‚Šã‚„ã™ãèª¬æ˜Žã—ãŸã¤ã‚‚ã‚Šã§ã‚ã‚‹ã€‚ ä»¥ä¸‹ã€å„ç« ã®ã‚¿ã‚¤ãƒˆãƒ«ã¨ç°¡å˜ãªå†…å®¹ã«ã¤ã„ã¦ã®èª¬æ˜Žã‚’ã™ã‚‹ã€‚ ã‚‚ãã˜ ç¬¬1ç« MySQL Clusterã®ã‚³ãƒ³ã‚»ãƒ—ãƒˆ ç¬¬2ç« ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¨è¨å®š ç¬¬3ç« åŸºæœ¬æ“ä½œã‚’èº«ã«ã¤ã‘ã‚‹ ç¬¬4ç« ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’é–‹ç™ºã™
yuanying 2012/04/10
mysql

cloud
ãƒªãƒ³ã‚¯
ã€MySQLã‚¦ã‚©ãƒƒãƒã€‘ç¬¬7å›ž å¤§è¦æ¨¡ã‚·ã‚¹ãƒ†ãƒ ã‚’æ”¯ãˆã‚‹MySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ï¼šITpro
ã“ã®ã¨ã“ã‚æ¥½å¤©ã‚’ã¯ã˜ã‚ã¨ã—ã¦ï¼ŒMySQLã‚’æ´»ç”¨ã—ãŸå¤§è¦æ¨¡ãªäº‹ä¾‹ãŒå¢—ãˆã¦ã„ã‚‹ï¼ˆé–¢é€£è¨˜äº‹ï¼‰ã€‚ã“ã®ã‚ˆã†ãªå¤§è¦æ¨¡ï¼Œã‹ã¤ã‚µãƒ¼ãƒ“ã‚¹åœæ¢ã®è¨±ã•ã‚Œãªã„ã‚·ã‚¹ãƒ†ãƒ ã‚’æ”¯ãˆã¦ã„ã‚‹ã®ãŒï¼ŒMySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã§ã‚ã‚‹ã€‚ ã€Œãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã€ã¨ã¯ï¼Œå¯¾è±¡ç‰©ã¨ã¾ã£ãŸãåŒã˜ç‰©ã‚’è£½ä½œã™ã‚‹å‡¦ç†ã ã€‚åŒã˜ã‚ˆã†ãªæ„å‘³ã«ã€ŒãƒŸãƒ©ãƒ¼ã€ãŒã‚ã‚‹ãŒï¼Œæ„å‘³ã™ã‚‹ã¨ã“ã‚ã¯ç‰©ç†çš„ãªã‚³ãƒ”ãƒ¼ã§ã‚ã‚‹ã€‚ã€Œãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã€ã¯ï¼Œè«–ç†çš„ãªè¤‡è£½ã§ã‚ã‚Šï¼Œå¯¾è±¡ç‰©ã®å…¨ä½“ã‚„ä¸€éƒ¨ã¨ã„ã£ãŸç¯„å›²ã‚’é™å®šã§ãã‚‹ç‚¹ãŒç•°ãªã‚‹ã€‚ ã“ã®ã‚ˆã†ãªæ©Ÿèƒ½ã¯ï¼Œå¤§ãŒã‹ã‚Šãªæº–å‚™ã¨é«˜åº¦ãªæŠ€è¡“ãŒå¿…è¦ã¨è€ƒãˆã¦ã„ã‚‹æ–¹ã‚‚å¤šã„ã ã‚ã†ã€‚ã—ã‹ã—ï¼ŒMySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã¯ï¼Œéžå¸¸ã«ç°¡å˜ã«åˆ©ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ä»Šå›žã¯ï¼Œç¾è¡Œãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã‚‚åˆ©ç”¨å¯èƒ½ãªãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã‚’è§£èª¬ã™ã‚‹ã€‚ Masterã®æ›´æ–°ãŒSlaveã«åæ˜ ã•ã‚Œã‚‹ MySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã¯ï¼ŒMasterã¨Slaveã«å½¹å‰²ãŒåˆ†ã‹ã‚Œã‚‹ï¼ˆå›³1[æ‹¡å¤§
yuanying 2012/01/27
mysql

machinae
ãƒªãƒ³ã‚¯
mysqlã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã€Œã®ã‚Œã‚“åˆ†ã‘ã€
å¤§ã¾ã‹ãªæ‰‹é †ã¯ä»¥ä¸‹ã§ã™ã€‚ ä¸‰æ®µæ§‹æˆã«ã™ã‚‹ã€‚ slaveã‚’åˆ‡ã‚Šæ›¿ãˆã‚‹ masterã‚’åˆ‡ã‚Šæ›¿ãˆã‚‹ ä½™åˆ†ãªãƒ†ãƒ¼ãƒ–ãƒ«ã‚’è½ã¨ã™ ã®4ã‚¹ãƒ†ãƒƒãƒ—ã§ã™ã€‚ 1.ä¸‰æ®µæ§‹æˆã«ã™ã‚‹ã€‚ ã“ã‚Œã¯ã¤ã¾ã‚Šã“ã‚“ãªçŠ¶æ…‹ã«ã™ã‚‹ã“ã¨ã‚’ã„ã„ã¾ã™ã€‚ ã“ã®ä½œæ¥ã¯åŸºæœ¬çš„ã«ã¯å˜ç´”ãªslaveå¢—è¨ã¨æ–°è¦ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ§‹æˆã‚’çµ„ã‚€ã®ã®çµ„ã¿åˆã‚ã›ã§ã§ãã‚‹ã®ã§ã€å‰å›žã®ã‚¨ãƒ³ãƒˆãƒªã€Œreplicationã—ã¦ã‚‹MySQLã®slaveå¢—è¨æ‰‹é †ã€ã‚’å‚è€ƒã«ã—ã¦ãã ã•ã„ã€‚ é€šå¸¸ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ§‹ç¯‰ã¨ã®é•ã†ã€ãƒã‚¤ãƒ³ãƒˆã¨ã—ã¦ã¯ ãƒ†ãƒ¼ãƒ–ãƒ«æ§‹æˆã¯æœ€åˆã¯ä¸¸ã¾ã¾ã‚³ãƒ”ãƒ¼ã™ã‚‹ã“ã¨ ã€ŒNew masterã€my.cnfã®è¨å®šã«log-slave-updatesã¨replicate-do-tableã§ãƒŽãƒ¬ãƒ³åˆ†ã‘ã—ãŸã„ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’è¨å®šã—ã¦ãŠãã“ã¨ ã§ã™ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«æ§‹æˆã‚’ä¸¸ã¾ã¾ã‚³ãƒ”ãƒ¼ã™ã‚‹ã®ã¯ã€ãã†ã—ãªã„ã¨ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒå¤±æ•—ã™ã‚‹ã‹ã‚‰ã§ã™ã€‚replicate-ignore-dbã‚„re
yuanying 2012/01/27
mysql

machinae
ãƒªãƒ³ã‚¯
replicationã—ã¦ã‚‹MySQLã®slaveå¢—è¨æ‰‹é †
ã“ã‚“ã«ã¡ã¯ã€hiroshiã§ã™ã€‚ãŠã²ã•ã—ã¶ã‚Šã§ã™ãã€‚ stoneãŒæ›¸ã„ãŸhadoopã®è¨˜äº‹ãŒæ‰“ã¡åˆã‚ã›ã¨ã‹ã§ã€Œè¦‹ã¾ã—ãŸã‚ˆã€‚è©•åˆ¤ã§ã™ã‚ˆã€‚ã€ã¨ã‹è¨€ã‚ã‚Œã¦ã‚¸ã‚§ãƒ©ã‚·ãƒ¼ã„ã£ã±ã„ã§ã™ã€‚ åƒ•ã‚‚ãŒã‚“ã°ã‚Šã¾ã™ã€‚ç›®æŒ‡ã›ãƒ›ãƒƒãƒ†ãƒ³ãƒˆã‚Šï¼ ã¨ã„ã£ã¦ã‚‚ã€åƒ•ã ã¨æ›¸ã‘ã‚‹ã“ã¨ã«é™ç•ŒãŒã‚ã‚‹ã®ã§ã€ä»Šæ—¥ã¯åŠå®šå¸¸ä½œæ¥ã®MySQLã®å¢—è¨ä½œæ¥ã«ã¤ã„ã¦æ›¸ã“ã†ã¨æ€ã„ã¾ã™ã€‚ ä¸‹å›³ã®ã‚ˆã†ã«ã€master1å°â†slave2å°ãŒLVS+keepalivedã§è² è·åˆ†æ•£æ§‹æˆã•ã‚Œã¦ã„ã‚‹DBãŒã‚ã‚‹ã¨ã—ã¾ã™ã€‚ ã“ã®æ§‹æˆã®çµ„ã¿æ–¹ã«ã—ã‚ˆã†ã‹ã¨æ€ã£ãŸã®ã§ã™ãŒã€ã“ã‚Œã¯ã‚°ã‚°ã£ãŸã‚‰ã„ã£ã±ã„ã‚ã£ãŸã®ã§ãƒ›ãƒƒãƒ†ãƒ³ãƒˆãƒªã¯ç‹™ãˆãªã„ã¨æ€ã£ã¦ã‚„ã‚ã¾ã—ãŸã€‚ ãªã®ã§ã€ä»Šå›žã®ãƒ†ãƒ¼ãƒžã¯ã€Œã“ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã¯writeã¯ä½™è£•ã ã‘ã©readãŒãã¤ããªã£ã¦ããŸã‹ã‚‰slaveã‚’å¢—è¨ã—ãªã‘ã‚Œã°ï¼ã€ã¨ãªã£ãŸå ´åˆã®slaveã‚’å¢—è¨ã™ã‚‹æ‰‹é †ã«ã¤ã„ã¦æ›¸ã„ã¦ã¿ã¾ã™ã€‚ ä¸‹å›³ã®slaveCã‚’è¿½åŠ ã™ã‚‹ãžï¼ã®å ´åˆã§ã™ã€‚ â€»
yuanying 2012/01/27
mysql

machinae
ãƒªãƒ³ã‚¯
MySQL Clusterã‚’è©¦ã™ï¼
Copyright Â© 2004-2024 Impress Corporation. An Impress Group Company. All rights reserved.
yuanying 2012/01/27
mysql
ãƒªãƒ³ã‚¯
MySQLã®RANGEãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã‚’ä½¿ã† | æ‘å¼æµ ã‚¤ãƒƒãƒ‘ã‚·ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¸ã®é“
MySQLã®RANGEãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã®ãŠè©±ã§ã™ã€‚ MySQL5.1ã‹ã‚‰ã‚µãƒãƒ¼ãƒˆã•ã‚Œã¦ã„ã‚‹ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã§ã™ãŒã€ãƒã‚°ãƒ†ãƒ¼ãƒ–ãƒ«ç‰ã€ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ãŒå¤šããªã‚ŠãŒã¡ãªãƒ†ãƒ¼ãƒ–ãƒ«ã«æ—¥ä»˜ã§ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã—ã¦ã¾ã™ã€‚ æœ€åˆã‹ã‚‰é ã„æœªæ¥ã¾ã§ã®ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã‚’åˆ‡ã‚‹ã®ã¯æ°—æŒã¡æ‚ªã„ã—ã€é•·ãé‹ç”¨ã•ã‚Œã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã®å ´åˆã¯å¿˜ã‚Œã‚‹å¯èƒ½æ€§ã‚‚ã‚ã‚‹ã®ã§ãƒãƒƒãƒã‚’å›žã™ã®ãŒã„ã„ã¨æ€ã„ã¾ã™ãŒè¿½åŠ ã™ã‚‹å ´åˆã®æ‰‹é †ã¨æ³¨æ„ç‚¹ã§ã™ã€‚ ãƒ»ã¾ãšã¯ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã‚’ä½œæˆ CREATE TABLE `mura`.`test1` ( `date` DATE NOT NULL , `name` VARCHAR( 40 ) NOT NULL , `contents` VARCHAR( 255 ) NOT NULL , `created_at` DATETIME NOT NULL ) ENGINE = InnoDB PARTITION BY RANGE (TO_
yuanying 2011/11/02
mysql

machinae
ãƒªãƒ³ã‚¯
MySQL Spiderã‚¨ãƒ³ã‚¸ãƒ³ã‚’ä½¿ã£ã¦ã¿ãŸã€‚ã€œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ãƒ£ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°(sharding)ã¨ã¯ã€œ - æ°—ã¾ã¾ã«æ›¸ã„ã¦ã¿ã¾ã—ãŸæ—¥è¨˜
ã‚‚ã—ã‹ã—ãŸã‚‰ä½¿ã†ã‹ã‚‚ã—ã‚Œãªã„ã®ã§èª¿ã¹ã¦ã¿ãŸã€‚ shard æ—¥æœ¬èªžã«è¨³ã™ã¨(ã‚¬ãƒ©ã‚¹ã‚„è²æ®»ã®) ã€Œç ´ç‰‡ã€ã¨ã„ã£ãŸã‚ˆã†ãªæ„å‘³ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’shardã«åˆ†è§£ã—ã¦è¤‡æ•°ã®ã‚µãƒ¼ãƒã«åˆ†æ•£ã—ã¦é‹ç”¨ã™ã‚‹ã®ãŒDB sharding ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã¨ã‚‚è¨€ãˆã‚‹ã®ã‹ã—ã‚‰ï¼Ÿ å˜ä¸€ã®ã‚µãƒ¼ãƒã®DBãƒ†ãƒ¼ãƒ–ãƒ«ã‚’è¤‡æ•°ã®ãƒ•ã‚¡ã‚¤ãƒ«ã«åˆ†å‰²ã™ã‚‹ã®ã‚’ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã¨ã‚‚å‘¼ã¶ãŒã€ã€Œãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã€ã¨ã„ã†è¨€è‘‰ã‚’ä½¿ã£ã¦DB shardingã®ã“ã¨ã‚’è¨€ã£ã¦ã„ã‚‹ãƒ–ãƒã‚°ç‰ã‚‚ã¡ã‚‰ã»ã‚‰è¦‹ã‹ã‘ã¾ã™ã€‚ ã‚ˆã‚Šçªã£è¾¼ã‚“ã§ã¿ãŸã„äººã¯ã€Œshared nothingã€ã§ããã£ã¦ãƒã€‚ ãªãœãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’åˆ†æ•£å‡¦ç†ã™ã‚‹ã®ã‹ æ¨ªè»¸ã«ã¯ã‚µãƒ¼ãƒ“ã‚¹é‹ç”¨é–‹å§‹ã‹ã‚‰ã®æ™‚é–“çµŒéŽã‚’è¨å®šã—ã€ç¸¦è»¸ã«ã¯ã€ŒDBã®å¿œç”æ™‚é–“ã€ã€ã€ŒDBã¸ã®å•ã„åˆã‚ã›æ•°ã€ã€ã€ŒDBã‚µã‚¤ã‚ºã€ã®å„æ•°é‡ã‚’ã¨ã‚Šã¾ã™ã€‚ã‚µãƒ¼ãƒ“ã‚¹ãŒé †èª¿ã«åˆ©ç”¨ã•ã‚Œã¦ã„ã£ã¦ã„ã‚‹ã‚‚ã®ã¨ã—ã€ã€ŒDBã‚µã‚¤ã‚ºã€ã‚„ã€ŒDBã¸ã®å•ã„åˆã‚ã›æ•°ã€ã¯æ™‚é–“çµŒ
yuanying 2011/11/02
mysql

triathlon

machinae
ãƒªãƒ³ã‚¯
Good night, Posterous
Posterous Spaces is no longer available Thanks to all of my @posterous peeps. Y'all made this a crazy ride and it was an honor and pleasure working with all of y'all. Thanks to all of the users. Thanks to the academy. Nobody will read this.
yuanying 2011/02/14
mysql

development
ãƒªãƒ³ã‚¯
Troubleshooting â€“ MacRuby â€“ Trac
All user-submitted text and content on this website is licensed under a Creative Commons Attribution 2.5 License unless otherwise noted. Copyright Â© 2008 Apple Inc. All rights reserved. Troubleshooting This page tries to enumerate frequently asked questions regarding well-known Ruby issues on Mac OS X. If your probl em isn't described here, feel free to [contact us]. I cannot build ruby-mysql on Le
yuanying 2007/10/28
mac

leopard

ruby

mysql
ãƒªãƒ³ã‚¯
MyDNS: Home
MyDNS is a free DNS server for UNIX. It was implemented from scratch and is designed to serve records directly from an SQL database (currently either MySQL or PostgreSQL). Its primary objectives are stability, security, interoperability, and speed, though not necessarily in that order. MyDNS does not include recursive name service, nor a resolver library. It is primarily designed for organizations
yuanying 2007/08/03
dns

mysql
ãƒªãƒ³ã‚¯
MySQL :: MySQL 8.0 Reference Manual :: 7.1.15 MySQL Server Time Zone Support
yuanying 2007/04/29
mysql

timezone
ãƒªãƒ³ã‚¯
MySQLã§å…¨æ–‡æ¤œç´¢ - FULLTEXTã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºç¤ŽçŸ¥è˜ï½œblogï½œãŸãŸã¿ãƒ©ãƒœ
tatamilab.jp
yuanying 2007/03/15
mysql
ãƒªãƒ³ã‚¯
MySQLã‚’è‡ªå‹•ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹ã€ŒAutoMySQLBackupã€
ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹ã®ãŒé¢å€’ãªMySQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’è‡ªå‹•çš„ã«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã§ãã‚‹ã‚ˆã†ã«ãªã‚‹ã‚¹ã‚¯ãƒªãƒ—ãƒˆã§ã™ã€‚ ã„ãã¤ã‚‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä¸€æ‹¬ã§ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã§ãã¾ã™ã€‚1ã¤ã®ãƒ•ã‚¡ã‚¤ãƒ«ã¨ã—ã¦ã¾ã¨ã‚ã¦ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹ã“ã¨ã‚‚ã§ãã‚‹ã—ã€å„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã”ã¨ã«åˆ†ã‘ã¦ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ã€‚ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ•ã‚¡ã‚¤ãƒ«ã¯gzipã‹bzip2ã§åœ§ç¸®ã•ã‚Œã¦ã„ã‚‹ã®ã§ãƒ‡ã‚£ã‚¹ã‚¯å®¹é‡ã‚‚é£Ÿã„ã¾ã›ã‚“ã€‚ãƒªãƒ¢ãƒ¼ãƒˆã®MySQLã‚’ä¸å¤®ã®MySQLã«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã—ãŸã‚Šã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®ãƒã‚°ã‚’ãƒ¡ãƒ¼ãƒ«ã§é€ã‚‹ã“ã¨ã‚‚å¯èƒ½ã€‚ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã—ãŸãƒ•ã‚¡ã‚¤ãƒ«è‡ªä½“ã‚’ãƒ¡ãƒ¼ãƒ«ã§é€ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ã€‚ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¯cronã‚’ä½¿ã†ä»¥å¤–ã«æ‰‹å‹•ã§è¡Œã†ã“ã¨ã‚‚å¯èƒ½ãªã®ã§ã€cronãŒãªãã¦ã‚‚ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¯ã§ãã¾ã™ã€‚ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã¨è©³ç´°ã¯ä»¥ä¸‹ã®é€šã‚Šã€‚ Automatic MySQL Backup SourceForge.net: AutoMySQLBackup æœ€å°é™ã®è¨å®šã§ã™ãã«ä½¿ã†
yuanying 2006/07/30
mysql

linux
ãƒªãƒ³ã‚¯
KLab
ã”æŒ‡å®šã®ãƒšãƒ¼ã‚¸ãŒè¦‹ã¤ã‹ã‚Šã¾ã›ã‚“ã§ã—ãŸ URLã®å¤‰æ›´ã€ã‚‚ã—ãã¯ãƒšãƒ¼ã‚¸ãŒå‰Šé™¤ã•ã‚ŒãŸå¯èƒ½æ€§ãŒã‚ã‚Šã¾ã™ã€‚ ãŠæ‰‹æ•°ã§ã™ãŒã€ä»¥ä¸‹ã®ãƒªãƒ³ã‚¯ã‹ã‚‰ç›®çš„ã®ãƒšãƒ¼ã‚¸ã‚’ãŠæŽ¢ã—ãã ã•ã„ã€‚
yuanying 2006/07/15
mysql
ãƒªãƒ³ã‚¯
Tagã®æ¤œç´¢ã«MySQLã®å…¨æ–‡æ¤œç´¢ã‚’ä½¿ã† : blog.nomadscafe.jp
Tagã®æ¤œç´¢ã«MySQLã®å…¨æ–‡æ¤œç´¢ã‚’ä½¿ã† Tags with MySQL fulltextã‚’å‚è€ƒã«ã—ã¦è©¦ã—ã¦ã¿ãŸã€‚ Femoã®ä¸ã§ã€ã‚¿ã‚°ã®çµžã‚Šè¾¼ã¿æ©Ÿèƒ½ã‚’å®Ÿè£…ã—ãŸã®ã«ç¶šã„ã¦ã€ã€Œå®Œäº†ã€ã‚„ã€Œfinishã€ã¨è¨€ã£ãŸã‚¿ã‚°ãŒã¤ã„ã¦ã„ã‚‹å ´åˆè¡¨ç¤ºã—ãªã„ã¨ã„ã†ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’è€ƒãˆã¦ã„ã‚‹ã€‚ ãã†ãªã£ã¦ãã‚‹ã¨ã€SQLã‚’ã©ã†æ›¸ã‘ã°ã„ã„ã®ã‹ã€ã¾ãŸè¤‡é›‘ãªSQLã‚’æ§‹ç¯‰ã—ãŸã¨ãã«ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¯å¤§ä¸ˆå¤«ãªã®ã‹ã¨å¿ƒé…ã€‚ãã“ã§ã€ä¸Šè¨˜ã®URLã‚’å‚è€ƒã«ã—ãªãŒã‚‰MySQLã®å…¨æ–‡æ¤œç´¢ã«æ³¨ç›®ã€‚ create table ft_tags( id int unsigned not null auto_increment primary key, tags text, unpack text, fulltext (unpack) ) ã¨è¨€ã†ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã€‚ ã“ã“ã«ã€ my @tags = ( q/task femo/, q/femo mail t
yuanying 2006/03/28
mysql

database
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸