[B! DBA] gouei2001ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

gouei2001 id:gouei2001

DBAã«é–¢ã™ã‚‹gouei2001ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

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

ä»Šã‹ã‚‰å‚™ãˆã‚‹MySQLæœ€æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.7
2015/06/10 db tech showcase 2015 Tokyo ãƒã‚°ã‚’è²¼ã‚Šä»˜ã‘ã¦ã„ã‚‹éƒ¨åˆ†ãŒè¦‹ã«ãããªã£ã¦ã„ã¾ã™ã®ã§ã€ http://yoku0825.blogspot.jp/search/label/5.7 ãªã©ã§ã‚‚åŒã˜ã‚ˆã†ãªå†…å®¹ãŒè¦‹ã‚‰ã‚ŒãŸã‚Šã—ã¾ã™
gouei2001 2016/11/21
DBA

5.6

2013å¹´

*ã‚ã¨ã§èªã‚€

development

mysql

ã‚ã¨ã§èªã‚€

mysql5.7

5.7

mysql 5.7
ãƒªãƒ³ã‚¯
DBAã®ãŸã‚ã®mysqldumpã®tips 25é¸ | Yakst
MySQLæ¨™æº–ã®ãƒ€ãƒ³ãƒ—ãƒ„ãƒ¼ãƒ«mysqldumpã«ã¤ã„ã¦ã€åŸºç¤Žçš„ãªä½¿ã„æ–¹ã‹ã‚‰ã‚ˆãä½¿ã‚ã‚Œã‚‹ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã€ç‰¹å¾´ã¾ã§ã‚’å«ã‚€25å€‹ã®å•ç”é›†ã€‚ 1) mysqldumpã¯ãƒ†ã‚ã‚¹ãƒˆãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ„ãƒ¼ãƒ«ï¼Ÿãã‚Œã¨ã‚‚ãƒã‚¤ãƒŠãƒªãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ„ãƒ¼ãƒ«ï¼Ÿ ãƒ†ã‚ã‚¹ãƒˆãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ„ãƒ¼ãƒ«ã ã€‚ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ•ã‚¡ã‚¤ãƒ«ã‚’é–‹ã‘ã°ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ãã®ä¸ã®ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’ä½œã‚Šç›´ã™ãŸã‚ã®å…¨æ–‡ãŒè¦‹ã‚‰ã‚Œã‚‹ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ã«ãƒ‡ãƒ¼ã‚¿ã‚’è©°ã‚è¾¼ã‚€ãŸã‚ã®insertæ–‡ã‚‚ã‚‚ã¡ã‚ã‚“å«ã¾ã‚Œã¦ã„ã‚‹ã€‚ 2) mysqldumpã®ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã¯ï¼Ÿ $ mysqldump -u [uname] -p[pass] â€“databases [dbname] [dbname2] > [backupfile.sql] 3) å…¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¯ã©ã†ã—ãŸã‚‰ã„ã„ï¼Ÿ $ mysqldump -u root -p â€“all-databases > backupfile.sql
gouei2001 2015/04/21
dump

Backup

DBA

mysql

mysqldump

ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—

sysadmin

server
ãƒªãƒ³ã‚¯
MySQLãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’å®‰å…¨ã«åˆ©ç”¨ã™ã‚‹ãŸã‚ã®10ã®ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯
MySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯éžå¸¸ã«ç°¡å˜ã«ä½¿ãˆã‚‹å‰²ã«ã¯å¿œç”¨ã®å¹…ãŒåºƒã„ã®ã§éžå¸¸ã«äººæ°—ã®ã‚ã‚‹æ©Ÿèƒ½ã®ä¸€ã¤ã§ã‚ã‚‹ã€‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®å¿œç”¨åˆ†é‡Žã¯ä¾‹ãˆã°ã€ ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— å‚ç…§ç³»ã®è² è·åˆ†æ•£ HAï¼ˆé«˜å¯ç”¨æ€§ï¼‰ ãƒ‡ã‚£ã‚¶ã‚¹ã‚¿ãƒªã‚«ãƒãƒªï¼ˆã‚µã‚¤ãƒˆé–“ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ï¼‰ BIï¼ˆãƒ¬ãƒãƒ¼ãƒ†ã‚£ãƒ³ã‚°etcï¼‰ ã¨ã„ã†é¢¨ã«ã¨ã¦ã‚‚å¤šãã®ãƒãƒªã‚¨ãƒ¼ã‚·ãƒ§ãƒ³ãŒã‚ã‚‹ã€‚ã“ã®ãƒ–ãƒã‚°ã‚’èªã‚“ã§é ‚ã„ã¦ã„ã‚‹çš†ã•ã‚“ã®ä¸ã«ã‚‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½¿ã£ã¦ã„ã‚‹æ–¹ã¯å¤šã„ã®ã§ã¯ãªã„ã ã‚ã†ã‹ã€‚ã”è¦§ã®é€šã‚ŠMySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã¯ãƒŸãƒƒã‚·ãƒ§ãƒ³ã‚¯ãƒªãƒ†ã‚£ã‚«ãƒ«åˆ†é‡Žã§ã‚‚åˆ©ç”¨ã•ã‚Œã¦ã„ã‚‹ãŒã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ä½¿ã„æ–¹ãŒé©åˆ‡ã§ãªã„ã¨ã‚·ã‚¹ãƒ†ãƒ ã®å®‰å®šç¨¼åƒã«æ”¯éšœã‚’æ¥ã—ã¦ã—ã¾ã£ã¦DBAã‚„ã‚·ã‚¹ãƒ†ãƒ ç®¡ç†è€…ã®è‚‰ä½“çš„ã€ç²¾ç¥žçš„è² æ‹…ãŒå¢—å¤§ã—ã¦ã—ã¾ã†ã€‚é€†ã«ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’å …ç‰¢ã«é‹ç”¨ã™ã‚‹ã“ã¨ãŒå‡ºæ¥ã‚Œã°ãƒžã‚¯ãƒ©ã‚’é«˜ãã—ã¦çœ ã‚Œã‚‹ã¨ã„ã†ã‚‚ã®ã ã€‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯MySQLã®ä»£è¡¨çš„ãªæ©Ÿèƒ½ã§ã‚ã‚‹ã®ã§ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³
gouei2001 2014/03/07
MySQL

