[B! backup] kwryã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kwry id:kwry

backupã«é–¢ã™ã‚‹kwryã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (28)

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

20130223 OSC Tokyo/Spring
ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ 2013 Tokyo/Spring ã§ã®è¬›æ¼”ã€‚ç ”ç©¶æ‰€åç¾©ã ã‘ã©ã»ã¨ã‚“ã©å‹ã®ä¼šã®å†…å®¹ã€‚ãƒ“ã‚¸ãƒã‚¹ç‰ˆã‚³ãƒžãƒ³ãƒ‰ã‚’å°‘ã—ä½¿ç”¨ã€‚
kwry 2015/03/01
mysql

backup
ãƒªãƒ³ã‚¯
mysqldump+bin-logã«ã‚ˆã‚‹InnoDBã®backupã®è¨å®šã¨Perlå®Ÿè£…ã‚¹ã‚¯ãƒªãƒ—ãƒˆ | hirobanex.net
è‹¥å¹²ãã‚Œã¾ã™ãŒã€ã‚ã¾ã‚Šã«å¯¾å¿œã™ã‚‹ã®ã‚‚ã©ã†ã‹ã¨æ€ã„ã¾ã™ãŒã€ãƒ‡ã‚£ãƒ¬ã‚¯ã‚¿ãƒ¼ã‚„é¡§å®¢ãŒã€Œã‚ã®ãƒ‡ãƒ¼ã‚¿æ‰‹ãŒæ»‘ã£ã¦å‰Šé™¤ã«ã—ã¡ã‚ƒã£ãŸã‚“ã ã‘ã©ã€ã‚„ã£ã±ã‚Šæˆ»ã›ãªã„??ã€ã£ã¦ã„ã†ã®ã‚’ç„¡è¦–ã™ã‚‹ã®ã¯ã©ã†ã‹ã¨æ€ã„ã¾ã™ã—ã€é–‹ç™ºæ™‚ã¨ã‹é‹ç”¨å½“åˆã¯ã„ã¾ã„ã¡è¦ä»¶ã‚‚å®šã¾ã£ã¦ã„ãªã„ã“ã¨ãŒå¤šã„ã¯ãšãªã®ã§ã€ãã†ã„ã†è¦³ç‚¹ã‹ã‚‰ã‚‚ã—ã£ã‹ã‚Šãã®ã»ã‹ã®æ‰‹æ³•ã‚‚çµ„ã¿åˆã‚ã›ã‚‹ã¹ãã§ã™ã‚ˆã? å®Ÿéš›ã®çµ„ã¿åˆã‚ã› é‹ç”¨çŠ¶æ³ã«å¿œã˜ã¦ä»¥ä¸‹ã®ã‚ˆã†ã«çµ„ã¿åˆã‚ã›ã‚‹ã®ãŒä¸€èˆ¬çš„ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹? [Webåž‹]mysqldumpç³» + bin-log + ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ [Webåž‹]mysqldumpç³» + ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ [ã©ã†ã§ã‚‚ã„ã„ç³»,Î±ç‰ˆ]mysqldumpç³» + bin-log [ãƒãƒƒãƒã‚·ã‚¹ãƒ†ãƒ ]mysqldumpç³» ãƒãƒƒãƒã®å ´åˆã¯æ¥½ã§ã™ãã€‚ã§ã€ä»Šå›žã¯ãŸã„ã—ã¦ãŠé‡‘ãªã„ã‚“ã ã‘ã©ã€ã¾ãã—ã£ã‹ã‚Šãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã£ã½ã„ã“ã¨ã‚’ã‚„ã‚ŠãŸã„ã‚±ãƒ¼ã‚¹ã¸ã®å¯¾å¿œã¨ã—ã¦æœ€ä½Žé™ã®ã€Œmysq
kwry 2013/09/03
mysql

backup
ãƒªãƒ³ã‚¯
Percona XtraBackupã®æŠ½å‡ºã¨åœ§ç¸®ã®ä¸¦åˆ—å‡¦ç† | å¤–é“çˆ¶ã®åŒ
ä¹…ã€…ã«XtraBackupã®è©±é¡Œã§ã™ã€‚ ä»¥å‰ã«ç´¹ä»‹ã—ãŸåŸºæœ¬æ‰‹é †ã§ã¯ã€tarã‚¢ãƒ¼ã‚«ã‚¤ãƒ–ã‚’gzipåœ§ç¸®ã—ã¦ã„ã¾ã—ãŸã€‚ å®Ÿã¯ã“ã‚Œã‚ˆã‚Šã‚‚ã£ã¨é€Ÿã„æ–¹æ³•ãŒã‚ã‚Šã¾ã—ã¦ã€ãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚ºãŒå¤§ãããªã‚‹ã¨å¿…é ˆã«ãªã£ã¦ãã‚‹ã®ã§ã¯ãªã„ã‹ã¨æ€ã„ã¾ã™ã€‚ãã®ã€è¨ˆæ¸¬å†…å®¹ã¨çµæžœã«ã¤ã„ã¦ç´¹ä»‹ã—ã¦ã„ããŸã„ã¨æ€ã„ã¾ã™ã€‚ ãƒªãƒ³ã‚¯ æœ¬ä»¶ã«é–¢ä¿‚ã‚ã‚Šãã†ãªãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã®ãƒªãƒ³ã‚¯ã«ãªã‚Šã¾ã™ã€‚ The xtrabackup Option Reference Streaming and Compressing Backups The xbstream Binary Accelerating with â€“parallel copy and â€“compress-threads Making a Compressed Backup (qpress) æœ¬å®¶ãƒ–ãƒã‚°ã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚‚ã‚ã‚Šã¾ã™ã€‚ Compression for InnoDB backup â€“ My
kwry 2012/12/06
backup

