Amazon Redshift ã¯é«éã§å®å šãããŒãžãåããã¿ãã€ãèŠæš¡ã®ããŒã¿ãŠã§ã¢ããŠã¹ã§ããæ¢åã®ããžãã¹ã€ã³ããªãžã§ã³ã¹ããŒã«ã䜿çšããŠããã¹ãŠã®ããŒã¿ãã·ã³ãã«ãã€ã³ã¹ã广ã®é«ãæ¹æ³ã§åæã§ããŸãã1 æéãããããã 0.25 USD ã§ãã³ãããã¡ã³ããªãã®å°èŠæš¡ããå§ããŠã幎é 1 ãã©ãã€ãããã 1,000 USD ã«ã¹ã±ãŒã«ã§ããŸããè²»çšã¯åŸæ¥ã®ãœãªã¥ãŒã·ã§ã³ã® 10 åã® 1 ã§ããéåžžã3 åã®å§çž®ã«ãã£ãŠãéå§çž®ã®ãã©ãã€ãããã幎é 333 USD ãŸã§ã³ã¹ããåæžã§ããŸãã
é«é
Amazon Redshift ã§ã¯ãã¯ãšãªããã©ãŒãã³ã¹ãé«éåããããã«åæåã¹ãã¬ãŒãžæè¡ãæ¡çšãããŠãããè€æ°ã®ããŒãã«ãŸãããã¯ãšãªã® I/O å¹çãšäžŠå床ãåäžããŠããŸãã ããŒã¿ããŒãã®é床ã¯ã¯ã©ã¹ã¿ãŒã®ãµã€ãºã«å¿ããŠæ¡å€§ããAmazon S3ãAmazon DynamoDBãAmazon Elastic MapReduceãAmazon Kinesis ããä»»æã® SSH 察å¿ãã¹ããšã®çµ±åãå¯èœã§ãã
äœã³ã¹ã
äœ¿çšæéã¯åŸé課éå¶ã§ãããŠãŒã¶ãŒæ°ãåæã®å®è¡åæ°ã«ãå¶éã¯ãããŸããã幎é 1 ãã©ãã€ããããããã 1,000 USDããŠã§ã¢ããŠã¹ãœãªã¥ãŒã·ã§ã³ã®ã³ã¹ããåŸæ¥ã® 1/10 ã«æããããšãã§ããŸãã
ã·ã³ãã«
Amazon Redshift ãªããããŒã¿ãŠã§ã¢ããŠã¹ã®ç®¡çãã¢ãã¿ãªã³ã°ãã¹ã±ãŒãªã³ã°ãªã©ãäžè¬çãªç®¡çäœæ¥ã®å€§åãç°¡åã«èªååã§ããŸããããããå€å€§ãªæéãšåŽåãèŠããäœæ¥ãèªååããããšã§ãã客æ§ã¯ããŒã¿ã®è§£æãšããžãã¹ã«å°å¿µã§ããŸãã
䌞瞮èªåšæ§
ããã©ãŒãã³ã¹ã容éã®ããŒãºã®å€åã«åãããŠãã³ã³ãœãŒã«ã§æ°åã¯ãªãã¯ãããç°¡å㪠API ã³ãŒã«ãè¡ãã ãã§ãã¯ã©ã¹ã¿ãŒã®ãµã€ãºãç°¡åã«å€æŽã§ããŸãã
å®å
š
ã»ãã¥ãªãã£ã¯åãããçµã¿èŸŒãŸããŠããŸããä¿ç®¡äžãç§»åäžã®ããŒã¿ããããŒããŠã§ã¢ã¢ã¯ã»ã©ã¬ãŒã·ã§ã³å¯Ÿå¿ã® AES-256 ããã³ SSL ã䜿çšããŠæå·åã§ããŸããAmazon VPC ã䜿çšããŠã¯ã©ã¹ã¿ãŒãéé¢ããããšããããŒã®ç®¡çã« AWS Key Management Service (KMS) ããã³ããŒããŠã§ã¢ã»ãã¥ãªãã£ã¢ãžã¥ãŒã« (HSM) ã䜿çšããããšãã§ããŸãã
äºææ§
Amazon Redshift ã¯æšæº SQL ã«å¯Ÿå¿ããã³ã³ãœãŒã«ããããŠã³ããŒãå¯èœãªã«ã¹ã¿ã ã® JDBC ãã©ã€ãã ODBC ãã©ã€ããçšæãããŠããã®ã§ãå¹
åºã䜿ãæ
£ãã SQL ã¯ã©ã€ã¢ã³ãã䜿çšã§ããŸãããŸããæšæºç㪠PostgreSQL JDBC ã ODBC ãã©ã€ãã䜿çšããããšãå¯èœã§ãã
ããŒã¿ãŠã§ã¢ããŠã¹ãžã®æé©å
Amazon Redshift ã«ã¯ããŸããŸãªé©æ°çæè¡ã䜿çšãããŠãããããŒã¿ã»ããã®ãµã€ãºã 100 ã®ã¬ãã€ãçšåºŠã 1 ãã¿ãã€ããè¶
ãããã«ããããããããããŠé«ãã¯ãšãªããã©ãŒãã³ã¹ãå®çŸããŠããŸããåæåã¹ãã¬ãŒãžãããŒã¿å§çž®ããŸãŒã³ã®ãããã³ã°ã䜿çšãããŠãããããã¯ãšãªå®è¡ã«å¿
èŠãª I/O ã®éãåæžãããŸããAmazon Redshift ã«ã¯è¶
䞊ååŠçïŒMPPïŒã¢ãŒããã¯ãã£ãŒãæ¡çšãããŠãããSQL æäœã®äžŠååãšåæ£åã«ãã£ãŠããã¹ãŠã®ãªãœãŒã¹ããã«ã«æŽ»çšãããŸããããŒããŠã§ã¢ã¯ããŒã¿åŠçã®ããã©ãŒãã³ã¹ãé«ããèšèšãšãªã£ãŠãããããŒã«ã«æ¥ç¶ã¹ãã¬ãŒãžã䜿çšã㊠CPU ãšãã©ã€ãã®éã®ã¹ã«ãŒããããæå€§åãããšãšãã«ã10 ã®ã¬ãããã€ãŒãµã¡ãã·ã¥ãããã¯ãŒã¯ã䜿çšããŠããŒãéã®ã¹ã«ãŒããããæå€§åããŸãã
ãã¿ãã€ãèŠæš¡
ã³ã³ãœãŒã«ã§æ°åã¯ãªãã¯ããããã·ã³ãã«ãª API ã³ãŒã«ãè¡ãã ãã§ãããŒã¿ãŠã§ã¢ããŠã¹ã®ããŒãã®æ°ãçš®é¡ãç°¡åã«å€æŽããŠã1 ãã¿ãã€ã以äžã®å§çž®ãŠãŒã¶ãŒããŒã¿ã«å¯Ÿå¿ããããã¹ã±ãŒã«ã¢ããã§ããŸããDense StorageïŒDSïŒããŒãã§ã¯ãããŒããã£ã¹ã¯ãã©ã€ãïŒHDDïŒã䜿çšãããŠãããããããŠå€§èŠæš¡ãªããŒã¿ãŠã§ã¢ããŠã¹ãäœã³ã¹ãã§äœæã§ããŸããDense ComputeïŒDCïŒããŒãã§ã¯ãããããŠé«ããã©ãŒãã³ã¹ã®ããŒã¿ãŠã§ã¢ããŠã¹ãäœæã§ããããã«ãé«é CPUã倧容é RAMãããã³ SSDïŒSolid-State DiskïŒã䜿çšãããŸããAmazon Redshift ã§ã¯ããµã€ãºã倿Žããéããæ°ããã¯ã©ã¹ã¿ãŒãå®å
šã«ããããžã§ãã³ã°ãããŠäœ¿çšã§ããããã«ãªããŸã§ãèªã¿åãå°çšã¢ãŒãã§ããŒã¿ãŠã§ã¢ããŠã¹ã«å¯Ÿãã¯ãšãªãå®è¡ãç¶ããããšãã§ããŸãã
åæãæéãªã
ããããžã§ãã³ã°ãããªãœãŒã¹åã«å¯ŸããŠã®ã¿ãæ¯æãããã ããŸããåæããé·æå¥çŽããªããªã³ããã³ãæéããéåžžæéãããåŸãªãªã¶ãŒããã€ã³ã¹ã¿ã³ã¹æéãéžæã§ããŸãããªã³ããã³ãã®æäœæéã¯ã0.25 USD/æéïŒ160 GB DC1.Large ããŒã 1 ã€ãããïŒãŸã㯠0.85 USD/æéïŒ2 TB DS1.XLarge ããŒã 1 ã€ãããïŒã§ããäžéšåæããªã¶ãŒããã€ã³ã¹ã¿ã³ã¹ãå©çšãããšãå®è³ªçãªæé㯠DC1.Large ããŒã 1 ã€ããã 0.10 USD/æéïŒ5,500 USD/TB/幎ïŒãDS2.XLarge ããŒã 1 ã€ããã 0.228 USD/æéïŒ999 USD/TB/幎ïŒãŸã§äžãããŸãã詳现ã«ã€ããŠã¯ãAmazon Redshift æéããŒãžãã芧ãã ããã
èé害æ§
Amazon Redshift ã¯ããŒã¿ãŠã§ã¢ããŠã¹ã¯ã©ã¹ã¿ãŒã®ä¿¡é Œæ§ãåäžãããåçš®æ©èœãããã€ãåããŠããŸããããŒãã«æžã蟌ãŸããããŒã¿ã¯ãã¹ãŠã¯ã©ã¹ã¿ãŒå
ã®å¥ããŒããžèªåçã«è€è£œãããå
šããŒã¿ã¯åžžæ Amazon S3 ã«ããã¯ã¢ãããããŸããã¯ã©ã¹ã¿ãŒã®ç¶æ
ã¯åžžæã¢ãã¿ãªã³ã°ãããŠãããé害ããããã©ã€ãããèªåçã«ããŒã¿ãå床è€è£œããå¿
èŠã«å¿ããŠããŒãã®äº€æãè¡ãããŸãã
èªåããã¯ã¢ãã
Amazon Redshift ã«ãããæ°ããããŒã¿ã¯ Amazon S3 ã«èªåçãã€ç¶ç¶çã«ããã¯ã¢ãããããŸããã¹ãããã·ã§ããã¯ãŠãŒã¶ãŒã®æå®ã«åºã¥ã 1ïœ35 æ¥éä¿åãããŸãããã€ã§ããŠãŒã¶ãŒç¬èªã®ã¹ãããã·ã§ãããåãããšãã§ããŸãããã®ã¹ãããã·ã§ããã¯ãŠãŒã¶ãŒãæç€ºçã«åé€ãããŸã§ä¿åãããŸãããŸããçœå®³å¯Ÿççšã«ãã¹ãããã·ã§ãããå¥ãªãŒãžã§ã³ã® S3 ã«éåæã§ã¬ããªã±ãŒãããããšãã§ããŸããã¯ã©ã¹ã¿ãŒãåé€ãããšãã·ã¹ãã ã®ã¹ãããã·ã§ããã¯åé€ãããŸããããŠãŒã¶ãŒã®ã¹ãããã·ã§ããã¯ãŠãŒã¶ãŒãæç€ºçã«åé€ãããŸã§å©çšã§ããŸãã
çæéã§ã®åŸ©å
ã·ã¹ãã ã®ã¹ãããã·ã§ãããŸãã¯ãŠãŒã¶ãŒã®ã¹ãããã·ã§ããã䜿çšããAWS ãããžã¡ã³ãã³ã³ãœãŒã«ãŸã㯠Amazon Redshift API ããã¯ã©ã¹ã¿ãŒã埩å
ã§ããŸããã·ã¹ãã ã®ã¡ã¿ããŒã¿ã埩å
ããããšããã«ã¯ã©ã¹ã¿ãŒãå©çšã§ããããã«ãªããããŒã¿ãããã¯ã°ã©ãŠã³ãã§ã¹ããŒã«ãããŠããéã«ã¯ãšãªã®å®è¡ãéå§ã§ããŸãã
æå·å
Amazon Redshift ã®ããã€ãã®ãã©ã¡ãŒã¿ãèšå®ããã ãã§ãç§»åäžã®ããŒã¿ã®ä¿è·ã«ã¯ SSLãä¿ç®¡äžã®ããŒã¿ã®ä¿è·ã«ã¯ããŒããŠã§ã¢ã¢ã¯ã»ã©ã¬ãŒã·ã§ã³å¯Ÿå¿ã® AES-256 æå·åã䜿çšãããããã«ãªããŸããä¿ç®¡äžã®ããŒã¿ã®æå·åãæå¹ã«ããå Žåã¯ããã£ã¹ã¯ã«æžã蟌ãŸãããã¹ãŠã®ããŒã¿ã«å ããŠãããã¯ã¢ãããæå·åãããŸããããã©ã«ãã§ã¯ãããŒã®ç®¡ç㯠Amazon Redshift ã«ãã£ãŠè¡ãããŸãããã客æ§ãææããããŒããŠã§ã¢ã»ãã¥ãªãã£ã¢ãžã¥ãŒã« (HSM)ãAWS CloudHSMããŸã㯠AWS Key Management Service ã䜿çšããŠããŒã管çããããšãã§ããŸãã
ãããã¯ãŒã¯ã®éé¢
Amazon Redshift ã¯ãŠãŒã¶ãŒãèšå®ãããã¡ã€ã¢ãŠã©ãŒã«ã®ã«ãŒã«ã䜿çšããŠãããŒã¿ãŠã§ã¢ããŠã¹ã¯ã©ã¹ã¿ãŒãžã®ãããã¯ãŒã¯ã¢ã¯ã»ã¹ãå¶åŸ¡ããŸããAmazon Redshift ã Amazon VPC ã®äžã§å®è¡ããããšãã§ãããã®ããã«ãããšããŒã¿ãŠã§ã¢ããŠã¹ã¯ã©ã¹ã¿ãŒã¯ã客æ§å°çšã®ä»®æ³ãããã¯ãŒã¯å
ã«éé¢ãããŸãããã®ã¯ã©ã¹ã¿ãŒãã客æ§ã®æ¢åã® IT ã€ã³ãã©ã¹ãã©ã¯ãã£ã«æ¥ç¶ããã«ã¯ãæ¥çæšæºã®æå·å IPsec VPN ã䜿çšããŸãã
ç£æ»ãšã³ã³ãã©ã€ã¢ã³ã¹
Amazon Redshift 㯠AWS CloudTrail ãšçµ±åãããŠãããããRedshift ã® API åŒã³åºãããã¹ãŠç£æ»ã§ããããã«ãªããŸãããŸããAmazon Redshift ã§ã® SQL æäœïŒããšãã°ãããŒã¿ããŒã¹ã«å¯Ÿããæ¥ç¶è©Šè¡ãã¯ãšãªã倿ŽïŒã¯ãã¹ãŠãã°ã«èšé²ãããŸãããã®ãã°ã«ã¢ã¯ã»ã¹ããã«ã¯ãã·ã¹ãã ããŒãã«ã«å¯Ÿãã SQL ã¯ãšãªã䜿çšããããAmazon S3 äžã®å®å
šãªå Žæã«ãã°ãããŠã³ããŒãããŸããAmazon Redshift ã¯ãSOC1ãSOC2ãSOC3ãããã³ PCI DSS Level 1 ã®èŠä»¶ã«æºæ ããŠããŸãã詳现ã«ã€ããŠã¯ãAWS ã¯ã©ãŠãã³ã³ãã©ã€ã¢ã³ã¹ãã芧ãã ããã
Amazon Redshift ã®ããŸããŸãªæ¥çãäŒæ¥èŠæš¡ã«ãããã客æ§ã®å°å ¥äºäŸã«ã€ããŠã¯ãcustomer success ããŒãžãã芧ãã ããã
ãã¥ãŒãžãã¯ãããªã®ã¹ããªãŒãã³ã°ãµãŒãã¹ãæäŸãã Vevo ã¯ã2009 幎ã«äºæ¥ãéå§ããã«ããããããããã 1 幎ã¯ãŸãã§å šãæ°ããæ°èäŒæ¥ã®ããã«åãçµãã§ããŸãã
Vevo ã¯ãYouTube ã®ãããªãã©ãããã©ãŒã ã«å®å
šã«äŸåããç¶æ
ããè±åŽãããšããç®æšãæ²ããŠãä»å¹Žã®æ©ãææããéå¿çãªååºçºãæãããŸãããã€ãŸããVevo ç¬èªã®è£œåã§ãã¥ãŒãžãã¯ãããªãèŠèŽããå©çšè
ãå¢ããããã«ãèªç€Ÿã®ã¢ããªãšãã¹ã¯ããããšã¯ã¹ããªãšã³ã¹ã 1 幎ãããŠç·ç¹æ€ããããŒãœãã©ã€ãºããããã¡ã€ã«ãªã©ã®æ°ããªæ©èœã远å ããŸããã
å€ããããããŒã±ãã£ã³ã°ææ³ãšããŠèª€è§£ãæããããªããã©ãŒãã³ã¹ãã³ãããŒã¯ãçºè¡šãããŠããŸããã(Oracle ã®ãããª) ä¿å®çãªäŒæ¥ããã®ææ³ã䜿ãããšã¯çããã¯ãããŸããããGoogle ãŸã§ããã®ãããªææ®µãåããšã¯ããããé©ãã§ãããã®ãããGoogle ã 2016 幎 9 æ 29 æ¥ã«ãµã³ãã©ã³ã·ã¹ã³ã®èªç€Ÿã€ãã³ãã§ BigQuery ãš Amazon Redshift ãæ¯èŒãããã³ãããŒã¯çµæãçºè¡šãããšããç§ãã¡ã¯èå³ãæã£ãŠãã£ãšè©³ãã調ã¹ãããšã«ããŸããã
ãã®èšäºã§ã¯ãPeriscope ã Amazon RedshiftãSnowflakeãGoogle BigQuery ã®ãã³ãããŒã¯ãæ¯èŒããçµæã玹ä»ããŠããŸãã
Amazon Redshift ã«é¢é£ããããã°èšäºãã¹ãŠã®ãªã¹ãã«ã€ããŠã¯ãblog posts ããŒãžãã芧ãã ããã
Amazon Redshift ã®æ°æ©èœãã¹ãŠã®è©³çްã«ã€ããŠã¯ãwhat's new ããŒãžãã芧ãã ããã
Amazon Redshift ãç¡æã§ã詊ããã ããã DC1.Large ã 1 ãæããã 750 æéã2 ãæéç¡æã§ãå©çšããã ããŸããAWS ã¢ã«ãŠã³ããäœæã㊠Amazon Redshift ã³ã³ãœãŒã«ã«ãµã€ã³ã€ã³ããã°ãç¡æãã©ã€ã¢ã«ãå§ããããšãã§ããŸããAmazon Redshift ã¯ã©ã¹ã¿ãŒãèµ·åããããŒãã¿ã€ãã«åãã㊠DC1.Large ãéžæããŠãã ããã

