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

Makots id:Makots

awsã¨mysqlã«é–¢ã™ã‚‹Makotsã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

RDS/Aurora ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã®ãƒã‚¤ãƒ³ãƒˆ
JAWS-UG æœä¼š #41ã€€2023/1/17
Makots 2023/01/18
db

mysql

postgresql

migration

deploy

aws

aurora

slides
ãƒªãƒ³ã‚¯
Herokuã‹ã‚‰ã€€ECSã«ã€€ç§»è¡Œã—ãŸ - pixiv inside
ã“ã‚“ã«ã¡ã¯ã€ã‚¤ãƒ³ãƒ•ãƒ©éƒ¨ã® id:sue445 ã§ã™ã€‚ç§äº‹ã§ã™ãŒå…ˆæ—¥GCPã® Professional Cloud Architect ã‚’å–å¾—ã—ã¾ã—ãŸã€‚ ãã†ã„ã†ã‚ã‘ã§ä»Šæ—¥ã¯GCPã§ã¯ãªãAWSã®è©±ã‚’ã—ã¾ã™ã€‚ tl;dr; åŠ‡çš„ãƒ“ãƒ•ã‚©ãƒ¼ã‚¢ãƒ•ã‚¿ãƒ¼ æ§‹æˆ ç§»è¡Œã®ãƒ¢ãƒãƒ™ãƒ¼ã‚·ãƒ§ãƒ³ ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å‘ä¸Š ã‚³ã‚¹ãƒˆåœ§ç¸® ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã®æŽ¡æŠžç†ç”± ã‚„ã£ãŸã“ã¨ 1. DBä½œæˆ 2. MySQL 5.7 -> 8.0 MySQL 8.0ã§ãƒãƒžã£ãŸã“ã¨ MySQL 8.0ã‹ã‚‰ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®èªè¨¼ãŒcaching_sha2_passwordã«ãªã£ãŸ RDSã®MySQL 8.0ã‹ã‚‰MariaDB ç›£æŸ»ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ãŒãªããªã£ãŸ 3. æœ¬ç•ªç”¨ã®Dockerã‚¤ãƒ¡ãƒ¼ã‚¸ã‚’ä½œæˆ å›°ã£ãŸã“ã¨ï¼šCodeIgniterãŒãƒã‚°ã®æ¨™æº–å‡ºåŠ›ã«å¯¾å¿œã—ã¦ã„ãªã‹ã£ãŸ 4. ECS + Fargate + CodePipelineæ§‹ç¯‰ 5. CDNä½œæˆ 6
Makots 2021/03/18
heroku

aws

migration

mysql
ãƒªãƒ³ã‚¯
RDSã§æŽ¥ç¶šæ•°ã¨ãƒ¡ãƒ¢ãƒªæ¶ˆè²»é‡ã®èª¿æ•´äº‹ä¾‹ | å¤–é“çˆ¶ã®åŒ
RDS Auroraã‚’ä½¿ã£ã¦ã„ã‚‹ã¨ã“ã‚ã§ã€OSã®ç©ºããƒ¡ãƒ¢ãƒªãŒå°‘ãªããªã£ãŸã‚¢ãƒ©ãƒ¼ãƒˆãŒå‡ºãŸã®ã§ã€ãã‚Œã«ã¤ã„ã¦ç´°ã‹ãè€ƒå¯Ÿã—ãŸã‚‰ã€ãã‚Œãªã‚Šã®é‡ã«ãªã£ãŸã®ã§ã¾ã¨ã‚ãŸæ„Ÿã˜ã§ã™ã€‚ åˆ¥ã«Auroraã˜ã‚ƒãªãRDS MySQLã§ã‚‚ã€MySQL Serverã§ã‚‚åŒã˜è©±ãªã®ã§ã™ãŒã€ã‚¯ãƒ©ã‚¦ãƒ‰ãªã‚‰ã§ã¯ã®å´é¢ã‚‚ã‚ã‚‹ãªã¨ã„ã†ã“ã¨ã§ã‚¿ã‚¤ãƒˆãƒ«ã¯RDSã«ã—ã¦ãŠã‚Šã¾ã™ã€‚ RDSã®ãƒ¡ãƒˆãƒªã‚¯ã‚¹ç›£è¦– RDSã¯ãƒ–ãƒ©ãƒƒã‚¯ãƒœãƒƒã‚¯ã‚¹ã¨ã¯ã„ãˆã€å¿…è¦ãªãƒ¡ãƒˆãƒªã‚¯ã‚¹ã¯ã ã„ãŸã„æƒã£ã¦ã„ã‚‹ã®ã§ã€CloudWatch ã‚’è¦‹ãŸã‚Šâ€¦â€¦APIã§å–å¾—ã—ã¦ã©ã£ã‹ã«é€ã‚Šã¤ã‘ãŸã‚Šã—ã¦åˆ©ç”¨ã—ã¾ã™ã€‚ ãªã®ã§ã€ã¾ãšã¯æŽ¥ç¶šæ•°ã¨ãƒ¡ãƒ¢ãƒªã«ã¤ã„ã¦å¾©ç¿’ã§ã™ã€‚ SHOW STATUS çš„ã«ã¯ Threads_connected ã§ã™ã€‚ CloudWatch Metrics çš„ã«ã¯ã€DBInstanceIdentifier â†’ DatabaseConnections ã§ã™ã€‚ è¦‹ãŸæ„Ÿã˜ã€ã©
Makots 2020/11/24
db

