[B! aws][*thresh25] slay-tã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

slay-t id:slay-t

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

SpotInstanceã¨JMeterã‚’ä½¿ã£ã¦400ä¸‡req/minã®è² è·è©¦é¨“ã‚’è¡Œã† | DevelopersIO
Apache JMeterã®Master/Slaveæ§‹æˆ ã‚·ãƒŠãƒªã‚ªã‚’ç”¨ã„ãŸè² è·è©¦é¨“ã¨ã„ãˆã°JMeterã¨ã„ã†ã“ã¨ã§ã€ä½¿ã£ãŸã“ã¨ãŒã‚ã‚‹æ–¹ã‚‚å¤šã„ã‹ã¨æ€ã„ã¾ã™ã€‚ã—ã‹ã—ã€ã»ã¨ã‚“ã©ã®æ–¹ã¯è‡ªåˆ†ã®PCã‚’ä½¿ã£ã¦ã‚„ã£ã¦ã„ã‚‹ç¨‹åº¦ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚æœ€è¿‘ã¯ã€ã‚¹ãƒžãƒ›é€£å‹•ã®ã‚·ã‚¹ãƒ†ãƒ ãŒå¤šããªã£ã¦ãã¦ã„ã¾ã™ã®ã§ã€1å°ã®PCã‹ã‚‰è² è·ã‚’æŽ›ã‘ãŸã¨ã—ã¦ã‚‚å¤§ã—ãŸè² è·è©¦é¨“ã«ãªã‚Šã¾ã›ã‚“ã€‚ãã“ã§ã€ä»Šå›žã¯JMeterã‚’Master/Slaveã®ã‚¯ãƒ©ã‚¹ã‚¿ãƒ¼æ§‹æˆã«ã—ã¦ãƒ‰ã‚«ãƒ¼ãƒ³ã¨åŒæ™‚ã‚¢ã‚¯ã‚»ã‚¹ã‚’è¡Œã„ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã‚¯ãƒ©ã‚¹ãƒ¡ã‚½ãƒƒãƒ‰ã®è² è·è©¦é¨“ã®æ´å² å‰µæ¥æ™‚ã‹ã‚‰æ¥å‹™ç³»ã®ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºãŒå¤šã‹ã£ãŸã“ã¨ã‹ã‚‰ã€ãƒ¬ã‚¹ãƒãƒ³ã‚¹ã¯3ç§’ä»¥å†…ã§OKã¨ã‹ã€ãƒ”ãƒ¼ã‚¯æ™‚ã®åŒæ™‚ãƒ¦ãƒ¼ã‚¶ã¯100åã¨ã„ã£ãŸã€ç·©ã„æ¡ä»¶ã‚’ã‚¯ãƒªã‚¢ã™ã‚Œã°è‰¯ã‹ã£ãŸã“ã¨ãŒæ‡ã‹ã—ãæ€ã„ã¾ã™ã€‚ä»Šã¯ã€ãƒ¦ãƒ¼ã‚¶æ•°ãƒ»ãƒ‡ãƒ¼ã‚¿é‡ãƒ»ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³æ•°ãƒ»ãƒˆãƒ©ãƒ•ã‚£ãƒƒã‚¯ç‰ãŒçˆ†ç™ºçš„ã«å¢—ãˆã‚‹å¯èƒ½æ€§ã®ã‚ã‚‹ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã‚‚å¤šãã€è² è·è©¦é¨“ã¯å¿…é ˆé …ç›®
slay-t 2013/05/07
ãƒ†ã‚¹ãƒˆ

è¨è¨ˆ

*thresh25

è² è·ãƒ†ã‚¹ãƒˆ

aws

performance

jmeter

EC2
ãƒªãƒ³ã‚¯
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ã«ã‚ã‚‹ãƒ–ãƒãƒƒã‚¯ãƒ‡ãƒã‚¤ã‚¹ã«å¯¾ã—ã¦åŒ
slay-t 2013/04/25
AWS

MySQL

mysql

*thresh25

tuning
ãƒªãƒ³ã‚¯
1

ãŠçŸ¥ã‚‰ã›

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

å…¬å¼Twitter

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

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

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

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

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

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

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

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

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

ã‚¿ã‚°

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

awsã¨*thresh25ã«é–¢ã™ã‚‹slay-tã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (2)

ãŠçŸ¥ã‚‰ã›

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

ã€Œã‚ã¨ã§èªã‚€ã€ã‚¿ã‚°ã§æŒ¯ã‚Šè¿”ã‚‹2024å¹´ ã€œä»Šå¹´ã®ã€Œã‚ã¨ã§èªã‚€ã€ã€ä»Šå¹´ã®ã†ã¡ã«ã€œ

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

å…¬å¼Twitter

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

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

å…¬å¼Twitter

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

ã‚¿ã‚°

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

awsã¨*thresh25ã«é–¢ã™ã‚‹slay-tã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (2)

SpotInstanceã¨JMeterã‚’ä½¿ã£ã¦400ä¸‡req/minã®è² è·è©¦é¨“ã‚’è¡Œã† | DevelopersIO

AWS RDS ã®æ›¸ãè¾¼ã¿æ€§èƒ½ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° : DSASé–‹ç™ºè€…ã®éƒ¨å±‹

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

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

ã€Œã‚ã¨ã§èª­ã‚€ã€ã‚¿ã‚°ã§æŒ¯ã‚Šè¿”ã‚‹2024å¹´ ã€œä»Šå¹´ã®ã€Œã‚ã¨ã§èª­ã‚€ã€ã€ä»Šå¹´ã®ã†ã¡ã«ã€œ

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

å…¬å¼Twitter

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

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

å…¬å¼Twitter

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

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

awsã¨*thresh25ã«é–¢ã™ã‚‹slay-tã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (2)

SpotInstanceã¨JMeterã‚’ä½¿ã£ã¦400ä¸‡req/minã®è² è·è©¦é¨“ã‚’è¡Œã† | DevelopersIO

AWS RDS ã®æ›¸ãè¾¼ã¿æ€§èƒ½ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° : DSASé–‹ç™ºè€…ã®éƒ¨å±‹

ãŠçŸ¥ã‚‰ã›

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

ã€Œã‚ã¨ã§èªã‚€ã€ã‚¿ã‚°ã§æŒ¯ã‚Šè¿”ã‚‹2024å¹´ ã€œä»Šå¹´ã®ã€Œã‚ã¨ã§èªã‚€ã€ã€ä»Šå¹´ã®ã†ã¡ã«ã€œ

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

å…¬å¼Twitter

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

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

å…¬å¼Twitter

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