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

nullpobug id:nullpobug

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (8)

ã‚¿ã‚°ã®çµžã‚Šè¾¼ã¿ã‚’è§£é™¤

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

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
nullpobug 2014/05/29
mysql

innodb

backup
ãƒªãƒ³ã‚¯
Percona XtraBackup for MySQL
All of Perconaâ€™s open source software products, in one place, to download as much or as little as you need.
nullpobug 2014/05/29
mysql

backup

innodb
ãƒªãƒ³ã‚¯
ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®ã€Œ3-2-1ãƒ«ãƒ¼ãƒ«ã€ã¨ã¯ï¼Ÿ - ä½¿ãˆã‚‹ãã£ã¨
ä¼æ¥ãŒæ‰±ã†ãƒ‡ãƒ¼ã‚¿ã¯ã€æ¥å‹™ã‚·ã‚¹ãƒ†ãƒ ã‚„é¡§å®¢æƒ…å ±ã€æ—¥ã€…ã®ã‚„ã‚Šå–ã‚Šãªã©ã€å¤šãã®æ´»å‹•ã‚’æ”¯ãˆã‚‹é‡è¦ãªè³‡ç”£ã§ã™ã€‚ã—ã‹ã—è¿‘å¹´ã¯ãƒ©ãƒ³ã‚µãƒ ã‚¦ã‚§ã‚¢ã‚’ã¯ã˜ã‚ã¨ã™ã‚‹ã‚µã‚¤ãƒãƒ¼æ”»æ’ƒã‚„ã€ä¸æ£ã‚¢ã‚¯ã‚»ã‚¹ã€ãƒãƒ¼ãƒ‰ãƒ‡ã‚£ã‚¹ã‚¯ã®æ•…éšœã€ç½å®³ãªã©ã€ãƒ‡ãƒ¼ã‚¿ã‚’è„…ã‹ã™ãƒªã‚¹ã‚¯ãŒæ€¥å¢—ã—ã¦ã„ã¾ã™ã€‚ç‰¹ã«ãƒªãƒ¢ãƒ¼ãƒˆãƒ¯ãƒ¼ã‚¯ã®æ™®åŠã«ã‚ˆã‚Šã€ã‚¯ãƒ©ã‚¦ãƒ‰ã‚„NASãªã©è¤‡æ•°ã®ç’°å¢ƒã§ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†ä¼æ¥ã§ã¯ã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®ä»•çµ„ã¿ãŒè¤‡é›‘ã«ãªã‚ŠãŒã¡ã§ã™ã€‚ ã“ã†ã—ãŸçŠ¶æ³ã§ä¼æ¥è¦æ¨¡ã‚’å•ã‚ãšå–ã‚Šçµ„ã‚€ã¹ãåŸºæœ¬åŽŸå‰‡ãŒã€Œ3-2-1ãƒ«ãƒ¼ãƒ«ã€ã§ã™ã€‚æœ¬è¨˜äº‹ã§ã¯ã€ã“ã®ãƒ«ãƒ¼ãƒ«ã®è€ƒãˆæ–¹ã¨ã€ä¸å°ä¼æ¥ã§ã‚‚å°Žå…¥ã—ã‚„ã™ã„ã‚¯ãƒ©ã‚¦ãƒ‰æ´»ç”¨åž‹ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®ãƒã‚¤ãƒ³ãƒˆã‚’ã‚ã‹ã‚Šã‚„ã™ãè§£èª¬ã—ã¾ã™ã€‚ã¾ãŸã€BCPå¯¾ç–ã¨ã—ã¦ã‚‚æœ‰åŠ¹ãªãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æˆ¦ç•¥ã‚’ã€ä½¿ãˆã‚‹ã‚¯ãƒ©ã‚¦ãƒ‰ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ»ä½¿ãˆã‚‹ãƒ•ã‚¡ã‚¤ãƒ«ç®±ã¨ã¨ã‚‚ã«ç´¹ä»‹ã—ã¾ã™ã€‚ ä½¿ãˆã‚‹ã‚¯ãƒ©ã‚¦ãƒ‰ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®è©³ç´°ã¯ã“ã¡ã‚‰ï¼žï¼ž ä½¿ãˆã‚‹ãƒ•ã‚¡ã‚¤ãƒ«ç®±ã®è©³ç´°ã¯ã“ã¡ã‚‰ï¼žï¼ž ç›®æ¬¡ 3-2-1ãƒ«ãƒ¼ãƒ«ã¨ã¯ï¼Ÿä¼æ¥ãƒãƒƒ
nullpobug 2013/05/09
backup
ãƒªãƒ³ã‚¯
MySQL :: MySQL 8.0 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 7.3.1 ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒãƒªã‚·ãƒ¼ã®ç¢ºç«‹
å½¹ã«ç«‹ã¤ã‚ˆã†ã«ã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¯å®šæœŸçš„ã«ã‚¹ã‚±ã‚¸ãƒ¥ãƒ¼ãƒ«ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ å®Œå…¨ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— (ç‰¹å®šã®æ™‚ç‚¹ã§ã®ãƒ‡ãƒ¼ã‚¿ã®ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆ) ã¯ã€MySQL ã§ã„ãã¤ã‹ã®ãƒ„ãƒ¼ãƒ«ã‚’ä½¿ç”¨ã—ã¦å®Ÿè¡Œã§ãã¾ã™ã€‚ ãŸã¨ãˆã°ã€MySQL Enterprise Backup ã¯ã€InnoDB ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ™‚ã«ã‚ªãƒ¼ãƒãƒ¼ãƒ˜ãƒƒãƒ‰ã‚’æœ€å°ã«ã—ã€ä¸æ–ã‚’é˜²ãæœ€é©åŒ–ã‚’ä¼´ã†ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹å…¨ä½“ã®ç‰©ç†ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å®Ÿè¡Œã§ãã¾ã™ã€‚mysqldump ã¯ã‚ªãƒ³ãƒ©ã‚¤ãƒ³è«–ç†ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’æä¾›ã—ã¾ã™ã€‚ ã“ã®èª¬æ˜Žã§ã¯ mysqldump ã‚’ä½¿ç”¨ã—ã¾ã™ã€‚ è² è·ãŒå°‘ãªã„æ—¥æ›œæ—¥ã®åˆå¾Œ 1 æ™‚ã«ã€æ¬¡ã®ã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ç”¨ã—ã¦ã€ã™ã¹ã¦ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã™ã¹ã¦ã® InnoDB ãƒ†ãƒ¼ãƒ–ãƒ«ã®å®Œå…¨ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’ä½œæˆã™ã‚‹ã¨ã—ã¾ã™ã€‚ shell> mysqldump --all-databases --master-data --single-transactio
nullpobug 2012/11/13
mysql

