ã¯ããã« ããã«ã¡ã¯ãããã¯ã¨ã³ãã¨ã³ã¸ãã¢ã®Sakiã§ãï¼ããã¯ã¨ã³ãã§PHPãæ¸ããããPHPã¨ããè¨èªãã®ãã®ã®ã¡ã³ããã¼ããã¦ãã¾ãã ãã®åº¦ã注æãã¼ã¿ãã¦ã³ãã¼ãAppã®ããã©ã¼ãã³ã¹ãã¢ããããããããã¨ã¦ãå ¥å¿µã«ãã¼ã¿ãã¼ã¹ã¾ããã®å¦çãè¦ç´ãã¾ããããã®ä¸ã§ãç¹ã«é度ã«é¢ãã£ã¦ãããindexãã«ã¤ãã¦ã®èãæ¹ãã¾ã¨ãããã¨æãã¾ãã ãã®è¨äºã¯MySQLï¼InnoDBï¼ã«ã¤ãã¦ã®è¨äºã§ãããä»ã®RDBã«ã¤ãã¦ã¯å½ã¦ã¯ã¾ããªãå ´åãããã¨ãããã¨ã«ã注æãã ããã indexã¨ã¯ä½ãããããã ãåç¥ã®æ¹ããã¡ããå¤ãã¨æãã¾ãããindexã«ã¤ãã¦ããããããã¦ãã ããã indexã¨ã¯è¾æ¸ã§ããã¨ããã®ç®æ¬¡ã«ç¸å½ãããã®ã§ãç®çã®ãã¼ã¿ããã¡æ©ãæ¤ç´¢ããããã«éè¦ãªãã®ã§ããããè¾æ¸ã«ç®æ¬¡ãåå¨ããªãã£ãå ´åãç®çã®æ å ±ãæ¢ãã®ã«ã¨ã¦ãè¦å´ããã ããã¨ããã®ã¯æ³åãã
ä¹ ã ã«æºã¾ã£ãããã°ãã¿æ¾åºããããããªã¨ããã®åã«ä¸æ¸ãããæãèµ·ããã¦ããããã¾ãããªã¹ãã¼ã¯ã¨ãªé¢é£ã§æºåéåã§ãã RDSã®ã¹ãã¼ã¯ã¨ãªæ å ±ã¯å½ç¶ãéè¨ãèªååãã¦ãã¤ã§ãè¦ããããã«ãã¦ããã®ã§ãããã¡ããã¨å¿ è¦ããã£ãã®ã§ãä»åã¯ããã¦åçºãã°ãéè¨ããå½¢ã«åãåºãããã®ãç¨æãã¦ã¿ã¾ããã ã¹ãã¼ã¯ã¨ãªãã°ã®å¿ è¦æ§ æè¿ã¯NewRelicã¨ãã§ãã¢ããªã±ã¼ã·ã§ã³ã®å¦çãåå¥ãã¦å¦çæéãªã©ãéè¨ããã®ã§ãããã§èª²é¡ã¨ãªãã¯ã¨ãªã確èªãããããã¾ãã é常ã«ä¾¿å©ãªä»çµã¿ã§ãããã¢ããªã±ã¼ã·ã§ã³å¤ã®ã¸ã§ããªã©ãå®è¡ããã¯ã¨ãªã¯éè¨ãããªããã¨ããè² è·è©¦é¨ã§èª²é¡ãçãåºãã¨ãã ã¨ãã¹ãç°å¢ã«ã¨ã¼ã¸ã§ã³ããã©ã¤ãã©ãªãä»è¾¼ãå¿ è¦ããããã¨ãã£ããã¡ãªããã¨ã¾ã§ã¯è¨ããªãã¾ã§ãé¢åããããã¾ãã ãã®ç¹ãã¹ãã¼ã¯ã¨ãªã¯ãµã¼ãã¼å´ã§è¨é²ãããã®ãªã®ã§ã0.1ç§ã¨ãã§ONã«ãã¦ããã°ã対象
CTO 室 SRE kenzo0107 ã§ãã 以åå·çãã ECS ãå©ç¨ããæ¤è¨¼ç°å¢ã®èªåæ§ç¯ã«ã¤ãã¦ãéç¨éå§ãã3å¹´ã®æãçµã¾ããã å®éç¨ã¨ãã®ä¸ã§é ããè¦æãåãå ¥ãå¤åãã¦ãã¾ããã®ã§ããã®çµç·¯ã綴ãã¾ãã tech.medpeer.co.jp æ¬ç¨¿ãè°è«ãéãæ¹åãé²ãã¦é ãããã¼ã ã¡ã³ãã¼ã®ç¥è¦ãéããå æ°çããã°ã¨ãªã£ã¦ããã¾ãã åæ 社å ã§ã¯ã以ä¸ã®æ§ã«å¼ã³åããã¦ãã¾ãã æ¬çªç¸å½ã®æ¤è¨¼ç°å¢ã STG ç°å¢ æ¬è¨äºã§èª¬æããèªåæ§ç¯ãããä»çµã¿ãæã¤ç°å¢ã QA ç°å¢*1 æ¤è¨¼ç°å¢ã®èªåæ§ç¯ã®ç®ç éçºããæ©è½ãéçºæ å½è 以å¤ã§ãç°¡æçã«ç¢ºèªã§ããæ§ã«ãã以ä¸ãä¿é²ãã¾ãã ãã£ã¬ã¯ã¿ã¼ã¨éçºè ã®ä»æ§é½é½¬ãæ¸ãã æ¹åã®ãµã¤ã¯ã«ãé«éåãã å½æã®æ¤è¨¼ç°å¢ã®èªåæ§ç¯ã®ä»çµã¿ 大ã¾ããªæµã â ãã©ã³ã qa/foo ã push â¡ CircleCI å®è¡ ⢠C
ãªã¼ãã³ã½ã¼ã¹ã®ãªã¬ã¼ã·ã§ãã«ãã¼ã¿ãã¼ã¹ç®¡çã·ã¹ãã ãMySQLãããã®æ´¾ççã§ãããMariaDBãã¨ã¨ãã«é«éãã¤ç¡æã§å©ç¨ã§ãããã¨ããé«ã人æ°ãéãã¦ãã¾ãã æ¬æ¥ç´¹ä»ãããawesome-mysql-performanceãã¯ãããããã¼ã¿ãã¼ã¹ã·ã¹ãã ã®ããã©ã¼ãã³ã¹ãæé©åããããã®æ å ±ãã¾ã¨ãããªã³ã¯éã§ãã MySQLãMariaDBãåã«ã¤ã³ã¹ãã¼ã«ãã¦ä½¿ç¨ããããã®æ¹æ³ã説æããæ å ±ã¯ã¤ã³ã¿ã¼ãããä¸ã«å¤æ°åå¨ãã¾ãããããæ·±ãè¦èãå¿ è¦ã¨ãªãããã©ã¼ãã³ã¹æ¹åã®ããã®æ å ±ã¯ãã¾ãå¤ãã¯ããã¾ããã ãã¼ã¿ãã¼ã¹ãµã¼ãã¼ãéç¨ãã¦ã¿ã¦ããã©ã¼ãã³ã¹ã®ä½ä¸ã«æ©ã¾ããã¦ããæ¹å¿ è¦ã®æ å ±ã¨ããããã§ãã ãµã¼ãã¼ã®è¨å®ããInnoDBã®æé©å åãªã³ã¯æ°ã«ã¯ä»¥ä¸ã®æ å ±ãå«ã¾ãã¦ãã¾ãã Ten MySQL performance tuning settings after
ç®æ¬¡ ã¯ã¼ã«ã¼ãã¼ãã®ä½æ Digdagã¨Embulkã®Dockerãã«ã Kubernetesã«Digdag/Embulkãããã㤠Redashã®å°å ¥ ã¾ã¨ã Kubernetesä¸ã«åæç°å¢ãæ§ç¯ããæ©ä¼ããã£ãã®ã§ã©ã®ããã«æ§ç¯ããããç´¹ä»ãã¾ããåããããªæ§æã§Kubernetesä¸ã§æ§ç¯ããã®ã¯3åç®ã«ãªã£ãã®ã§æ§ç¯æ¹æ³ãæ´ç·´ããã¦ãã¾ãããæ§æã¯ä»¥ä¸ã®ããã«ãªã£ã¦ãã¾ãã MySQL(RDS): ãµã¼ãã¹ã®ãã¼ã¿ãã¼ã¹ãããã®ãã¼ãã«ããBigQueryã«Embulkã§ãã¼ã¿ãã¨ã¯ã¹ãã¼ããã¾ãã PostgreSQL(RDS): Digdagã®ãã¼ã¿ãã¼ã¹ãä»åæ°ãã«ã¤ããã¾ããã Digdag: ãã¼ã¿ãã¼ã¹ã®ã¨ã¯ã¹ãã¼ããªã©ãå®è¡ããã¿ã¹ã¯ã¹ã±ã¸ã¥ã¼ã©ã失æããã¨ãã«ãªãã©ã¤ãã§ãã¾ãã Embulk: ãã©ã°ã¤ã³ã使ã£ã¦ãã¼ã¿ãã¼ã¹ãMySQLããBigQueryã«ã¨
以åembulkã§CSVããelasticsearchã¸ã¨ããã®ããã£ã¦ã¿ã¾ãã ãµã¼ãã¹ã®ãã¼ã¿ããã°ã©ãä½æãããã¨ããããã£ãå ´åã«ãMySQLãããã¼ã¿åã£ã¦ãã¦elasticsearch+kibanaã§ãã確èªã§ããããã£ã¦ãããã¨ãæãã¤ãããããã£ã¦ã¿ã embulkã®ã¤ã³ã¹ãã¼ã« ä¸è¨åç § embulkã§elasticsearchã¸éå»ãã°ãå ¥ãè¾¼ã pluginã®ã¤ã³ã¹ãã¼ã« embulk gem install embulk-input-mysql è¨å® config.yml in: type: mysql host: localhost user: user password: "" database: service query: | SELECT date, SUM(c), SUM(a) FROM report GROUP BY date exec: {} out
ããã«ã¡ã¯ãæè¿ãªã¢ã¼ãã¯ã¼ã¯ç¨ã«ãã¤ã¯ãè²·ã£ãã½ããã¦ã§ã¢ã¨ã³ã¸ãã¢ã®ç¦é(fkmy)ã§ãã å æãANDPADã®ãã¼ã¿ãã¼ã¹ã®æè¡é¡§åããã¦é ãã¦ãä¸è°·(mita2)ããã«ããããã¯ã®åºç¤ç·¨)ãã«ã¤ãã¦åå¼·ä¼ãéå¬ãã¾ãããä»æã¯ããã¯ã®DDLç·¨ã«ã¤ãã¦8/4(æ)ã«åå¼·ä¼ãå®æ½ãã¾ãããéè¦ãªç®æãããã¯ã¢ãããã¾ãï¼ ã¾ãä»åãå¨å® å¤åæéä¸ã®ãããªã³ã©ã¤ã³éå¬ã¨ãªãå½æ¥ã¯16åãåå ãã¦ãã¾ããã å 容 å½æ¥ã®è³æã¯ãã¡ãã«ãªãã¾ãã DDLã«ã¤ã㦠DDLã¨ã¯Data Definition Languageã®ç¥ç§°ã§ãã¼ã¿æ§é ãå®ç¾©ããããã®è¨èªã®ãã¨ã§ããSQLã§ã¯CREATEæãDROPæãALTERæãTRUNCATEæã該å½ãã¾ãã DDLã®ä»çµã¿ã¨æ¹åã®æ©ã¿ã«ã¤ã㦠MySQLã®ALTER TABLEã®åæå®è£ æ°ãããã¼ãã«å®ç¾©ã®ãã¼ãã«ã«ãã¼ã¿ã³ãã¼ãã å®è¡ä¸ã¯æ¸
èæ¯ 2020å¹´4æã«å æ¬æ¨ã®ToCåãã¡ãã£ã¢ç³»ãµã¼ãã¹ãéå¶ããä¼æ¥ã«æ°åå ¥ç¤¾ãã社ä¼äºº1å¹´ç®ã®ã¨ã³ã¸ãã¢ã§ããå ¥ç¤¾ãã1å¹´åããå§ããå å®ã¤ã³ã¿ã¼ã³ã§ã¯ãµã¼ãã¼ãµã¤ãéçºã¯Golangã使ã£ã¦ãã¾ãããã¡ã¤ã³ã®éçºã¯Vue.js/Nuxt.jsã§ã®ããã³ãã¨ã³ãéçºã§ãã£ãçºãGolangã¯æ®ã©åå¿è ã¬ãã«ã§ãããä»åã¯åå¼·ç®çã§TODOã¢ããªç¨ã®APIãµã¼ãã¼ã0ããéçºããã®ã§ããã®ãã¦ãã¦ãªã©ããã®è¨äºã§å ±æã§ããã°ã¨æã£ã¦ããã¾ãã ãã®è¨äºã®å¯¾è±¡è Golangãåå¼·ãå§ããåå¿è ã®æ¹ Golangã使ã£ã¦ãµã¼ãã¹ãéçºãããã¨èãã¦ããåå¿è ã®æ¹ ã¢ã¼ããã¯ã㣠次ã®ãããªç°¡æãªã¢ã¼ããã¯ãã£ã«ãã¾ãããè¨èã§èª¬æããã¨ã¡ãã£ã¨é·ããªããããªã®ã§docker-compose.ymlãæ·»ä»ãã¦ããã¾ãã version: '3' services: app: build:
å¤ä»£ã®Webã¢ããªã±ã¼ã·ã§ã³ã¨ã³ã¸ãã¢ãªã®ã§ãç¾ä»£ã¨ã®å·®åã身ã«ä»ãã¦ãããï¼ å人çãªã¹ãã«ã»ããã®å·®åãåããããã®ãã®ãªã®ã§ã誰ã«ã§ãããããããã®ã§ã¯ããã¾ããã ç¿ãããæ £ããã®ç²¾ç¥ã§ãèªãã§çµãããããªãã¦æãåããã¾ãã ã³ã³ããå x done.icon The Twelve-Factor App ï¼æ¥æ¬èªè¨³ï¼ done.icon What is Amazon Elastic Container Service? - Amazon Elastic Container Service æ©æ¢°ç¿»è¨³ãã²ã©ãã£ãã®ã§è±èªçãGoogle翻訳ã§èªãã»ãããã·ãã ã¡ãã¥ã¼1é層ç®ã ãå ¨é¨èªãã§ãæ°ã«ãªãã¨ãããããã°æ·±å ããã âã§ç©è¶³ããªãã£ããKuberneteså®å ¨ã¬ã¤ã 第2ç impress top gearã·ãªã¼ãº | éå±±çä¹ | å·¥å¦ | Kindleã¹ã㢠| Ama
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}