[B! aws][mysql] moritataã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

moritata id:moritata

awsã¨mysqlã«é–¢ã™ã‚‹moritataã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (12)

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

Heroku PostgresãŒAmazon Auroraãƒ™ãƒ¼ã‚¹ã«ç§»è¡Œã€‚æ–°ãƒ—ãƒ©ãƒ³ã€ŒHeroku Postgres Essentialã€æ£å¼ãƒªãƒªãƒ¼ã‚¹
ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã‚µãƒ¼ãƒ“ã‚¹ã‚’æä¾›ã™ã‚‹Herokuã¯ã€Amazon Auroraã‚’æŽ¡ç”¨ã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒ“ã‚¹ã€ŒHeroku Postgres Essentialã€ãƒ—ãƒ©ãƒ³ã®æ£å¼ãƒªãƒªãƒ¼ã‚¹ã‚’ç™ºè¡¨ã—ã¾ã—ãŸã€‚ Heroku Postgresã¯ä»Šå¾ŒAmazon Auroraãƒ™ãƒ¼ã‚¹ã¸ç§»è¡Œ Heroku Postgresã¯ã€ãƒžãƒãƒ¼ã‚¸ãƒ‰ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒ“ã‚¹ãŒã¾ã ä¸€èˆ¬çš„ã§ã¯ãªã‹ã£ãŸã‚¯ãƒ©ã‚¦ãƒ‰åˆæœŸã®é ƒã‹ã‚‰æä¾›ã•ã‚Œã¦ããŸã€ä»£è¡¨çš„ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒ“ã‚¹ã®1ã¤ã§ã™ã€‚ ãã®Heroku Postgresã‚’é–‹ç™ºã€é‹å–¶ã—ã¦ããŸHerokuã¯æ˜¨å¹´ï¼ˆ2023å¹´ï¼‰ã€AWSä¸»å‚¬ã®ã‚¤ãƒ™ãƒ³ãƒˆã€ŒAWS re:Invent 2023ã€ã§Amazon Auroraãƒãƒ¼ãƒ ã¨ã®å”åŠ›ã‚’ç™ºè¡¨ã—ã€ä»Šå¾ŒHeroku Postgreså…¨ä½“ã‚’Amazon Auroraãƒ™ãƒ¼ã‚¹ã¸ç§»è¡Œã™ã‚‹ã“ã¨ã‚’æ˜Žã‚‰ã‹ã«ã—ã¦ã„ã¾ã™ã€‚ ã€ŒWe are migratin
moritata 2024/06/05
amazon

ã‚µãƒ¼ãƒ“ã‚¹

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

aws