backup
ãƒªãƒ³ã‚¯
GitHub - kazuho/blockdiff: differential backup tool for block devices and files
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
nullpobug 2010/04/06
backup

lvm
ãƒªãƒ³ã‚¯
Amazon S3ã«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’ã™ã‚‹ - aticoã«ã‚ˆã†ã“ã
ä¼šç¤¾ã§ã‚µãƒ¼ãƒã®ãƒ•ã‚¡ã‚¤ãƒ«éƒ¡ã‚’Amazonã€€S3ã«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹ã“ã¨ã«ãªã‚Šã€ãã® ãŸã‚ã®ãƒ„ãƒ¼ãƒ«ã‚’Rubyã§ä½œæˆã—ã¾ã—ãŸã€‚ ä¼šç¤¾ã®äº†è§£ã‚’å¾—ã¦ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã«ã—ã¦ã„ã„ã“ã¨ã«ãªã£ãŸã®ã§ã€rubyforgeã« ç™»éŒ²ã—ã¾ã—ãŸã€‚ãŸã ã€Windowsã§ã¯å‹•ä½œã—ã¾ã›ã‚“ã€‚ S3Backup:http://rubyforge.org/projects/s3backup/ S3Backupã«ã¤ã„ã¦ æ¦‚è¦ S3Backupãƒ„ãƒ¼ãƒ«ã¨ã¯ã€æŒ‡å®šã—ãŸãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªä»¥ä¸‹ã‚’Amazon S3ã«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— /ãƒªã‚¹ãƒˆã‚¢ã™ã‚‹ãŸã‚ã®ãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ ç‰¹å¾´ã¨ã—ã¦ã¯ä¸‹è¨˜ãŒã‚ã‚Šã¾ã™ã€‚ åœ§ç¸® Amazon S3ã«ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã™ã‚‹éš›ã«å„ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã‚’åœ§ç¸®ã™ã‚‹ãŸã‚ã€é€šä¿¡å¸¯åŸŸã‚„ä¿å˜é ˜åŸŸã‚’ç¯€ç´„ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ æš—å·åŒ– è¨å®šã«ã‚ˆã‚Šã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã™ã‚‹ãƒ•ã‚¡ã‚¤ãƒ«ã‚’æš—å·åŒ–ã•ã›ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ã€‚ å·®åˆ†ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãŒå‰å›žãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã—ãŸæ™‚ã¨å†…å®¹ãŒå¤‰ã‚
nullpobug 2010/03/30
s3

backup

amazon

ruby

aws
ãƒªãƒ³ã‚¯
Mac OS Xã‹ã‚‰Windowsãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹ã«ã¯
ãƒ‹ãƒ¥ãƒ¼ã‚¹ã€å ã„ã€ã‚¢ãƒ—ãƒªã€éŸ³æ¥½ã€å‹•ç”»ã€æ›¸ç±ãªã©ã€Œã‚¹ãƒžãƒ›ãƒ»ãƒ©ã‚¤ãƒ•ã€ã‚’æ¥½ã—ã‚€ãŸã‚ã®æƒ…å ±ã‚’ç„¡æ–™ã§ãŠå±Šã‘ã—ã¾ã™ã€‚ ä»Šå¾Œã¯ã€dãƒ¡ãƒ‹ãƒ¥ãƒ¼ã‚’ã”åˆ©ç”¨ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
nullpobug 2008/03/06
mac

backup
ãƒªãƒ³ã‚¯
1