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

hnw id:hnw

awsã«é–¢ã™ã‚‹hnwã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (2)

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

é‹ç”¨çš„é–¢å¿ƒäº‹ã‚’å®Ÿé¨“çš„ã«AWS Lambda on VPCã«ãŠä»»ã›ã—ã¦ã¿ãŸã®ã§æ‰€æ„Ÿ - tehepero note(ãƒ»Ï‰<)
2016 - 02 - 25 é‹ç”¨çš„é–¢å¿ƒäº‹ã‚’å®Ÿé¨“çš„ã«AWS Lambda on VPCã«ãŠä»»ã›ã—ã¦ã¿ãŸã®ã§æ‰€æ„Ÿ AWS Lambda Slack ãƒªãƒªãƒ¼ã‚¹ã—ãŸæ™‚ã¯ãã‚Œã„ã ã£ãŸã‚³ãƒ¼ãƒ‰ã‚‚ã€é‹ç”¨ã«æ›ã•ã‚Œã‚‹ã“ã¨ã§æ±šããªã£ã¦ã„ã£ãŸã‚Šã—ã¾ã™ã‚ˆãã€‚ ChatOpsãªä»Šã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§ã¯ã€ã€Œ ã¨ã‚ã‚‹ã‚¤ãƒ™ãƒ³ãƒˆãŒç™ºç”Ÿã—ãŸéš›ã«ã€é‹ç”¨æ‹…å½“è€…ãŒè¿…é€Ÿã«åå¿œã§ãã‚‹ã‚ˆã†Slackã«é€šçŸ¥ã—ã¦ã»ã—ã„ ã€ã¨ã„ã†è¦æœ›ãŒå‡ºã¦ããŸã‚Šã—ã¦ã„ã¾ã™ã€‚ä»¥å‰ã§ã‚ã‚Œã°ã€ãƒ¡ãƒ¼ãƒ«é€šçŸ¥ã—ã¦ãŸã¨ã“ã‚ã§ã—ã‚‡ã†ã‹ãã€‚ é‹ç”¨çš„é–¢å¿ƒäº‹ã¯ç§»ã‚ã„ã‚„ã™ã„ ã‹ã¤ã¦ Java ã§ AOP ãŒæµè¡Œã‚Šã ã—ãŸé ƒã«ã€ãƒã‚®ãƒ³ã‚°ã ã£ãŸã‚Šæ¨©é™ãƒã‚§ãƒƒã‚¯ã ã£ãŸã‚Šã®å‡¦ç†ã‚’ ãƒ¡ã‚½ãƒƒãƒ‰ ã«weavingã—ãŸInterceptorã«è¿½ã„ã‚„ã‚‹ã¨ã„ã†ã€æ‰€è¬‚ã€Œæ¨ªæ–çš„é–¢å¿ƒäº‹ã€ã‚’ ãƒ“ã‚¸ãƒã‚¹ãƒã‚¸ãƒƒã‚¯ ã®æœ¬è³ªã‹ã‚‰é™¤å¤–ã™ã‚‹ã¨ã„ã†æ‰‹æ³•ãŒã‚ã‚Šã¾ã—ãŸãã€‚ è‡ªåˆ†ãŒé‹ç”¨çš„é–¢å¿ƒäº‹ã¨è¨€ã£ã¦ã„ã‚‹ã®ã¯ä½•ã®ã“ã¨ã‹ã¨ã„ã†ã¨ã€ ã‚¢ãƒ—ãƒª
hnw 2016/03/09
aws
ãƒªãƒ³ã‚¯
Amazon RDS ã§è‚¥å¤§åŒ–ã—ãŸslow_logãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ã‚¯ãƒªã‚¢ã™ã‚‹æ–¹æ³•
ä»¥å‰AmazonRDSã§slow queryã‚’å‡ºåŠ›ã™ã‚‹ã‚ˆã†ã«ã™ã‚‹æ–¹æ³•ã«ã¦RDSã§slow_logã‚’å‡ºåŠ›ã™ã‚‹ã‚ˆã†ã«è¨å®šã™ã‚‹ã¨ã€mysqlãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®slow_logãƒ†ãƒ¼ãƒ–ãƒ«ã«ãƒã‚°ãŒä¿å˜ã•ã‚Œã‚‹ã‚ˆã†ã«ãªã‚‹ã®ã§ã™ãŒã€ã“ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«ä¿å˜ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã¯ã€RDSã§ä½œæˆã§ãã‚‹ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®æ¨©é™ã§ã¯å‰Šé™¤ã™ã‚‹ã“ã¨ãŒã§ãã¾ã›ã‚“ã€‚ mysql> delete from slow_log; ERROR 1556 (HY000): You can't use locks with log tables. mysql> truncate table slow_log; ERROR 1044 (42000): Access denied for user 'xxxx'@'%' to database 'mysql' ã“ã®ã“ã¨ã¯general_logã«ã‚‚è¨€ãˆã‚‹ã®ã§ã™ãŒã€ ã“ã‚Œã«å¯¾ã—ã¦ã€Amazonã‹ã‚‰ä»¥ä¸‹ã®ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸
hnw 2012/05/08
rds

aws
ãƒªãƒ³ã‚¯
1

ãŠçŸ¥ã‚‰ã›

ã‚‚ã£ã¨èªã‚€

å…¬å¼Twitter

@hatebu
æœ€æ–°ã®äººæ°—ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã®é…ä¿¡

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

jæ¬¡ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kå‰ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

lã‚ã¨ã§èªã‚€

eã‚³ãƒ¡ãƒ³ãƒˆä¸€è¦§ã‚’é–‹ã

oãƒšãƒ¼ã‚¸ã‚’é–‹ã

è¨å®šã‚’å¤‰æ›´ã—ã¾ã—ãŸx

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (1)

awsã«é–¢ã™ã‚‹hnwã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (2)

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬2é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬1é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´11æœˆï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (1)

awsã«é–¢ã™ã‚‹hnwã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (2)

é‹ç”¨çš„é–¢å¿ƒäº‹ã‚’å®Ÿé¨“çš„ã«AWS Lambda on VPCã«ãŠä»»ã›ã—ã¦ã¿ãŸã®ã§æ‰€æ„Ÿ - tehepero note(ãƒ»Ï‰<)

Amazon RDS ã§è‚¥å¤§åŒ–ã—ãŸslow_logãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ã‚¯ãƒªã‚¢ã™ã‚‹æ–¹æ³•

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬2é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬1é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´11æœˆï¼‰

å…¬å¼Twitter

ã‚­ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (1)

awsã«é–¢ã™ã‚‹hnwã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (2)

é‹ç”¨çš„é–¢å¿ƒäº‹ã‚’å®Ÿé¨“çš„ã«AWS Lambda on VPCã«ãŠä»»ã›ã—ã¦ã¿ãŸã®ã§æ‰€æ„Ÿ - tehepero note(ãƒ»Ï‰<)

Amazon RDS ã§è‚¥å¤§åŒ–ã—ãŸslow_logãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ã‚¯ãƒªã‚¢ã™ã‚‹æ–¹æ³•

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬2é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬1é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´11æœˆï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