mysql
ãƒªãƒ³ã‚¯
RDS Blue/Green Deployments ã‚’ä½¿ã£ã¦ã‚·ãƒ¥ãƒƒã¨ utf8mb4 ã«ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã—ãŸè©± - ã‚«ãƒŸãƒŠã‚· ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€‚ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®å‚äº• (@manabusakai) ã§ã™ã€‚ ã‚«ãƒŸãƒŠã‚·ã§ã¯ RDB ã« Amazon Aurora MySQL 2ï¼ˆMySQL 5.7 äº’æ›ï¼‰ã‚’ä½¿ã£ã¦ã„ã¾ã™ï¼ˆä»¥ä¸‹ Aurora MySQL ã¨ç•¥ã—ã¾ã™ï¼‰ã€‚ ã‚ã‚‹æ—¥ã€ç¤¾å†…ã® Slack ã§ã€Œð ®·ã€ãªã©ã®æ–‡å—åˆ—ãŒç™»éŒ²ã§ããªã„ã®ã§ã¯ãªã„ã‹ã¨ã„ã†è©±ãŒå‡ºã¾ã—ãŸã€‚ã“ã‚Œã‚’èžã„ã¦ã€Œã‚ãƒ¼ã€ã¨æ€ã£ãŸæ–¹ã‚‚å¤šã„ã§ã—ã‚‡ã†ã€‚ MySQL ã§æœ‰åãª UTF-8 ã® 4 ãƒã‚¤ãƒˆæ–‡å—å•é¡Œã§ã€æ´å²çš„ãªç†ç”±ã‹ã‚‰ MySQL 5.7 ä»¥å‰ã§ã¯ utf8 ã®æ–‡å—ã‚»ãƒƒãƒˆã¯ utf8mb4 ã§ã¯ãªã utf8mb3 ã‚’æŒ‡ã—ã¦ã„ã¾ã™ã€‚ dev.mysql.com ã‚«ãƒŸãƒŠã‚·ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯ 4 ãƒã‚¤ãƒˆã®æ–‡å—åˆ—ãŒå…¥åŠ›ã•ã‚ŒãŸå ´åˆã¯ã‚·ã‚¹ãƒ†ãƒ ã‚¨ãƒ©ãƒ¼ã‚’è¿”ã™å®Ÿè£…ã«ãªã£ã¦ã„ã¾ã™ãŒã€ã‚¨ãƒ©ãƒ¼ã®å†…å®¹ã‚’ãƒ¦ãƒ¼ã‚¶ãƒ¼ã«ã‚ã‹ã‚Šã‚„ã™ãä¼ãˆã‚‹ã“ã¨ã¯é›£ã—ã„ãŸã‚ãƒ¦ãƒ¼ã‚¶ãƒ¼ä½“é¨“ã¨ã—ã¦ã‚‚è‰¯ããªã„
moritata 2023/07/03
db

mysql

aws
ãƒªãƒ³ã‚¯
â˜…â˜…å†è¿½è¨˜ ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒã¯ã€è‡ªç”±åº¦ãŒä½Žãã¦ã‚¹ãƒˆãƒ¬ã‚¹ã«ãªã‚‹ã‹ã‚‰ã‚„ã‚‰ãªã„..
â˜…â˜…å†è¿½è¨˜ ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒã¯ã€è‡ªç”±åº¦ãŒä½Žãã¦ã‚¹ãƒˆãƒ¬ã‚¹ã«ãªã‚‹ã‹ã‚‰ã‚„ã‚‰ãªã„ã€‚SQLã§withä½¿ã„ãŸã„ã‹ã‚‰MySQL8ã‚’ã£ã¦è¨€ã£ã¦ã‚‚ã•ãã‚‰ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒã˜ã‚ƒç„¡ç†ãªã‚“ã§ã—ã‚‡ï¼Ÿ ã‚ã¨åŒå±…åˆ©ç”¨è€…ã®ã›ã„ã§é«˜è² è·ã£ã¦ã®ã‚‚é¿ã‘ãŸã„ã€‚ãã“ã‚’æ°—ã«ã—ãªã„äººã¯ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒã§ã„ã„ã¨æ€ã†ã‚ˆã€‚ ã‚ã¨ LB $0.025/h ã ã£ãŸã€‚æœˆ2000å††ãã‚‰ã„ã‹ã€‚ â˜…è¿½è¨˜ LBã¯ç‹¬è‡ªãƒ‰ãƒ¡ã‚¤ãƒ³+è‡ªå‹•æ›´æ–°ç„¡æ–™SSLè¨¼æ˜Žæ›¸ã®ãŸã‚ãã€‚Cloud Storageã®ç„¡å‘³ä¹¾ç‡¥ãªãƒ‰ãƒ¡ã‚¤ãƒ³ã§ã„ã„ãªã‚‰ã€SSLè‡ªå‹•ã‹ã¤ç„¡æ–™ã§ã»ã‚“ã¨ã«æœˆæ•°å††ã€‚ ï¼ï¼ï¼ï¼ï¼ï¼ï¼ ã‚‚ã†ãã‚ã‚“ã©ãã•ã„ã‚“ã ã‚ã€‚ã‚‚ã¡ã‚ã‚“ä»¥å‰ã¯ãã†ã‚„ã£ã¦ãŸã‚ˆã€‚ PHPã ã®Apacheã ã®MySQLã ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸã‚Šè¨å®šãƒ•ã‚¡ã‚¤ãƒ«ç½®ã„ãŸã‚Šã€ è„†å¼±æ€§å¯¾å¿œã—ãŸã‚Šã€SSLè¨¼æ˜Žæ›¸æ›´æ–°ã—ãŸã‚Šã€ä¸€å¿œè½ã¡ã¦ãªã„ã‹ç„¡æ–™ç›£è¦–ã‚µãƒ¼ãƒ“ã‚¹ä½¿ã£ãŸã‚Šã€‚ ã§ã‚‚ä»•äº‹ãªã‚‰ã¨ã‚‚ã‹ãã€è¶£å‘³ã ã‹ã‚‰ã“ãã“ã‚“ãªã“ã¨ã‚„ã‚ŠãŸããªã„ã˜ã‚ƒã‚“ã€‚ ãªã®
moritata 2022/05/06
ã‚µãƒ¼ãƒ

