Skyeng ã§ã¯ã䞊åã¹ã±ãŒãªã³ã°ãå«ã Amazon Redshift ã䜿çšããŠãããããdotgo.com ã®åµèšè
ã§ãã Stefan Gromoll ã«ãã intermix.io åãã®ãã®èšäºãèå³æ·±ããšæããŸããã 翻蚳åŸãããŒã¿ ãšã³ãžã㢠Daniyar Belkhodzhaev ããã®çµéšãå°ã玹ä»ããŸãã
Amazon Redshift ã®äžŠåã¹ã±ãŒãªã³ã°ã«ãããRedshift ã¯ã©ã¹ã¿ãŒã«ããŒã¯æã®ãªã¯ãšã¹ãéãåŠçããããã®è¿œå 容éãäžããããŸãã ããã¯ãããã¯ã°ã©ãŠã³ãã§ãªã¯ãšã¹ããæ°ããã䞊åãã¯ã©ã¹ã¿ãŒã«ç§»åããããšã§æ©èœããŸãã ãªã¯ãšã¹ãã¯ãWLM ã®èšå®ãšã«ãŒã«ã«åºã¥ããŠã«ãŒãã£ã³ã°ãããŸãã
䞊åã¹ã±ãŒãªã³ã°ã®äŸ¡æ Œã¯ãç¡æå©çšæ ã®ããã¯ã¬ãžãã ã¢ãã«ã«åºã¥ããŠããŸãã ç¡æã¯ã¬ãžãããè¶
ãããšãParallel Scaling Cluster ããªã¯ãšã¹ããåŠçããæéã«åºã¥ããŠæ¯æããè¡ãããŸãã
èè ã¯ãå éšã¯ã©ã¹ã¿ãŒã® XNUMX ã€ã§äžŠåã¹ã±ãŒãªã³ã°ããã¹ãããŸããã ãã®æçš¿ã§ã¯ããã¹ãçµæã«ã€ããŠèª¬æããéå§æ¹æ³ã«ã€ããŠã®ãã³ããæäŸããŸãã
ã¯ã©ã¹ã¿ãŒã®èŠä»¶
䞊åã¹ã±ãŒãªã³ã°ã䜿çšããã«ã¯ãAmazon Redshift ã¯ã©ã¹ã¿ãŒã次ã®èŠä»¶ãæºãããŠããå¿ èŠããããŸãã
- ãã©ããããŒã ïŒ EC2-VPCã
â ããŒãã¿ã€ã: dc2.8xlargeãds2.8xlargeãdc2.large ãŸã㯠ds2.xlarge;
â ããŒãã®æ°: 2 ïœ 32 (åäžããŒãã¯ã©ã¹ã¿ãŒã¯ãµããŒããããŠããŸãã)ã
åãå ¥ãå¯èœãªãªã¯ãšã¹ãã®ã¿ã€ã
䞊åã¹ã±ãŒãªã³ã°ã¯ããã¹ãŠã®çš®é¡ã®ã¯ãšãªã«é©ããŠããããã§ã¯ãããŸããã æåã®ããŒãžã§ã³ã§ã¯ã次㮠XNUMX ã€ã®æ¡ä»¶ãæºããèªã¿åããªã¯ãšã¹ãã®ã¿ãåŠçãããŸãã
â SELECT ã¯ãšãªã¯èªã¿åãå°çšã§ã (ãã ããããå€ãã®ã¿ã€ããèšç»ãããŠããŸã)ã
â ã¯ãšãªã¯ INTERLEAVED 䞊ã¹æ¿ãã¹ã¿ã€ã«ã®ããŒãã«ãåç
§ããŸããã
- ã¯ãšãªã¯ãå€éšããŒãã«ãåç
§ããããã« Amazon Redshift Spectrum ã䜿çšããŸããã
Parallel Scaling Cluster ã«ã«ãŒãã£ã³ã°ããã«ã¯ããªã¯ãšã¹ãããã¥ãŒã«å
¥ããå¿
èŠããããŸãã ããã«ããã¥ãŒã®å¯Ÿè±¡ãšãªãã¯ãšãª
ãã¥ãŒãš SQA ã«ã¯é©åãªæ§æãå¿
èŠã§ã
䞊åã¹ã±ãŒãªã³ã°ã®ã³ã¹ã
AWS ã¯ã䞊åã¹ã±ãŒãªã³ã°ã®ããã®ã¯ã¬ãžãã ã¢ãã«ãæäŸããŸãã ã¢ã¯ãã£ããªåã¯ã©ã¹ã¿ãŒ
æéãæ¯æãã®ã¯ãParallel Scaling Clusters ã®äœ¿çšéãåãåã£ãã¯ã¬ãžããã®éãè¶ ããå Žåã®ã¿ã§ãã
ã³ã¹ãã¯ãç¡ææéãè¶
ããŠäœ¿çšããã䞊åã¯ã©ã¹ã¿ãŒã® XNUMX ç§ãããã®ãªã³ããã³ãæéã§èšç®ãããŸãã æéã¯ãªã¯ãšã¹ãã®ç¶ç¶æéã«å¯ŸããŠã®ã¿çºçããParallel Scaling Cluster ãã¢ã¯ãã£ãåããããã³ã«æäœæé㯠XNUMX åãšãªããŸãã XNUMX ç§ãããã®ãªã³ããã³ãæéã¯ãäžè¬çãªäŸ¡æ Œèšå®ååã«åºã¥ããŠèšç®ãããŸãã
䞊åã¹ã±ãŒãªã³ã°ã®éå§
䞊åã¹ã±ãŒãªã³ã°ã¯ãWLM ãã¥ãŒããšã«ããªã¬ãŒãããŸãã AWS Redshift ã³ã³ãœãŒã«ã«ç§»åããå·ŠåŽã®ããã²ãŒã·ã§ã³ ã¡ãã¥ãŒãã [ã¯ãŒã¯ããŒã管ç] ãéžæããŸãã 次ã®ããããããŠã³ ã¡ãã¥ãŒããã¯ã©ã¹ã¿ãŒã® WLM ãã©ã¡ãŒã¿ãŒ ã°ã«ãŒããéžæããŸãã
åãã¥ãŒã®æšªã«ãåæå®è¡ã¹ã±ãŒãªã³ã° ã¢ãŒãããšããæ°ããåã衚瀺ãããŸãã ããã©ã«ãã¯ãç¡å¹ãã§ãã ãç·šéããã¯ãªãã¯ãããšãåãã¥ãŒã®èšå®ãå€æŽã§ããŸãã
èšå®
䞊åã¹ã±ãŒãªã³ã°ã¯ãé©åãªãªã¯ãšã¹ããæ°ããå°çšã¯ã©ã¹ã¿ãŒã«è»¢éããããšã§æ©èœããŸãã æ°ããã¯ã©ã¹ã¿ãŒã®ãµã€ãº (ããŒãã®ã¿ã€ããšæ°) ã¯ã¡ã€ã³ ã¯ã©ã¹ã¿ãŒãšåãã§ãã
䞊åã¹ã±ãŒãªã³ã°ã«äœ¿çšãããããã©ã«ãã®ã¯ã©ã¹ã¿ãŒæ°ã¯ 1 ã§ãåèšã§æ倧 10 åã®ã¯ã©ã¹ã¿ãŒãæ§æã§ããŸãã
䞊åã¹ã±ãŒãªã³ã°ã®ã¯ã©ã¹ã¿ãŒã®åèšæ°ã¯ãmax_concurrency_scaling_clusters ãã©ã¡ãŒã¿ãŒã§èšå®ã§ããŸãã ãã®ãã©ã¡ãŒã¿ã®å€ãå¢ãããšãè¿œå ã®åé·ã¯ã©ã¹ã¿ãæäŸãããŸãã
ç£èŠ
AWS Redshift ã³ã³ãœãŒã«ã§ã¯ãè¿œå ã®ã°ã©ããããã€ãå©çšå¯èœã§ãã [æ倧æ§æåæå®è¡ã¹ã±ãŒãªã³ã° ã¯ã©ã¹ã¿ãŒ] ã°ã©ãã«ã¯ãæéã®çµéã«äŒŽã max_concurrency_scaling_clusters ã®å€ã衚瀺ãããŸãã
ã¢ã¯ãã£ããªã¹ã±ãŒãªã³ã° ã¯ã©ã¹ã¿ãŒã®æ°ã¯ããŠãŒã¶ãŒ ã€ã³ã¿ãŒãã§ã€ã¹ã®ãåæå®è¡ã¹ã±ãŒãªã³ã° ã¢ã¯ãã£ããã£ãã»ã¯ã·ã§ã³ã«è¡šç€ºãããŸãã
[ã¯ãšãª] ã¿ãã«ã¯ãã¯ãšãªãã¡ã€ã³ ã¯ã©ã¹ã¿ãŒã§å®è¡ãããã䞊åã¹ã±ãŒãªã³ã° ã¯ã©ã¹ã¿ãŒã§å®è¡ããããã瀺ãåããããŸãã
ç¹å®ã®ã¯ãšãªãã¡ã€ã³ ã¯ã©ã¹ã¿ãŒã§å®è¡ããããã䞊åã¹ã±ãŒãªã³ã° ã¯ã©ã¹ã¿ãŒãéããŠå®è¡ããããã«é¢ä¿ãªããã¯ãšãªã¯ stl_query.concurrency_scaling_status ã«ä¿åãããŸãã
å€ 1 ã¯ã¯ãšãªã䞊åã¹ã±ãŒã« ã¯ã©ã¹ã¿ãŒã§å®è¡ãããããšã瀺ããä»ã®å€ã¯ã¯ãšãªããã©ã€ã㪠ã¯ã©ã¹ã¿ãŒã§å®è¡ãããããšã瀺ããŸãã
äŸïŒ
åæå®è¡ã¹ã±ãŒãªã³ã°æ
å ±ã¯ãSVCS_CONCURRENCY_SCALING_USAGE ãªã©ã®ä»ã®ããŒãã«ããã¥ãŒã«ãä¿åãããŸãã ããã«ã䞊åã¹ã±ãŒãªã³ã°ã«é¢ããæ
å ±ãä¿åããã«ã¿ãã° ããŒãã«ãå€æ°ãããŸãã
çµæ
èè ãã¯ã18 幎 30 æ 00 æ¥ã®ã°ãªãããžæšæºæçŽ 29.03.2019:3:20 ã«å éšã¯ã©ã¹ã¿ãŒå ã® 30 ã€ã®ãã¥ãŒã®äžŠåã¹ã±ãŒãªã³ã°ãéå§ãã00 幎 29.03.2019 æ XNUMX æ¥ã®çŽ XNUMX:XNUMX:XNUMX ã« max_concurrency_scaling_clusters ãã©ã¡ãŒã¿ãŒã XNUMX ã«å€æŽããŸããã
ãªã¯ãšã¹ã ãã¥ãŒãã·ãã¥ã¬ãŒãããããã«ããã®ãã¥ãŒã®ã¹ãããæ°ã 15 ãã 5 ã«æžãããŸããã
以äžã¯ãã¹ãããæ°ãæžãããåŸã«å®è¡äžããã³ãã¥ãŒã«å ¥ããããŠãããªã¯ãšã¹ãã®æ°ã瀺ã intermix.io ããã·ã¥ããŒã ã°ã©ãã§ãã
ãã¥ãŒå
ã®ãªã¯ãšã¹ãã®åŸ
æ©æéãå¢å ããæ倧æéã 5 åãè¶
ããŠããããšãããããŸãã
ãã®éã«äœãèµ·ãã£ããã«ã€ããŠã® AWS ã³ã³ãœãŒã«ããã®é¢é£æ
å ±ã¯æ¬¡ã®ãšããã§ãã
Redshift ã¯ãæ§æã©ããã« 3 ã€ã®äžŠåã¹ã±ãŒãªã³ã° ã¯ã©ã¹ã¿ãŒãèµ·åããŸããã ã¯ã©ã¹ã¿ãŒå
ã®å€ãã®ãªã¯ãšã¹ãããã¥ãŒã«å
¥ããããŠããã«ããããããããããã®ã¯ã©ã¹ã¿ãŒã¯ååã«æŽ»çšãããŠããªãã£ãããã§ãã
䜿çšç¶æ³ã°ã©ãã¯ãã¹ã±ãŒãªã³ã° ã¢ã¯ãã£ãã㣠ã°ã©ããšçžé¢é¢ä¿ããããŸãã
æ°æéåŸãäœæè
ããã¥ãŒã確èªãããšããã6 ã€ã®ãªã¯ãšã¹ãã䞊åã¹ã±ãŒãªã³ã°ã§å®è¡ãããŠããããã§ããã ãŸãããŠãŒã¶ãŒ ã€ã³ã¿ãŒãã§ã€ã¹ãä»ã㊠XNUMX ã€ã®ãªã¯ãšã¹ããã©ã³ãã ã«ãã¹ãããŸããã è€æ°ã®äžŠåã¯ã©ã¹ã¿ãŒãåæã«ã¢ã¯ãã£ããªå Žåã«ãããã®å€ã䜿çšããæ¹æ³ã¯ç¢ºèªããŠããŸããã
æèŠ
䞊åã¹ã±ãŒãªã³ã°ã«ãããããŒã¯è² è·æã«ãªã¯ãšã¹ãããã¥ãŒå ã§è²»ããæéãççž®ã§ããŸãã
åºæ¬ãã¹ãã®çµæãèªã¿èŸŒã¿ãªã¯ãšã¹ãã®ç¶æ³ãéšåçã«æ¹åãããŠããããšãå€æããŸããã ãã ãã䞊åã¹ã±ãŒãªã³ã°ã ãã§ã¯åæå®è¡ã®åé¡ããã¹ãŠè§£æ±ºã§ããããã§ã¯ãããŸããã
ããã¯ã䞊åã¹ã±ãŒãªã³ã°ã䜿çšã§ããã¯ãšãªã®çš®é¡ã«å¶éãããããã§ãã ããšãã°ãäœæè ã¯ã€ã³ã¿ãŒãªãŒãããããœãŒãããŒãæã€ããŒãã«ãå€æ°æã£ãŠãããã¯ãŒã¯ããŒãã®ã»ãšãã©ã¯æžã蟌ã¿ã§ãã
䞊åã¹ã±ãŒãªã³ã°ã¯ WLM ãã»ããã¢ããããããã®æ®éçãªãœãªã¥ãŒã·ã§ã³ã§ã¯ãããŸãããããã®æ©èœã®äœ¿çšã¯ã·ã³ãã«ã§ç°¡åã§ãã
ãããã£ãŠãèè ã¯ããã WLM ãã¥ãŒã«äœ¿çšããããšããå§ãããŸãã XNUMX ã€ã®äžŠåã¯ã©ã¹ã¿ãŒããéå§ããã³ã³ãœãŒã«ãéããŠããŒã¯è² è·ãç£èŠããŠãæ°ããã¯ã©ã¹ã¿ãŒãå®å šã«å©çšãããŠãããã©ãããå€æããŸãã
AWS ãè¿œå ã®ã¯ãšãª ã¿ã€ããšããŒãã«ã®ãµããŒããè¿œå ããã«ã€ããŠã䞊åã¹ã±ãŒãªã³ã°ã¯åŸã ã«å¹ççã«ãªãã¯ãã§ãã
Skyeng ããŒã¿ãšã³ãžã㢠Daniyar Belkhodzhaev ã®ã³ã¡ã³ã
ç§ãã¡ Skyeng ãã䞊åã¹ã±ãŒãªã³ã°ã®å¯èœæ§ãæµ®äžããŠããããšã«ããã«æ°ã¥ããŸããã
ç¹ã«ã»ãšãã©ã®ãŠãŒã¶ãŒã¯è¿œå æéãæ¯æãå¿ èŠãããªããš AWS ãèŠç©ãã£ãŠããããšãèæ ®ãããšããã®æ©èœã¯éåžžã«é åçã§ããå¶ç¶ã«ãã24 æäžæ¬ã« Redshift ã¯ã©ã¹ã¿ãŒãžã®ãªã¯ãšã¹ããç°åžžã«æ®ºå°ããŸããã ãã®æéäžãç§ãã¡ã¯åæå®è¡ã¹ã±ãŒãªã³ã°ã«é Œãããšãå€ããè¿œå ã®ã¯ã©ã¹ã¿ãŒã XNUMX æéåæ¢ããããšãªã皌åããããšããããŸããã
ããã«ããããã¥ãŒã®åé¡ãå®å šã«è§£æ±ºã§ããªãã£ããšããŠããå°ãªããšã蚱容å¯èœãªç¶æ³ã«ããããšãã§ããŸããã
ç§ãã¡ã®èŠ³å¯ã¯ãintermix.io ã®äººã ã®å°è±¡ãšã»ãŒäžèŽããŠããŸãã
ãŸãããã¥ãŒå ã§åŸ æ©ããŠãããªã¯ãšã¹ãããã£ãŠãããã¹ãŠã®ãªã¯ãšã¹ããããã«äžŠåã¯ã©ã¹ã¿ãŒã«è»¢éãããããã§ã¯ãªãããšã«ãæ°ä»ããŸããã ã©ãããããã¯ã䞊åã¯ã©ã¹ã¿ãŒã®èµ·åã«ãŸã æéããããããã«çºçããããã§ãã ãã®çµæãçæéã®ããŒã¯è² è·äžãå°ããªãã¥ãŒãæ®ãã察å¿ããã¢ã©ãŒã ãããªã¬ãŒããããŸã§ã«æéãããããŸãã
XNUMX æã«ç°åžžãªè² è·ã解æ¶ããããããAWS ã®äºæ³éããç¡ææšæºã®ç¯å²å ã§æã 䜿çšããã¢ãŒãã«å ¥ããŸããã
AWS Cost Explorer ã§äžŠåã¹ã±ãŒãªã³ã°ã®ã³ã¹ãã远跡ã§ããŸãã ãµãŒãã¹ - Redshiftã䜿çšã¿ã€ã - CS (USW2-CS:dc2.large ãªã©) ãéžæããå¿ èŠããããŸããäŸ¡æ Œã«ã€ããŠè©³ããã¯ãã·ã¢èªã§ã芧ããã ããŸã
ããã«ã
åºæïŒ habr.com