ç§ãã¡ã¯ãäŒç€Ÿèšç«ã®æŽå²ãéèŠãªäŸ¡å€ãçŸä»£ã®æè¡åžå Žã§åãããšã®é£ãããäŒç€Ÿã®éçºæŠç¥ã«ã€ããŠããŒã¿ãŒãšè©±ããããŒã³ãã®åŸæ¥å¡ã®éžæã®ããã€ãã®ç¹åŸŽã«ã€ããŠè©±ããŸãã-ããŒã¿ãŒãå人çã«ç£ç£ããããã»ã¹ã§ãã
PG Day'17 Russiaã§ãPetrã¯åã㊠ããã·ã¢èªåã®èŠèŽè åãã«InnoDBã®ã¢ãŒããã¯ãã£ãšããã©ãŒãã³ã¹ã®æé©åã«é¢ããèè ã®ã³ãŒã¹ãæäŸããããã¥ã¡ã³ãæåããŒã¿ããŒã¹ãšããŠMySQL 5.7ã䜿çšããããã®å©çšå¯èœãªããŒã«ã確èªããŸã ã
![](https://habrastorage.org/web/1a7/ddd/054/1a7ddd054726461d9f5b4a22df0e2955.jpg)
PG DayïŒããŒã¿ãŒãããªãèªèº«ãããªãã誰ã§ãäœãããŠããã®ãæããŠãã ããã
PeterïŒ Peter Zaitsevã¯Perconaã®åµèšè å ŒCEOã§ã ã äŒç€Ÿã¯10幎以äžåã«èšç«ãããŸããã MySQLããã³MongoDBã®åéã§ãœãªã¥ãŒã·ã§ã³ãæäŸããŠããŸãã ç§ãã¡ã®äž»ãªããžãã¹ã¯ããµããŒãããªã¢ãŒã管çïŒãªã¢ãŒãDBAïŒãããã³ç®¡çïŒãããŒãžããµãŒãã¹ïŒã§ãããã³ã³ãµã«ãã£ã³ã°ãšãã¬ãŒãã³ã°ãè¡ã£ãŠããŸãã
PG DayïŒã©ã®ããã«ããŠMySQLãäžå¿ã«ããžãã¹ãæ§ç¯ãå§ããŸãããïŒ ãªããã®DBMSãéžæããã®ã§ããïŒ
ããŒã¿ãŒïŒå®éãç§ã¯åº§ã£ãŠäœãããã¹ããèãå§ããŸããã Perconaãèšç«ããåã¯ãMySQL ABã§åããŠããã®ã§ããã¯ãããžãŒãç¥ã£ãŠããã®ã§ããã®æ¥çã®äººã ãšåºäŒããã€ãªãããæã¡ãŸããã ãããã£ãŠãæ©äŒãçŸããèªåã§äœããããããšããé¡æããã£ããšããéžæã¯éåžžã«æ確ã§æçœã§ããã ããžãã¹ã§ã¯ãããªããããæ¹æ³ãç¥ã£ãŠããããšãããªããæœåšçãªæåãšããŠèŠãŠããããšãããå¿ èŠããããŸãã Perconaã®èšç«æã«ã¯ãåŸæ¥å¡ã100人ãè¶ ããäŒç€Ÿã«ãªããšãã壮倧ãªèãã¯ãããŸããã§ããã ç§ã¯æ°å¹Žéã³ã³ãµã«ãã£ã³ã°ãè¡ãããã®åŸäœãä»ã®ããšãããã ãããšæããŸããã ããããã¹ã¿ãŒãã¯éåžžã«æåãããã¹ãŠãè¡ãæ¥ããç§ãã¡ã¯é¢äžããŸããã
PG DayïŒãŸã MySQL ABã§åããŠãããšããæè¡çãªããã¯ã°ã©ãŠã³ãã¯ãããŸãããïŒã€ãŸããæè¡ç®¡çã«æ¥ãŸãããïŒ
ããŒã¿ãŒïŒã¯ããããã§ãã MySQLã§ã¯ãçŽç²ã«æè¡çãªåœ¹å²ã§åããŸããã æšå¹Žç§ã¯ãšã³ããªãŒã¬ãã«ã®ãããŒãžã£ãŒã§ããã ããããåºæ¬çã«ã¯æè¡çãªæ¹åæ§ã§ããã
PG DayïŒã³ã³ãµã«ãã£ã³ã°ããžãã¹ãéãããšã«æ±ºããå Žåãã©ã®åºæºã§ãã¯ãããžãŒãã¹ã¿ãã¯ãéžæããŸããïŒ çŸåšã®çŸå®ã«é¢ãã決å®ã¯ã©ã®ããã«å€ãããŸããïŒ
ããŒã¿ãŒïŒããã€ãã®åºæºããããŸãã MySQLã§ã¯ã2ã€ã®çç±ã§éåžžã«å¹žéã ã£ããšæããŸãã 第äžã«ãPerkonaãèšç«ããããšããMySQLåžå Žã¯éåžžã«æ¥éã«æé·ã ãååãªå°é家ãããªãã£ãããããã®ãã¯ãããžãŒãå®è£ ããããšèããå€ãã®äŒæ¥ã¯å€é¡ã®è²»çšãæ¯æãæºåãã§ããŠããŸããã ãã®ãããªãµã€ã¯ã«ã¯ãä»ã®ãã¯ãããžãŒã§ãç¹°ãè¿ãããŸãã ããšãã°ãHadoopã æ°å¹ŽåãHadoopã®ççºçãªæé·ãèµ·ãã£ããšãããã®æè¡ãç解ãã人ã ã¯ã éèŠãäŸçµŠãæ°åè¶ ãããããéåžžã«è¯ãæ©äŒãåŸãŸããã ä»ããã¡ãããç§ã¯ãã®æ¹åãèŠãŸãã 第äºã«ã æåã®éèŠãªç¬éã®1ã€ã§ãã奜ããªããšãèªåã®éã®ããããšãããããšãéèŠã§ã ã ãéã®ããã ãã«å«ããªããšããããšãã©ãã§åããŠãæåããå¯èœæ§ã¯äœããªããŸãã
PG DayïŒãã¹ãŠã®ãœãããŠã§ã¢ã¯å®å šã«ç¡æã§ãã 売ãããããã©ã€ãšã¿ãªãªãœãããŠã§ã¢ãäœæããŸããã éãããœãªã¥ãŒã·ã§ã³ã販売ãããããªããžãã¹éçºã®ã¢ãã«ããªãæåŠããã®ã§ããïŒ
ããŒã¿ãŒïŒã¯ããŒãºããœãããŠã§ã¢ã®åžå ŽããŸãã¯äžéšã®æææ©èœãåããåºæ¬æ©èœïŒãªãŒãã³ã³ã¢ïŒã®ãªãŒãã³ãœãŒã¹ã³ãŒãã®åžå Žã¯ãPerconaãæ±ãå®å šã«ãªãŒãã³ãªãœãããŠã§ã¢ã®åžå Žãããã¯ããã«å€§ããã§ãã ãã ããå€ãã®ç«¶åäŒæ¥ããããŸãã ãã³ãã£ãŒãã£ãã¿ã«ãªã©ãå€ãã®ãªãœãŒã¹ããã®åžå Žã«æè³ãããäŒæ¥ã¯å€ãã®è³éã調éããŠããŸãã 圌ãã¯ç§ãã¡ãããŸãèå³ãæã£ãŠããªãå šãç°ãªãããžãã¹ã¢ãã«ãæã£ãŠããŸãã
ç§ãã¡ã¯ãã¯ãªãŒã³ã§ãªãŒãã³ãªãœãããŠã§ã¢ã®åžå Žã«çŠç¹ãåœãŠãŠããŸã ãããã«ãããä»ã®ãã³ããŒãšã¯å€§ããç°ãªããŸãã ããã¯MySQLåžå Žã§ç¹ã«éèŠã§ããMySQLåžå Žã§ã¯ããŸã£ããæ°ãããã¯ãããžãŒã䜿çšããããŒãããäœæããããšã¯ãããŸããã
å€ãã®å ŽåãPerkonaåžå Žã«ã€ããŠè©±ããŠãã人ã ã¯ãMongoDBãMySQLãMariaDBãªã©ãšæ¯èŒããŸãã å®éãããã¯å®å šã«æ£ããããã§ã¯ãããŸããããªããªããç§ãã¡ã®ä»äºã¯ãã©ãããã©ãŒã ããã¯ãããžãŒããŒãããäœæããã®ã§ã¯ãªãããã®åéã§æé«ã®ãªãŒãã³ãã©ãããã©ãŒã ã«ãµãŒãã¹ãæäŸããããã§ãã éãããããŒã·ã§ã³ãã§Percona Serverãäœæããå Žåããœãªã¥ãŒã·ã§ã³ãšOracleãœãªã¥ãŒã·ã§ã³ãªã©ã®éãã¯éåžžã«å°ãããªããŸãã åãOracleã§ãããããã·ã³ãã«ã§å®äŸ¡ã§ãã ããã¯è¯ãåæ©ä»ãã§ã¯ãããŸããã Oracleã®éåœããŠãŒã¶ãŒãã³ããŒãããã¯ã€ã³ãããç¬èªã®ãœãããŠã§ã¢ã§ããå ŽåãMySQLããªãŒãã³ã³ã¢ã§ãã£ãŠãããããåé¿ããããã«ãªãŒãã³ãœãŒã¹ãäœæããŠããŸãã éåžžã«æ確ã§ã·ã³ãã«ãªéãã
PG DayïŒäŒç€Ÿãèšç«ãããç¬éãããMySQLã®ãµããŒããšã³ã³ãµã«ãã£ã³ã°åžå Žã¯ã©ã®ããã«çºå±ããŸãããïŒ ç¢ºãã«ãPerconaã¯ããå€ãã®ç«¶åä»ç€Ÿãæã£ãŠããŸãã ããããšã©ãéãã®ã§ããïŒ ç«¶äºåãç¶æããåžå Žã§é«ãå°äœãå ããããšãã§ããã®ã¯äœã§ããïŒ
PeterïŒ MySQLãšèšãã°ãPerconaã¯ç°ãªã競åä»ç€Ÿã®ããããã€ãã®åžå Žã§äºæ¥ãå±éããŠããŸãã ãµããŒãã«ã€ããŠè©±ããšã競åä»ç€Ÿã§ããäŒæ¥ã¯OracleãšMongoDBã®ã¿ã§ãåé¡ã®ä¿®æ£ããœãããŠã§ã¢ã®ãã°ãªã©ã å®å šãªãµããŒããµã€ã¯ã«ãæäŸã§ããå¯äžã®äŒæ¥ã§ãã MariaDBãMySQLåžå Žã«ååšããŠããŸããããçŸåšã¯åžå Žãå»ããMariaDBãã©ãããã©ãŒã ã®ãµããŒãã®ã¿ã«æ³šåããŠããŸãã
ãœãªã¥ãŒã·ã§ã³ã ãã§ãªãã MySQLãšMongoDBã®å¹ åºãæè¡ããµããŒãããŠããå¯äžã®äŒæ¥ã§ãããšããç¹ã§ãç§ãã¡ã¯ãŠããŒã¯ã§ãã ããšãã°ãOracleã®MySQLãããã¯ã¢ãããç£èŠããã®ä»ãã¹ãŠã®ç¬èªã®ãã¯ãããžãŒã¹ã¿ãã¯ããµããŒãããŠããå ŽåãOracleã®Percona ServerãPercona XtraDB ClusterãMySQLãã¯ãããžãŒãMariaDBã®MySQLããŒãžã§ã³ãããã³æ¬¡ã®ãããªã¯ã©ãŠããœãªã¥ãŒã·ã§ã³ã®äž¡æ¹ããµããŒãããŸãã Amazon RDSããã³Google Cloud SQLã
ãµããŒãã®åéã§ã¯ãMySQLãšMongoDBã®äž¡æ¹ãåæã«ã«ããŒããå¯äžã®ãã³ããŒã§ããããã¯ã2ã€ã®çç±ã§å€ãã®äººã«ãšã£ãŠéåžžã«èå³æ·±ããã®ã§ãã ãŸãããã¯ãããžãŒãé²åãããšãå€ãã®äŒæ¥ãMySQLã®äœ¿çšéãšäœ¿çšããMongoDBã®æ°ã®ãã©ã³ã¹ãåããŸãã 2ã€ã®ãã³ããŒãšååããããšã¯é£ãããæè»æ§ããªãäžå¿«ã§ãã OracleãµãŒãã¹ã®äŸ¡æ Œãé«éš°ããå Žåã¯ããèããŠãããã¿ããªã 100åã®MySQLã€ã³ã¹ã¿ã³ã¹ã®ãµããŒããã客æ§ããè³Œå ¥ããŸããããå®éã«ã¯50åã®MySQLã€ã³ã¹ã¿ã³ã¹ã䜿çšããæ®ãã¯MongoDBã«ãªããŸãã ã©ã€ã»ã³ã¹ã翻蚳ã§ããŸããïŒã ãã¡ããã圌ãã¯ãããªãã¯ã§ããªãããšèšãã§ãããããªããªã圌ãã¯ããå°ãªããéãåãåãããã§ãã ç§ãã¡ã®åŽã§ã¯ãäž¡æ¹ã®ãœãªã¥ãŒã·ã§ã³ãã«ããŒãããµããŒããæäŸããã¯ã©ã€ã¢ã³ãã䜿çšããããšãæåŸ ããŠãããã®ã¯åœŒã®è£éã«æ®ããŸãã
第äºã«ã1ã€ã®ãã¯ãããžã®ã¿ã䜿çšãããã³ããŒã¯ããã®ãã¯ãããžãå¯èœãªéã䜿çšããããšã«é¢å¿ããããŸãã MySQLã䜿çšã§ããããšã瀺ãããšãã§ããã°ãããå€ãã®ãµããŒãå¥çŽãç²åŸã§ããŸãã çŸåšã®æ®µéã§ã¯ãããã2ã€ã®DBMSã®éã«éžæè¢ãããå Žåããã®ãããªåæ©ã¯ãããŸããã ã¯ã©ã€ã¢ã³ãã¯MySQLãŸãã¯MongoDBã䜿çšã§ããŸã-ç§ãã¡ã«ãšã£ãŠã¯ãééçãªéãã¯ãããŸããã ããã«ãããããŒã å šäœãã¯ã©ã€ã¢ã³ãã®å©çã«åºã¥ãããã客芳çãªãœãªã¥ãŒã·ã§ã³ãæäŸããå©ççžåãåé¿ã§ããŸãã ãããããPerconaã®åºç€ã圢æããæãéèŠãªããšã®1ã€ã§ããç§ãã¡ã¯ããŠã©ã¬ããã§ã¯ãªããæ¬åœã«æé©ãªã¯ã©ã€ã¢ã³ãã§ãããœãªã¥ãŒã·ã§ã³ã«éäžããããšããŠããŸãã
ãªã¢ãŒã管çããã³ãªã¢ãŒã管çã®åéã§ã¯ã競åä»ç€Ÿã¯ãã§ã«ç°ãªã£ãŠããŸããPythianãDatavailãªã©ã®äŒæ¥ã§ãã ãã¯ã©ãŠããäŒæ¥ããå€ãã®äŒæ¥ã®ææè ãããµãŒãã¹ãšããŠããŒã¿ããŒã¹ãAmazonã®ã¯ã©ãŠããœãªã¥ãŒã·ã§ã³ãGoogle Cloud SQLã䜿çšããå ŽåãDBAã¯å¿ èŠãªããããããŸããããšèãå§ããŠããããã§ããããã¯å®å šã«çå®ã§ã¯ãããŸãããããã®ç«¶äºã®éžæè¢ãç§ãã¡ã«ãšã£ãŠèå³æ·±ãäºäŸã§ãã ããããç§ãã¡ã®ãµãŒãã¹ã«ã€ããŠå šäœçã«èšãã°ãæ倧ã®ç«¶äºçžæã¯ããããèªåã§ãã¹ãŠãè¡ã人ã§ã ã äŸãšããŠããªãã£ã¹ã¯ãªãŒãã³ã°åžå Žã䜿çšããŠããããã説æããŸãã ããã§æ倧ã®ç«¶äºçžæã¯èª°ã§ããïŒ ããããå€ãã®äººãèšãã ããïŒããããŠãéãç¯çŽããŸããããç§ãã¡ã¯èªåèªèº«ããããã«ããŠæé€æ©ããããŸãïŒããããäžçš®ã®éžæã§ããããšã¯æããã§ãã ãããŠããã®ãããªéžæã¯ãèªåã®ããŒã¿ããŒã¹ã管çããããä»ã®èª°ãã«ããããäžããããšã決ãã人ã ã«ãã£ãŠçŽé¢ãããŸãã
PG DayïŒãªã¢ãŒã管çãµãŒãã¹ã«ã€ããŠèšåããŸããã ç§ãç解ããŠããããã«ããããã¯äŒæ¥ã®å€éšè«è² æ¥è ãšããŠåããã³ã³ãµã«ãã£ã³ã°ãµãŒãã¹ãæäŸããDBAã¹ãã·ã£ãªã¹ãã§ãã ã©ããã£ãŠãã®ãããªæ¹åã«æ¥ãã®ãæããŠãã ãããä»ã§ã¯äœãé åçã§ããïŒ
ããŒã¿ãŒïŒãŸããããã«ã€ããŠã¯å€éšå¥çŽãšããŠã§ã¯ãªãããã¬ãã£ããªäœãã«é¢é£ããŠããããšãå€ããšæããŸãã ã¯ã©ãŠãã¢ãã«ãšãX as a serviceããªã©ã®ãã¯ãããžãŒã®ç¶ç¶ã«ã€ããŠãã話ããŸãã ã¯ã©ãŠãã§äœãèµ·ãã£ãŠããŸããïŒ äººã ã¯ããµãŒããŒãèšçœ®ããŠã±ãŒãã«ãæ¥ç¶ã§ããå°é家ã®å®å šãªã¹ã¿ãããéã£ãŠç¶æããããšã¯ã»ãšãã©æå³ããªããšæ°ã¥ããŸããã å€ãã®äŒæ¥ã«ãšã£ãŠããããã¯ããŸãéèŠãªæ±ºå®ã§ã¯ãªããã¢ãŠããœãŒã·ã³ã°ããããšã§äŒæ¥ãã³ã¢ããžãã¹ã«éäžã§ããããã«ããŸãã
ãã¯ãããžãŒäŒæ¥ã«ãšã£ãŠãããã¯è£œåã®åµé ã§ãã å°å£²æ¥è ã«ãšã£ãŠãããã¯ããŒã±ãã£ã³ã°ãŸãã¯ããžã¹ãã£ã¯ã¹ã§ãã ãŸããããŒã¿ããŒã¹ã®ä¿å®äœæ¥ã¯ãå€ãã®å Žåãå®è¡ããå¿ èŠãããäœæ¥ã ãã«ãªããŸãã 圌ãã瀟å ã§æåããããšãããšããšãã«ã®ãŒãå¿ èŠã«ãªããŸãã ãã®å Žåããããã®åé¡ããã¹ãŠåœç€Ÿã«è»¢éãã補åã®éçºã«å°å¿µãããã人ã ã«æäŸããŸã ã
ãã®ç¹ã§ããããã®äŒæ¥ã¯ããŒã±ãã£ã³ã°ã«å€ãã®æè³ãããŠããããã Database as a Serviceåžå Žã¯ç§ãã¡ã«ãšã£ãŠã圹ç«ã¡ãŸãã ããŒã¿ããŒã¹ã®ã»ããã¢ãããšç®¡çèªäœãäžå©ã«ãªãå¯èœæ§ããããšããèãã顧客ã«äŒããããšããŸãã ãããã圌ãã¯æåŸãŸã§è¡ããŸããã ããšãã°ãAmazon RDSãèŠããšãããã¯ãããŒãžã£ãŒãæäœã§ãããµãŒãã¹ã§ã¯ãããŸããã å±éããã€ã³ã¹ã¿ã³ã¹ãã¹ããŒã ã®ãèšèšãæ¹æ³ã誰ãã決å®ããå¿ èŠããããŸãã ç°¡åãªããã¯ã¢ããèšå®ãç£èŠã«ã¯æè¡å°é家ãå¿ èŠã§ãã ãããŠããããŸãã«ç§ãã¡ãæäŸã§ãããã®ã§ãããªããªãã ç§ãã¡ã¯ããŒã ã®äžå¡ã«ãªãããããã®åé¡ãå®å šã«è§£æ±ºããããã«ç®¡çéšéãšéçºéšéã®äž¡æ¹ãšçŽæ¥é£æºã§ããããã§ãã
PG DayïŒãµããŒããããã¯ãããžãŒã®å€æ§åã«ã€ããŠè©±ããŸããã ã©ã®æç¹ã§MongoDBããµããŒãããããšã«ããŸãããïŒ ããã¯æå³ã®ããã¹ãããã§ãããããããšãææ©çã«ããŸããã£ãã®ã§ããïŒ
ããŒã¿ãŒïŒäžæ¹ã§ã¯ãæŠç¥ã®éçºã®å§ãã«ããã¯ãããžãŒãè¿œå ããããšèããŠããŸããã ã¯ã©ã€ã¢ã³ãã«å®¢èŠ³çãªãœãªã¥ãŒã·ã§ã³ãæ¬åœã«æ瀺ã§ããããšãéåžžã«éèŠã ãšæããŸãã sayingãããå ŽåïŒãã³ããŒãæã£ãŠããå Žåããã¹ãŠãéã®ããã«èŠããŸã-䜿çšã§ããããŒã«ã1ã€ããå ŽåããããäžèŠãªå Žåã§ããã¹ãŠããã®ããŒã«ã«é©ããŠããããã§ãã MongoDBåžå Žã«æ©äŒãçŸããç§ãã¡ã«ãšã£ãŠéåžžã«ããŸããããŸãããMongoDBãäŒæ¥ãšããŠMySQLã®ä»£æ¿ãšããŠäœçœ®ã¥ããããã«äžçæžåœåããããšãããããã®åžå Žã«ã¯ä»£æ¿ãµããŒããã³ããŒã®éèŠããããŸãã
TokuTekãè²·åããããšãã§ããŸãããTokuTek㯠ããã§ã«MongoDBãšãã®ãã©ãŒã¯MongoDBã®ãµããŒããµãŒãã¹ãæäŸããŠãããåžå Žã§ããç¥ãããŠããŸãã ããã«ããããŒããããã¹ãŠãè¡ãã®ã§ã¯ãªããæ°ããåžå Žã«åå ¥ããããšãã§ããŸããã ãããèµ·ãããªãã£ãå ŽåãMySQL以å€ã®äœããå§ããã«ã¯ãã£ãšæéãããããŸãã
PG DayïŒã³ã³ãµã«ãã£ã³ã°ã¯äººãåºç€ãšããããžãã¹ã§ãã ããªãã®äŒç€Ÿã¯åæ£ããŠãããããªããå šå¡åº§ã£ãŠãã倧ããªå»ºç©ã¯ãããŸããã å€æ°ã®é¡§å®¢ã«ã©ã®ããã«å¯ŸåŠããŸããïŒ ã©ã®ãããªå°é家ãããªãã®ããã«åããŠããŸããïŒ
ããŒã¿ãŒïŒçŸåšãçŽ150人ã®åŸæ¥å¡ã 30ãåœã 20ãåœã®ç±³åœã®å·ããããŸãã ã»ãšãã©ã®äººã¯èªå® ã§ä»äºãããŠããŸãã ç±³åœã®ããŒã¹ã«ãã©ã€ãå·ã«ã¯ã1æ¥å¹³å5人ã®å°ããªãªãã£ã¹ããããŸãã äŒè°ãéå¬ããã®ã«äŸ¿å©ãªããã«äœãããŠããŸãã ã²ã¹ããããæ¥ãŸãã ãŸããå€ãã®å°èŠæš¡ãªãã£ã¹ããããŸãã
ç§ã®æèŠã§ã¯ããµããŒãäºæ¥ãšã³ã³ãµã«ãã£ã³ã°äºæ¥ãäžè¡ã«ãŸãšããã®ã¯ãŸã£ããæ£ãããããŸããã ç§ãã¡ã¯ã³ã³ãµã«ãã£ã³ã°äŒç€ŸãšããŠã¹ã¿ãŒãããæ°å¹ŽåŸã«ã¯éçºãå°é£ã«ãªããŸããã äŒç€Ÿãæé·ããæ§é ãããè€éã«ãªããã³ã¹ããå¢å ããããã Percona Server for MySQLãªã©ã®ãœãããŠã§ã¢ã®éçºãéå§ããŸããã å€ãã®å Žåãã³ã³ãµã«ãã£ã³ã°ã¯ãŸã£ããäºæž¬äžå¯èœã§ããã¯ã©ã€ã¢ã³ãã次ãã次ãžãšæ¥ãããšããããŸãããæã«ã¯ãå¥åº·ãªãå£ç¯ãéããŠãäœã®é¢ä¿ããªãã³ã³ãµã«ã¿ã³ããããããããããšããããŸãã
ãã®ãããããžãã¹ã¢ãã«ã«ç§»è¡ããŸããã ãµããŒããšãªã¢ãŒã管ç -1ãæãŸãã¯1幎éã®åºå®ã³ã¹ãã®ãµãã¹ã¯ãªãã·ã§ã³ã§ãããåœç€Ÿãšã客æ§ã®äž¡æ¹ã«ã¡ãªããããããããŸãã ç§ãã¡ã«ãšã£ãŠãããã¯äºæž¬å¯èœãªåå ¥ã§ãããæè³ãšãªãœãŒã¹ãèšç»ããèœåã§ãã ãããã顧客ã«ãšã£ãŠã¯ãããã¯äžåºŠã¹ã±ãžã¥ãŒã«ã§ããäºç®ã§ãäºæž¬å¯èœã§ãã éå»1幎éããµãã¹ã¯ãªãã·ã§ã³ãµãŒãã¹ãæäŸãããã®ã¢ãã«ã«åãæ¿ããŸããããåå ¥ã®çŽ85ïŒ ããµããŒããšãªã¢ãŒã管çã§ãã ã³ã³ãµã«ãã£ã³ã°ãšãã¬ãŒãã³ã°ãè¡ã£ãŠããã®ã¯ããã15ïŒ ã§ãã
ä»ã¹ã±ãŒãªã³ã°ã®ç¹ã§ã ãµãã¹ã¯ãªãã·ã§ã³ãåºå®ãããšãå¹çãé«ããããã«ãã¯ãããžãŒã«æè³ã§ããŸãã ããã¯ããªã¢ãŒãã³ã³ãããŒã«ã®èŠ³ç¹ããæãæçœã§ãã 1æéãããã®æéãè«æ±ããå€ãã®äŒæ¥ã¯å©ççžåãæ±ããŠããŸãã 顧客ã«ããŸãã«ãå€ãã®èªååãå°å ¥ãããšã顧客ã¯ããå°ãªãæéãæ¯æãå¿ èŠããããŸãã ãããã顧客ã¯æéã®æ¯æãããããããèªååãä¿é²ããçç£æ§ãåäžãããããã«ãã€ãããŒã·ã§ã³ã«æè³ããããã®è³éãèŠã€ããããšã¯å°é£ã§ãã ç§ãã¡ã®èŠ³ç¹ããã¯ãçµæãåºå®äŸ¡æ Œã§è²©å£²ãããããäž»ãªé¢å¿ã¯äººä»¶è²»ãåæžããããã«å¯èœãªéããã¹ãŠãèªååããããšã§ãã ããã«ãããèªååã«çå£ã«æè³ã§ããŸã ã èªååãããã·ã¹ãã ã¯ããå®å®ããŠãããããããã¯ã¯ã©ã€ã¢ã³ãã«ãšã£ãŠäŸ¿å©ã§ãã ã³ã³ãã¥ãŒã¿ãŒã¯äººããããã¹ãå°ãªãããŸãã ããã¯ãç¹ã«å€§èŠæš¡ãªã·ã¹ãã ãšå€§èŠæš¡ãªããŒã ã«åœãŠã¯ãŸããŸãã
ç§ãã¡ã®æåã®å€§éšåã¯ããã«é¢é£ããŠãããšæããŸãã ããã«ãããã¹ã¿ããã®é¢ã§å€§å¹ ã«æè»ã«ãªããŸãã ããçš®ã®è«æ±æžã顧客ã«è²©å£²ããçç£æ§ã5åé«ãã¹ã¿ããã®ããçš®ã®ã¹ãŒããŒéçºè ãããããããã®ããã«3åã®ãéãæããããšããŸãããã å®éãã³ã³ãµã«ãã£ã³ã°ããžãã¹ã¢ãã«ã¯ãã®ããã«ã¯æ©èœããŸããã äŒæ¥é¡§å®¢ã¯å¹ åºãäŸ¡æ Œã«åŠå®çã«åå¿ããŸããããœãããŠã§ã¢éçºã®åéã«ãããçç£æ§ã¯äžçŽããé«çŽã®ã¹ãã·ã£ãªã¹ãã®éã§10åãç°ãªãããšãåºãç¥ãããŠããŸãã ãããã£ãŠããµãã¹ã¯ãªãã·ã§ã³ã¯ãŒã¯ã¢ãã«ã«çŠç¹ãåœãŠãããšã§ã éåžžã«å¹ççãªã¹ã¿ããã«æè³ããäœè£ããããŸãã
PG DayïŒãšã³ã¿ãŒãã©ã€ãºã¬ãã«ã®é¡§å®¢ã«ã€ããŠè©±ãå§ããŸããã BBCãAirbnbãCiscoãªã©ã®éåžžã«å€§èŠæš¡ãªã¯ã©ã€ã¢ã³ããå€æ°ååšããããšã¯åšç¥ã®äºå®ã§ãã ãã®ã¬ãã«ã®ã¯ã©ã€ã¢ã³ããšããåãããäž»ãªåé¡ã¯äœã§ããïŒ
ããŒã¿ãŒïŒå€§äŒæ¥ã¯ãçµæã®æ§é ãšäžè²«æ§ã«å¯ŸããŠããé«ãèŠä»¶ãæã£ãŠããŸãã ããã¯ç§ã«ãšã£ãŠãPerconaã®å€é©ã«ããã課é¡ã®1ã€ã§ããã ç§ãã¡ãå§ãããšããç§ãã¡ã¯å€ãã®ã¹ã¿ãŒãã¢ãããšååããŸããã ãèããŠãã©ãã ãã¯ãŒã«ããPerconetã«è³ªåãããŠãååšããæš©å©ããã3ã€ã®ç°ãªãæèŠãèããŠãã ããããšèšãããšãã§ãããèå³æ·±ãã掻çºãªäººãã¡ã æè¡ã®åéã§ã¯ãæ°åŠã®åé¡ã®ãããªãŠããŒã¯ãªè§£æ±ºçã¯ãªãããšããç§ãã¡ã¯çç解ããŠããŸãã éåžžããããã®ããã€ããããããã¹ãŠãéåžžã«èš±å®¹ãããŸãïŒããªãã¯ãããè¡ãããšãã§ããŸããŸãã¯ããããããŠãã¹ãŠãåäœããŸãã æåã«ãç§ãã¡ã¯ãã®ãããªè³¢ãç¬ç«ãã人ãéã£ãŠèšããŸããã äž»ãªããšã¯ããããåççã§ãããã¯ã©ã€ã¢ã³ããæºè¶³ããŠãããšããããšã§ããã
ãšã³ã¿ãŒãã©ã€ãºã¯ã©ã€ã¢ã³ããšã®é£æºãéå§ãããšã æåŸ ãå€ããå§ããŸãã ã â , , Starbucks, : «, , , , ». . ( , , ) . , . . , , , , ââ . 25 , , . , . enterprise- .
PG Day: ? , . , , .
: , , â . : , , . . - -, , . , . , . â , . : «, SQL . ». , - , MySQL , .
ä»ã«äœãé¢çœãã§ããïŒ , . , , . , , . . : , . , . , , : « ?» , , , . ââ, , , : ââ , . , , , . .
95% . , , . , , , , , , , , , . , . , , , . , .
. : , . , , , 5 , , , . , , . -, , . , ââ, : «, . , , , !» , . , , . -, , , . .
PG Day: ? DBA â , ââ , - .
: , , . , - , . , , , , . , . , background check : - , , -. . , 10 . - , - . , , , - â .
PG Day: , , , -, PG Day'17.
: -, InnoDB. , storage engine, , , 99% MySQL . Percona Live , . : MySQL, - . , . . - , InnoDB: , , , , . , , InnoDB , , ââ - , .
PG DayïŒããããããã¹ã¿ãŒã¯ã©ã¹ãžã®åå ã«èå³ãæã£ãŠãã人ã¯ããŸããïŒ
PeterïŒãšãããããã®ãã¹ã¿ãŒã¯ã©ã¹ã¯ãMySQLã䜿çšããDBAããã³ã·ã¹ãã 管çè ã«ãšã£ãŠèå³æ·±ããã®ã§ãã圌ãã¯MySQLãæ倧éã«æŽ»çšããæ¹æ³ãç¥ãå¿ èŠããããŸããèãæã¯ã質åããããç 究ããè³æã®æèã§åœŒãã®å¿çšåé¡ã®ããã€ããè°è«ãããããæ©äŒãå€ããããŸãã
PG DayïŒããããšãPeterïŒ