cloud

mysql

storage

ã‚¯ãƒ©ã‚¦ãƒ‰

aws

server

é–‹ç™º

webã‚µãƒ¼ãƒ“ã‚¹
ãƒªãƒ³ã‚¯
mysqlsh (MySQL Shell): Dump and Restore in AWS Aurora - LayerX ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒ–ãƒã‚°
LayerX ã‚¤ãƒ³ãƒœã‚¤ã‚¹ ã‚’é–‹ç™ºã—ã¦ã„ã‚‹DXäº‹æ¥éƒ¨ã® @yyoshiki41ï¼ˆä¸å·ä½³å¸Œï¼‰ã§ã™ã€‚ DXäº‹æ¥éƒ¨ã§ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ MySQLï¼ˆAmazon Auroraï¼‰ã‚’åˆ©ç”¨ã—ã¦ã„ã¾ã™ã€‚ ä»Šå›žã®ãƒ–ãƒã‚°ã¯ã€mysqlsh (MySQL Shell) ã‚’ç”¨ã„ã¦ã€Dumpãƒ‡ãƒ¼ã‚¿å–å¾—ã¨ãƒªã‚¹ãƒˆã‚¢ã‚’è¡Œã†éš›ã«æ°—ã‚’ã¤ã‘ã‚‹ç‚¹ã§ã™ã€‚ mysqldump, mysqlpump Dumpãƒ‡ãƒ¼ã‚¿å–å¾—ã‚’è¡Œã†éš›ã«ã€åºƒãçŸ¥ã‚‰ã‚Œã¦ã„ã‚‹ã®ãŒ mysqldump ã‹ã¨æ€ã„ã¾ã™ã€‚ MySQL 5.7.8 ã‹ã‚‰ã¯ã€ mysqlpump ã¨ã„ã†åˆ¥ã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆãƒ„ãƒ¼ãƒ«ã‚‚æä¾›ã•ã‚Œã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ ä¸»ã«ä¸‹è¨˜ã®ã‚ˆã†ãªç‰¹å¾´ãŒã‚ã‚Šã¾ã™ã€‚ ä¸¦åˆ—ã§ã®å‡¦ç†ãŒè¡Œã‚ã‚Œã‚‹ï¼ˆParallelï¼‰ Dump Progress ãŒã¿ã‚Œã‚‹ åœ§ç¸®æ–¹å¼ã¯ã€LZ4 ã¨ ZLIB ãŒä½¿ç”¨å¯èƒ½ï¼ˆmysqlpump Ver 1.0.0 Distrib 5.7.35ï¼‰ TA
moritata 2021/10/07
mysql

data

