2021/10/03 PHP Conference Japan 2021 https://fortee.jp/phpcon-2021/proposal/85631599-8ed0-4b20-a46c-9ef5319c7aba
ã©ããfujiharaã§ããä»å¹´ãæ®ããããã§ããã å¹´ã å¯ãæãã度åããå¼·ããªã£ã¦ããã®ã§ãããåºç¤ä»£è¬ãè½ã¡ã¦ãã®ã åå ãã¨æ¯ãã¦ãã¾ãã ä»åã¯ã¨ããæ¡ä»¶ã§ãµã¼ã移è¡æã«MySQLã®ãã¼ã¸ã§ã³ãä¸ãã 8.x ã«ãªã£ãã¨ãã« PHPããæ¥ç¶ã§ããªãç¾è±¡ãçºçãã¦è§£æ±ºããæ¹æ³ããç´¹ä»ãã¾ãã èæ¯ ã¨ããããã¸ã§ã¯ãã§ãµã¼ã移è¡ãå¿ è¦ã ã£ãã®ã§ããã ã³ã³ãã³ãã移è¡ãã¦ããããã¼ã¸ã表示ããã¨MySQLã«ã¤ãªãããªãã åå ã¨ã©ã¼ã確èªããã¨ãã¹ã¯ã¼ãã§å¼¾ããã¦ã¾ããã åå ãæ¢ãã¨MySQL 8ã§ã¯ ãã¹ã¯ã¼ããããã©ã«ãã§æå·åãããã®ã§(cache_sha2_password) ããã°ã©ã ããæ¥ç¶ããå ´åãããã«å¯¾å¿ãã¦ããªãã¨æ¥ç¶ãã§ããªãã¨ã®ãã¨ã ä»åã¯ããã°ã©ã å´ãå¤æ´ããªãã£ãã®ã§ã MySQLå´ã§ä»¥ä¸ã®ç¨ã«å¯¾å¿ãã¾ããã # /etc/my.cnf [mysq
ã¯ããã« php7ccã§æ¤åºãããªãåé¡ã¨ã¯ ããã£ãç¹1: counté¢æ°ã®æåå¤æ´ ããã£ãç¹2: $array[] ã§å¤ã追å ãããã¨ãã¦å£ãã è¦å´ããç¹: mysqlé¢æ°ã®ç½®ãæã è¦å´ããç¹2: PHPUnitã®ãã¼ã¸ã§ã³ãä¸ããªãã¨ãããªã éã«å¬ããã£ãç¹: åã¢ããã¼ã·ã§ã³ã®å¼·å ã¾ã¨ã ã¯ããã« ãã®è¨äºã¯ PHPã¢ããã³ãã«ã¬ã³ãã¼ 6æ¥ç®ã®è¨äºã§ãã çãããPHP 5.6ã®ã»ãã¥ãªãã£ãµãã¼ãã¯2018å¹´12æãã£ã±ãã§çµäºã§ããã¤ã¾ãããã®ã¢ããã³ãã«ã¬ã³ãã¼ã®ã«ã¦ã³ããã¦ã³ãPHP 5.6çµäºã¸ã®ã«ã¦ã³ããã¦ã³ãªããã§ãã PHP5.6ããPHP7ç³»ã«ç§»è¡ãããã¨ãã¦ããçããã¯ãã£ã¨php7ccã使ã£ã¦ã³ã¼ãã®ãã§ãã¯ããã¦ãããã¨æãã¾ãããphp7ccã§ã¯æ¤åºããããå®éã«åããã¦ã¿ãªãã¨æ°ã¥ããªãåé¡ãããã¾ãã ä»åã¯ãããã£ãããã£ãç¹ãè¦å´ããç¹
ãã¹ãã»éçºã«ä½¿ç¨ãããã¼ã¿çæã®å¿ è¦æ§ åä½ç¢ºèªãã¹ããéçºæã«ä½¿ç¨ãããã¼ã¿ãã¼ã¹ã®ãã¼ã¿ãã©ã®ããã«æºåãã¦ãã¾ãã§ããããï¼æ¯åæåã§ä½æãã¦ãããæ¬çªç°å¢ããæã£ã¦ããããããã¯ä¸çªè¯ããªãä¾ã§ãããã æ¯åæåã§ä½æãã¦ãã¦ã¯ãéçºç°å¢æ§ç¯ã®åº¦ã«ããã¹ãå®è¡ã®åº¦ã«ä½æ¥ã³ã¹ãããããããªãã¬ã¼ã·ã§ã³ãã¹ãçºçãããããªãã¾ããç¥ã£ã¦ããªãã¨ç¨æã§ããªããã¼ã¿é ç®ãªã©ãããã§ããããããããæ¯åä¸ã¤ä¸ã¤ç¢ºèªããã®ã¯å¤§å¤ãªä½æ¥ã§ãã æ¬çªç°å¢ã®ãã¼ã¿ã使ç¨ãããã¨ãå±éºã§ãããã¨ã¯è¨ãã¾ã§ããªãã¨æãã¾ããå人æ å ±ãæ±ã£ã¦ããã·ã¹ãã ã§ããã°ãæ å ±ä¿è·ã®ç¹ãã大å¤ãªãªã¹ã¯ãç¯ãè¡çºã§ããã¡ã¼ã«ã¢ãã¬ã¹ãä¿åãã¦ããã·ã¹ãã ã§ããã°ããªãã¬ã¼ã·ã§ã³ãã¹ã«ããä¸è¦ãªã¡ã¼ã«ãå®éã«éä¿¡ãã¦ãã¾ãå±éºæ§ãä¼´ãã¾ãã ç¹ã«ãåä½ç¢ºèªã®éã«èªåãã¹ããå®è¡ããå ´åãæ³å®éãã®ãã¼ã¿ãå ¥ã£ã¦
ãã«ãã¡ã¾ãã¨ããã® ãããããPHPã®æç§æ¸ããã®ãã³æ¹çããã¦ããããããPHPã®æç§æ¸ ãPHP5.5対å¿çãã¨ãã¦åºçããã¾ãããæ§çã¯mysqlé¢æ°ã使ã£ã¦SQLå¼ã³åºããã¦ãã¾ããããmysqlé¢æ°ãPHP5.5ã«ã¦éæ¨å¥¨ã¨ãªã£ãããã®ç·æ¥å¯¾å¦çãªå 容ã¨ãªã£ã¦ããããã§ããã¤ã¾ããå¾æ¥mysqlé¢æ°ãå¼ã³åºãã¦ããç®æãmysqliã®å¼ã³åºãã«å¤æ´ããã¨ããã®ãã主ãªå¤æ´ç¹ã®ããã§ããã以å¤ã¯ãã¾ãå¤æ´ç¹ã¯è¦ãããã¾ããã æ¢ã«ãAmazonã§ã¯ãç±çãªèªè ã®æ¹ããã®è©³ç´°ã®ã¬ãã¥ã¼ãå±ãã¦ãã¾ãã ç¥æ¬å¾¡éè¨ï¼ è¨ããã¨ç¥ããPHPããã°ã©ãã³ã°æ¸ç±ã®ãã³ã°ã»ã©ã¼ã 2010å¹´9æã«çºå£²ãããåä½ã®æ¹è¨çã PHPã®ãã¼ã¸ã§ã³ãææ°ã®5.5ã«å¯¾å¿ãå 容ã¯åä½ã¨æ®ã©åãã å°ãåã«åä½ãè³¼å ¥ããæ¹ãæ¬æ¸ãè³¼å ¥ããæ¹ãããã§ãããã ãä¸ç¥ã ããã«ãã¦ãã帯ã®ãï¼ä¸äººã«èªã¾ããå®
æ°æã¡ç£è¦ãµã¼ãã®è² è·ãæ¸ã£ããããªã»ã»ã»ã ããããTrigger ã Event ã§é½åº¦ãªãã¼ãããªãã®ã大ããããªã â çµç·¯ã¨æ¦è¦ Zabbix 社ã11æ12æ¥ã«å ¬éãã Zabbix 2.2 ããã¼ã¸ã§ã³ã¢ããã試ã¿ããã®ã®ãé ä»ããã¦ãããã¤ããªããã±ã¼ã¸ã¯ RHEL6 ã»Debian 7ã»Ubuntu 12.04 TLS ã®ã¿ã ç§ã®ç°å¢ã¯ãRHEL5 ãªã®ã§ãã½ã¼ã¹ãããã¼ã¸ã§ã³ã¢ããã試ã¿ãäºã«ãããµããã»ã»ã»RHEL5ã®ããã±ã¼ã¸ããªãããã»ã»ã»ãã¨æã£ã¦ãããã©ããªãã¨ããªãã¾ããã æé ã¯ãZabbix 2.0 ã¨ã»ã¼åããMySQL ã®ãã¼ã¿ãã¼ã¹æ´æ°ãèªåçã«è¡ã£ã¦ãããã®ã§ãä½æ¥ã楽ã§ããã å ¥ãã¦ã¿ãçµæã¯ãMySQL ã®ã¯ã¨ãªãæããã«ç¾è±¡æ¸å°ãã模æ§ãç£è¦ãµã¼ã3å°ãç£è¦ã¢ã¤ãã 50åãããã®å¼±å°ç°å¢ã§ãå¹æã¯æãããã ããhousekeper ãåã£ã¦
ãã¼ã æè¡ããã° PHPMatsuri2013ã§çºè¡¨ããè³æãå ¬éãã¾ãããã½ã¼ã·ã£ã«ã²ã¼ã æ¡ä»¶ã«ãããDBåå²ã®PHPå®è£ ï½ã¨ã«ããåå²ã§ããã10åãã足ããªãã20åãããåå²ãï½ã PHPMatsuri2013ã§çºè¡¨ããè³æãå ¬éãã¾ãããã½ã¼ã·ã£ã«ã²ã¼ã æ¡ä»¶ã«ãããDBåå²ã®PHPå®è£ ï½ã¨ã«ããåå²ã§ããã10åãã足ããªãã20åãããåå²ãï½ã è¨äºãæ¸ãã®ã¯åãã¦ã«ãªãã¾ããsasakiã§ãã 2013å¹´7æ14æ¥ãã15æ¥ã«ããã¦ãPHP Matsuri 2013ãéå¬ããã¾ããã ä»åã¯åæµ·ééå¬ã¨ããäºã§å¼ç¤¾ãã¹ãã³ãµã¼ã¨ãªãã社å¡ã®ä½åãã¯ã¹ã¿ããã¨ãã¦éå¬ã«ååãã¾ããã ã¾ããã¹ãã³ãµã¼æ ã§ã»ãã·ã§ã³æéãä¸ã³ãé ã ãã½ã¼ã·ã£ã«ã²ã¼ã æ¡ä»¶ã«ãããDBåå²ã®PHPå®è£ ãï½ã¨ã«ããåå²ã§ããã10åãã足ããªãã20åãããåå²ãï½ã ã¨é¡ããçºè¡¨ãè¡ãã¾ããã®
OSC 2011 Hokkaidoã®çºè¡¨ã§ä½¿ç¨ããã¹ã©ã¤ãè³æã§ãã å¼ç¤¾ãããã©ã¦ã¶ä¸å½å¿ãããè±éã¯ã¨ã¹ããã¨ãã£ãã²ã¼ã ããPHPï¼MySQLã§æ§ç¯ãã¦ããä¸ã§ã身ã«ã¤ãããã¦ãã¦ãã注æãã¹ãç®æãæéãªã©ãã¾ã¨ããè³æã¨ãªã£ã¦ãã¾ããRead less
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}