ã§ã¯ã人ã
ã¯ã©ããã£ãŠæµ·å€ã®ã«ã³ãã¡ã¬ã³ã¹ã«åå ããã®ã§ããããïŒ å®éããã®ããã»ã¹ã¯ããã»ã©è€éã§ã¯ãããŸãããããã°ã©ã å§å¡äŒã«é£çµ¡ããã¬ããŒãã®ããŒãã宣èšãããã§ã«æè¡ã€ãã³ãã§è¬æŒããçµéšããããšãã蚌æ ãæ·»ä»ããå¿
èŠããããŸãã åœç¶ã®ããšãªãããäŒè°ã®å°çãèæ
®ãããšãèªåŠåã¯éèŠãªãã€ã³ããšãªããŸãã è±èªã話ãèŽè¡ã®åã§è©±ãçµéšã¯éåžžã«æãŸããã§ãã ããããã¹ãŠã®åé¡ã¯ããã°ã©ã å§å¡äŒã§è°è«ãããããªãã®å¯èœæ§ãè©äŸ¡ãããã©ã¡ããäžæ¹ã«ãªããŸãã
ãã¡ãããæ³çãªåé¡ã¯ç¬èªã«è§£æ±ºããå¿ èŠããããŸãã ããªãèªèº«ãç解ããŠããçç±ã«ããããã·ã¢ã§ãã¶æžé¡ãååŸããããšã¯ããå°é£ã§ãã ããšãã°ãã¢ã¹ã¯ã¯ã§ã¯ããã®èšäºã®å·çæç¹ã§èšªåãã¶ã®åŸ æ©æé㯠300 æ¥ã§ãã éŠéœã®äœæ°ã¯äžè¬ã«ãè¿é£ã®å·ã§æžé¡ãåŠçããããšã§ããããå°é£ãåé¿ããããšã«æ £ããŠããã ããããç§ãã¡ã¯ã€ã«ã¯ãŒãã¯ã«æ ç¹ã眮ããŠããã®ã§ãæãè¿ãé£åœã¯ã¢ã³ãŽã«ã§ã...ãããŠãã ããã ãŠã©ã³ããŒãã«ïŒ äœããã¢ã¡ãªã«å€§äœ¿é€šããããã§ãããã ãããŠãæ£çŽã«èšããšãç¹ã«äººæ°ãããããã§ã¯ãªãã®ã§ãããã»ã©æ··éããŠããŸããã ã€ã«ã¯ãŒãã¯ãããŠã©ã³ããŒãã«ãŸã§ã¯é£è¡æ©ã§XNUMXæéããããŸãã ã¿ã€ã ãŸãŒã³ã¯å€æŽãããŸãããå¿«é©ã§æ £ããããŒã¹ã§äœæ¥ãç¶ããããšãã§ããŸãã 倧䜿通ã«å ¥ã£ãŠãããã¶ãåãåããŸã§æåéãXNUMXåããããŸãã å¯äžã®åé¡ã¯ãããŒã³éè¡ã®æ¯åºã§ã¯é äºææ°æããã¥ã°ã«ã¯ã§çŸéã§ããæ¯æããªãããšã§ãã ãããã£ãŠãæ¢è£œã®ãã¶ãååŸããããã«ããã«æ¥ããå Žåã¯ããã®åé¡ã®è§£æ±ºãæäŒã£ãŠãããç¥ãåãããããšè¯ãã§ãããã
ããã§ã ãã¶ã¯åçãããé£è¡æ©ã®åº§åžã確ä¿ãããŸããã ç±³åœãžã®å ¥åœèªäœãè¿ã¥ããŠããŸãã åœå¢ãè¶ãããšããããšã¯ããã€ãéåžžã«é¢åãªäœæ¥ã ã£ãã 2010幎ã«åããŠå°çãããšããã¯ã·ã³ãã³ã®åºåœå¯©æ»ã«ã©ãã ãæéãããããã«è¡æãåããŸããã ãããããã¡ããã誰ããæ§ããçªå£ãžã®è¡åã¯æããå®çªã§ãã ãããããã°ããåããïŒæ£ç¢ºã«ã¯æ°å¹ŽåããïŒãããªãã®æ å ±ãã¹ãã£ã³ããŠåçãæžãããçŽãæž¡ãç¹å¥ãªãã·ã³ãè¿œå ããããã¹ãŠãé«éã«ãªããŸããã æè¿ã®æ è¡ã§ã¯ãã¹ãŠã宿æ³æœèšã®è©³çŽ°ãªã©ããã¹ãŠãã±ããã«æžã蟌ãã åŸåŸ©èªç©ºåžãæã£ãŠå°çããŸããã ãããä»åã¯ãæ¥ä»ãå€æŽããããã±ãããæã£ãŠå°çããŸããããããã«é¢é£ä»ããããåž°ãã®ãã±ããã¯ãããŸããã§ããã ãªããšãçœãçŽã®äžã®åçã«åãæ¶ãç·ãåŒãããŠããŸããã
圹å¡ã®ã¢ãããŒã
åã¯çªç¶ãæ°å¹Žåãšåããããé·ããªãã1æéåŸã«ãããããã¹ããŒãã³ã³ãããŒã«ã«å°çãããšããç§ã¯å®å šã«ãªã©ãã¯ã¹ããŠå°çããŸããã èŠå®ã¯ç§ããªãæ¥ãã®ããšå°ããŸããã ç§ã¯ãããžãã¹ïŒå¶æ¥ããã¶ã¿ã€ãb2/bXNUMXã§èš±å¯ãããŠããŸãïŒãšäŒæ¯ïŒäŒæïŒãšçããŸããããããšã圌ã¯ç§ãã©ã®ãã©ã€ãã§å°çããããæããã«ããç§ãé£è¡æ©ã«ä¹ã人ã®ããŒã¿ããŒã¹ã«èŒã£ãŠããªãããšã説æããŸããã ç§ã¯æ¬åœã«å¯ããã£ãã®ã§ããããªããããªãã®ãããããŸããâŠããããåºçºæ¥ãå€æŽããããã ãšçããŸããã ã¢ã¡ãªã«ã®åœ¹äººã¯ãç§ããªããã©ã€ãã®æ¥çšãå€æŽããã®ãããã€åž°åœããã®ãã«èå³ãæã¡ãŸããã ããã«å¯ŸããŠç§ã¯ãå¥ã®æéã«é£ã¶ããšã«ããã®ã§å€æŽãããšçããŸããããŸãé£è¡æ©ã«æ»ããšãã¯ãããããã®çãããã§ããŸããã ãããšèŠå®ã¯ãåãã£ãããšèšã£ãŠæãæããŠå¥ã®ç·ãåŒã³ããã®ç·ã«ãã¹ããŒããæž¡ããã 圌ã¯ç§ãè¿œå æ€æ»ã«é£ããŠè¡ã£ãã ç§ãXNUMXæéåŸã®ãã©ã€ããããããšã念ãæŒãããšããã圌ã¯å·éã«ãå¿é ããªãã§ãã ãããééããªãä¹ãé ããŸããæ°æéããããŸãããã±ãããä¹ãæããããã®çŽãæž¡ããŸãããããšçããŸããã
ãããããããŸããã ç§ãéšå±ã«å ¥ããšãããã«ã¯ä»ã«çŽ40人ã座ã£ãŠããŠãç§ãå«ããŠç§ãã¡ã®ãã©ã€ãããã®3人ãããŸããã ç§ã座ã£ãŠæºåž¯é»è©±ãèŠããŠãããšãããã«èŠåå¡ãé§ãå¯ã£ãŠããŠãé»æºãåãããã«èšãããå£ãæå·®ããŸãããåšå²ã«ã¯ãé»è©±äœ¿çšçŠæ¢ãã®æšèããã£ãããšãåãããŸãããç²ããšå¯äžè¶³ã§æ°ä»ããªãã£ãã ç§ã¯é»æºãåããŸããããé£äººã«ã¯æéããããŸããã§ãããæéããªã人ã¯ãæºåž¯é»è©±ãåãäžããããã ãã§ãã çŽXNUMXæéãçµéããææ誰ããè¿œå ã®æ¯æŽãæ±ããããŸããã é¢æ¥ã§ã¯ãçµå±ãã©ãã«ãé»è©±ãããããå ¥åœèš±å¯ã®ã¹ã¿ã³ããæŒããããã¹ããŒããæž¡ãããã ãã§ããã ãããäœã ã£ãïŒ (c) 確ãã«ãæ¬ èªãããã©ã€ãã®èªç©ºåžã¯ãæçµçã«ã¯åãåã£ã蚌ææžã«åºã¥ããŠå®éã«å€æŽãããŸããã
ãããµã¹å·ãªãŒã¹ãã£ã³åž
ãããŠä»ãã€ãã«ãããµã¹ã®åãç§ã®è¶³å ã«ãã£ãŠããŸããã ãããµã¹ã¯ãã·ã¢äººã«ãšã£ãŠãªãã¿ã®ããå°åã§ã¯ããããäŸç¶ãšããŠåèãæã蚪ããå Žæã§ã¯ãªãã ç§ã¯ãããŸã§ä»äºã§ã«ãªãã©ã«ãã¢ãšãã¥ãŒãšãŒã¯ã«è¡ã£ãããšããããŸããããããŸã§åã«è¡ãå¿ èŠã¯ãããŸããã§ããã Percona Live ããªãã£ããããã€ããããªããã°ãªããªãã£ãã®ãã¯ãŸã ããããŸããã
ãªãŒã¹ãã£ã³åžã¯ããããµã¹å·å
ã®ãã«ãªãã©ã«ãã¢ã®é£ã³å°ãã®ãããªãã®ã§ãã ã©ãããŠãããªã£ãïŒ ãã¬ãŒã®æ¥éãªæé·ã®æåã®åºç€ã¯ããã¡ããæ¿åºã®æè³ã«å ããŠãç©ãããªæ°åãšç掻費ãšããžãã¹ã®äœã³ã¹ãã§ããã ãããçŸåšããµã³ãã©ã³ã·ã¹ã³ãšãã®åšèŸºå°åã¯æåéãæ³å€ãªã³ã¹ãã®è±¡åŸŽãšãªã£ãŠãããæ°èäŒæ¥ã¯æ°ããªæ ç¹ãæ¢ããŠããã ãããŠãããµã¹ãè¯ãéžæè¢ã§ããããšãå€æããã ãŸãæåŸçšãŒãã 第äºã«ãå人äºæ¥äž»ã®ç²å©ã«å¯ŸããçšéããŒãã«ããããšã 倧åŠã®æ°ãå€ããšããããšã¯ãæèœãªåŽååãæ±ããåžå ŽãçºéããŠããããšãæå³ããŸãã ç掻費ã¯ã¢ã¡ãªã«ã®åºæºãããããšããã»ã©é«ããããŸããã ããããã¹ãŠã¯äžè¬ã«ãæ°ãããã¯ãããžãŒäŒæ¥ã®éçºã«è¯ãçæãæäŸããŸãã ãã㊠- é¢é£ããã€ãã³ãã®èŽè¡ãäœæããŸãã
Percona Live èªäœã¯ãã€ã¢ãã ãªãŒãžã§ã³ã·ãŒ ããã«ã§éå¬ãããŸããã çŸåšæ®åããŠããã¹ããŒã ã«ããã°ããã®ã«ã³ãã¡ã¬ã³ã¹ã¯ãMySQL ã«é¢ãã XNUMX ã€ãMongo ãš PostgreSQL ã«é¢ãã XNUMX ã€ãã€ãããã³ AIãã»ãã¥ãªãã£ãããžãã¹ã«é¢ããã»ã¯ã·ã§ã³ãšãããããã€ãã®äžŠè¡ããããŒãå¥ã¹ããªãŒã ã§æ§æãããŠããŸããã æ®å¿µãªãããèªèº«ã®å
¬æŒã«åããå€å¿ãªæºåã¹ã±ãžã¥ãŒã«ã®ãããããã°ã©ã å
šäœãååã«è©äŸ¡ããããšã¯ã§ããŸããã§ããã ããããç§ãèŠãæ©äŒããã£ãã¬ããŒãã¯éââåžžã«é¢çœãã£ãã§ãã ç¹ã«ããŒã¿ãŒã»ã¶ã€ãã§ãèããªãŒãã³ãœãŒã¹ã»ããŒã¿ããŒã¹ã®å€åãã颚æ¯ããšãToo Much Data?ãã«æ³šç®ããããšæããŸãã ã€ãŽã»ãã«ããŒèã ç§ãã¡ã¯ããã§ã¢ã¬ã¯ã»ã€ã»ãããŽã£ããã«äŒããŸããã圌ãå ±åãããã¯ãªãã¯ããŠã¹ã®ããŒã å
šå¡ãé£ããŠããŸãããããã«ã€ããŠã¯ç§ã®ã¹ããŒãã§ã觊ããŸããã
å ±åãããŠãã ãã
ãããŠå®éãèå¿ãªããšã«ã€ããŠã§ãããç§ã¯äœã«ã€ããŠè©±ããŠããŸããã? ãã®ã¬ããŒãã§ã¯ãç§ãã¡ãæ°ããããŒãžã§ã³çšã«æç³»åããŒã¿ããŒã¹ç£èŠã·ã¹ãã ãã©ã®ããã«éžæãããã«ã€ããŠèª¬æããŸããã ã©ãããããããç§ãã¡ã®ãã¬ã¹ããã§ã¯ããã®çš®ã®ããŒã«ã®å¿
èŠæ§ãçããå Žåãããã©ã«ãã§ã¯ãªãã¯ããŠã¹ã䜿çšããã®ãç¿æ
£ã«ãªã£ãŠããŸãã ãªãïŒ ã圌ã®æ¹ãéããããã æ¬åœã«éãã®ã§ããããïŒ ãããïŒ äœãä»ã®ããšãè©ŠããŠã¿ãªããšèããããªããä»ã«ãé·æãšçæã¯ãããŸãã? ç§ãã¡ã¯ãã®åé¡ãç 究ããããã«åŸ¹åºçãªã¢ãããŒãããšãããšã«ããŸããã ããããåã«ç¹åŸŽãåæããã ãã§ã¯éå±ã§ãããççŽã«èšã£ãŠããŸãèšæ¶ã«æ®ããŸããã ãããŠäººã
ã«ãçŽ æŽããã人ãæããããã«
ã€ãã³ãã§ã©ã®ãããªå°è±¡ãåããŸãããïŒ
ãã¹ãŠãå®ç§ã«æŽçãããŠãããã¬ããŒãã¯èå³æ·±ããã®ã§ããã ããããæãç®ç«ã£ãã®ã¯ãDBMS ãæè¡çã«çŸåšã©ãã«åãã£ãŠããã®ããšããããšã§ããã ããšãã°ãå€ãã®äººã¯é·ãéã»ã«ããã¹ãåãœãªã¥ãŒã·ã§ã³ã䜿çšããŠããŸããã ç§ãã¡ã¯ããã«ãŸã ããŸãæ £ããŠããªããããDBMS ãæåã§ã€ã³ã¹ããŒã«ãæ§æããµããŒãããéã«ç°åžžãªããšã¯äœããããŸããã ãããŠãããã§ã¯ã¯ã©ãŠããé·ãéãã¹ãŠã®äººã奎é·ã«ããŠãããæ¡ä»¶ä»ã RDS ãããã©ã«ãã®ãªãã·ã§ã³ã§ãã ãã¹ãŠãäºåã«èæ ®ãããŠããæ¢è£œã®ãµãŒãã¹ãå©çšã§ããã®ã§ããã°ãããã©ãŒãã³ã¹ãã»ãã¥ãªãã£ãããã¯ã¢ããã«ã€ããŠå¿é ãããããã®ããã«å¥ã®æè¡å°é家ãéã£ããããå¿ èŠã¯ãããŸããã
ããã¯éåžžã«èå³æ·±ããã®ã§ãããããããããã®ãããªåœ¢åŒã§ãœãªã¥ãŒã·ã§ã³ãæäŸããæºåããŸã æŽã£ãŠããªã人ã«ãšã£ãŠã¯èŠéãšãªãã§ãããã
ãããŠäžè¬ã«ããã㯠DBMS ã ãã§ãªãããµãŒã㌠ã€ã³ãã©ã¹ãã©ã¯ãã£å šäœã«ãåœãŠã¯ãŸããŸãã 管ç㯠Linux ã³ã³ãœãŒã«ãã Web ã³ã³ãœãŒã«ã«ç§»è¡ããŠãããé©åãªãµãŒãã¹ãéžæããŠçžäºã«é£æºããç¹å®ã®ã¯ã©ãŠã ãããã€ããŒã EKSãECSãGKEããã®ä»ã®å€§æåã§ã©ã®ããã«åäœããããç解ã§ããå¿ èŠããããŸãã ããåœã§ã¯ãå人ããŒã¿ã«é¢ããæ³åŸã«é¢é£ããŠããã¹ãã£ã³ã°åžå Žã«ãããåœå ãã¬ãŒã€ãŒã¯é 調ã«çºå±ããŠããŸãããããããŸã§ã®ãšãããäžççãªæè¡ååã®æå 端ããã¯ããããé ãããšã£ãŠããããã®ãããªãã©ãã€ã ã®å€åããŸã çµéšããŠããŸãããç§ãã¡èªèº«ã
ã¬ããŒãã®è©³çŽ°ãªåæã¯ééããªãå
¬éããŸãããå°ãåŸã«ãªããŸããçŸåšæºåäžã§ããè±èªãããã·ã¢èªã«ç¿»èš³ããŠããŸã:)
åºæïŒ habr.com