aws
ãƒªãƒ³ã‚¯
AWS Lambdaã§Seleniumã¨ActiveRecordã‚’æ‰±ã† Â· ãƒ•ãƒãƒƒãƒ”ãƒ¼ãƒ‡ã‚£ã‚¹ã‚¯ã®æ®‹éª¸
æ°—ä»˜ã„ãŸã‚‰ã‚‚ã†9æœˆã§ã™ãã€‚ æœ€è¿‘ã€AWS Lambdaã§ã„ã‚ã„ã‚ã¨éŠã¶æ©Ÿä¼šãŒã‚ã£ãŸã®ã§ãƒ¡ãƒ¢ã¨ã—ã¦æ®‹ã—ã¾ã™ã€‚ ã¯ã˜ã‚ã« ã¨ã‚ã‚‹ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã‚²ãƒ¼ãƒ ã®é‹å–¶ç”¨ã«ã€Seleniumã§Webã‚¹ã‚¯ãƒ¬ã‚¤ãƒ”ãƒ³ã‚°ã‚’ã‚„ã£ã¦ã„ã‚‹Rubyã®ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’EC2ã§é‹ç”¨ã—ã¦ã„ãŸã®ã§ã™ãŒã€Headless Chromeã‚’æ‰±ã†ãŸã‚å¤§é‡ã«èµ·å‹•ã™ã‚‹ã¨ãƒ¡ãƒ¢ãƒªé£Ÿã£ã¡ã‚ƒã†ã—ã€ã‚¹ã‚±ãƒ¼ãƒ«ã—ã‚ˆã†ã«ã‚‚EC2ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã®AutoScalingçµ„ã‚€ã®ã‚‚ã¡ã‚‡ã£ã¨ãªã‚ã€‚ã¨ã‹ã€ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã®èµ·å‹•ã¾ã§å¾…ã£ã¦ã‚‰ã‚Œãªã„ã‹ã‚‰ã‚ã‚‹ç¨‹åº¦å¤šã‚ã«ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚’å®Ÿè¡Œã—ãŸã‚Šã™ã‚‹ã®ã‚‚ä½™åˆ†ã«ã‚³ã‚¹ãƒˆãŒã€‚ã€‚ã€‚ 1å®Ÿè¡Œã«15åˆ†ã‚‚ã‹ã‹ã‚‰ãªã„ã‚¹ã‚¯ãƒªãƒ—ãƒˆã ã—ã€ã¨ã„ã†ã“ã¨ã§Lambdaã«ç§»è¡Œã™ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ Lambda Layerã«ã¤ã„ã¦ Headless Chromeã‚’æ‰±ã†å ´åˆã€å˜ç´”ã«Functionã®ãƒ‡ãƒ—ãƒã‚¤ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã«ãƒã‚¤ãƒŠãƒªã‚’å«ã‚ã‚‹ã¨50MBã‚’è¶…ãˆã¦ã—ã¾ã†ãŸã‚ã€Lambda
moritata 2020/09/14
aws

ruby

ãƒ©ã‚¤ãƒ–ãƒ©ãƒª

chrome

mysql
ãƒªãƒ³ã‚¯
Amazon RDS Proxy for Scalable Serverless Applications â€“ Now Generally Available | Amazon Web Services
AWS News Blog Amazon RDS Proxy for Scala ble Serverless Applications â€“ Now Generally Available At AWS re:Invent 2019, we launched the preview of Amazon RDS Proxy, a fully managed, highly available database proxy for Amazon Relational Database Service (RDS) that makes applications more scala ble, more resilient to database failures, and more secure. Following the preview of MySQL engine, we extended
moritata 2020/07/01
aws

amazon

db

database

mysql

rds

