[B! db] snb04ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

snb04 id:snb04

dbã«é–¢ã™ã‚‹snb04ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

DBã‚µãƒ¼ãƒãƒ¼ã®è² è·åˆ†æ•£
MySQLã‚¢ã‚¯ã‚»ã‚¹ã‚’è² è·åˆ†æ•£ã™ã‚‹ ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‹ã‚‰ã®ã‚¢ã‚¯ã‚»ã‚¹æ•°ãŒéžå¸¸ã«å¤šã„Webã‚µã‚¤ãƒˆã«ãŠã„ã¦ã€MySQLã®SLAVEã‚µãƒ¼ãƒãƒ¼ã‚’è¤‡æ•°å°ä¸¦ã¹ã¦è² è·åˆ†æ•£ã•ã›ã‚‹ã¨ã„ã†ã“ã¨ãŒã‚ˆãè¡Œã‚ã‚Œã¦ã„ã¾ã™ã€‚ãŸã ã€Webã‚¢ã‚¯ã‚»ã‚¹ã®è² è·åˆ†æ•£ã¯ä¸€èˆ¬çš„ãªãƒ†ãƒ¼ãƒžãªã®ã§ã„ã‚ã„ã‚ãªã¨ã“ã‚ã§èªžã‚‰ã‚Œã¦ã„ã‚‹ã®ã«å¯¾ã—ã€DBã‚¢ã‚¯ã‚»ã‚¹ã®è² è·åˆ†æ•£ã¨ã„ã†ãƒ†ãƒ¼ãƒžã¯ä¸€èˆ¬çš„ã§ãªã„ã®ã‹ã‚ã¾ã‚Šèªžã‚‰ã‚Œã¦ã„ãªã„ã‚ˆã†ã«æ„Ÿã˜ã¾ã™ã€‚ DBã‚¢ã‚¯ã‚»ã‚¹ã‚’è² è·åˆ†æ•£ã™ã‚‹ã«ã‚ãŸã£ã¦ä¸€ç•ªè’ã£ã½ã„æ–¹æ³•ã¯ã€Webã‚µãƒ¼ãƒãƒ¼ä¸Šã®ãƒ—ãƒã‚°ãƒ©ãƒ ã®ä¸ã§ã©ã®SLAVEã‚µãƒ¼ãƒãƒ¼ã«æŽ¥ç¶šã™ã‚‹ã‹ã‚’ãƒ©ãƒ³ãƒ€ãƒ ã§æ±ºã‚ã‚‹æ–¹æ³•ã§ã™ã€‚ãƒ©ãƒ³ãƒ€ãƒ ã¨è¨€ã£ã¦ã‚‚é•·æ™‚é–“ã‚¢ã‚¯ã‚»ã‚¹ã—ã¦ã„ã‚‹ã¨ã»ã¼æŽ¥ç¶šå…ˆãŒå‡ç‰åŒ–ã•ã‚Œã‚‹ã®ã§ã€ä¸€è¦‹ã“ã®æ–¹æ³•ã§ã‚‚å•é¡Œãªã„ã‚ˆã†ã«è¦‹ãˆã¾ã™ã€‚ã—ã‹ã—ã“ã®æ–¹æ³•ã ã¨ã€æŽ¥ç¶šã—ã«è¡Œã“ã†ã¨ã—ãŸSLAVEã‚µãƒ¼ãƒãƒ¼ãŒé«˜è² è·ã‚‚ã—ãã¯ã‚µãƒ¼ãƒ“ã‚¹åœæ¢ä¸ã§ã‚ã£ã¦ã‚‚æ§‹ã‚ãšæŽ¥ç¶šã—ã«è¡Œã£ã¦ã—ã¾ã†ã¨ã„ã†å•é¡ŒãŒã‚ã‚Šã¾ã™ã€‚ ã“ã®ã‚ˆã†ãªå•é¡Œã‚’è§£æ±ºã™ã‚‹
snb04 2012/02/04
db
ãƒªãƒ³ã‚¯
MySQLã®ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ï¼šè€ãƒ—ãƒã‚°ãƒ©ãƒžãƒ¼ã®å‚™å¿˜éŒ²ï¼šSo-netãƒ–ãƒã‚°
MySQLã®ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ« MySQLã®ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã¯ã€å®Ÿè¡Œã‚¨ãƒ©ãƒ¼ãƒã‚°ã€ã‚¯ã‚¨ãƒªãƒã‚°ã€ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚°åŠã³ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãƒã‚°ã®4ç¨®é¡žã®ãƒã‚°ãŒã‚ã‚Šã¾ã™ã€‚ å®Ÿè¡Œã‚¨ãƒ©ãƒ¼ãƒã‚° å®Ÿè¡Œã‚¨ãƒ©ãƒ¼ãƒã‚°ã¯ã€èµ·å‹•ã€åœæ¢åŠã³å®Ÿè¡Œæ™‚ã®ã‚¨ãƒ©ãƒ¼ãŒMySQLãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«"ãƒ›ã‚¹ãƒˆå.err"ã¨ã„ã†ãƒ•ã‚¡ã‚¤ãƒ«åã§ä¿ç®¡ã•ã‚Œã¾ã™ã€‚ MySQLã§éšœå®³ç™ºç”Ÿæ™‚ã«éšœå®³ç‰¹å®šã®æƒ…å ±ã‚’å¾—ã‚‹ã“ã¨ãŒå‡ºæ¥ã¾ã™ã€‚ ãƒ»è¨å®šæ–¹æ³• 1ï¼Žã‚³ãƒžãƒ³ãƒ‰ UNIXã€Linuxã®å ´åˆ $ mysqld_safe --log-error=myerror.log --log-warnings=1 Windowsã®å ´åˆ C\> mysqld-nt --log-error=myerror.log --log-warnings=1 ã‚ªãƒ—ã‚·ãƒ§ãƒ³ ã‚ªãƒ—ã‚·ãƒ§ãƒ³ å†…å®¹ --log-error[=filename] ã‚¨ãƒ©ãƒ¼ãƒã‚°ã®å‡ºåŠ›å…ˆãƒ•ã‚¡ã‚¤ãƒ«åã‚’æŒ‡å®šã—ã¾ã™ã€‚ --log-warnings[
snb04 2011/08/28
mysql

db
ãƒªãƒ³ã‚¯
DSASé–‹ç™ºè€…ã®éƒ¨å±‹:5åˆ†ã§ã§ãã‚‹ã€MySQLã®ãƒ¡ãƒ¢ãƒªé–¢ä¿‚ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ï¼
MySQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ãŠã„ã¦éžå¸¸ã«é‡è¦ã¨ãªã‚‹ãƒ¡ãƒ¢ãƒª(ãƒãƒƒãƒ•ã‚¡)é–¢é€£ã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã«ã¤ã„ã¦ã€ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãƒã‚¤ãƒ³ãƒˆ DSASã®ã¨ã‚ã‚‹DBã‚µãƒ¼ãƒ(å®Ÿãƒ¡ãƒ¢ãƒª4GB)ã®å®Ÿéš›ã®è¨å®šå€¤ ã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã™ã€‚ ã¾ãŸã€å¿…è¦ãƒ¡ãƒ¢ãƒªã®ç·é‡ã®è¨ˆç®—ã‚„é™ç•Œå€¤ã‚’è¶Šãˆã¦ãªã„ã‹ãƒã‚§ãƒƒã‚¯ã—ã¦ãã‚Œã‚‹ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚‚ç´¹ä»‹ã—ã¾ã™ã€‚ æ˜¯éžã€å‚è€ƒã«ã—ã¦ã¿ã¦ãã ã•ã„ï¼ ã¾ãšæœ€åˆã«æ³¨æ„ç‚¹ã‚’ã€‚ ãƒãƒƒãƒ•ã‚¡ã«ã¯2ã¤ã®ã‚¿ã‚¤ãƒ—ãŒã‚ã‚Šã¾ã™ã€‚ ã‚°ãƒãƒ¼ãƒãƒ«ãƒãƒƒãƒ•ã‚¡ ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ ã‚°ãƒãƒ¼ãƒãƒ«ãƒãƒƒãƒ•ã‚¡ã¯mysqldå…¨ä½“ã§ãã®ãƒãƒƒãƒ•ã‚¡ãŒ1ã¤ã ã‘ç¢ºä¿ã•ã‚Œã‚‹ã‚‚ã®ã§ã€ ã“ã‚Œã«å¯¾ã—ã€ ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ã¯ã‚¹ãƒ¬ãƒƒãƒ‰(ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³)ã”ã¨ã«ç¢ºä¿ã•ã‚Œã‚‹ã‚‚ã®ã§ã™ã€‚ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®éš›ã«ã¯ã‚°ãƒãƒ¼ãƒãƒ«/ã‚¹ãƒ¬ãƒƒãƒ‰ã®é•ã„ã‚’æ„è˜ã™ã‚‹ã‚ˆã†ã«ã—ã¾ã—ã‚‡ã†ã€‚ ãªãœãªã‚‰ã€ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ã«å¤šãã®ãƒ¡ãƒ¢ãƒªã‚’å‰²ã‚Šå½“ã¦ã‚‹ã¨ã€ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãŒå¢—ãˆãŸã¨ãŸã‚“ã«ã‚¢ãƒƒã¨ã„ã†é–“ã«ãƒ¡ãƒ¢ãƒªä¸è¶³ã«ãªã£ã¦ã—ã¾ã†ã‹ã‚‰ã§ã™ã€‚ in
snb04 2011/08/28
mysql

db
ãƒªãƒ³ã‚¯
Mysqlã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— | Develop Spot
snb04 2010/01/24
mysqldump

db

èª¿æŸ»
ãƒªãƒ³ã‚¯
http://www.mysqlpracticewiki.com/index.php/InnoDB%E3%81%AE%E3%83%AA%E3%82%B9%E3%83%88%E3%82%A2%E3%82%92%E9%AB%98%E9%80%9F%E5%8C%96
snb04 2010/01/24
InnoDBã®ãƒªã‚¹ãƒˆã‚¢ã‚’é«˜é€ŸåŒ–ã™ã‚‹ï¼ï¼ï¼

db

è³‡æ–™
ãƒªãƒ³ã‚¯
MySQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è‡ªå‹•ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—é‹ç”¨(mysqlhotcopy) - Fedoraã§è‡ªå®…ã‚µãƒ¼ãƒãƒ¼æ§‹ç¯‰
MySQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è‡ªå‹•ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’è¡Œãªã†ã€‚ ã“ã“ã§ã¯ã€MySQLå…¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã‚µãƒ¼ãƒãƒ¼å†…ã®åˆ¥ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã¸ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹ã€‚ [root@fedora ~]# vi mysql-backup.shã€€â†ã€€MySQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚¹ã‚¯ãƒªãƒ—ãƒˆä½œæˆ #!/bin/bash PATH=/usr/local/sbin:/usr/bin:/bin # ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—å…ˆãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒª BACKDIR=/backup/mysql # MySQLrootãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ ROOTPASS=Mysqlrootãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ # ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—å…ˆãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªå†ä½œæˆ rm -rf $BACKDIR mkdir -p $BACKDIR # ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åå–å¾— DBLIST=`ls -p /var/lib/mysql | grep / | tr -d /` # ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã”ã¨ã«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— for dbname
snb04 2010/01/24
MySQLãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—é‹ç”¨

db

é‹ç”¨
ãƒªãƒ³ã‚¯
ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã—ã¦ã‚‹MySQLã§ã€ãƒžã‚¹ã‚¿ã‚„ã‚¹ãƒ¬ãƒ¼ãƒ–ãŒéšœå®³åœæ¢ã—ãŸå ´åˆã®ãƒªã‚«ãƒãƒªãƒ—ãƒ©ãƒ³ - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢
MySQLã§ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒ™ãƒ¼ã‚¹ã®HAãªæ§‹æˆã«ã¤ã„ã¦è€ƒãˆãŸãƒ¡ãƒ¢ã§ã™ã€‚ 3å°(ã¨ã„ã†ã‹2å°ï¼‹1å°)ãŒã„ã„ã‹ãªãã¨æ€ã£ã¦ã„ã¦ã€å‰åŠã¯ãã®ç†ç”±ã‚’ã€å¾ŒåŠã§ã¯{ãƒžã‚¹ã‚¿,ã‚¹ãƒ¬ãƒ¼ãƒ–}ãŒ{å†èµ·ä¸èƒ½ã«ãªã£ãŸ,ã¡ã‚‡ã£ã¨ãƒ€ã‚¦ãƒ³ã—ã¦ã™ãå¾©å¸°ã—ãŸ}å ´åˆã®ãƒªã‚«ãƒãƒªãƒ—ãƒ©ãƒ³ã«ã¤ã„ã¦æ›¸ãã¾ã™ã€‚ ä»Šã®ã¨ã“ã‚ã¯ã“ã‚ŒãŒãƒ™ã‚¹ãƒˆã‹ãªã¨æ€ã£ã¦ã„ã‚‹ã®ã§ã™ãŒã€ã€Œã“ã†ã—ãŸã»ã†ãŒã„ã„ã¨æ€ã†ï¼ã€ã€Œã“ã“ãŒãŠã‹ã—ã„ï¼ã€ãªã©ãªã©ã®ã”æ„è¦‹ã¯ã‚³ãƒ¡ãƒ³ãƒˆã€TBãªã©ã§ã„ãŸã ã‘ã‚‹ã¨ã†ã‚Œã—ã„ã§ã™ã€‚ ã‚´ãƒ¼ãƒ« ãƒžã‚¹ã‚¿ãŒè½ã¡ã¦ã‚‚ããƒ¼ã™ã‹å¯ã¦ã„ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ã—ãŸã„ ãƒªã‚«ãƒãƒªã®ä½œæ¥ã¯ã§ãã‚‹ã ã‘å˜ç´”ã«ã€ã‹ã¤ã€çŸæ™‚é–“ã§å®Œäº†ã™ã‚‹ã‚ˆã†ã«ã—ãŸã„ ã‚ã‚“ã©ãã•ã„ã®ã¯ã„ã‚„ åŸºæœ¬æ§‹æˆã€æ–¹é‡ 2å°ï¼‹1å° ã‚µãƒ¼ãƒ“ã‚¹ã§ä½¿ã†ã®ã¯2å° (db1, db2) ã‚‚ã†1å°ã¯ç®¡ç†ç”¨ (db3) ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚’å¤šæ•°ä¸¦ã¹ã‚‹æ§‹æˆã«ã¯ã—ãªã„ å°æ•°å¢—ãˆã‚‹ã¨ç®¡ç†ã‚³ã‚¹ãƒˆãŒä¸ŠãŒã‚‹ ãƒžã‚¹ã‚¿ãƒ€ã‚¦ãƒ³æ™‚ã®ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒã¨ãã®ãƒ•ã‚§ã‚¤ãƒ«ãƒ
snb04 2009/10/23
ä¸è¦æ¨¡ã‚¢ãƒ—ãƒªã«ãƒ‰ãƒ³ãƒ”ã‚·ãƒ£ã®DBæ§‹æˆ

è¨è¨ˆ

db

é‹ç”¨
ãƒªãƒ³ã‚¯
1