Amazon Relational Database Service (Amazon RDS) ã§ã¯ããªãã¬ãŒãã£ã³ã°ã·ã¹ãã ã®ãªã¢ã«ã¿ã€ã ã¡ããªã¯ã¹ã«ã¢ã¯ã»ã¹ã§ããããã«ããããšã§ãRDS ã®ãªãœãŒã¹ãããŸããŸãªããã»ã¹ãã¹ã¬ãããã©ã®ããã«äœ¿çšããŠããããç£èŠã§ããŸããAmazon RDS ã³ã³ãœãŒã«ã§ãã€ã³ã¹ã¿ã³ã¹ããšã« ç£èŠãããã¡ããªã¯ã¹ ã管çã§ããŸãã Amazon CloudWatch 㯠AWS ã®ãã€ãã£ãã¢ãã¿ãªã³ã°ããŒã«ã§ãããã¹ãŠã® AWS ãµãŒãã¹ãšã¯ãŒã¯ããŒãã®äž»èŠãªç£èŠããŒã«ãšããŠãã客æ§ã«åºã䜿çšãããŠããŸãã ããããRDS ã«ã¯ãCloudWatch ãšçµã¿åãããŠäœ¿çšã§ãã æ¡åŒµã¢ãã¿ãªã³ã° ãšåŒã°ããã¢ããªã³æ©èœããããŸãããã¬ã¡ããªãŒã®è¿œå ã¬ã€ã€ãŒãæäŸããããããããé«ãè§£å床ã®ç£èŠããŒã¿ãå¿
èŠãªèª¿æ»ã«åœ¹ç«ã¡ãŸããCloudWatch ã¡ããªã¯ã¹ã®ã¿ã«äŸåãããã©ãã«ã·ã¥ãŒãã£ã³ã°ææ³ã§ã¯ããããã®éèŠãªææšãèŠéãå¯èœæ§ããããŸãããã®ãããæ¡åŒµã¢ãã¿ãªã³ã°ã®ãã现ããªã¡ããªã¯ã¹ãš CloudWatch ã¡ããªã¯ã¹ã䜵çšããããšã§ãã€ã³ã¹ã¿ã³ã¹ã®ããã©ãŒãã³ã¹ãããå
æ¬çãã€æ£ç¢ºã«ææ¡ã§ããåé¡è§£æ±ºã®ããã®å¹æçãªæææ±ºå®ãå¯èœã«ãªããŸããRDS ã€ã³ã¹ã¿ã³ã¹ãäœæãããšãæ¡åŒµã¢ãã¿ãªã³ã°ã¯ããã©ã«ãã§ã¯ç¡å¹ã«ãªã£ãŠããŸããããããã€ã³ã¹ã¿ã³ã¹ã®äœææã«æå¹ã«ããããæ¢åã®ã€ã³ã¹ã¿ã³ã¹ã倿ŽããŠæå¹ã«ããããšãã§ããŸãããã®èšäºã§ã¯ãæ¡åŒµã¢ãã¿ãªã³ã°ãæäŸããããŸããŸãªæ©èœã«ã€ããŠèª¬æããŸãã æ¡åŒµã¢ãã¿ãªã³ã°ã¯æ¬¡ã®ããŒã¿ããŒã¹ãšã³ãžã³ã§äœ¿çšã§ããŸãã Amazon RDS for MariaDB Amazon RDS for MySQL Amazon RDS for Oracle Amazon RDS for PostgreSQL Amazon RDS for SQL Server Amazon Aurora MySQL-Compatible Edition Amazon Aurora PostgreSQL-Compatible Edition ïŒè𳿳šïŒ Amazon RDS for Db2 (2023 幎 11 æ 27 æ¥ã«äžè¬æäŸãéå§) ã§ã䜿çšå¯èœã§ãïŒ æ¡åŒµã¢ãã¿ãªã³ã°ã¯ãdb.m1.small ã€ã³ã¹ã¿ã³ã¹ã¯ã©ã¹ãé€ããã¹ãŠã® DB ã€ã³ã¹ã¿ã³ã¹ã¯ã©ã¹ ã§äœ¿çšã§ããŸãããã®èšäºã§ã¯ãAmazon RDS for MySQL ã䜿çšããæ¡åŒµã¢ãã¿ãªã³ã°ã®æ©èœã«ã€ããŠèª¬æããŸãã æ¡åŒµã¢ãã¿ãªã³ã°ã®æŠèŠ RDS ã€ã³ã¹ã¿ã³ã¹ãç£èŠããå Žåãæ¡åŒµã¢ãã¿ãªã³ã°ã«ã¯æ¬¡ã®å©ç¹ããããŸãã CloudWatch ã¡ããªã¯ã¹ã Amazon RDS Performance Insights ãšäžç·ã«äœ¿çšã§ããã¢ãã¿ãªã³ã°ã®ãã 1 ã€ã®ã¬ã€ã€ãŒã远å ãããŸã 泚: ããã§ã® CloudWatch ã¡ããªã¯ã¹ãšã¯ãRDS ãµãŒãã¹ãã远å è²»çšãªãã 1 ååäœã§ CloudWatch ã«å
¬éãããããã©ã«ãã®æšæºçãªã¡ããªã¯ã¹ã®ããšãæããŸãã CPU Niceã空ãã¡ã¢ãªãã¢ã¯ãã£ãã¡ã¢ãªãããŒãã¢ãã¬ãŒãž (1ã5ã15 å)ãã¹ã¯ããã€ã³ãã¹ã¯ããã¢ãŠãããªã©ãç£èŠããããã®ããµãã³ã³ããŒãã³ãã¬ãã«ã®ã¡ããªã¯ã¹ã®ã°ã©ããæäŸããŸã CloudWatch ã®æšæºç㪠1 åãããè§£å床ãé«ã (1 ç§ã5 ç§ã10 ç§ã15 ç§ã30 ç§ã60 ç§) ãããã©ãŒãã³ã¹ããªãœãŒã¹é¢é£ã®åé¡ã®èª¿æ»ããã©ãã«ã·ã¥ãŒãã£ã³ã°ã«åœ¹ç«ã¡ãŸã DB ã€ã³ã¹ã¿ã³ã¹ã®ããŒã¿ã¹ãã¬ãŒãžããªã¥ãŒã ã«ããããããããã®ãã£ã¹ã¯ã®ã¡ããªã¯ã¹ã瀺ããç©çããã€ã¹ã¬ãã«ã®ã°ã©ããæäŸããŸã Amazon CloudWatch Logs ã¢ã«ãŠã³ãã«ãã°ãé
ä¿¡ãããCPU 䜿çšçãã¡ã¢ãªããã£ã¹ã¯ IOããããã¯ãŒã¯ãç©çããã€ã¹ IO ãªã©ã® ã¡ããªã¯ã¹ ã衚瀺ããŠèª¿ã¹ãããšãã§ããŸãã DB ã€ã³ã¹ã¿ã³ã¹ã§å®è¡ãããŠããããã»ã¹ã®è©³çްãå«ãã ãªãã¬ãŒãã£ã³ã°ã·ã¹ãã ã®ããã»ã¹ãªã¹ã ãæäŸããŸã ãã®èšäºã§ã¯ã次ã®ããšã«ã€ããŠèª¬æããŸãã Amazon RDS for MySQL ã§ 1 ç§åäœã®æ¡åŒµã¢ãã¿ãªã³ã°ãèšå®ããæ¹æ³ RDS for MySQL ã€ã³ã¹ã¿ã³ã¹ã«ãã¹ãçšã®è² è·ããããæ¹æ³ CloudWatch ã³ã³ãœãŒã«ãš RDS æ¡åŒµã¢ãã¿ãªã³ã°ã䜿çšããŠã¡ããªã¯ã¹ãåæããæ¹æ³ æ¡åŒµã¢ãã¿ãªã³ã°ã®è¿œå æ©èœ CloudWatch ãã°ã°ã«ãŒã RDSOSMetrics ãå
ã«ãããæ¡åŒµã¢ãã¿ãªã³ã°ãã°ã®è¡šç€º ç£èŠã®ããã® OS ããã»ã¹ãªã¹ãã®è¡šç€º RDS ã€ã³ã¹ã¿ã³ã¹ã§ã¯ãŒã¯ããŒããå®è¡ããCloudWatch ã¡ããªã¯ã¹ãšæ¡åŒµã¢ãã¿ãªã³ã°ã¡ããªã¯ã¹ã®äž¡æ¹ãã¢ãã¿ãªã³ã°ããŸããæ¡åŒµã¢ãã¿ãªã³ã°ã®ã¡ããªã¯ã¹ã¯ CloudWatch ã¡ããªã¯ã¹ã§ã¯ãªã CloudWatch ãã°ã«ä¿åãããŸããæ¡åŒµã¢ãã¿ãªã³ã°ã«ãããè²»çšã¯ãRDS ã€ã³ã¹ã¿ã³ã¹ãã転éãããããŒã¿éãæ¡åŒµã¢ãã¿ãªã³ã°ã®è§£å床ããã°ãã¡ã€ã«ã®ä¿æããªã·ãŒãªã©ã®èŠå ã«ãã£ãŠç°ãªããŸãã詳现ã«ã€ããŠã¯ãã æ¡åŒµã¢ãã¿ãªã³ã°ã®ã³ã¹ã ããåç
§ããŠãã ããã åææ¡ä»¶ ãã¹ãã§ã¯ã次ã®ã€ã³ã¹ã¿ã³ã¹ãšã¹ãã¬ãŒãžæ§æã䜿çšããŸããã Amazon RDS for MySQL ãšã³ãžã³ããŒãžã§ã³ â 8.0.32 ã€ã³ã¹ã¿ã³ã¹ã¯ã©ã¹ â db.t2.medium ã¹ãã¬ãŒãžã¿ã€ã â gp2 ã¹ãã¬ãŒãžãµã€ãº â 20GB ã¯ã©ã€ã¢ã³ã â RDS ã€ã³ã¹ã¿ã³ã¹ãšåã VPC ã«ãã Amazon Elastic Compute Cloud (Amazon EC2) ã€ã³ã¹ã¿ã³ã¹ã§ãã¹ããããŠãã MySQL Workbench (ããŒãžã§ã³ 8.0) ããŒã« Amazon RDSã§æ¡åŒµã¢ãã¿ãªã³ã°ãèšå®ãã æ¡åŒµã¢ãã¿ãªã³ã°ã«ã¯ãOS ã¡ããªã¯ã¹æ
å ±ã CloudWatch Logs ã«éä¿¡ããããã®ã AWS Identity and Access Management (IAM) ããŒã«ãå¿
èŠã§ãããã®ããŒã«ã¯ã æ¡åŒµã¢ãã¿ãªã³ã°ãæå¹ã«ãããšãã«äœæããããšããäºåã«äœæããããšãã§ããŸã ãRDS ã€ã³ã¹ã¿ã³ã¹ã®æ¡åŒµã¢ãã¿ãªã³ã°ãæå¹ãŸãã¯ç¡å¹ã«ããã«ã¯ãæ¬¡ã®æé ãå®è¡ããŸãã Amazon RDS ã³ã³ãœãŒã«ã§ã€ã³ã¹ã¿ã³ã¹ãéžæããã€ã³ã¹ã¿ã³ã¹ãæ¢ã«ååšããå Žå㯠[倿Ž] ãéžæããŸãã æ°ãã DB ã€ã³ã¹ã¿ã³ã¹ãäœæããå Žåãã以äžã®æé ã¯åãã§ãã [远å èšå®] ãå±éããŸãã ã¢ãã¿ãªã³ã°ã»ã¯ã·ã§ã³ ã§ãDB ã€ã³ã¹ã¿ã³ã¹ã® [æ¡åŒµã¢ãã¿ãªã³ã°ã®æå¹å] ãéžæããŸãã ã¢ãã¿ãªã³ã°ããŒã« ã§ã¯ãAmazon RDS ã CloudWatch ãã°ãšèªåçã«éä¿¡ã§ããããã«ããããã«äœæãã IAM ããŒã«ãéžæãããã ããã©ã«ã ãéžæããŠãAmazon RDS ã« rds-monitoring-role ãšããååã®ããŒã«ãäœæãããŸãã [詳现床] ã§ã¯ãDB ã€ã³ã¹ã¿ã³ã¹ãŸãã¯ãªãŒãã¬ããªã«ã®ã¡ããªã¯ã¹ãåéãããæéã®ééãç§åäœã§éžæããŸãããã®ãã©ã¡ãŒã¿ãŒã¯ã1 ç§ã5 ç§ã10 ç§ã15 ç§ã30 ç§ããŸã㯠60 ç§ã«èšå®ã§ããŸãã ãŸãã¯ã AWS ã³ãã³ãã©ã€ã³ã€ã³ã¿ãŒãã§ã€ã¹ (AWS CLI) ã³ãã³ãã䜿çšããŠæ¡åŒµã¢ãã¿ãªã³ã°ãæå¹ã«ããããšãã§ããŸãã詳现ã«ã€ããŠã¯ãã æ¡åŒµã¢ãã¿ãªã³ã°ã®ãªã³ãšãªããåãæ¿ãã ããåç
§ããŠãã ããã RDS for MySQL ã€ã³ã¹ã¿ã³ã¹ã§ã¯ãŒã¯ããŒããå®è¡ãã ãã®ãã¹ãã§ã¯ã10,000 ä»¶ã®ã¬ã³ãŒãã 2 ã€ã®ã¹ããã (ãããã 5,000 ä»¶) ã§ 5 ç§ã®é
å»¶ãæãã§æ¿å
¥ããŸãããã®ç®çã¯ãRDS for MySQL ã€ã³ã¹ã¿ã³ã¹ã®æ¥æ¿ãªè² è·äžæãã·ãã¥ã¬ãŒãããåŸã§æ¡åŒµã¢ãã¿ãªã³ã°ã®ã¡ããªã¯ã¹ããã¹ãã€ã¯ã調ã¹ãããšã§ãããããã£ãã¹ãã€ã¯ã¯ãRDS ãµãŒãã¹ãããã©ã«ãã§ CloudWatch ã«ãããªãã·ã¥ããããã©ã«ãã®ã¡ããªã¯ã¹ã§ã¯èгå¯ã§ããªãå ŽåããããŸãã MySQL Workbench ãªã©ã®ã¯ã©ã€ã¢ã³ããã MySQL çš Amazon RDS ã«æ¥ç¶ããŸãã MySQL Workbench ãã Amazon RDS for MySQL ã«æ¥ç¶ããæ¹æ³ã«ã€ããŠã¯ãã MySQL Workbenchããã®æ¥ç¶ ããŸãã¯ã Amazon RDS ã§ MySQL ããŒã¿ããŒã¹ãäœæããŠæ¥ç¶ãã ããåç
§ããŠãã ããã æ¬¡ã®ã³ãã³ããå®è¡ããŠãMySQL Workbench ãŸãã¯ä»ã®ã奜ã¿ã®ã¯ã©ã€ã¢ã³ãã䜿ã£ãŠããŒã¿ããŒã¹ãäœæããŸãã Create database testdb; ããŒãã«ãäœæããŸãã use testdb; create table test1 ( id int not null auto_increment primary key, col1 varchar(10), col2 varchar(10) ) engine = InnoDB; 次ã®ã¹ã¯ãªãããå®è¡ããŠã5 ç§ããšã«ããŒãã«ã«ããŒã¿ãæ¿å
¥ããŸãã Drop procedure if exists testdata; delimiter // create procedure testdata (in num int) begin declare i int default 0; while i < num do insert into test1 (col1,col2) values ('col1_value','col2_value'); set i = i + 1; end while; end // delimiter ; call testdata (5000); DO SLEEP(5); Drop procedure if exists testdata; delimiter // create procedure testdata (in num int) begin declare i int default 0; while i < num do insert into test1 (col1,col2) values ('col1_value','col2_value'); set i = i + 1; end while; end // delimiter ; call testdata (5000); ã¡ããªã¯ã¹ã®æ¯èŒ ãã®ã»ã¯ã·ã§ã³ã§ã¯ãCloudWatch ã«ãããªãã·ã¥ãããããã©ã«ãã®ã¡ããªã¯ã¹ãš RDS æ¡åŒµã¢ãã¿ãªã³ã°ã«ãã£ãŠçæãããã¡ããªã¯ã¹ãæ¯èŒããŠãåè¿°ã®ã¯ãŒã¯ããŒãã®äž»èŠãªã¡ããªã¯ã¹ãããã€ã調ã¹ãŸãã WriteIOPS: CloudWatch 10,000 ä»¶ã®ã¬ã³ãŒããã5 ç§ã®é
å»¶ãã¯ããã§ 2 åã«ãã㊠RDS for MySQL ã€ã³ã¹ã¿ã³ã¹ã«æ¿å
¥ããããšããæ¬¡ã® CloudWatch ã°ã©ãã«ç€ºãããã«ãCloudWatch ã¡ããªã¯ã¹ã§ã¯ WriteIOPS ãçŽ 530 ã§ããããšã瀺ãããŸãããAmazon RDS ã¯ãã¡ããªã¯ã¹ããŒã¿ã 1 åééã§ CloudWatch ã«éä¿¡ããããšã«æ³šæããŠãã ããããã®ãããã°ã©ãã«ã¯ 1 åæªæºã®æ¥äžæããã£ããšããŠã衚瀺ãããŸããã WriteIOPS: æ¡åŒµã¢ãã¿ãªã³ã° åãã¯ãŒã¯ããŒãã«ãããŠãæ¡åŒµã¢ãã¿ãªã³ã°ã§ã¯ WriteIOPS ãçŽ 1600 ãšè¡šç€ºãããŸããããã¯ããã®ãã¢ã§ã¯æ¡åŒµã¢ãã¿ãªã³ã°ã®è§£å床ã1ç§ã«èšå®ãããŠãããããæ¡åŒµã¢ãã¿ãªã³ã°ã®ã¢ããªã³æ©èœãæäŸããæã詳现ãªããŒã¿ãåŸãããããã§ããæ¬¡ã®ã¹ã¯ãªãŒã³ã·ã§ããã¯ãæ¡åŒµã¢ãã¿ãªã³ã°ã®è§£å床ãé«ãããã«1åæªæºã®ã¹ãã€ã¯ãçºçããŠãããæ¡åŒµã¢ãã¿ãªã³ã°ã«ãã æžã蟌㿠IO/ç§ ã瀺ããŠããŸãããã£ã¹ã¯ I/O ãšãã¡ã€ã«ã·ã¹ãã ã®éèšã°ã©ãã衚瀺ããå Žåãrdsdev ããã€ã¹ã¯ããã¹ãŠã®ããŒã¿ããŒã¹ãã¡ã€ã«ãšãã°ãä¿åãããŠãã /rdsdbdata ãã¡ã€ã«ã·ã¹ãã ã«é¢é£ä»ããããŸããfilesystem ããã€ã¹ã¯ããªãã¬ãŒãã£ã³ã°ã·ã¹ãã ã«é¢é£ãããã¡ã€ã«ãä¿åãããŠãã / ãã¡ã€ã«ã·ã¹ãã ( root ãšãåŒã°ãã) ã«é¢é£ããŠããŸãã CPU 䜿çšç: CloudWatch åãã¯ãŒã¯ããŒãã§ã® CloudWatch ã® CPU 䜿çšçã«ã€ããŠãåãåŸåãèŠãããŸãã1 åã®ç²ŸåºŠã§æå€§å€ã¯çŽ 12% ãšå ±åãããŸããæ¬¡ã®ã¹ã¯ãªãŒã³ã·ã§ããã¯ãCloudWatch ããã® CPU 䜿çšçã瀺ããŠããŸãã CPU åèš: æ¡åŒµã¢ãã¿ãªã³ã° äžæ¹ãæ¡åŒµã¢ãã¿ãªã³ã°ã§ã¯ãããçã1 ç§åäœã®è§£ååºŠã®æ©èœã«ãããCPU 䜿çšçãçŽ 50% ãšå ±åãããŠããŸããæ¬¡ã®ã¹ã¯ãªãŒã³ã·ã§ããã¯ãæ¡åŒµã¢ãã¿ãªã³ã°ã«ãã CPU åèšã瀺ããŠããŸãã CPU Nice:æ¡åŒµã¢ãã¿ãªã³ã° ã€ã³ã¹ã¿ã³ã¹äžã®ããŠãŒã¶ã®ã¯ãŒã¯ããŒãã«ãã CPU 䜿çšçãæå³ãã CPU Nice ãªã©ã®ã¡ããªã¯ã¹ã確èªãããå Žåãæ¡åŒµã¢ãã¿ãªã³ã°ã§ã¯æ¬¡ã®ã°ã©ãã衚瀺ãããŸããåæ§ã«ãã¢ã¯ãã£ãã¡ã¢ãªã空ãã¡ã¢ãªã空ãã¹ã¯ãããã¹ã¯ããã€ã³ãã¹ã¯ããã¢ãŠã çã
ã®ã°ã©ãã衚瀺ãããŸãã 芳å¯ã®ãŸãšã æ¡åŒµã¢ãã¿ãªã³ã°ã¯ãOS ã¬ãã«ã®ãã现ããª1åæªæºã®è§£å床ã®ã¡ããªã¯ã¹ãç£èŠããã®ã«åœ¹ç«ã¡ãŸããæ¡åŒµã¢ãã¿ãªã³ã°ã®ãã®è§£ååºŠã®æ©èœã¯ãAmazon RDS ã 1 åééã§å¹³ååããã¡ããªã¯ã¹ããŒã¿ã CloudWatch ã«éä¿¡ãããããCloudWatch ã§ã¯ãã£ããã£ãããªãã1 åæªæºã®éã§ã¹ãã€ã¯ããã¯ãŒã¯ããŒããç£èŠããå Žåã«äŸ¿å©ã§ããããšãã°ããã¹ãã®çµæãããCloudWatch ã§ã¯ WriteIOPS ã®äœ¿çšçãé«ãïŒããŒã¯ã¯ 1,600 IOPSïŒããšã¯ç¢ºèªãããŠããŸãããReadIOPS ãåæ§ã®ã¬ãã«ãŸã§äžæãããšããŠããåãçŸè±¡ãäºæ³ãããŸãããã®ãããæ¡åŒµã¢ãã¿ãªã³ã°ã CloudWatch ã®ããã©ã«ãã¡ããªã¯ã¹ãšçµã¿åãããŠäœ¿çšãããšãå
æ¬çãã€è©³çްãªãã©ãã«ã·ã¥ãŒãã£ã³ã°ãå®è¡ããã®ã«åœ¹ç«ã¡ãŸãã ããã«ãCPU Nice ã°ã©ãã«èŠãããããã«ãæ¡åŒµã¢ãã¿ãªã³ã°ããããŸããŸãªã¡ããªã¯ã¹ã®ãµãã³ã³ããŒãã³ãã®ã°ã©ãã確èªããããšãã§ããŸããæ¡åŒµã¢ãã¿ãªã³ã°ã®ããã·ã¥ããŒãã«è¡šç€ºããã°ã©ããéžæããã«ã¯ã [ã°ã©ãã管ç] ã¿ããéããŠãµãã³ã³ããŒãã³ããéžæããŸãã æ¡åŒµã¢ãã¿ãªã³ã°ã®ãã®ä»ã®æ©èœ RDSã€ã³ã¹ã¿ã³ã¹äžã§ããŒã¿ãã¹ãã©ã€ãã³ã°ãããããªã¥ãŒã ã®æ°ãç¥ãå¿
èŠãããå ŽåããããŸãããã®æ
å ±ã¯ãã¹ããããªã³ã°ãã¬ã€ãã³ã·ãŒãããã³ãã®ä»ã®ããã©ãŒãã³ã¹é¢é£ã®åé¡ã«å¯Ÿãããã©ãã«ã·ã¥ãŒãã£ã³ã°ã«åœ¹ç«ã¡ãŸãã æ¬¡ã®ã¹ã¯ãªãŒã³ã·ã§ããã®äžã§ãRDS ã€ã³ã¹ã¿ã³ã¹ã« 4 ã€ã®ããªã¥ãŒã ãã¢ã¿ãããããŠããããšãããããŸããAmazon RDS for SQL Server ã§ã¯ããµã€ãºã«é¢ä¿ãªãã¢ã¿ãããããããªã¥ãŒã 㯠1 ã€ã ãã§ããã¢ã¿ããããããªã¥ãŒã ã®ã¿ã€ãã«å¿ããŠãããããã®ã¹ã«ãŒããããš IOPS ã®å¶éãé©çšãããAmazon RDS ã®ããã©ãŒãã³ã¹ã«ãããŠã«å€§ããªåœ¹å²ãæãããŸãã æ¬¡ã®ã¹ã¯ãªãŒã³ã·ã§ããã¯ãæ¡åŒµã¢ãã¿ãªã³ã°ã«ããç©çæžã蟌㿠IO/ç§ ã瀺ããŠããŸãã CloudWatch ã®ãã°ã°ã«ãŒã æ¡åŒµã¢ãã¿ãªã³ã°ã§ã¯ããã°ã°ã«ãŒã RDSOSMetrics äžã§ãçæããããã°ãä¿æãããŸãããããã®ãã°ã«ã¯ JSON 圢åŒã®ããŒã¿ãå«ãŸããŠãããCloudWatch ã³ã³ãœãŒã«ãš AWS CLI ã§è¡šç€ºã§ããŸãããã°ã¹ããªãŒã ã®åãã°ã«ã¯ã RDS ã€ã³ã¹ã¿ã³ã¹ã«é¢é£ããããŒã¿ ã®é
åãå«ãŸããŠããŸãããã°ã°ã«ãŒã RDSOSMetrics ã§çæããã RDS ã€ã³ã¹ã¿ã³ã¹ãã°ã衚瀺ããã«ã¯ãæ¬¡ã®æé ã«åŸããŸãã CloudWatch ã³ã³ãœãŒã«ã®ããã²ãŒã·ã§ã³ãã€ã³ã§ [ãã°ã°ã«ãŒã] ãéžæããŸãã RDS ã€ã³ã¹ã¿ã³ã¹ã«å¯Ÿå¿ãããã°ã¹ããªãŒã ãéžæããŸã (ãã°ã¹ããªãŒã 㯠RDS DBãªãœãŒã¹IDãšåãååã§ã)ã æéç¯å²ã®ãã£ã«ã¿ãŒã«åºã¥ããŠèª¿æ»ã«å¿
èŠãªãã°ãéžæããŸãã æ¬¡ã®äŸã«ã¯ã cpuUtilization:nice ã memory:buffers ãªã©ã®ãã¹ãŠã®ã¡ããªã¯ã¹ã®è©³çްãªå€ãå«ãŸããŠããŸãã { "engine": "MYSQL", "instanceID": "yyyy", "instanceResourceID": "xxxx", "timestamp": "2023-05-01T20:36:02Z", "version": 1, "uptime": "00:27:36", "numVCPUs": 4, "cpuUtilization": { "guest": 0, "irq": 0, "system": 0.3, "wait": 0, "idle": 99.3, "user": 0.3, "total": 0.9, "steal": 0, "nice": 0.3 }, "loadAverageMinute": { "one": 0.04, "five": 0.03, "fifteen": 0.04 }, "memory": { "writeback": 0, "hugePagesFree": 0, "hugePagesRsvd": 0, "hugePagesSurp": 0, "cached": 716380, "hugePagesSize": 2048, "free": 13573744, "hugePagesTotal": 0, "inactive": 2026324, "pageTables": 7744, "dirty": 848, "mapped": 107644, "active": 267504, "total": 16069100, "slab": 72004, "buffers": 140440 }, "tasks": { "sleeping": 111, "zombie": 0, "running": 0, "stopped": 0, "total": 111, "blocked": 0 }, "swap": { "cached": 0, "total": 16776188, "free": 16776188, "in": 0, "out": 0 }, "network": [ { "interface": "eth0", "rx": 910, "tx": 12785 } ], "diskIO": [ { "writeKbPS": 16, "readIOsPS": 0, "await": 1, "readKbPS": 0, "rrqmPS": 0, "util": 0.8, "avgQueueLen": 0, "tps": 4, "readKb": 0, "device": "rdsdev", "writeKb": 16, "avgReqSz": 8, "wrqmPS": 0, "writeIOsPS": 4 }, { "writeKbPS": 4, "readIOsPS": 0, "await": 1, "readKbPS": 0, "rrqmPS": 0, "util": 0.4, "avgQueueLen": 0, "tps": 1, "readKb": 0, "device": "filesystem", "writeKb": 4, "avgReqSz": 8, "wrqmPS": 0, "writeIOsPS": 1 } ], "physicalDeviceIO": [ { "writeKbPS": 16, "readIOsPS": 0, "await": 1, "readKbPS": 0, "rrqmPS": 0, "util": 0.8, "avgQueueLen": 0, "tps": 3, "readKb": 0, "device": "nvme1n1", "writeKb": 16, "avgReqSz": 10.67, "wrqmPS": 1, "writeIOsPS": 3 } ], "fileSys": [ { "used": 372316, "name": "", "usedFiles": 251, "usedFilePercent": 0, "maxFiles": 13107200, "mountPoint": "/rdsdbdata", "total": 205270252, "usedPercent": 0.18 }, { "used": 2233064, "name": "", "usedFiles": 39420, "usedFilePercent": 6.02, "maxFiles": 655360, "mountPoint": "/", "total": 10230600, "usedPercent": 21.83 } ] ãã°ã¯ããã°ã¹ããªãŒã ããŒã¿ãæ¶è²»ã§ãããã®ä»ã®AWSãµãŒãã¹ããåŠçããã³å¯èŠåããŒã«ãæäŸãããµãŒãããŒãã£ãŒããŒã«ã«è»¢éããããšãã§ããããããã Amazon Kinesis Data Firehose ã Amazon QuickSight ãšãã£ããã®ãæããããŸãã ç£èŠã®ããã®OSããã»ã¹ãªã¹ã DB ã€ã³ã¹ã¿ã³ã¹ã§å®è¡ãããŠããããã»ã¹ã®è©³çްã確èªãããå Žåã¯ãAmazon RDS ã³ã³ãœãŒã«ã® RDS ã€ã³ã¹ã¿ã³ã¹ã® [ã¢ãã¿ãªã³ã°] ã¿ãã«ãã [ OS ããã»ã¹ãªã¹ã ] ãéžæããŸãã ããã»ã¹ãªã¹ããã¥ãŒã«è¡šç€ºãããæ¡åŒµã¢ãã¿ãªã³ã°ã¡ããªã¯ã¹ã¯ãRDS åããã»ã¹ãRDS ããã»ã¹ãããã³ OS ããã»ã¹ã«åé¡ãããŸãã CloudWatch ãšæ¡åŒµã¢ãã¿ãªã³ã°ã®æž¬å®å€ã«ã¯éãããããããããŸããã詳现ã«ã€ããŠã¯ãã CloudWatch ãšæ¡åŒµã¢ãã¿ãªã³ã°ã®ã¡ããªã¯ã¹ã®çžéç¹ ããåç
§ããŠãã ããã æ¡åŒµã¢ãã¿ãªã³ã°ã«ããããããã¯ãŒã¯ãã¹ã¯ãããProcessListãªã©ã®æ°ããã¡ããªã¯ã¹ã«ã¢ã¯ã»ã¹ã§ããŸããæ¡åŒµã¢ãã¿ãªã³ã°å°çšã®ãããã®ã¡ããªã¯ã¹ã¯ããã©ãã«ã·ã¥ãŒãã£ã³ã°ãè¡ã£ãŠããéã«ãOS ãã©ã®ããã«åäœããŠããããããæ·±ãçè§£ããã®ã«åœ¹ç«ã¡ãŸããæ¡åŒµã¢ãã¿ãªã³ã°ã§å©çšã§ããã¡ããªã¯ã¹ã確èªããã«ã¯ãã æ¡åŒµã¢ãã¿ãªã³ã°ã® OS ã¡ããªã¯ã¹ ããåç
§ããŠãã ããã Amazon RDS ã¢ãã¿ãªã³ã°ããŒã«ã«é¢ããèæ
®äºé
Amazon RDS ã¯ãããŒã¿ããŒã¹ããã©ãŒãã³ã¹ã®ã¢ãã¿ãªã³ã°ãšãã©ãã«ã·ã¥ãŒãã£ã³ã°ã®ãããæ¡åŒµã¢ãã¿ãªã³ã°ãCloudWatchãPerformance Insights ã® 3 ã€ã®äž»èŠãªããŒã«ãæäŸããŸãããããã®ããŒã«ã¯ãRDS ã«é¢ããç¹å®ã®åé¡ã®ãã©ãã«ã·ã¥ãŒãã£ã³ã°ã®ãããããããç¬èªã®ãŠãŒã¹ã±ãŒã¹ããããŸãã æ¡åŒµã¢ãã¿ãªã³ã°ã䜿çšãããšãããŒã¿ããŒã¹ãšã³ãžã³ãå®è¡ãããŠãã OS ã«é¢ããéåžžã«è©³çްãªã¡ããªã¯ã¹ã现ããåããããã¡ããªã¯ã¹ (CPUUtilization.niceãmemory.free ãªã©)ãããã³ CloudWatch ã«éããããã°ãååŸããŠããããªãåæãšçµ±åãå¯èœã«ãªããŸãã äžæ¹ãCloudWatch ã¯ãRDS ãµãŒãã¹ã«ãã£ãŠå
¬éãããããã©ã«ãã®ã¡ããªã¯ã¹ã 1 ååäœã§åãåããã€ã³ã¹ã¿ã³ã¹ã®åäœãèŠèŠçã«ç¢ºèªããããã«å¹
åºã䜿çšãããŸãããã®ããŒã«ã«ã¯ãã°ã©ãã®éãåããã軞ã®åãæ¿ããæ°åŒèšç®ãç²åºŠã®å€æŽ (1 åã5 åã15 å)ãCloudWatch ä¿æããªã·ãŒã§å®çŸ©ãããŠããå±¥æŽããŒã¿ (æ°ãæã«ããã®ãŒã) ã®è¡šç€ºãªã©ã®æ©èœããããAmazon RDS ã§ã®ãªãœãŒã¹äœ¿çšã顧客ã¯ãŒã¯ããŒãã®åŸåãç¹å®ããã®ã«éåžžã«åœ¹ç«ã¡ãŸãã æ¡åŒµã¢ãã¿ãªã³ã°ãš CloudWatch ã«ã¯ããããç¬èªã®ã¡ããªã¯ã¹ããããŸããæ¡åŒµã¢ãã¿ãªã³ã°ã«ã¯ãä»ã®ã¡ããªã¯ã¹ã«å ããŠç©çããã€ã¹ã®ã¡ããªã¯ã¹ããããŸããäžæ¹ãCloudWatch ã«ã¯ãBurstBalanceãDatabaseConnections ãªã©ã䜿çšãã¿ãŒã³ã®ç¹å®ã«åœ¹ç«ã€éèŠãªã¡ããªã¯ã¹ããããŸãã Performance Insights ã§ã¯ãããŒã¿ããŒã¹ã®è² è·ãè©äŸ¡ããŠæé©åã§ããŸãããŸãã1 åæªæºã®ã¡ããªã¯ã¹ãæäŸããã1 ç§éã®ã¡ããªã¯ã¹ã¯æå€§ 2 幎éä¿æãããŸããåŸ
æ©ã€ãã³ãã SQL ã¯ãšãªãªã©ãè€æ°ã®ãã£ã¡ã³ã·ã§ã³ã䜿çšããŠçްããåæã§ããŸãããŸããPerformance Insightsã§ã¯ãAmazon RDS ã®è² è·ãèŠèŠåãããã®åå ãšãªã£ãŠããã¯ãšãªã®çš®é¡ãã¯ãšãªã®çºä¿¡å
ãåå ãšãªã£ãŠãããŠãŒã¶ãŒãç¹å®ããã®ã«åœ¹ç«ã¡ãŸãã ã¯ãªãŒã³ã¢ãã 远å ã³ã¹ããçºçããªãããã«ããã®ãã¢ã³ã¹ãã¬ãŒã·ã§ã³ã«äœ¿çšãããªãœãŒã¹ã¯ãã¹ãŠåé€ããŠãã ããã RDS ã€ã³ã¹ã¿ã³ã¹ãåé€ããŸãã ããŒã«ã«ãã¹ããã ã¯ã©ã€ã¢ã³ãããŒã«ãåé€ ããŸãã RDS ã€ã³ã¹ã¿ã³ã¹ã®æ¡åŒµã¢ãã¿ãªã³ã°ã«é¢é£ãã ãã°ã¹ããªãŒã ãåé€ ããŸãã RDSOSMetrics ã¯ããã©ã«ãã§ 30 æ¥éä¿æãããããšã«æ³šæããŠãã ããã ãŸãšã ãã®èšäºã§ã¯ãAmazon RDS for MySQL ã®ã¯ãŒã¯ããŒããã¹ãã€ã¯ãããã¢ã䜿ã£ãŠãã€ã³ã¹ã¿ã³ã¹ã®ããã©ãŒãã³ã¹ãããå
æ¬çãã€æ£ç¢ºã«ææ¡ããããã«ãæ¡åŒµã¢ãã¿ãªã³ã°ã®è©³çްãªã¡ããªã¯ã¹ã䜿çšããããšã®éèŠæ§ã匷調ããŸããã ãã®æçš¿ã«ã€ããŠè³ªåãã³ã¡ã³ããããå Žåã¯ãã³ã¡ã³ãã»ã¯ã·ã§ã³ã«æ®ããŠãã ããã èè
ã«ã€ã㊠Abdul Sarker ã¯ãAWS ã§ 2 幎éã«ããã£ãŠã¯ã©ãŠããµããŒããšã³ãžãã¢ãåããŠããŸããAWS ã¯ã©ãŠãã§åªããã«ã¹ã¿ããŒãšã¯ã¹ããªãšã³ã¹ãæäŸããããšã«éç¹ã眮ããå€éšã®ã客æ§ãšååããŠãAmazon RDS ã€ã³ãã©ã¹ãã©ã¯ãã£ã®ãã©ãã«ã·ã¥ãŒãã£ã³ã°ãAWS DMS ãããžã§ã¯ãã®æ¯æŽã瀟å
ææžãèšäºã®äœæãšæ¹åãªã©ãããŸããŸãªã·ããªãªãåŠçããŠããŸãã Nirupam Datta 㯠AWS ã®ã¯ã©ãŠããµããŒã DBA ã§ãã圌ã¯AWSã«çŽ3幎ååšç±ããŠããŸããããŒã¿ããŒã¹ãšã³ãžãã¢ãªã³ã°ãšã€ã³ãã©ã¹ãã©ã¯ãã£ã¢ãŒããã¯ãã£ã§ 11 幎以äžã®çµéšãæã€Nirupamã¯ãAmazon RDSã®ã³ã¢ã·ã¹ãã ãš Amazon RDS for SQL Server ã®å°éå®¶ã§ããããŸãã圌ã¯ã客æ§ã«æè¡æ¯æŽãæäŸããAWS ã¯ã©ãŠããžã®ç§»è¡ãæé©åãç§»è¡ãæ¯æŽããŠããŸãã 翻蚳ã¯ã¯ã©ãŠããµããŒããšã³ãžãã¢ã®ç«éãæ
åœããŸãããåæã¯ ãã¡ã ã§ãã