connection
ãƒªãƒ³ã‚¯
CloudWatch Logsã®ãƒã‚°ãƒ‡ãƒ¼ã‚¿ã‚’Kinesis Data FirehoseçµŒç”±ã§S3ã«å‡ºåŠ›ã™ã‚‹ | DevelopersIO
Lambda Functionãªã©ã§ä½œã‚Šè¾¼ã¿ã‚’è¡Œã‚ãšã€CloudWatch Logsã®ãƒã‚°ãƒ‡ãƒ¼ã‚¿ã‚’S3ã«å‡ºåŠ›ã™ã‚‹ã«ã¯ã€Kinesis Data FirehoseãŒåˆ©ç”¨ã§ãã¾ã™ã€‚ æœ¬ã‚¨ãƒ³ãƒˆãƒªã§ã¯ã€Kinesis Data Firehoseã‚’ä»‹ã—ã¦ã€CloudWatch Logsã®ãƒ‡ãƒ¼ã‚¿ã‚’S3ã¸å‡ºåŠ›ã™ã‚‹è¨å®šã‚’ç´¹ä»‹ã—ã¦ã„ã¾ã™ã€‚CloudWatch Logsã‹ã‚‰Kinesis Data Firehoseã¸å‡ºåŠ›ã™ã‚‹ã«ã¯ã€CloudWatch Logsã®ã‚µãƒ–ã‚¹ã‚¯ãƒªãƒ—ã‚·ãƒ§ãƒ³ãƒ•ã‚£ãƒ«ã‚¿ã®è¨å®šãŒå¿…è¦ã«ãªã‚Šã¾ã™ãŒã€ã“ã¡ã‚‰ã®è¨å®šã¯ãƒžãƒã‚¸ãƒ¡ãƒ³ãƒˆã‚³ãƒ³ã‚½ãƒ¼ãƒ«ã§ã¯è¡Œãˆãªã„ã®ã§ã€é–¢é€£ã™ã‚‹ä½œæ¥å«ã‚AWS CLIã‚’åˆ©ç”¨ã—ã¦å®Ÿæ–½ã—ã¦ã„ã¾ã™ã€‚ã•ã„ã”ã«ã€AWS CLIã§æ§‹ç¯‰ã—ãŸåŒæ§˜ã®æ§‹æˆã‚’å®šç¾©ã™ã‚‹CFnãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã‚‚æ·»ä»˜ã—ã¦ã„ã¾ã™ã€‚ æ§‹æˆ S3ã¸ã®å‡ºåŠ›å…ƒã¨ãªã‚‹CloudWatch Logsï¼ˆãƒã‚°ã‚°ãƒ«ãƒ¼ãƒ—ï¼‰ã®ä½œæˆã¯å‰²æ„›ã—ã¦ã„ã¾ã™ã®ã§ã€
moritata 2020/05/11
data

mysql

aws

techfeed
ãƒªãƒ³ã‚¯
AWSã«ãŠã‘ã‚‹æœ¬ç•ªç’°å¢ƒã‚’æƒ³å®šã—ãŸCI/CDå®Ÿè·µ - y-ohgi's blog
ã“ã®è¨˜äº‹ã¯ DMM.com Advent Calendar 2018 - Qiita ã®25æ—¥ç›®ã§ã™ã€‚ About CircleCIã¨Codeå…„å¼Ÿã‚’ä½¿ã„CI/CDã‚’ä½œã£ã¦ã„ã“ã†ã¨ã„ã†ã‚‚ã®ã§ã™ã€‚ å˜ç´”ã«ç’°å¢ƒã‚’ä½œã‚‹ã‚ã‘ã§ã¯ãªãã€CloudFormationã‚’ä½¿ã£ã¦æœ¬ç•ªç’°å¢ƒã‚’æƒ³å®šã—ãŸæ§‹æˆã«ã—ã¦ã„ãã¾ã™ã€‚ ã‚¿ãƒ¼ã‚²ãƒƒãƒˆã¨ã—ã¦ã¯æ—¢ã«CircleCIãƒ»CodePipelineã‚’ã–ã£ãã‚ŠçŸ¥ã£ã¦ã„ã‚‹äººã§ã€æœ¬ç•ªå‘ã‘ã®CI/CDã‚’ã©ã®ã‚ˆã†ã«æ§‹ç¯‰ã—ã¦ã„ãã‹ã«ã¤ã„ã¦è‡ªåˆ†ãªã‚Šã®ãƒ—ãƒ©ã‚¯ãƒ†ã‚£ã‚¹ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ã‚µãƒ³ãƒ—ãƒ«ã‚³ãƒ¼ãƒ‰ ä»Šå›žã®æ§‹æˆã‚’å†ç¾ã™ã‚‹ãŸã‚ã®ã‚³ãƒ¼ãƒ‰ã‚’ç”¨æ„ã—ã¾ã—ãŸã€‚ https://github.com/y-ohgi/ci-cd-example CloudFormation ç’°å¢ƒã¯CloudFormationã§ç®¡ç†ã—ã¦ã„ã‚‹ãŸã‚ä»¥ä¸‹ã®ã‚³ãƒžãƒ³ãƒ‰ã§å†ç¾ã§ãã¾ã™ã€‚ VPCã€Auroraã€ECSã€CodePipelineãªã©
moritata 2018/12/26
aws

