AWSã®ALB(Application Load Balancer)ã®ãã°ã¯S3ã«ç½®ããããããã®ä¸èº«ããµã¯ãã¨èª¿ã¹ããã¨ããAthenaã使ãæ¹æ³ãæ¨æºçã§ãä¸è¨ã§æ¡å ããã¦ããããã«ãã¼ãã£ã·ã§ã³å°å½±(Partition Projection)ã§ãã¼ãã«ãä½ã£ã¦Athenaããã¯ã¨ãªããã ãã¼ãã£ã·ã§ã³å°å½±ã使ç¨ã㦠Athena 㧠ALB ã¢ã¯ã»ã¹ãã°ç¨ãã¼ãã«ãä½æãã - Amazon Athena ç§ãå¾æ¥ã¯ãã®æ¹æ³ã使ã£ã¦ããããAthenaã¯ãã©ã¦ã¶ãã使ãã¨åä½ããã£ãããã¦ãããã決ã¾ã£ãã¯ã¨ãªã1åããå®è¡ãã¦çµæãåå¾ãããã ãã®ã¨ããªãã¾ã ãããæ¢ç´¢çã«ã¯ã¨ãªãä½çºãå®è¡ãããã¨ãã«ã¯ä½¿ãåæãæªãã æè¿ä»ã®ããã¸ã§ã¯ãã§DuckDBã使ãããã«ãªã£ã¦ã使ãåæã®è¯ãã«æåãã¦ããããDuckDBã¯ALBã®ãã°ãæ¢ç´¢çã«èª¿ã¹ããã¨ãã«ããã£ã¡ã使ããã¨æã£ã
If youâve ever built a web service or a web app, you know the drill: pick a database, pick a web service framework (and in todayâs day and age, pick a front-end framework, but letâs not get into that). This has been the case for several decades now, and people donât stop to question if this is still the best way to build a web app. Many things have changed in the last decade: Disk is a lot faster
è±èªçè¨äºãæ¥æ¬èªã¸æ©æ¢°ç¿»è¨³ãããã¼ã¸ã§ã³ï¼Google翻訳ï¼ã ä¸ãä¸ç¿»è¨³ã®æãããã¨ãã¦æ©æ¢°ç¿»è¨³ãç¨ããå ´åã翻訳è ã¯å¿ ã翻訳å åæãåç §ãã¦æ©æ¢°ç¿»è¨³ã®èª¤ããè¨æ£ããæ£ç¢ºãªç¿»è¨³ã«ããªããã°ãªãã¾ããããããæããã¦ããªãå ´åãè¨äºã¯åé¤ã®æ¹éG-3ã«åºã¥ããåé¤ãããå¯è½æ§ãããã¾ãã ä¿¡é ¼æ§ãä½ãã¾ãã¯ä½å質ãªæç« ã翻訳ããªãã§ãã ãããããå¯è½ãªãã°ãæç« ãä»è¨èªçè¨äºã«ç¤ºãããæç®ã§æ£ãããã©ããã確èªãã¦ãã ããã å±¥æ´ç¶æ¿ãè¡ããããè¦ç´æ¬ã«ç¿»è¨³å ã¨ãªã£ãè¨äºã®ãã¼ã¸åã»çã«ã¤ãã¦è¨è¿°ããå¿ è¦ãããã¾ããè¨è¿°æ¹æ³ã«ã¤ãã¦ã¯ãWikipedia:翻訳ã®ã¬ã¤ãã©ã¤ã³#è¦ç´æ¬ã¸ã®è¨å ¥ãåç §ãã ããã 翻訳å¾ã{{翻訳åç¥|en|Raft (algorithm)|â¦}}ããã¼ãã«è¿½å ãããã¨ãã§ãã¾ãã Wikipedia:翻訳ã®ã¬ã¤ãã©ã¤ã³ã«ããã詳細ãªç¿»è¨³ã®æé ã»æéã«ã¤ãã¦ã®èª¬
SRE NEXT 2024 ã®çºè¡¨è³æã§ãã https://sre-next.dev/2024/schedule/#jp041 ãåéã¨éã¹ããã¾ãå ´ã¢ã㪠ãã©ã¬ã«ãã§ã¯ãã¯ã©ã¦ããã³ãã¼ã«ããä¸å®æã¡ã³ããã³ã¹ãå£ç¯ã¤ãã³ãã«ããã¢ã¯ã»ã¹æ¥å¢ã«ãã£ã¦ãã¼ã¿ãã¼ã¹ãä¸å®å®ã«ãªããæçµçã«ãµã¼â¦
ãDevelopers Summit 2024 Summerãã§ã®çºè¡¨è³æã§ãã
é©ç¨å¯¾è±¡: SQL Server Azure Data Factory ã® SSIS Integration Runtime ç·©ããã«å¤åãããã£ã¡ã³ã·ã§ã³å¤æã¯ããã¼ã¿ ã¦ã§ã¢ãã¦ã¹ã®ãã£ã¡ã³ã·ã§ã³ ãã¼ãã«å ã«ãããã¬ã³ã¼ãã®æ´æ°ããã³æ¿å ¥ã調æ´ãã¾ãã ãã¨ãã°ããã®å¤æã使ç¨ããã¨ãAdventureWorks OLTP ãã¼ã¿ãã¼ã¹ã® Production.Products ãã¼ãã«ã«ãããã¼ã¿ã使ã£ã¦ AdventureWorksDW2022 ãã¼ã¿ãã¼ã¹ã® DimProduct ãã¼ãã«ã«æ¿å ¥ãæ´æ°ãè¡ãå¤æåºåãæ§æã§ãã¾ãã ç·©ããã«å¤åãããã£ã¡ã³ã·ã§ã³å¤æã«ã¯ãç·©ããã«å¤åãããã£ã¡ã³ã·ã§ã³ã管çããããã®ã次ã®æ©è½ãç¨æããã¦ãã¾ãã åä¿¡ããè¡ãåç §ãã¼ãã«å ã®è¡ã¨ç §åããæ°ããè¡ããã³æ¢åã®è¡ãèå¥ãã¾ãã å¤æ´ã許å¯ããã¦ããªãå ´åã«ãå¤æ´ãå«ã¾ããåä¿¡è¡ãè
ã¹ã¿ã¼ã¹ãã¼ã(åºç¤) ã®è¨äºã®ç¥èãåæã¨ãã¦ãã¾ãã ãã£ã¡ã³ã·ã§ã³ãã¼ãã«ã®ã½ã¼ã¹ã¨ãªããã¼ã¿ã¯ãéç¨ãã¦ããæ¥åã·ã¹ãã ã®ãã®ã§ããããããã®ãã¼ã¿ã¯ããã¼ã¿ã¦ã§ã¢ãã¦ã¹ã«ç§»ãããããããã®ãã£ã¡ã³ã·ã§ã³ãã¼ãã«ã«æ ¼ç´ãããã ãããããã®æ å ±ã¯éç¨ã®éç¨ã§å¤æ´ããããã¨ããããä¾ãã°ãä¼å¡ã®çå¹´ææ¥ãç´ããããä½æå¤æ´ãªã©ã§ããããã®æã«éç¨ã·ã¹ãã å´ã¯ãå¤æ´å±¥æ´ã追ãããã«ãããã¾ãã¯ç´ ç´ã«ä¸æ¸ããã¦ãããããããã«ãã¦ãããã£ã¡ã³ã·ã§ã³ãã¼ãã«ã¯ãã©ã®ããã«åæãããããã«ãã£ã¦ãå¤æ´ã«å¯¾å¿ãããã¨ãå¿ è¦ã«ãªãã ãã£ã¡ã³ã·ã§ã³ã®è¨è¨ã«ããã¦ãã½ã¼ã¹ãã¼ã¿ã®å¤æ´ãã©ã®ããã«è¡¨ç¾ãããã決ãããã¨ã¯éè¦ã§ããããããã¹ãã¼ã»ãã§ã³ã¸ã»ãã£ã¡ã³ã·ã§ã³ãã¨å¼ã¶ãããã¯ãã¡ã¯ãã«æ¯ã¹ãã¨ãã£ã¡ã³ã·ã§ã³ã¯ãã£ããã¨å¤æ´ããããã¨ããç±æ¥ãã¦ããã ãã¼ã¿å¤æ´ããããå ´åãæ§ã ãªå¯¾å¿ãè
ãã㯠Livesense Advent Calendar 2022 DAY 4 ã®è¨äºã§ãã ããã«ã¡ã¯ãã¢ã«ãã¤ãäºæ¥é¨ã¨ã³ã¸ãã¢ã®@mnmandahalfã§ãã ä»æ¥ã¯å æ¥éå¬ããã社å LT大ä¼ã§è©±ãããã¿ãè¨äºã«ãã¦ã¿ããã¨æãã¾ãã VPoEã ãã追ãåºãããï¼ï¼ã¨ã³ã¸ãã¢LT大ä¼ãéå¬ãã話 - LIVESENSE ENGINEER BLOG TL;DR ã¯ãã¹ã¢ã«ã¦ã³ãã§æå·åããRDSã¹ãããã·ã§ãããå ±æããã¨ãã¯CMKã§æå·åããæ¹ããã¿ã¼ CMKãä½ãã¨ãã®ãã¼ããªã·ã¼ã«æ³¨æããã ããããã£ãã㨠ãã£ãã説æããã¨ã以ä¸ã®éãã§ãã æ¬çªç°å¢ï¼ä»¥ä¸ãAWSã®productionã¢ã«ã¦ã³ãï¼ã®DBãã¼ã¿ãã¹ãã¼ã¸ã³ã°ç°å¢ï¼ä»¥ä¸ãAWSã®stagingã¢ã«ã¦ã³ãï¼ã«æ¥æ¬¡ã§åæãã¦å©ç¨ããã ãã®éãå人æ å ±çã«ã¢ã¯ã»ã¹ã§ããªãããã«ãã¹ãã³ã°å¦çï¼ä¾ï¼ãã¼ã¿ã®åé¤ãæ¹
å¼ç¤¾ã§ã¯ä¼ç¤¾å ¨ä½ã§ï¼ã¤ã®ã¢ã«ã¦ã³ããå ±æãã¦ãã¾ãããã管çãé¢åï¼ã©ã®é¨ç½²ãã©ãã使ã£ã¦ããã®ããã£ã±ãåãããï¼ãã¨ããè¦æ ãå¢ãã¦ãããããé¨ç½²ãã¨ã«ã¢ã«ã¦ã³ããåããäºã«ãªã Aurora 移è¡ã®ä½æ¥ãæ¯ãããããæé ãã¾ã¨ãã¾ããã AWS ããã¥ã¢ã«ãç¢ºèª ããã¥ã¢ã«è¦ã¦ãã¨æåã¹ãããã·ã§ãããå ±æããã ãã£ã½ãã®ã§ç°¡åã ãªï¼ã¨æã£ã¦ãã¾ãããå½ç¶ãããªã«ä¸æãè¡ããâ¦ããã©ã«ãKMSãã¼ã§æå·åããã¦ãããããå¥ã¢ã«ã¦ã³ãã¸ã®å ±æãä¸å¯ã«ãªã£ã¦ãã¾ãããã㨠KMS ãã¼ãå¥éçºè¡ãã¦å¥ã¢ã«ã¦ã³ãã«å ±æãã¦ããå¿ è¦ãããã£ã½ãã ããã©ã«ãã® Amazon RDS æå·åãã¼ã使ç¨ããªããæå·åãããæåã¹ãããã·ã§ããã¯å ±æã§ãã¾ãããã ããã¾ã AWS Key Management Service (AWS KMS) ãã¼ããã¹ãããã·ã§ãããå ±æããã¢ã«ã¦ã³ãã¨å ±æã
翻訳ã¯æ©æ¢°ç¿»è¨³ã«ããæä¾ããã¦ãã¾ããæä¾ããã翻訳å 容ã¨è±èªçã®éã§é½é½¬ãä¸ä¸è´ã¾ãã¯çç¾ãããå ´åãè±èªçãåªå ãã¾ãã ãã¼ã¿ã®çµå Amazon ã®çµåã¤ã³ã¿ã¼ãã§ã¤ã¹ã使ç¨ã㦠QuickSight ã1 ã¤ä»¥ä¸ã®ãã¼ã¿ã½ã¼ã¹ãããªãã¸ã§ã¯ããçµåã§ãã¾ããAmazon ã使ç¨ãã¦ãã¼ã¿ã QuickSight çµåãããã¨ã§ãç°ãªãã½ã¼ã¹ãããã¼ã¿ãè¤è£½ãããã¨ãªããç°ãªããã¼ã¿ããã¼ã¸ã§ãã¾ãã çµåããããã¼ã¿ã»ããã®ã¿ã¤ã çµå㯠2 ã¤ã® QuickSight è«çãã¼ãã« éã§å®è¡ãããåè«çãã¼ãã«ã«ã¯ãã¼ã¿ã®åå¾æ¹æ³ã«é¢ããæ å ±ãå«ã¾ãã¾ããã§ãã¼ã¿ã»ãããç·¨éããå ´å QuickSightããã¼ã¸ã®ä¸ååã®çµåå³ã«ã¯ãåè«çãã¼ãã«ãé·æ¹å½¢ã®ãããã¯ã¨ãã¦è¡¨ç¤ºããã¾ãã çµåãã¼ã¿ã»ããã«ã¯ã QuickSightåä¸ã½ã¼ã¹ã¨ã¯ãã¹ã½ã¼ã¹ã® 2 ã¤ã®ç°ãªãã¿ã¤ã
ã¯ããã« MySQL8.0 ã使ã£ãã¦ããããã¹ããã©ãã«ãé ãã®ã§ãæ°ã«ãªã£ã¦è¨æ¸¬ãã¦ã¿ããç¹ã« Truncate ãé ãæ°ãããã®ã§æ¤è¨¼ã MySQL5.7(5.7.44)㨠MySQL8.0(8.0.28)ã§æ¯è¼ããã æ¤è¨¼ã³ã¼ã iwahara/mysql_performance: è¨äºç¨ã®ããã©ã¼ãã³ã¹è¨æ¸¬ã³ã¼ã æ¤è¨¼ç¨ãã¼ãã« æ¤è¨¼ã«ä½¿ããã¼ãã«å®ç¾©ã¯ä»¥ä¸ã®éãã主ãã¼ã®ã¿ã®ãã¼ãã«ã¨ãindex ãï¼ã¤ãï¼ã¤ãï¼ã¤è¨å®ãããã¼ãã«ãç¨æããã ç §åé åºã¯æãã¦ããã CREATE TABLE `no_index` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(256) NOT NULL, `code1` varchar(8) NOT NULL, `code2` varchar(8) NOT NU
Photo by Rubaitul Azad on Unsplashã¯ããã«ããã«ã¡ã¯ã2021å¹´4æã«Finatextã«æ°åã§å ¥ç¤¾ããã¾ããªã3å¹´ç®ã«ãªãToshiya Matsuzakiã§ãããµã¼ãã¼ãµã¤ãã¨ã³ã¸ãã¢ã¨ãã¦ãAWSã§ã®ã¤ã³ãã©æ§ç¯ã¨Goã«ããã·ã¹ãã éçºãè¡ã£ã¦ãã¾ãã å æ¥ãMySQL5.7ç³»äºæã§ããAmazon Aurora v2ã使ç¨ãã¦ãããªãªã¼ã¹åã®ãããã¯ãã®ãã¼ã¿ãã¼ã¹ããMySQL8.0ç³»äºæã§ããAmazon Aurora v3ã«ã¢ããã°ã¬ã¼ãããéã«ãäºæãã¬ãã°ãçºçãã¾ããã調ã¹ãã¨ãããMySQL5.7ãã8.0ã¸ã®ã¢ããã°ã¬ã¼ãã«å«ã¾ãã¦ããç ´å£çå¤æ´ç¹ã«ãããã®ã§ããã ããã§ãä»åã®ãã°ããå¾ãå¦ã³ã¨å¯¾å¿æ¹æ³ã«ã¤ãã¦æ¸ãããã¨æãã¾ããç¾å¨ç¨¼åãã¦ããã·ã¹ãã ã«å¯¾ãã¦ãMySQL5.7ç³»ãã8.0ç³»ã«ã¢ããã°ã¬ã¼ãããããã¨ãæ¤è¨ãã¦ã
Aurora MySQL ãã¼ã¸ã§ã³ 2 ã¯ã©ã¹ã¿ã¼ããã¼ã¸ã§ã³ 3 ã«ã¢ããã°ã¬ã¼ãããéã«æ³¨æãã¹ãå¤æ´ã«ã¤ãã¦ã¯ã以ä¸ãåç §ãã¦ãã ããã Aurora MySQL ãã¼ã¸ã§ã³ 2 㨠3 ã®ç¹å¾´ã®éã 次㮠Amazon Aurora MySQL æ©è½ã¯ Aurora MySQL 5.7 ã§ãµãã¼ãããã¦ãã¾ããããããã®æ©è½ã¯ç¾å¨ MySQL 8.0 ã® Aurora MySQL ã§ã¯ãµãã¼ãããã¦ãã¾ããã Aurora Serverless v1 ã¯ã©ã¹ã¿ã¼ã« Aurora MySQL ãã¼ã¸ã§ã³ 3 ã使ç¨ãããã¨ã¯ã§ãã¾ãããAurora MySQL ãã¼ã¸ã§ã³ 3 㯠Aurora Serverless v2 ã§åä½ãã¾ãã ã©ãã¢ã¼ã㯠Aurora MySQL ãã¼ã¸ã§ã³ 3 ã«ã¯é©ç¨ããã¾ãããAurora MySQL ãã¼ã¸ã§ã³ 3 ã«ã¯ãã©ãã¢ã¼ãã®æ©è½ã¯ãã
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}