msyql
ãƒªãƒ³ã‚¯
MySQLãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®åŸºæœ¬
ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—å‹‰å¼·ä¼š#2 (#bkstudy) ã§ã®ç™ºè¡¨è³‡æ–™ã§ã™ã€‚ http://atnd.org/event/bkstudy02 MySQLãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®åŸºæœ¬çš„ãªå†…å®¹ã«ã¤ã„ã¦ã¾ã¨ã‚ã¦ã„ã¾ã™ã€‚
kwry 2012/11/24
backup

mysql
ãƒªãƒ³ã‚¯
Percona XtraBackupã®æ©Ÿèƒ½ç´¹ä»‹ (2) ãƒ†ãƒ¼ãƒ–ãƒ«å˜ä½ã§æŠ½å‡º | å¤–é“çˆ¶ã®åŒ
XtraBackupã‚·ãƒªãƒ¼ã‚ºã§ä»Šå›žã¯ãƒ†ãƒ¼ãƒ–ãƒ«å˜ä½ã®ãƒ‡ãƒ¼ã‚¿æŠ½å‡ºï¼†ãƒªã‚¹ãƒˆã‚¢ã§ã™ã€‚ é€šå¸¸ã¯å…¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å¯¾è±¡ã¨ã—ã¾ã™ãŒã€ãƒ†ã‚¹ãƒˆç”¨ã¨ã‹ã§éƒ¨åˆ†çš„ã«æœ¬ç•ªãƒ‡ãƒ¼ã‚¿ãŒæ¬²ã—ã„æ™‚ãªã©ã«åˆ©ç”¨ã§ãã¾ã™ã€‚ç”¨æ„ã•ã‚Œã¦ã„ã‚‹ï¼’ç¨®é¡žã®æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ åˆ©ç”¨æ¡ä»¶ ã©ã¡ã‚‰ã®æ–¹æ³•ã‚‚ã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ï¼ãƒªã‚¹ãƒˆã‚¢ã®ä¸¡ã‚µãƒ¼ãƒã«ãŠã„ã¦ innodb_file_per_table è¨å®šãŒæœ‰åŠ¹ãªå¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ éƒ¨åˆ†çš„ãªãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— Partial Backups ã‚ˆã‚Šã€‚ æ£è¦è¡¨ç¾æŒ‡å®š â€“tables é€šå¸¸ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨åŸºæœ¬ã¯åŒã˜ã§ã€â€“tables ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’æŒ‡å®šã™ã‚‹ã“ã¨ã§ç‰¹å®šã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã¿ã‚’æŠ½å‡ºã§ãã¾ã™ã€‚ã“ã®ä¾‹ã§ã¯ sbtestãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã€test* ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã¿å–ã‚Šå‡ºã—ã¦ãŠã‚Šã€sbtestãƒ†ãƒ¼ãƒ–ãƒ«ãŒã‚¹ã‚ãƒƒãƒ—ã•ã‚Œã¦ã„ã‚‹ã“ã¨ãŒã‚ã‹ã‚Šã¾ã™ã€‚ # xtrabackup --backup --datadir=/fio/mysql/ --ta
kwry 2012/10/21
backup

mysql
ãƒªãƒ³ã‚¯
Percona XtraBackupã®åŸºæœ¬çš„ãªä½¿ã„æ–¹ | å¤–é“çˆ¶ã®åŒ
Perconaã¨ã„ãˆã°XtraBackup!! ã¨ã„ã£ã¦ã‚‚éŽè¨€ã§ã¯ãªã„ã“ã®æ©Ÿèƒ½ã€‚ ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ‰‹æ³•ã¯ã„ãã¤ã‹ã‚ã‚Œã©ã€å°‘ãªãã¨ã‚‚mysqldumpã‚’ä½¿ã†ãã‚‰ã„ãªã‚‰XtraBackupã‚’ä½¿ã£ã¨ã‘ã°ã„ã„ã¨æ€ã„ã¾ã™ã€‚æ‰‹å§‹ã‚ã«ã€ç°¡å˜ãªä½¿ã„æ–¹ã‹ã‚‰ç´¹ä»‹ã—ã¦ã„ãã¾ã™ã€‚ ã¯ã˜ã‚ã« ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã«ã¤ã„ã¦ã¯å‰ã«ã¾ã¨ã‚ã¦ã‚ã‚Šã€å˜ã«ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã ã‘ã«ãªã£ã¦ã„ã¾ã™ã€‚ ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯å¿…ãšæœ€æ–°ã‚’ä½¿ã£ã¦ãã ã•ã„ã€‚ã ã„ã¶å®‰å®šã—ã¦ããŸã¨ã¯ã„ãˆã€ãƒã‚°ãƒ•ã‚£ãƒƒã‚¯ã‚¹ã¯å¸¸ã«ã•ã‚Œã¦ãŠã‚Šã€ç‰¹ã« v2.0.0 ã§ã¯8GBã‚’è¶…ãˆã‚‹ãƒ‡ãƒ¼ã‚¿ã®éš›ã«ã‚¨ãƒ©ãƒ¼ãŒèµ·ã“ã‚‹ãŸã‚ã€ä¿®æ£ã•ã‚Œã¦ã„ã¾ã™ï¼ˆå‚ç…§ï¼šAnnouncing Percona XtraBackup 2.0.1ï¼‰ã€‚ XtraBackupã¯mysqldumpã¨æ¯”ã¹ã‚‹ã¨ã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ä½œæˆé€Ÿåº¦ãŒé…ããªã£ãŸã‚Šã€ãƒ‡ãƒ¼ã‚¿å®¹é‡ãŒå¤§ãããªã£ãŸã‚Šã™ã‚‹å ´åˆãŒã‚ã‚Šã¾ã™ãŒã€ãã®ä»£ã‚ã‚Šã«ä»¥ä¸‹ã®ã‚ˆã†ãªãƒ¡ãƒªãƒƒãƒˆãŒã‚ã‚Šã¾
kwry 2012/09/26
backup

