LINEã®MySQLé‹ç”¨ã«ã¤ã„ã¦æ—¥æœ¬èªžãŒæ£ã—ã表示ã•ã‚Œã¦ã„ãªã‹ã£ãŸãŸã‚ä¿®æ£ç‰ˆã‚’アップãƒãƒ¼ãƒ‰ã„ãŸã—ã¾ã—ãŸã€‚ https://www.slideshare.net/linecorp/linemysql-115766814
YAPC::Kansai 㧠RDBアンãƒãƒ‘ターン ãã®2 ã«ã¤ã„ã¦è©±ã—ã¦ãƒ™ã‚¹ãƒˆãƒˆãƒ¼ã‚«ãƒ¼è³žã‚’å–ã£ã¦ã㟠#yapcjapan - ãーã ã„ãªã‚‹ã‚‰ããŒã帳
YAPC::Kansaiã§ãƒˆãƒ¼ã‚¯ã—ã¦ãã¾ã—ãŸã€‚ yapcjapan.org RDBアンãƒãƒ‘ターンã®è©±ã—ã¦ãã¾ã—ãŸã€‚ 去年ã€PHPカンファレンスã§RDBアンãƒãƒ‘ターンã®è©±ã‚’ã—ã¦ç››ã‚Šä¸ŠãŒã£ãŸã®ã§ãã‚Œã®ç¬¬äºŒå¼¾ã§ã™ã€‚ b.hatena.ne.jp speakerdeck.com 僕ãŒä¼ãˆãŸã„事ã¯ãŸã£ãŸã²ã¨ã¤ã€‚ ã“ã®ãƒ–ãƒã‚°ã‚’èªã‚“ã らã™ã自分ãŸã¡ã®ã‚µãƒ¼ãƒ“スã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨ãƒªã‚¹ãƒˆã‚¢æ‰‹æ®µç¢ºèªã—ã¦ãã ã•ã„ï¼ ãŠå…„ã•ã‚“ã¨ã®ç´„æŸã ãžï¼ï¼ ã“ã®ãƒˆãƒ¼ã‚¯å¿œå‹Ÿã—ãŸã‚‰GitLab.comãŒå¤§äº‹æ•…èµ·ã“ã—ãŸã‚Šã€S3ãŒè½ã¡ãŸã‚Šä¸–ã®ä¸ã§ã¯å¤§å¤‰ãã†ã§ã—ãŸã€‚ www.publickey1.jp ヒューマンエラーã¨ã‹ã‚ã‚‹ã‚“ã§ã™ã‚ˆã»ã‚“ã¨ã€‚ 僕もã„ã£ã±ã„見ã¦ããŸã—ã€ã‚„ã£ãŸã—（ã‰ãƒ ãªã®ã§æœ¬å½“ã«ã‚‚ã†ã“ã‚Œã ã‘ã¯çµ¶å¯¾ç¢ºèªã—ã¦ã»ã—ã„ã£ã¦æ€ã„ã¾ã™ã€‚ 実際ã«ã€Œãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ç„¡ã„DBã‚’ãƒã‚°ã§é£›ã°ã—ãŸã‚“ã§ã™ã‘ã©ã©ã†ã™ã‚Œã°ã„ã„ã§ã™ã‹ï¼Ÿã€ã¨ã‹ç›¸è«‡æ¥ã¾ã™ã€‚ ã»ã‚“
MySQLã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨"FLUSH TABLES WITH READ LOCK"ã«ã¤ã„㦠- jitsu102's blog
MySQLã§æ•´åˆæ€§ã®ã‚ã‚‹ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å–å¾—ã™ã‚‹ã®ã«ã€ "FLUSH TABLES WITH READ LOCK"ã§ãƒ†ãƒ¼ãƒ–ルãƒãƒƒã‚¯ ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—処ç†(mysqldumpやスナップショット) "UNLOCK TABLES"ã§ãƒãƒƒã‚¯è§£é™¤ ã¿ãŸã„ãªã‚¹ã‚¯ãƒªãƒ—トを実行ã—ã¦ã„ãŸãŒã€"FLUSH TABLES WITH READ LOCK"ã£ã¦å¿…ãšæ•°ãƒŸãƒªç§’ã¿ãŸã„ãªãƒ¬ãƒ™ãƒ«ã§ãƒãƒƒã‚¯ã§ãã‚‹ã®ã‹ãªã¨ç–‘å•ã«æ€ã£ãŸã€‚ çµæ§‹æ™‚é–“ã®ã‹ã‹ã‚‹ã‚¯ã‚¨ãƒªãŒå‡¦ç†ã•ã‚Œã¦ã„ãŸã‚Šã™ã‚‹ã¨ã€ã™ãã«ãƒãƒƒã‚¯ã§ããªã„ã‚“ã§ã¯ãªã„ã‹ã¨æ€ã£ãŸã€‚ ã¡ã‚‡ã£ã¨èª¿ã¹ã¦ã¿ã‚‹ã¨ã€ã‚„ã¯ã‚Šã™ãã«ãƒãƒƒã‚¯ã•ã‚Œãªã„å¯èƒ½æ€§ã‚‚ã‚るよã†ã 。*1 FLUSH TABLES WITH READ LOCKã®é€Ÿåº¦ã«ã¤ã„㦠ã¨ã„ã†ã“ã¨ã§ã€"FLUSH TABLES WITH READ LOCK"後ã«ã€ä»¥ä¸‹ã®ã‚ˆã†ãªç¢ºèªå‡¦ç†ã‚’è¿½åŠ ã—ãŸã€‚ "SHOW PROCESSLIST"を実行ã—ã¦ã€"FLUS
MySQLãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—é ‚ä¸Šæ±ºæˆ¦ï¼ï¼ LVMスナップショット vs InnoDB Hot Backup
スナップショットを使ãˆã°ã¨ã‚る瞬間ã®ãƒ‡ã‚£ã‚¹ã‚¯ã‚„ファイルシステムã®ãƒ‡ãƒ¼ã‚¿ã‚’ã„ã¤ã§ã‚‚後ã‹ã‚‰å‚ç…§ã™ã‚‹ã“ã¨ãŒã§ãる。ã—ã‹ã‚‚スナップショットã®ä½œæˆã¯ä¸€çž¬ã 。スナップショット機能を活用ã™ã‚Œã°æœ€å¼·ã®ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ソリューションãŒå‡ºæ¥ã‚‹ã ã‚ã†ã€‚ ã—ã‹ã—ã€ã‚¹ãƒŠãƒƒãƒ—ショットã§ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å–ã‚‹ãªã‚“ã¦å±é™ºãªæ“作ã˜ã‚ƒãªã„ã®ã‹ï¼Ÿï¼ã¨ä¸å®‰ã«æ€ã‚れる方もã„らã£ã—ゃるã‹ã‚‚知れãªã„。MySQL ServerãŒç¨¼åƒä¸ã«ã„ããªã‚Šãƒ‡ãƒ¼ã‚¿ã ã‘ã‚’ã¨ã£ã¦ãã‚‹ã®ã ã‹ã‚‰ã€ãã®ã‚ˆã†ãªç–‘å•ã‚’æŒãŸã‚Œã‚‹ã®ã¯é ·ã‘る。ã—ã‹ã—仕組ã¿ã•ãˆåˆ†ã‹ã‚Œã°ã‚¹ãƒŠãƒƒãƒ—ショットã«ã‚ˆã‚‹ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¯æ€–ããªã„ã¨ã„ã†ã“ã¨ãŒåˆ†ã‹ã‚‹ã¯ãšã 。ãã“ã§ã€ã¾ãšã¯ã‚¹ãƒŠãƒƒãƒ—ショットã«ã‚ˆã‚‹ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®ä»•çµ„ã¿ã«ã¤ã„ã¦èª¬æ˜Žã™ã‚‹ã€‚スナップショットをå–ã‚‹éš›ã®è¦ä»¶ã¯æ¬¡ã®é€šã‚Šã§ã‚る。 å…¨ã¦ã®ãƒ‡ãƒ¼ã‚¿ã‚’å˜ä¸€ã®ãƒœãƒªãƒ¥ãƒ¼ãƒ ã«ç½®ãã“ã¨ã€‚ã¤ã¾ã‚Šã€ä¸€å›žã®ã‚¹ãƒŠãƒƒãƒ—ショットæ“作ã§ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãŒå–れるã“ã¨ã 。 ディ
10分ã§åˆ†ã‹ã‚‹ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨ãƒ¬ãƒ—リケーション
レプリケーション •  データを他ノードã«ã‚ªãƒ³ãƒ©ã‚¤ãƒ³è¤‡è£½ •  ⽬目的:å¯â½¤ç”¨æ€§å‘上 Master-slave åž‹ Master 1  å°ï¼Œslave 1  å°ä»¥ä¸Š Master å¹³ç‰åž‹ å…¨ã¦ã®è¤‡è£½ãŒåŒç‰ 今回ã“ã¡ã‚‰ã¯è€ƒãˆãªã„ Replica Slave Slave Replica Repica 5 レプリケーションã®åˆ†é¡ž •  åŒæœŸ –  Slaveストレージã«ã‚‚ 書ã„ã¦ã‹ã‚‰ write IO 完了了 •  â¾®éžåŒæœŸ –  Master ストレージ㫠書ã„ãŸã‚‰ write IO 完了了 6 1 2 5 3’ 2’ 4 Master 3 Slave 4 1 3 2 2’ 4’ 3’ •  準åŒæœŸ –  ⾊色々ãªæ„味ã§ä½¿ã‚れるã®ã§æ³¨æ„ 6
ãªãœï¼Ÿâ€œç£æ°—テープâ€ãŒå¾©æ´» - NHK 特集ã¾ã‚‹ã”ã¨
データä¿å˜ã®å°‚門家 「ã„ã¾ã€ç£æ°—テープãŒéžå¸¸ã«è„šå…‰ã‚’æµ´ã³ã¦ã„る。 復活ã—ãŸã¨ã„ã£ã¦ã‚‚ã„ã„状態ã ã¨æ€ã†ã€‚〠阿部 「ãã†ã€ã‚ã‚Œã‚ã‚Œã®æ™‚代ã¯ã€ã‚«ã‚»ãƒƒãƒˆãƒ†ãƒ¼ãƒ—ã§ã™ã‚ˆã€é’春ã®æ€ã„出ã¨å…±ã«ã€‚ ãªã‹ãªã‹å‡¦åˆ†ã§ããªã„ã‚“ã§ã™ã‚ˆã€ã‹ã•ã°ã£ã¦ã„ã¦ã‚‚。〠鈴木 「ãã†ã„ã†æ–¹ã€å¤šã„ã¨æ€ã†ã‚“ã§ã™ã‚ˆã。 使ã„ã‚„ã™ã•ã®é¢ã§ã‚‚ã€è¨˜éŒ²ã§ãã‚‹æƒ…å ±é‡ã®é¢ã§ã‚‚ã€ï¼£ï¼¤ã‚„ＤＶＤã«ã¨ã£ã¦ä»£ã‚られãŸç£æ°—テープãªã‚“ã§ã™ãŒã€æ—¥æœ¬ã®ãƒ¡ãƒ¼ã‚«ãƒ¼ãŒæ€§èƒ½ã‚’飛èºçš„ã«é«˜ã‚ãŸçµæžœã€ä»Šã€å†ã³è¨˜éŒ²åª’体ã¨ã—ã¦ã€å¾©æ´»ã®ãã–ã—を見ã›ã¦ã„ã¾ã™ã€‚ æ–°ã—ã„ç£æ°—テープã¯ã€ï¼‘本ã§ï¼¤ï¼¶ï¼¤ï¼•ï¼ï¼æžšåˆ†ã¨ã„ã†ã€å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’記録ã§ãるよã†ã«ãªã£ã¦ã„ã‚‹ã‚“ã§ã™ã€‚〠阿部 「ãªãœä»Šã€ç£æ°—テープãŒæ³¨ç›®ã‚’集ã‚ã‚‹ã®ã‹ã€å–æã—ã¾ã—ãŸã€‚ã€
[MySQL] MySQLãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—シェルスクリプト – (ã£Â´âˆ€ï½€)㣠ゃー | 一撃
皆ã•ã‚“ã“ã‚“ã«ã¡ã¯ã€‚今年もåŠåˆ†ï¼¼(^o^)ï¼ï½µï¾œï¾€ã¨å˜†ãよりもã€21世紀ã®1/8ãŒçµ‚ã‚ã£ãŸã¨ã„ã†ã‚¹ã‚±ãƒ¼ãƒ«ã®å¤§ãã•ã§ã„ã‚ã„ã‚ã¨èª¤é”化ã—ã¦ã„ã‚‹ (ã£Â´âˆ€ï½€)㣠ゃー ã§ã”ã–ã„ã¾ã™ã€‚ã„ã‹ãŒãŠéŽã”ã—ã§ã—ょã†ã‹ã€‚ MySQLã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¯å¸¸ã«ã¨ã£ã¦ãŠããŸã„ã§ã™ã‚ˆã。シェルスクリプトã«æ›¸ã„ã¦ã—ã¾ã£ã¦cronã§ã¾ã‚ã›ã°ã€ã‚ã–ã‚ã–コンソールやブラウザ(phpMyAdmin)ã§ã‚«ã‚¿ã‚«ã‚¿ãƒãƒãƒãƒã—ãªãã¦æ¸ˆã¿ã¾ã™ã€‚今回作æˆã—ãŸMySQLã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—シェルスクリプトã¯ã€ãƒ¯ãƒ³ãƒ©ã‚¤ãƒŠãƒ¼ã§ã¯ã‚ã‚Šã¾ã›ã‚“ãŒãƒ¯ãƒ³ãƒ©ã‚¤ãƒŠãƒ¼ã®å¿œç”¨ã‚’使ã£ã¦ã„ã‚‹ã®ã§ã€ä¸€å¿œã‚·ã‚§ãƒ«èŠ¸ã®ã²ã¨ã¤ã¨ã—ã¦ã”紹介ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã¾ãšã¯ã„ããªã‚Šã‚½ãƒ¼ã‚¹ã‚’見ã¦ã¿ã¾ã—ょã†ã€‚ #!/bin/bash LANG=C ID=<å…¨DBã«ã‚¢ã‚¯ã‚»ã‚¹ã§ãã‚‹ID rootã¨ã‹> PASSWD=<パスワード> DSTDIR=${HOME}/src/sql [ ! -d ${DSTD
![[MySQL] MySQLãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—シェルスクリプト – (ã£Â´âˆ€ï½€)㣠ゃー | 一撃](https://cdn-ak-scissors.b.st-hatena.com/image/square/7962940168de00984df933bdf5e89f6c62f95350/backend=imagemagick;height=288;version=1;width=512/https%3A%2F%2Fnullpopopo.blogcube.info%2Fwp-content%2Fuploads%2F2013%2F08%2Fnullpopopo.jpg)
Redisã§ãƒã‚°ã®æ›¸ãè¾¼ã¿ãŒblockを引ãèµ·ã“ã™ - 酒日記 ã¯ã¦ãªæ”¯åº—
「Redisã‹ã‚ã„ã„よRedisã€(by typester)……ã¨ã„ã†ã»ã©è‡ªåˆ†ã¯ Redis 期ã§ã‚‚ãªã„ã®ã§ã™ãŒã€æœ€è¿‘ Redis を使ã£ãŸã‚µãƒ¼ãƒ“スã®é¢å€’を見ã¦ã„ã¦æ™‚々レスãƒãƒ³ã‚¹ãŒæ‚ªåŒ–ã™ã‚‹ç¾è±¡ã«å‡ºä¼šã£ãŸã®ã§èª¿ã¹ã¾ã—ãŸã€‚ å‰æ 使用ã—ã¦ã„ã‚‹ã®ã¯ Redis 2.4.16 ã§ã™ã€‚ redis.conf ã« "save [t] [n]" を定義ã™ã‚‹ã¨ã€æœ€å¾Œã« save ã‚’ã—ã¦ã‹ã‚‰ [t]秒間㫠[n]個以上㮠key ãŒæ›´æ–°ã•ã‚ŒãŸå ´åˆã« background 㧠save (=bgsave) ãŒå®Ÿè¡Œã•ã‚Œã¾ã™ã€‚ save 60 10000ã“ã‚Œã ã¨ã€60秒間㫠10,000 keys ã§ã™ã€‚ bgsave ã§ã¯ redisã¯è‡ªåˆ†è‡ªèº«ã®ãƒ—ãƒã‚»ã‚¹ã‚’ fork() ã—ã€åプãƒã‚»ã‚¹å´ã¯è‡ªåˆ†ã®ãƒ¡ãƒ¢ãƒªã«ä¹—ã£ã¦ã„る内容をファイルã«ã™ã¹ã¦æ›¸ã出ã—ã¾ã™ã€‚ ã“ã®ä»•çµ„ã¿ã«ã‚ˆã£ã¦ã€1プãƒã‚»ã‚¹ 1スレッドã§å‹•ä½œã—ã¦ã„ã‚‹ re
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
PaperBack
Olly, the author of OllyDbg, presents his new open source joke: PAPERBACK v1.10 Updated by Michael Mohr Download PaperBack v1.10 Download sources v1.10 PaperBack version 1.00 does not implement AES encryption properly. Specifically: a) The key used for (en|de)cryption in version 1.00 provides at most an effective key strength of less than 50 bits (and likely far less, perhaps on the order of 15-2
Offsite Backup for Databases | Dumper
MySQL | PostgreSQL | MongoDB | Redis Works with AWS, Linode, DigitalOcean, Rackspace, Heroku and more. Automatic daily backup to Amazon S3. Review your backup strategy Replication and RAID aren't a backup. What happens if your database is wiped by a developer by mistake, or taken hostage by an attacker? You have a virtual machine snapshot, but what happens when a wrong instance was dropped? What a
Simple Automated Backups for MongoDB Replica Sets « Michael Conigliaro
There are a bunch of different methods you can use to back up your MongoDB data, but if you want to avoid downtime and/or potential performance degradation, the most common advice seems to be that you should simply do all your backups on a slave. This makes sense, since most of your queries will be hitting the primary server anyway. Unfortunately, picking a slave isn’t so simple when dealing with
MongoDB Administration
This is a write up of Mathias Stearn's talk at the MongoUK conference, covering useful things for administrators to know when running MongoDB in production. You can find Mathias on Twitter: @mathias_mongo. Starting the server Start the server like this: $ mongod --dbpath /path/to/data Stop it with Ctrl-C or with kill (but don't use kill -9, which doesn't give the server a chance to shut down clean
1
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
Mysql casial01
snailinaturtleneck.com - snailinaturtleneck リソースãŠã‚ˆã³æƒ…å ±
{{#tags}}- {{label}}
{{/tags}}