DBA

MySQL

ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³
ãƒªãƒ³ã‚¯
Amazon RDS(MySQL)ã§Timezoneã‚’å¤‰æ›´ã™ã‚‹ | DevelopersIO
ã©ã‚‚ã€å¤§ç€§ã§ã™ã€‚ RDSã«ã™ã‚‹ã‹ã€DB on EC2ã«ã™ã‚‹ã‹ã‚’æ¤œè¨Žã™ã‚‹éš›ã«ã‚ˆãæŒ™ãŒã‚‹ã®ãŒã€Timezoneã‚’ã©ã†ã™ã‚‹ã‹ã¨ã„ã†è©±ã€‚AWSã®ã‚µãƒ¼ãƒ“ã‚¹ã¯åŸºæœ¬çš„ã«ã¯UTC(ä¸–ç•Œæ¨™æº–æ™‚)ã§æä¾›ã•ã‚Œã€RDSã‚‚ä¾‹å¤–ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ ã€Œä¸–ç•Œå±•é–‹ã‚’ç‹™ã†ã‚µãƒ¼ãƒ“ã‚¹ã§ã‚ã‚Œã°å½“ç„¶UTCã§ï¼ã€ã¨ãªã‚‹ã®ã§ã™ãŒã€æ—¢å˜ã‚·ã‚¹ãƒ†ãƒ ã‚’AWSã«ç§»è¡Œã™ã‚‹æ¡ˆä»¶ãªã©ã§ã¯ã€Œã‚¢ãƒ—ãƒªã®æ”¹ä¿®ãŒã§ããªã„ã®ã§ã€ç§»è¡Œå‰ã¨Timezoneã‚’åˆã‚ã›ãŸã„ã€ã‚±ãƒ¼ã‚¹ãŒå¤šã„ã¨æ€ã„ã¾ã™ã€‚ EC2ã§ã‚ã‚Œã°ã€OSã®Timezoneè¨å®šã‚’ã¡ã‚‡ã¡ã‚‡ã„ã¨å¤‰ãˆã‚‹ã ã‘ã§å¯¾å¿œã§ãã‚‹ã®ã§ã™ãŒã€RDSã¯ç›´æŽ¥ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã«ãƒã‚°ã‚¤ãƒ³ã§ããªã„ãŸã‚ã€ã¡ã‚‡ã£ã¨ã—ãŸå·¥å¤«ã¨æ³¨æ„ãŒå¿…è¦ã§ã™ã€‚ æ¦‚è¦ ä»Šå›žã¯RDS MySQLã‚’å¯¾è±¡ã«ã€Timezoneã‚’å¤‰æ›´ã™ã‚‹æ–¹æ³•ã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚ RDSã§ãƒ¦ãƒ¼ã‚¶ãƒ¼ã«æä¾›ã•ã‚Œã‚‹"Masterãƒ¦ãƒ¼ã‚¶ãƒ¼"ã¯ã€MySQLã®rootãƒ¦ãƒ¼ã‚¶ãƒ¼ã¨ã¯ç•°ãªã‚ŠSUPERæ¨©é™(ç®¡ç†è€…æ¨©é™)
gouei2001 2014/02/20
db

AWS

ec2

EC

Amazon

DBA

MySQL

Amazon RDS

database

mysql
ãƒªãƒ³ã‚¯
æœ¬å½“ã«æ€–ã„ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒæ‚ªã„å®Ÿè£… #phpcon2013
(PHPã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹2013ã§ã®ç™ºè¡¨å†…å®¹ã§ã™) Yahoo! JAPANã»ã©ã®å¤§è¦æ¨¡ã‚µã‚¤ãƒˆã«ãŠã„ã¦ã¯ã€å°ã•ãªã‚³ãƒ¼ãƒ‰ã§ã‚‚åœ§å€’çš„ã«ä½¿ã‚ã‚Œã‚‹ã“ã¨ã§å¤§é‡ã®ã‚³ã‚¹ãƒˆã‚’ç”Ÿã¿å‡ºã—ã¾ã™ã€‚å®Ÿä¾‹ã‚’äº¤ãˆã¦éžåŠ¹çŽ‡ãªå®Ÿè£…ã¨ã€ãã®æ”¹å–„ä¾‹ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚
gouei2001 2013/09/18
DBA

db

php

performance

phpcon2013

php.tuning

presentation
ãƒªãƒ³ã‚¯
Devsã®å¸¸è˜ã€DBAã¯éžå¸¸è˜
PostgreSQLã‚’Kubernetesä¸Šã§æ´»ç”¨ã™ã‚‹ãŸã‚ã®Operatorç´¹ä»‹ï¼ï¼ˆCloud Native Database Meetup #3 ç™ºè¡¨è³‡æ–™ï¼‰
gouei2001 2013/09/15
MySQL

DB

database

mysql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

DBA

performance

Slideshare

presentation

tuning
ãƒªãƒ³ã‚¯
1