ç’°å¢ƒ

php

blog

mysql
ãƒªãƒ³ã‚¯
BASEã®ãƒ¡ã‚¤ãƒ³DBã‚’Aurora(MySQL)ã«ç§»è¡Œã—ã¾ã—ãŸ - BASEãƒ—ãƒãƒ€ã‚¯ãƒˆãƒãƒ¼ãƒ ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€BASEãƒ©ãƒ³ãƒ‹ãƒ³ã‚°éƒ¨ã§10kmãƒžãƒ©ã‚½ãƒ³ãªã©ã«å‚åŠ ã—ã€3kgã»ã©ä½“é‡ãŒè½ã¡ãŸSRE Groupã«æ‰€å±žã—ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æ¤æœ¨ã§ã™ã€‚ãŠã‹ã’ã§ç”˜ã„ã‚‚ã®ãŒç¾Žå‘³ã—ã„ã§ã™ã€‚ã¡ãªã¿ã«æ¬¡ã¯ãƒãƒ¼ãƒ•ãƒžãƒ©ã‚½ãƒ³ã«æŒ‘æˆ¦ã§ã™ï¼ ä»Šå›žã¯ä¼šç¤¾ã®ãƒ–ãƒã‚°ãªã©ã‚’æ›¸ã„ã¦ã¿ã¾ã™ã€‚å¼Šç¤¾ã§ã¯ã€ãƒãƒƒãƒˆã‚·ãƒ§ãƒƒãƒ—ä½œæˆã‚µãƒ¼ãƒ“ã‚¹ã€ŒBASEã€ãŠã‚ˆã³ã‚·ãƒ§ãƒƒãƒ”ãƒ³ã‚°ã‚¢ãƒ—ãƒªã€ŒBASEã€ã‚’é‹å–¶ã—ã¦ã„ã¾ã™ãŒã€11æœˆã«ãƒ¡ã‚¤ãƒ³DBã‚’RDS for MySQL5.6ã‹ã‚‰Aurora(MySQL5.6ã‚³ãƒ³ãƒ‘ãƒãƒ–ãƒ«)ã«å¤‰æ›´ã—ã¾ã—ãŸã®ã§ã€ãã¡ã‚‰ã®è©±ã‚’æ›¸ã‹ã›ã¦ã„ãŸã ãã¾ã™ã€‚ ä½•æ•…Auroraï¼Ÿ ã¾ãšã€å¼Šç¤¾ã§AWSã‚’ãƒ¡ã‚¤ãƒ³ã«ä½¿ã£ã¦ã„ãŸã¨ã„ã†èƒŒæ™¯ãŒã‚ã‚Šã¾ã™ã€‚å…¥ç¤¾ã—ãŸéš›ã«ã¯RDS for MySQLã‚’ä½¿ç”¨ã—ã¦ãŠã‚Šã€CTOã®è—¤å·ã‚‚ã€ŒAWSã‚’ä½¿ã†ãªã‚‰Auroraã«ã—ãŸã„ã€ã¨ã„ã†è¦æœ›ã‚’æŒã£ã¦ã„ã¾ã—ãŸã€‚ç§è‡ªèº«ã€AWSã‚’ãƒ¡ã‚¤ãƒ³ã«ä½¿ã„ç¶šã‘ã‚‹ã¤ã‚‚ã‚Šã§ã‚ã‚Œã°Aurora
moritata 2018/11/29
Aurora

mysql

aws

RDS

