12/21 çºå£²ã® WEB+DB PRESS Vol.78 ã®Perlãªã¬ã¼é£è¼ã«ã¦ãPSGI/Plackå®è·µå ¥éãã¨ããè¨äºãæ¸ãã¾ããã å 容ã¯YAPC::Asiaã§çºè¡¨ããå 容 + plackconã§è¤åãããçºè¡¨ãããã¨ãä¸å¿ã§ãã¦ããçãã¨ãªã£ã¦ããã¾ãã PSGIã®ä»æ§ã®å¾©ç¿ PSGIãµã¼ãã®å½¹å² ãã使ãããPSGIãµã¼ãã¨ãã®ç¹å¾´çãªæ©è½ã®ç´¹ä»(Starlet,Starman,Twiggyãªã©) PSGIãµã¼ãã®é¸ã³æ¹ Plack::Middleware Server::Starterã使ã£ããããããã㤠Perlã§Webã¢ããªã±ã¼ã·ã§ã³ãä½ããåããã®ã§ããã°å¿ ãæ¼ããã¦ããã¹ãäºæãã¾ã¨ãã¦ããã®ã§ãã²èªãã§é ãããã¨æãã¾ãã WEB+DB PRESSç·¨éé¨ ç·¨ æ æ å¥å¤ªé å®è©®é¢ åº·åº å±±å£ è¯å¹³ å°¾ä¸ å¿ è¼ å¤§å· é«å¿ åæ¬ å¯æ¨¹ éæ¨ å³°é å¢äº éä¸é ä¸
ã©ãã大ç§ã§ãã RDSã«ããããDB on EC2ã«ããããæ¤è¨ããéã«ããæããã®ããTimezoneãã©ããããã¨ãã話ãAWSã®ãµã¼ãã¹ã¯åºæ¬çã«ã¯UTC(ä¸çæ¨æºæ)ã§æä¾ãããRDSãä¾å¤ã§ã¯ããã¾ããã ãä¸çå±éãçããµã¼ãã¹ã§ããã°å½ç¶UTCã§ï¼ãã¨ãªãã®ã§ãããæ¢åã·ã¹ãã ãAWSã«ç§»è¡ããæ¡ä»¶ãªã©ã§ã¯ãã¢ããªã®æ¹ä¿®ãã§ããªãã®ã§ã移è¡åã¨Timezoneãåãããããã±ã¼ã¹ãå¤ãã¨æãã¾ãã EC2ã§ããã°ãOSã®Timezoneè¨å®ãã¡ãã¡ããã¨å¤ããã ãã§å¯¾å¿ã§ããã®ã§ãããRDSã¯ç´æ¥ã¤ã³ã¹ã¿ã³ã¹ã«ãã°ã¤ã³ã§ããªããããã¡ãã£ã¨ãã工夫ã¨æ³¨æãå¿ è¦ã§ãã æ¦è¦ ä»åã¯RDS MySQLã対象ã«ãTimezoneãå¤æ´ããæ¹æ³ããç´¹ä»ãã¾ãã RDSã§ã¦ã¼ã¶ã¼ã«æä¾ããã"Masterã¦ã¼ã¶ã¼"ã¯ãMySQLã®rootã¦ã¼ã¶ã¼ã¨ã¯ç°ãªãSUPER権é(管çè 権é)
CodeZineç·¨éé¨ã§ã¯ãç¾å ´ã§æ´»èºãããããããã¼ãã¹ã¿ã¼ã«ããããã®ã«ã³ãã¡ã¬ã³ã¹ãDevelopers Summitãããã¨ã³ã¸ãã¢ã®çããã¾ããã¼ã¹ãããããã®ã¤ãã³ããDevelopers Boostããªã©ããã¾ãã¾ãªã«ã³ãã¡ã¬ã³ã¹ãä¼ç»ã»éå¶ãã¦ãã¾ãã
ã¾ã¨ã è¶ é·ããªã£ãã®ã§ã¾ã¨ããä¸ã«æã£ã¦ããã å··ã§è¨ããã¦ãããã¥ã¼ãã³ã°ã¯çµæ§åãå¤ãäºã解ã£ã¦ããã ãã¼ã«ç workingSet Analyzer ã¯ä¿¡ç¨ãªããªããï¼overSecondsã¯ã¾ãè¯ãï¼ mongoperfã®å¤ã¯å®å ¨ã«åèã«ãªããªãã insert mongoperfã®å¤ã¯insertæ§è½ã¨é¢é£ããªããï¼ä½ã測ã£ã¦ããã ï¼ï¼ ã«ã©ã ã®ããªã¢ãã±ã¼ã·ã§ã³ã«ããUPDATEæã®ãã¼ã¿è¥å¤§ååé¿($setOnInsert)ã¯MUSTã ã¯ãªãã£ã«ã«ãªæé帯ã«ã¹ãã¬ã¼ã¸ãã¡ã¤ã«(2GB)ã®çæãé¿ãããã¥ã¼ãã³ã°ã®å¹æã¯æççã ã¬ã³ã¼ãããªã¢ãã±ã¼ã·ã§ã³ã»ãã¥ã¼ãã³ã°ã¯é å¼µã価å¤ãç¡ãã(ãããéå¹æ) update ä¸è¨ã®éãå¿ ãin-placeã«ãªãããã«ããã paddingFactorãåãããã ã¨ã話ã«ãªããªãæ§è½å£å remove ããªãé«éã å ¨ä»¶åé¤ã®å ´
OSSã®RDBMSã§ããPostgreSQLã§ãäºåããã¦ããã»ãã¥ãªãã£ã¢ãããã¼ãããªãªã¼ã¹ããããã¦ã¼ã¶ã¼ã¯éãããªã¢ãããã¼ããã 2013å¹´4æ4æ¥ãPostgreSQLã§ãæ·±å»ãªèå¼±æ§ãã«å¯¾å¿ããããã®ãã¤ãã¼ã¢ãããã¼ãããªãªã¼ã¹ãããã ä»åçºè¦ãããèå¼±æ§ã¯ãDBã®æ£è¦ã¢ã«ã¦ã³ããæããªãã¦ã¼ã¶ã¼ãpsqlãªã©ã§DBæ¥ç¶ãããã¨ããã ãã§DBãç ´å£ã§ããã¨ãããã®ãã-ãã§å§ã¾ãã¦ã¼ã¶ã¼åã§æ¥ç¶ããã¨ããã¼ã¿ãã¼ã¹ãµã¼ãã®ãã¼ã¿ãã£ã¬ã¯ããªæ§é ãªã©ã«å½±é¿ãä¸ããå¯è½æ§ããããä¸è¬ã¦ã¼ã¶ã¼æ¨©éã§å®è¡ã§ãããã¨ãããã¦ã¼ã¶ã¼ã«ã¯éãããªã¢ãããã¼ããå¼ã³æãã¦ããã ããå³æã®ã¢ãããã¼ããå°é£ãªå ´åã¯ãä¸æçã«ãªã¼ãã³ãªãããã¯ã¼ã¯ããPostgreSQLã¸ã®æ¥ç¶ãå¶éããã¨ãã£ãåé¿çãæ¤è¨ããå¿ è¦ãããã ããã ã¢ãããã¼ãã®å¯¾è±¡ã¯ä»¥ä¸ã®ãã¼ã¸ã§ã³ã7.4ç³»ã8.0ï½3
2013å¹´3æ26æ¥ããçºçãã¦ããä½æ°åºæ¬å°å¸³ãããã¯ã¼ã¯ã·ã¹ãã ï¼ä½åºãããï¼ã®é害ã®åå ãããã¼ã¿ãã¼ã¹ï¼DBï¼ã«æ å ±ãæ¸ãè¾¼ãéã®æåã³ã¼ãã®èª¤ãï¼æååãï¼ã«ãã£ããã¨ããé害ãå½±é¿ããå¸çºæã®åè¨ã231ã«åãã§ãããã¨ãªã©ãåãã£ããç·åçã4æ2æ¥ã«çºè¡¨ããï¼é¢é£è¨äºï¼å ¨å½200ã®èªæ²»ä½ã§ä½åºããããå©ç¨ä¸å¯è½ã«ãªãé害ãçºçï¼ã ä»åã®é害ã¯ãèªæ²»ä½ã«ããä½æ°åºæ¬å°å¸³ã·ã¹ãã ã¨ä½åºããããæ¥ç¶ãããã³ãã¥ãã±ã¼ã·ã§ã³ãµã¼ãã¼ãã®ãã¼ãã¦ã¨ã¢ã¨OSã231ã®èªæ²»ä½ã§æ´æ°ããããã«ä¼´ããã³ãã¥ãã±ã¼ã·ã§ã³ãµã¼ãã¼ã®ã¢ããªã±ã¼ã·ã§ã³ã«å¯¾ãã¦ãæ°OSã«å¯¾å¿ãããä¿®æ£ããã°ã©ã ãé©ç¨ãããã¨ã§çºçããã ã³ãã¥ãã±ã¼ã·ã§ã³ãµã¼ãã¼ã®ã¢ããªã±ã¼ã·ã§ã³ã¯ãæ°åã»ä½æã»çå¹´ææ¥ã»æ§å¥ã¨ãã4ã¤ã®ãæ¬äººç¢ºèªæ å ±ãããDBãµã¼ãã¼ã§ãããOracle Databaseãã«ä¿åããéã«ãä½åºã
æ¸ç±ç´¹ä» æ¬é£è¼ã¯ä¸è¨æ¸ç±ãã第5ç« ãåºã«ãï¼ ITåãã«åæ§æãã¦æ²è¼ãã¦ãã¾ãã ç®æ¬¡ åº ç« ããã°ãã¼ã¿ã®æ代 第1ç« NOSQLã¨ã¯ä½ã? 第2ç« NOSQLã®ãã¼ã¿ã¢ã㫠第3ç« ã¢ã¼ããã¯ãã£ã®åºæ¬æ¦å¿µã¨æè¡ ç¬¬4ç« Hadoopã¯NOSQL? 第5ç« ä¸»ãªNOSQLãã¼ã¿ãã¼ã¹è£½å 第6ç« NOSQLãã¼ã¿ãã¼ã¹ã®é¸æåºæº 第7ç« NOSQLã使ããã¸ãã¹ æ¬é£è¼ã¯æ¸ç±ãNOSQLã®åºç¤ç¥èãï¼ãªãã¯ãã¬ã³ã åãISBNï¼978-4897978871ï¼ã§è§£èª¬ããã¦ããå 容ããä¸é¨ãæç²ããæ¬é£è¼åãã«ä¸é¨åç·¨éãã¦æ²è¼ãããã®ã§ãã æ¸ç±ã§ã¯ãä¸è¬ã«NoSQLã¨å¼ã°ãã¦ããå種ãã¼ã¿ãã¼ã¹æè¡ã«ã¤ãã¦ãåºæ¬æ¦å¿µãã主è¦ãªãããã¯ãã®ç¹æ§ããã³ããã¼ã¯çµæã¾ã§ãç´¹ä»ãã¦ãã¾ãããã¼ã¿ã¢ãã«ãã¢ã¼ããã¯ãã£ã®éãã¨ãã£ãåºæ¬æ¦å¿µãããåãããã¯ãã®ç¹å¾´ãç解ã§ããå 容ã«ãªã£ã¦ãã¾
MySQL 5.6æ£å¼çãå ¬éããªããã£ãã¤ã¶ãInnoDBã®åä¸ã§ããã«é«éãã¯ã©ãã·ã¥ã»ã¼ããªã¬ããªã±ã¼ã·ã§ã³ãªã© ç±³ãªã©ã¯ã«ã¯ãMySQL 5.6ã®æ£å¼çãå ¬éããããã¨ãçºè¡¨ãã¾ãããMySQLã¯ãªã¼ãã³ã½ã¼ã¹ã®ãã¼ã¿ãã¼ã¹ã§ãç¡æã§å©ç¨å¯è½ãªMySQL Community Server 5.6.10ãå ¬éããã¦ãã¾ãã MySQL 5.6ã®ãããªæ°æ©è½ã¯ãã¬ã¹ãªãªã¼ã¹ãããã¥ã¡ã³ããWhat's New in MySQL 5.6ãã§ç´¹ä»ããã¦ãã¾ããæ¬è¨äºã§ã¯ãããã¨ããªã¼ãã³ã½ã¼ã¹ã«ã³ãã¡ã¬ã³ã¹ 2012 Tokyoã§å ¬éãããæ¥æ¬ãªã©ã¯ã« å±±å´ç±ç« æ°ã®è³æãå§åçãªé²åãç¶ããMySQLã®ææ°æ©è½ãï¼PDFï¼ã®ä¸é¨ãå¼ç¨ãã¤ã¤ä¸»ãªæ©è½ãç´¹ä»ãã¾ãã ãªããã£ãã¤ã¶ãInnoDBãã¬ããªã±ã¼ã·ã§ã³ MySQL 5.6ã§ã¯ãSQLã解æãã¦å®è¡ãããªããã£ãã¤ã¶ã®æ¹åã¨ããã¼ã¿ã
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}