tuning

mysql

aws

performance

memory

monitoring
ãƒªãƒ³ã‚¯
RDS for MySQLã‹ã‚‰Auroraã«ç§»è¡Œã—ãŸè©± / RDS for MySQL to Aurora
2016.11.02 JAWS-UGæ¨ªæµœ - Reboot!! http://jawsug-yokohama.connpass.com/event/40497/
Makots 2016/11/02
aurora

mysql

aws

rds

slides
ãƒªãƒ³ã‚¯
Admins Bar #1 - MySQL in the Real World
Your current browser isn't compatible with SoundCloud. Please download one of our supported browsers. Need help?
Makots 2014/07/05
mysql

rds

aws

podcast
ãƒªãƒ³ã‚¯
AWS RDS ã®æ›¸ãè¾¼ã¿æ€§èƒ½ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° : DSASé–‹ç™ºè€…ã®éƒ¨å±‹
4/25è¿½è¨˜: innodb_support_xa=0 ã¯ã‚¯ãƒ©ãƒƒã‚·ãƒ¥æ™‚ä»¥å¤–ã«ã‚‚ binlog ã¨ innodb ã®æ•´åˆæ€§ãŒå–ã‚Œãªããªã‚‹å•é¡ŒãŒã‚ã‚Šã¾ã—ãŸã€‚ innodb_support_xa ã¨ binlog ã®å±ãªã„é–¢ä¿‚ ã‚‚ã”è¦§ãã ã•ã„ã€‚ KLab ã§ã‚‚æœ€è¿‘ã¯ AWS ã‚’ä½¿ã£ãŸãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆãŒã‹ãªã‚Šå¢—ãˆã¦ãã¾ã—ãŸã€‚ AWS ã§å•é¡Œã«ãªã‚ŠãŒã¡ãªã®ãŒã€ RDB ã®æ€§èƒ½ãŒ DSAS ç’°å¢ƒã«æ¯”ã¹ã¦ä½Žã„ã“ã¨ã§ã™ã€‚ DSAS ã§ã¯ãƒãƒƒãƒ†ãƒªãƒ¼ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ä»˜ãã®RAID + éžåŒæœŸãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½¿ã£ã¦ã„ã‚‹ã®ã§ã™ãŒã€ RDS ã§ã¯ Multi-AZ ã‚’ä½¿ã£ã¦è€éšœå®³æ€§ã‚’ç¢ºä¿ã—ã¦ã„ã¾ã™ã€‚ ã“ã®é•ã„ã«ã‚ˆã£ã¦æ›¸ãè¾¼ã¿æ€§èƒ½ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãƒã‚¤ãƒ³ãƒˆãŒå¤‰ã‚ã£ã¦ãã¾ã™ã€‚RAIDã‚«ãƒ¼ãƒ‰ã¯ãƒ‡ãƒ¼ã‚¿ãŒæ›¸ãè¾¼ã¿ãƒãƒƒãƒ•ã‚¡ã«ä¹—ã£ã¦ã„ã‚‹é–“ã¯ fsync ãŒé«˜é€Ÿãªã®ã«å¯¾ã—ã¦ã€ Multi-AZ ã§ã¯åˆ¥ã®AZã«ã‚ã‚‹ãƒ–ãƒãƒƒã‚¯ãƒ‡ãƒã‚¤ã‚¹ã«å¯¾ã—ã¦åŒ
Makots 2013/04/25
aws

raid

mysql

io
ãƒªãƒ³ã‚¯
1