mysql
ãƒªãƒ³ã‚¯
gitã®bareãƒªãƒã‚¸ãƒˆãƒªã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’ã¨ã‚‹ - tumblr
ãƒãƒ¼ãƒ ã§gitã‚’ä½¿ã†ã¨ãã¯å€‹äººã®å…¬é–‹ãƒªãƒã‚¸ãƒˆãƒªã‹ã‚‰é©å®œpullã™ã‚‹ã€ãªã‚“ã¦ã“ã¨ã¯ã›ãšã«svnã®ã‚ˆã†ã«ä¸å¤®é›†æ¨©çš„ãªbareãƒªãƒã‚¸ãƒˆãƒªã‚’ä½œã‚‹ã“ã¨ã«ãªã‚‹ã¨æ€ã„ã¾ã™ã€‚ ã§ã€ãã®ãƒªãƒã‚¸ãƒˆãƒªãŒå¹ã£é£›ã‚“ã ã¨ãã¨ã‹ã¯ã€åˆ†æ•£åž‹ã®ç‰¹æ€§ã‚’ç”Ÿã‹ã—ã¦å€‹äººã®ãƒªãƒã‚¸ãƒˆãƒªã‚’ãƒ‰ãƒ©ã‚´ãƒ³ãƒœãƒ¼ãƒ«ã¿ãŸã„ã«å¯„ã›é›†ã‚ã¦é¡˜ã„äº‹ã‚’å”±ãˆãªãŒã‚‰mergeã‚’ã—ã¦bareãƒªãƒã‚¸ãƒˆãƒªã‚’è˜‡ã‚‰ã›ã‚‹ã¨ã„ã†ãƒŠãƒ¡ãƒƒã‚¯å¼ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å–ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ãŒã€ã‚„ã¯ã‚Šã“ã“ã¯å®‡å®™äººã®ãªã‹ã§ã‚‚ãƒ€ãƒ³ãƒˆãƒ„ã§ã‹ã—ã“ã„ã¨ã•ã‚Œã‚‹åœ°çƒäººã‚‰ã—ã•ã‚’è¦‹ã›ã¦ãŠããŸã„ã‚ã‘ã§ã‚ã‚Šã¾ã™ã€‚ ã¨ã„ã†ã‚ã‘ã§bareãƒªãƒã‚¸ãƒˆãƒªã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’ã¨ã‚ŠãŸã„ã®ã§ã™ã€‚ ãƒ™ã‚¿ã«rsyncã¨ã‹scpã§ãƒªãƒã‚¸ãƒˆãƒªã¾ã‚‹ã”ã¨æ—¥æ¬¡ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨ã„ã†ã®ã‚‚ã„ã„ã®ã§ã™ãŒã€ãã®å ´åˆãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ™‚åˆ»ã‹ã‚‰ãƒªãƒã‚¸ãƒˆãƒªãŒå¹ã£é£›ã‚“ã çž¬é–“ã®é–“ã«pushã•ã‚Œã¦ã„ãŸå¤‰æ›´ã¯å¤±ã‚ã‚Œã¦ã—ã¾ã†ã‚ã‘ã§ã™ã€‚å¤±ã‚ã‚ŒãŸåˆ†ã‚’ã‚ã–ã‚ã–pushã™ã‚‹ã®ã¯åœ°çƒäººã‚‰ã—ãã‚ã‚Šã¾
kwry 2012/09/16
backup

git
ãƒªãƒ³ã‚¯
Mysql casial01
[db tech showcase Tokyo 2015] C27:æ¥½å¤©MySQL Backup Structure by æ¥½å¤©æ ªå¼ä¼šç¤¾ ç²Ÿç”°å•“ä»‹
kwry 2012/06/27
backup

mysql
ãƒªãƒ³ã‚¯
http://blog.suz-lab.com/2012/05/ec2ami.html
kwry 2012/05/18
backup