ã‚µãƒ¼ãƒ“ã‚¹
ãƒªãƒ³ã‚¯
AWSã®ä»®æƒ³ãƒ—ãƒ©ã‚¤ãƒ™ãƒ¼ãƒˆã‚µãƒ¼ãƒï¼ˆVPSï¼‰ã€ŒAmazon Lightsailã€ã€æ•°ã‚¯ãƒªãƒƒã‚¯ã§MySQLãªã©ã®ãƒžãƒãƒ¼ã‚¸ãƒ‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒè¨å®šå¯èƒ½ã«
AWSã®ä»®æƒ³ãƒ—ãƒ©ã‚¤ãƒ™ãƒ¼ãƒˆã‚µãƒ¼ãƒï¼ˆVPSï¼‰ã€ŒAmazon Lightsailã€ã€æ•°ã‚¯ãƒªãƒƒã‚¯ã§MySQLãªã©ã®ãƒžãƒãƒ¼ã‚¸ãƒ‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒè¨å®šå¯èƒ½ã« Amazon Lightsailã¯ã€ä»®æƒ³ãƒ—ãƒ©ã‚¤ãƒ™ãƒ¼ãƒˆã‚µãƒ¼ãƒï¼ˆVPSï¼‰ã‚„ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒã®ã‚ˆã†ã«æ•°ã‚¯ãƒªãƒƒã‚¯ã§ç°¡å˜ã«AWSã§ä»®æƒ³ã‚µãƒ¼ãƒã‚’åˆ©ç”¨å¯èƒ½ã«ã™ã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã§ã™ã€‚WordPressã‚„Node.jsã€Drupalãªã©ä»£è¡¨çš„ãªã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚„ãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ã‚‚ã‚¯ãƒªãƒƒã‚¯ã§ç°¡å˜ã«å°Žå…¥ã§ãã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã¾ã™ã€‚ åˆ©ç”¨æ–™é‡‘ã«ã¯ä»®æƒ³ã‚µãƒ¼ãƒã¨ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã€ãƒ‡ãƒ¼ã‚¿è»¢é€æ–™é‡‘ãŒå«ã¾ã‚Œã¦ã„ã‚‹ãŸã‚ã€ã‚·ãƒ³ãƒ—ãƒ«ã§åˆ†ã‹ã‚Šã‚„ã™ã„ä¾¡æ ¼è¨å®šã‚‚Amazon Lightsailã®ç‰¹é•·ã®ã²ã¨ã¤ã§ã—ãŸã€‚ ã¾ãŸã€ä»Šå¹´ã®8æœˆã«ã¯æ–™é‡‘ãŒã»ã¼åŠé¡ã«ãªã‚Šã€ã‚ˆã‚Šåˆ©ç”¨ã—ã‚„ã™ããªã£ã¦ã„ã¾ã™ã€‚ å‚è€ƒï¼šAWSã®ä»®æƒ³ãƒ—ãƒ©ã‚¤ãƒ™ãƒ¼ãƒˆã‚µãƒ¼ãƒï¼ˆVPSï¼‰ã€ŒAmazon Lightsailã€ãŒæ–™é‡‘æ”¹å®šã§ã»ã¼åŠé¡ã«ã€‚ãƒ¡ãƒ¢ãƒª16GBã€32G
moritata 2018/10/18
aws

amazon

ã‚µãƒ¼ãƒ

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