ec2
ãƒªãƒ³ã‚¯
XtraBackupã‚’ä½¿ã£ã¦MySQLã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã—ã‚ˆã† | ã•ã¶ã¿ã£ã¨ï¼JAPAN
XtraBackupã¨ã¯ Perconaç¤¾ ãŒé–‹ç™ºã—ã¦ã„ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®MySQLã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ„ãƒ¼ãƒ«ã§ã™ã€‚InnoDB, XtraDBã¨MyISAMã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’ãƒ–ãƒãƒƒã‚¯ã™ã‚‹ã“ã¨ãªããƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’ã™ã‚‹äº‹ãŒå‡ºæ¥ã¾ã™ã€‚ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã¯GPLv2ã§ç„¡æ–™ã§ä½¿ãˆã¾ã™ã€‚ MySQLã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ–¹æ³•ã¨ã—ã¦ã‚ˆãä½¿ã‚ã‚Œã¦ã„ã‚‹mysqldumpã¨ã„ã†ãƒ„ãƒ¼ãƒ«ãŒæœ‰ã‚Šã¾ã™ãŒã€ å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‹ã‚‰ãƒ€ãƒ³ãƒ—ã—ãŸãƒ‡ãƒ¼ã‚¿ã‚’ãƒªã‚¹ãƒˆã‚¢ï¼ˆå¾©æ—§ï¼‰ã™ã‚‹æ™‚ã«éžå¸¸ã«æ™‚é–“ãŒæŽ›ã‹ã£ã¦ã—ã¾ã†ã¨ã„ã†æ¬ ç‚¹ãŒã‚ã‚Šã¾ã™ã€‚ ã“ã“ã§ã¯ã€mysqldumpã¨XtraBackupã‚’ä½¿ã£ã¦ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å–ã‚Šã€ä¸¡è€…ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨ãƒªã‚¹ãƒˆã‚¢ã®ã‚¹ãƒ”ãƒ¼ãƒ‰ã®é•ã„ã‚’æ¯”è¼ƒã—ã¦ã¿ã¾ã™ã€‚ ä½¿ç”¨ã™ã‚‹ã‚µãƒ¼ãƒã¯ä»¥ä¸‹ã®é€šã‚Šã§ã™ ã‚µãƒ¼ãƒ ã•ãã‚‰ã®ã‚¯ãƒ©ã‚¦ãƒ‰ã€€ãƒ—ãƒ©ãƒ³8ã€€CPUä»®æƒ³4ã‚³ã‚¢ã€€ãƒ¡ãƒ¢ãƒª24GBã€€HDD100GB OS CentOS 5.7 64bit M
kwry 2012/02/05
backup

mysql
ãƒªãƒ³ã‚¯
ã€Œãƒ‹ãƒ•ãƒ†ã‚£rã‚¯ãƒ©ã‚¦ãƒ‰ãƒ¦ãƒ¼ã‚¶ãƒ¼ãƒ–ãƒã‚°ã€ã¯ã€ç§»è»¢ã—ã¾ã—ãŸã€‚
ã€Œãƒ‹ãƒ•ãƒ†ã‚£ã‚¯ãƒ©ã‚¦ãƒ‰ãƒ¦ãƒ¼ã‚¶ãƒ¼ãƒ–ãƒã‚°ã€ã¯ã€ç§»è»¢ã—ã¾ã—ãŸã€‚ è‡ªå‹•ã§ãƒšãƒ¼ã‚¸ã‚’ç§»å‹•ã—ãªã„å ´åˆã¯ã€ä¸‹è¨˜ã®ãƒªãƒ³ã‚¯ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã€ æ–°ã—ã„ã€Œãƒ‹ãƒ•ãƒ†ã‚£ã‚¯ãƒ©ã‚¦ãƒ‰ãƒ¦ãƒ¼ã‚¶ãƒ¼ãƒ–ãƒã‚°ã€ã‚’ã”è¦§ãã ã•ã„ã€‚ ä»Šå¾Œã¨ã‚‚ã€Œãƒ‹ãƒ•ãƒ†ã‚£ã‚¯ãƒ©ã‚¦ãƒ‰ãƒ¦ãƒ¼ã‚¶ãƒ¼ãƒ–ãƒã‚°ã€ã‚’ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ ï¼ž ãƒ‹ãƒ•ãƒ†ã‚£ã‚¯ãƒ©ã‚¦ãƒ‰ãƒ¦ãƒ¼ã‚¶ãƒ¼ãƒ–ãƒã‚°
kwry 2011/09/07
mysql

backup
ãƒªãƒ³ã‚¯
xtrabackupã‚’ã¡ã‚‡ã£ã¨ä¾¿åˆ©ã«ä½¿ã† - ã‹ã¿ã½ã‚ãƒ¼ã‚‹
xtrabackupã«ã¯innobackupexã¨ã„ã†ãƒ©ãƒƒãƒ‘ãƒ¼ã‚¹ã‚¯ãƒªãƒ—ãƒˆãŒä»˜å±žã—ã¦ã„ã¦ã€MySQLã®ãƒ—ãƒã‚»ã‚¹ã‚’æ¢ã‚ã‚‹ã“ã¨ãªããƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å–ã‚Œã¦ä¾¿åˆ©ãªã‚“ã§ã™ãŒã€innobackupexã§ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—å–ã‚‹ã¨ä»¥ä¸‹ã®ç‚¹ãŒä¸æº€ã ã£ãŸã‚Šã™ã‚‹ã€‚ --slave-infoã§ç”Ÿæˆã•ã‚Œã‚‹CHANGE MASTERæ–‡ãŒä¸å®Œå…¨ãªã®ã§slaveã®è¤‡è£½ãŒé¢å€’ InnoDBã¨MyISAMã®ãƒ•ã‚¡ã‚¤ãƒ«ã—ã‹ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã•ã‚Œãªã„ tritonnã§sennaã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«ãŒãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã•ã‚Œãªãã¦å›°ã‚‹ ãã“ã§ã€innobackupexã¯Perlã§æ›¸ã‹ã‚Œã¦ã‚‹ã®ã§ç›´æŽ¥æ›¸ãæ›ãˆã¦master.infoã¨sennaã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«ã‚‚ä¸€ç·’ã«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹ã‚ˆã†ã«ã—ãŸã‚‰slaveç°¡å˜ã«è¤‡è£½ã§ãã‚‹ã‚ˆã†ã«ãªã£ã¦ä¾¿åˆ©ã§ã™ã‚ˆï¼
kwry 2011/01/28
mysql

backup
ãƒªãƒ³ã‚¯
slaveã‹ã‚‰ãƒ€ãƒ³ãƒ—ã‚’ã¨ã£ãŸå ´åˆã®CHANGE MASTER TOã«ã¤ã„ã¦ - ãƒ¡ãƒ¢ã¨ã‹ãã‚“ãªæ„Ÿã˜ãªã‚„ã¤
MySQLã®slaveã‚µãƒ¼ãƒã‹ã‚‰cronã§ä¸€æ—¥ä¸€å›žãƒ€ãƒ³ãƒ—ãƒ•ã‚¡ã‚¤ãƒ«ã‚’å–å¾—ã—ã¦ã¦ã€ ãã®ãƒ€ãƒ³ãƒ—ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½¿ã£ã¦ã©ã“ã‹ã®ã‚µãƒ¼ãƒã«ãƒªã‚¹ãƒˆã‚¢ã—ãŸå ´åˆã€ æ–°ã—ããƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’é–‹å§‹ã™ã‚‹éš›ã«ç™ºè¡Œã™ã‚‹CHANGE MASTER TOã‚³ãƒžãƒ³ãƒ‰ã¯ä¸€ä½“ä½•ã‚’æŒ‡å®šã—ãŸã‚‰ã„ã„ã‚“ã ã‚ã†ï¼Ÿ ä¾‹ãˆã°masterã‚µãƒ¼ãƒã§ãƒ€ãƒ³ãƒ—ã‚’å–å¾—ã™ã‚‹å ´åˆã€mysqldumpã‚³ãƒžãƒ³ãƒ‰ã®ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã¨ã—ã¦ ã€Œ--master-data=2ã€ã‚’æŒ‡å®šã—ã¦ã‚„ã‚‹ã¨ã€dumpãƒ•ã‚¡ã‚¤ãƒ«ä¸ã«CHANGE MASTERã‚³ãƒžãƒ³ãƒ‰ãŒä»˜åŠ ã•ã‚Œã‚‹ã€‚ ã“ã‚Œã¯éžå¸¸ã«ä¾¿åˆ©ãªã‚“ã ã‘ã©ã€ã‚ãã¾ã§show master statusã®å€¤ã‚’å–ã£ã¦ã„ã‚‹ã®ã§ slaveã‚µãƒ¼ãƒã§ã“ã‚Œã¤ã‘ã¦ã‚‚ã¾ã£ãŸãæ„å‘³ãŒãªã„ã€‚ slaveã§ãƒ€ãƒ³ãƒ—ã¨ã‚‹ã¨ãã‚‚ã€ã“ã‚“ãªä¾¿åˆ©ã‚ªãƒ—ã‚·ãƒ§ãƒ³ãªã„ã‹ãªãƒ¼ã¨æ€ã£ã¦ãŸã‚“ã§ã™ãŒã€ MySQL 5.5ã‹ã‚‰--dump-slaveã£ã¦ã®ãŒè¿½åŠ ã•ã‚Œã‚‹ã‚ˆã†ã§ã™ã€‚ --dump-sl
kwry 2011/01/01
mysql

backup
ãƒªãƒ³ã‚¯
Amazon S3 ã«è‡ªå‹•ã§å®šæœŸçš„ã«DB ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’ã¨ã‚‹ã‚ˆã†ã«ã—ã¾ã—ãŸ
Amazon S3 ã¯åˆ©ç”¨é‡ã®ä¸Šé™ãŒãªã„ã§ã™ã—ã€è²»ç”¨ã‚‚å‰²ã¨å®‰ã„ã®ã§ã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ç”¨ã®ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã¨ã—ã¦ã¯çµæ§‹ä¾¿åˆ©ã ã¨æ€ã„ã¾ã™ã€‚SCP ãªã©ã®ä»Šã¾ã§ä½¿ã„æ…£ã‚Œã¦ã„ãŸãƒ‡ãƒ¼ã‚¿è»¢é€ã®ä»•çµ„ã¿ã‚’ä½¿ãˆãªã„ã®ãŒå°‘ã—é¢å€’ã«æ„Ÿã˜ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒã€ãã‚Œã‚‚ã‚·ã‚§ãƒ«ã‚¹ã‚¯ãƒªãƒ—ãƒˆãªã©ã§ä¸€åº¦è‡ªå‹•åŒ–ã—ã¦ã—ã¾ãˆã°å•é¡Œã‚ã‚Šã¾ã›ã‚“ã€‚S3 ã¸ã®ãƒ‡ãƒ¼ã‚¿è»¢é€ã«ã¯Ruby è£½ã®s3sync ã‚’ä½¿ã£ã¦ã„ã¾ã™ãŒã€ã“ã‚Œã«é–¢ã—ã¦ã¯ä»–ã«è©³ã—ã„è¨˜äº‹ãŒã”ã–ã„ã¾ã™ã®ã§ãã¡ã‚‰ã‚’å‚ç…§ã—ã¦ãã ã•ã„ã€‚ S3sync ã«ã¤ã„ã¦ S3Sync.net - S3Sync Wiki Amazon EC2/S3ã‚’ä½¿ã£ã¦ã¿ãŸ - 8.EC2ã¨S3ã®ãƒ‡ãƒ¼ã‚¿ã‚’åŒæœŸã•ã›ã‚‹(S3Syncã‚’ä½¿ã†) ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’è‡ªå‹•åŒ– åŸºæœ¬çš„ã«ç›´è¿‘2ãƒ¶æœˆé–“ã¯æ¯Žæ™‚ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’æ®‹ã—ã€ãã‚Œä»¥å‰ã¯æœˆåˆã®ãƒ‡ãƒ¼ã‚¿ã ã‘æ°¸ç¶šçš„ã«æ®‹ã™ã¨ã„ã†ãƒãƒªã‚·ãƒ¼ã§é‹ç”¨ã—ã‚ˆã†ã¨æ€ã„ã¾ã™ã®ã§ã€ä»Šå›žã¯ä»¥ä¸‹ã®ä½œæ¥ã‚’è‡ªå‹•åŒ–ã—ã¾ã—ãŸ
kwry 2010/11/06
ec2