mysql
ãƒªãƒ³ã‚¯
RDSã‚’SSD(General Purpose)ã§é‹ç”¨ã™ã‚‹ã¨ãã«æ³¨æ„ã™ã¹ãã“ã¨ | iret.media
ã“ã‚“ã«ã¡ã¯ã€cloudpack ã® ä»Šå²¡ ã§ã™ã€‚ EBSã«SSDã‚¿ã‚¤ãƒ—ãŒè¿½åŠ ã•ã‚Œã¦ã—ã°ã‚‰ãçµŒã¡ã¾ã—ãŸãŒã€ ã€Œã§ã‚‚ã€ãŠé«˜ã„ã‚“ã§ã—ã‚‡ï¼Ÿã€ ã€Œå€¤æ®µèª¿ã¹ãŸã‘ã©ã€ãã‚“ãªã«é«˜ãç„¡ã„ã—ã€SSDã ã£ãŸã‚‰çµ¶å¯¾ã«æ—©ã„ã‚ˆãï¼HDDã‚ˆã‚Šã¯ã€ ã¨ã„ã†å…ˆå…¥è¦³ãŒã‚ã‚‹ã¨æ€ã„ã¾ã™ãŒã€ã¡ã‚ƒã‚“ã¨èª¿ã¹ã¦ã¿ã¾ã—ãŸã€‚ ç´ æ™´ã‚‰ã—ã„ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ ãã‚Œã¯AWSã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã§ã™ã€‚ Amazon RDS ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ â€“ Amazon Relational Database Service ã“ã‚Œã‚’èªã‚ã°ã€ã“ã®ã‚¨ãƒ³ãƒˆãƒªã¯ã‚‚ã†ç”¨æ¸ˆã¿ã§ã™ã€‚#èª¬æ˜Žæ›¸èªã¾ãªã„ç—…ã¯ç›´ã•ã‚“ã¨ã‚¤ã‚«ãƒ³ã§ã™ã€‚ EBSã®ã‚¯ãƒ¬ã‚¸ãƒƒãƒˆ General Purposeã«ã¯EBS I/O ã‚¯ãƒ¬ã‚¸ãƒƒãƒˆã¨ã„ã†ã‚‚ã®ãŒæœ‰ã‚Šã¾ã™ã€‚ä»–æ–¹ã§ã‚‚ç´¹ä»‹ã•ã‚Œã¦ã„ã¾ã™ãŒã€ãƒ‡ã‚£ã‚¹ã‚¯I/OãŒå°‘ãªã„æ™‚ã«ã‚¯ãƒ¬ã‚¸ãƒƒãƒˆãŒãŸã¾ã‚Šã€å¤§è¦æ¨¡ãªãƒ‡ã‚£ã‚¹ã‚¯I/OãŒç™ºç”Ÿã—ãŸæ™‚ã«ãã®ã‚¯ãƒ¬ã‚¸ãƒƒãƒˆåˆ†ã ã‘ãƒãƒ¼ã‚¹ãƒˆã™ã‚‹ã¨ã„ã†ã‚‚ã®ã§ã™ã€‚åŒã˜ã‚ˆã†ãª
moritata 2015/11/12
cpu

Cloudpack

Amazon

EC

aws

EBS

MySQL

rds
ãƒªãƒ³ã‚¯
Amazon RDSã®é‹ç”¨ãƒ¡ãƒ¢ - ã‚¹ãƒ†ã‚£ãƒ«ãƒã‚¦ã‚¹ã®æ›¸åº«ã®æ›¸åº«
ãŸã ã„ã¾Amazon RDSã§å®Ÿé‹ç”¨ç’°å¢ƒã‚’çµ¶è³›æ§‹ç¯‰ä¸ï¼ ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‹ã‚‰é‹ç”¨ã‚„æ§‹æˆä¸Šã§æ°—ã«ãªã‚‹ã¨ã“ã‚ã ã‘ãƒ¡ãƒ¢ã—ã¾ã—ãŸï¼š http://aws.amazon.com/rds/faqs/ http://docs.amazonwebservices.com/AmazonRDS/latest/DeveloperGuide/index.html?Overview.BackingUpUpAndRestoringAmazonRDSInstances.html ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹æ™‚é–“å¸¯ï¼ˆmaintenance windowï¼‰ã¨ã¯ä½•ã‹ï¼Ÿ Q: What is a maintenance window? Will my DB Instance be available during software maintenance? Any system changes (such as patching the data
moritata 2015/11/12
db

database

amazon

AWS

RDS

ã‚¯ãƒ©ã‚¦ãƒ‰

mysql
ãƒªãƒ³ã‚¯
1