backup

storage
ãƒªãƒ³ã‚¯
Google Code Archive - Long-term storage for Google Code Project Hosting.
Code Archive Skip to content Google About Google Privacy Terms
kwry 2010/06/04
datastore

backup
ãƒªãƒ³ã‚¯
DataStoreã®ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆã‚’ã¨ã£ã¦ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹æ‰‹é † - urekatã®ã‚¹ã‚«ãƒ³ã‚¯æ—¥è¨˜ï¼“
ã‚’è€ƒãˆã¦ã¿ã¾ã—ãŸã€‚ã©ã†ã§ã—ã‚‡ã†ã€‚ ã‚µãƒ¼ãƒ“ã‚¹ã¯æ¢ã‚ãšã«ï¼ˆã ã„ãŸã„ï¼‰æ•´åˆæ€§ã®ã‚ã‚‹ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆã‚’å–ã‚Šã¾ã™ã€‚ ãã‚‚ãã‚‚åˆ†æ•£DBã ã‹ã‚‰åŽ³å¯†ãªã®ã¯é›£ã—ã„ã‚“ã§ã™ã‚ˆãï¼Ÿ å„ã‚µãƒ¼ãƒã®æ™‚è¨ˆã¯ã»ã¨ã‚“ã©ãšã‚Œã¦ã„ãªã„å‰æã€‚ å…¨ä½“ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— [ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆæ™‚åˆ»]ã‚’è¨å®šã—ã¦deploy put/deleteæ™‚ã« updated_at < [ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆæ™‚åˆ»] ã‹ã¤ [ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆæ™‚åˆ»] <= ç¾æ™‚åˆ» ãªã‚‰ [å¤‰æ›´å‰ã®Entity]ã‚’ã‚·ãƒªã‚¢ãƒ©ã‚¤ã‚ºã—ã¦ä¿å˜ã™ã‚‹(Entityå†…ã§ã‚‚åˆ¥Entityã§ã‚‚ã€‚åã«ã™ã‚Œã°ã„ã„ã‹ã‚‚) [å…¨Entity]ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ [ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆæ™‚åˆ»]ã®è¨å®šã‚’è§£é™¤ã—ã¦deploy ä¿å˜ã—ã¦ãŠã„ãŸ[å¤‰æ›´å‰ã®Entity]ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ [å…¨Entity]+[å¤‰æ›´å‰ã®Entity]ã‹ã‚‰ã€Œupdated_at < [ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆæ™‚åˆ»]ã€ãªãƒ‡ãƒ¼ã‚¿ã‚’æŠ½å‡º å·®åˆ†ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— ã€Ž[å…¨Ent
kwry 2010/06/04
datastore

backup
ãƒªãƒ³ã‚¯
#appengine ã§ã‚¹ã‚ãƒ¼ãƒžå¤‰æ›´ã«å¯¾å¿œã™ã‚‹ãƒãƒƒãƒå‡¦ç†ã‚’è¡Œã†
2009/11/05è¿½è¨˜ã²ãŒã•ã‚“ã‚ˆã‚ŠæŒ‡æ‘˜ã‚’é ‚ã„ã¦ã€30ç§’åˆ¶é™ã«é–¢ã™ã‚‹è£œè¶³ã‚’æœ¬æ–‡ä¸ã«é’å—ã§è¿½è¨˜ã—ã¾ã—ãŸã€‚ã„ã¤ã‚‚ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€åŠ©ã‹ã‚Šã¾ã™ï¼žã²ãŒã•ã‚“ ã“ã“ã‹ã‚‰æœ¬æ–‡ ã‚¿ã‚¤ãƒˆãƒ«ã®å‡¦ç†ã«ã¤ã„ã¦ã€ã„ãã¤ã‹ãƒŽã‚¦ãƒã‚¦ã‚’æ›¸ã„ã¦ãŠãã¾ã™ã€‚ãƒã‚¤ãƒ³ãƒˆã¯ä»¥ä¸‹ã®2ç‚¹ã€‚ å…¨ã¦ã®ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã«ã‚¹ã‚ãƒ¼ãƒžãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚’ä¿æŒã™ã‚‹ ãƒãƒ¼ã‚«ãƒ«ç’°å¢ƒã‹ã‚‰ãƒ‡ãƒ—ãƒã‚¤ç’°å¢ƒã¸ç›´çµã—ã¦ãƒãƒƒãƒå‡¦ç†ã‚’å®Ÿè¡Œã™ã‚‹äº‹ã§ã€30ç§’åˆ¶é™ãªã‚“ã¦ç„¡è¦–ã—ã¦ã—ã¾ã† å®Ÿä¾‹ã‚’ã‚‚ã¨ã«èª¬æ˜Žã—ã¦ã¿ã¾ã™ã€‚æœ€è¿‘ã€appengine java nightç”¨ã®ã¾ã¨ã‚ãƒšãƒ¼ã‚¸ã¨ã‹ã«ä½¿ãŠã†ã¨ã—ã¦ã„ã‚‹ã‚µã‚¤ãƒˆã‚’é‹å–¶ã—ã¦ã„ã¦ã€ãã“ã«ã€ŒTwitterã§AppEngineé–¢é€£ã«ã¤ã„ã¦ã¤ã¶ã‚„ã‹ã‚ŒãŸå†…å®¹ã‚’åŽé›†ã™ã‚‹ã€ã¨ã„ã†æ©Ÿèƒ½ã‚’å®Ÿè£…ã—ã¾ã—ãŸã€‚ã—ã‹ã—ã€ã¤ã¶ã‚„ãã‚’ä¿å˜ã™ã‚‹éš›ã®æŠ•ç¨¿è€…ã®æƒ…å ±ã¨ã—ã¦ã€ŒNameã€ã‚’ä¿æŒã—ã¦ã„ã‚‹ã‚‚ã®ã®ã€ŒScreenNameã€ã‚’ä¿æŒã—ã¦ãŠã‚‰ãšã€æŠ•ç¨¿è€…ã®ã‚¿ã‚¤ãƒ ãƒ©ã‚¤ãƒ³ãƒšãƒ¼ã‚¸ã¸ã®ãƒªãƒ³ã‚¯ã‚’ä½œæˆ
kwry 2010/06/04
datastore

backup
ãƒªãƒ³ã‚¯
MySQLãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—é ‚ä¸Šæ±ºæˆ¦ï¼ï¼ LVMã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆ vs InnoDB Hot Backup
ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆã‚’ä½¿ãˆã°ã¨ã‚ã‚‹çž¬é–“ã®ãƒ‡ã‚£ã‚¹ã‚¯ã‚„ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã®ãƒ‡ãƒ¼ã‚¿ã‚’ã„ã¤ã§ã‚‚å¾Œã‹ã‚‰å‚ç…§ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ã—ã‹ã‚‚ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆã®ä½œæˆã¯ä¸€çž¬ã ã€‚ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆæ©Ÿèƒ½ã‚’æ´»ç”¨ã™ã‚Œã°æœ€å¼·ã®ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ãŒå‡ºæ¥ã‚‹ã ã‚ã†ã€‚ ã—ã‹ã—ã€ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆã§ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å–ã‚‹ãªã‚“ã¦å±é™ºãªæ“ä½œã˜ã‚ƒãªã„ã®ã‹ï¼Ÿï¼ã¨ä¸å®‰ã«æ€ã‚ã‚Œã‚‹æ–¹ã‚‚ã„ã‚‰ã£ã—ã‚ƒã‚‹ã‹ã‚‚çŸ¥ã‚Œãªã„ã€‚MySQL ServerãŒç¨¼åƒä¸ã«ã„ããªã‚Šãƒ‡ãƒ¼ã‚¿ã ã‘ã‚’ã¨ã£ã¦ãã‚‹ã®ã ã‹ã‚‰ã€ãã®ã‚ˆã†ãªç–‘å•ã‚’æŒãŸã‚Œã‚‹ã®ã¯é ·ã‘ã‚‹ã€‚ã—ã‹ã—ä»•çµ„ã¿ã•ãˆåˆ†ã‹ã‚Œã°ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆã«ã‚ˆã‚‹ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¯æ€–ããªã„ã¨ã„ã†ã“ã¨ãŒåˆ†ã‹ã‚‹ã¯ãšã ã€‚ãã“ã§ã€ã¾ãšã¯ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆã«ã‚ˆã‚‹ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®ä»•çµ„ã¿ã«ã¤ã„ã¦èª¬æ˜Žã™ã‚‹ã€‚ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆã‚’å–ã‚‹éš›ã®è¦ä»¶ã¯æ¬¡ã®é€šã‚Šã§ã‚ã‚‹ã€‚ å…¨ã¦ã®ãƒ‡ãƒ¼ã‚¿ã‚’å˜ä¸€ã®ãƒœãƒªãƒ¥ãƒ¼ãƒ ã«ç½®ãã“ã¨ã€‚ã¤ã¾ã‚Šã€ä¸€å›žã®ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆæ“ä½œã§ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãŒå–ã‚Œã‚‹ã“ã¨ã ã€‚ ãƒ‡ã‚£
kwry 2009/12/27
mysql

backup
ãƒªãƒ³ã‚¯
Tritonn ã®ãƒ›ãƒƒãƒˆãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—(ã¨sync ï¼“å›žä¼èª¬) - kazuhoã®ãƒ¡ãƒ¢ç½®ãå ´
Tritonn ã®ãƒ›ãƒƒãƒˆãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ç’°å¢ƒã‚’æ§‹ç¯‰ã—ã‚ˆã†ã¨æ€ã£ã¦èª¿æŸ»ã€‚çµè«–ã‹ã‚‰è¨€ã†ã¨ æ¼¢(ã‚ªãƒˆã‚³)ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿é“: MySQLãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—é ‚ä¸Šæ±ºæˆ¦ï¼ï¼ LVMã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆ vs InnoDB Hot Backup ã®ã€ŒMyISAMã‚’ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆã§ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã€ã§ã‚ˆã•ãã†ã€‚ ç¢ºèªã—ãŸã“ã¨ã¨ã—ã¦ã¯ã€ Tritonn ã®å…¨æ–‡æ¤œç´¢ãƒ‡ãƒ¼ã‚¿ã¯ FLUSH TABLES ã—ã¦ã‚‚ fsync ã•ã‚Œãªã„ ã¤ã¾ã‚Š sync (1) ã®å‘¼ã³å‡ºã—ãŒå¿…é ˆ linux ã®å ´åˆ sync (1) ã¯ï¼‘å›žå‘¼ã¹ã°ååˆ†ã ã¨ man ã«æ›¸ã„ã¦ã‚ã‚‹ POSIX çš„ã«ã¯ä½•å›žå‘¼ã‚“ã§ã‚‚æ›¸ãè¾¼ã¿ãŒå®Œäº†ã—ã¦ã‚‹ä¿è¨¼ã¯ãªã„ ã£ã¦ã‚ãŸã‚Šã€‚å®Ÿéš›ã«ã€FLUSH TABLES WITH READ LOCK ã—ã¦ sync ï¼“å›žå‘¼ã‚“ã§ã‹ã‚‰ LVM snapshot ã¨ã£ã¦ã€myisamchk ã¨ sennachk ã—ã¦ã¿ãŸã‘ã©ã€myisamchk
kwry 2009/12/27
mysql

toritonn

backup
ãƒªãƒ³ã‚¯
DBã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‹ã‚‰ãƒªã‚«ãƒãƒªã™ã‚‹æ‰‹é † - (ï¾Ÿâˆ€ï¾Ÿ)oå½¡ sasata299's blog
2009å¹´06æœˆ11æ—¥00:17 MySQL DBã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‹ã‚‰ãƒªã‚«ãƒãƒªã™ã‚‹æ‰‹é † DBãŒå£Šã‚ŒãŸã¨ãã«ã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’ä½¿ã£ã¦ãƒªã‚«ãƒãƒªã™ã‚‹æ‰‹é †ã‚’è€ƒãˆã¦ã¿ã¾ã—ãŸã€‚ã“ã‚“ãªæ„Ÿã˜ã§ã„ã‘ã‚‹ã‹ãªã€œã£ã¨ã€‚å®Ÿéš›ã«ã¯è©¦ã—ã¦ç„¡ã„ã‚“ã§ã™ã‘ã©ãã€‚ã€‚ã€‚ å‰ææ¡ä»¶ ãƒ»ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ã¤ã„ã¦ã¯è€ƒæ…®ã—ã¦ã„ãªã„ã€‚ã‚ãã¾ã§ã‚‚1å°ã®ãƒªã‚¹ãƒˆã‚¢ã®ã¿ ãƒ»mysqldumpã‚’ä½¿ã£ã¦ã€æ¯Žé€±æ—¥æ›œåˆå‰1æ™‚ã«ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å–ã£ã¦ã„ã‚‹ ãƒ»ãƒã‚¤ãƒŠãƒªãƒã‚°ã‚’ä¿å˜ã™ã‚‹ã‚ˆã†ã«ã—ã¦ã„ã‚‹ï¼ˆmy.cnf ã« log-bin ã®æŒ‡å®šãŒã‚ã‚‹ï¼‰ ã‚“ï¼Ÿãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãªã‚“ã¦ã—ã¦ãªã„ã‚ˆã£ã¦äººã¯ã¾ã•ã‹ã„ãªã„ã ã‚ã†ããƒ»ãƒ»ã„ã‚„ã¾ã•ï½‹ (ã€€ï¾ŸÐ´ï¾Ÿ)ï½´??ï½¼ï¾ƒï¾…ï½²ï¾‰?? (( ï¼›ï¾ŸÐ´ï¾Ÿ))ï½±ï¾œï¾œï¾œï¾œ (((( ï¼›ï¾ŸÐ”ï¾Ÿ)))ï½¶ï¾žï½¸ï½¶ï¾žï½¸ï¾Œï¾žï¾™ï¾Œï¾žï¾™ (((((((( ï¼›ï¾ŸÐ”ï¾Ÿ)))))))ï½¶ï¾žï½¸ï½¶ï¾žï½¸ï¾Œï¾žï¾™ï¾Œï¾žï¾™ï½¶ï¾žï¾€ï½¶ï¾žï¾€ï¾Œï¾žï¾™ï½¶ï¾žï¾€ï½¶ï¾žï½¸ï½¶ï¾žï½¸ï½¶ï¾žï½¸ï½¶ï¾žï½¸ï½¶ï¾žï½¸ æœ¬å½“
kwry 2009/12/12
mysql

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