Repro ã§éé‡ã—㟠Aurora MySQL ã«ã¾ã¤ã‚るトラブル 5 é¸ - Repro Tech Blogã“ã‚“ã«ã¡ã¯ã€Platform Team ã®è’引 (@a_bicky) ã§ã™ã€‚å‰å›žã¯ç¶šãƒ»ä½•ã§ã‚‚屋ã«ãªã£ã¦ã„ã‚‹ SRE çš„ãªãƒãƒ¼ãƒ ã‹ã‚‰è²¬å‹™ã‚’分離ã™ã‚‹ã¾ã§ã®é“ã®ã‚Š 〜新è¨ãƒãƒ¼ãƒ ã§ã‚ªãƒ³ã‚³ãƒ¼ãƒ«ä½“制を構築ã™ã‚‹ã¾ã§ã€œã¨ã„ã†è©±ã‚’書ã„ãŸã‚“ã§ã™ãŒã€ä»Šå›žã¯ Repro ã®é‹ç”¨ã« 7 年以上æºã‚ã‚‹ä¸ã§ç§ãŒéé‡ã—ã¦å°è±¡çš„ã ã£ãŸ Aurora MySQL 絡ã¿ã®ãƒˆãƒ©ãƒ–ルã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ã€‚ Aurora MySQL ãŒè©°ã¾ã£ã¦ãƒ‡ãƒ¼ã‚¿å‡¦ç†ã®ã‚¹ãƒ«ãƒ¼ãƒ—ットãŒä¸‹ãŒã‚‹ã¨ã‹ã€API ã®ãƒ¬ã‚¹ãƒãƒ³ã‚¹ãŒé…ããªã‚‹ã¨ã‹ã€ALTER TABLE ã™ã‚‹åº¦ã«ã‚¢ãƒ—リケーションエラーãŒç™ºç”Ÿã™ã‚‹ã¨ã‹ã€èƒƒãŒç—›ããªã‚‹èƒ¸ãŒç†±ããªã‚‹è©±ãŒå¤šã„ã®ã§ã€Aurora MySQL を利用ã—ã¦ã„ãªãã¦ã‚‚楽ã—ã‚“ã§ã„ãŸã ã‘ã‚‹ã®ã§ã¯ãªã„ã‹ã¨æ€ã„ã¾ã™ã€‚Aurora MySQL を利用ã—ã¦ã„ã‚‹æ–¹ã§ã‚ã‚Œã°å‚考ã«ãªã‚‹æƒ…å ±ã‚‚ã‚ã‚‹ã§ã—ょã†ã—ã€é€šå¸¸ã® MySQL ã«ã‚‚é©ç”¨å¯èƒ½ãªè©±ã‚‚ã‚ã‚Šã¾ã™
Re: Configuring sql.DB for Better Performance : DSAS開発者ã®éƒ¨å±‹
MySQLã§ãƒ—ライマリã‚ーをUUIDã«ã™ã‚‹å‰ã«çŸ¥ã£ã¦ãŠã„ã¦æ¬²ã—ã„ã“㨠| Raccoon Tech Blog [æ ªå¼ä¼šç¤¾ãƒ©ã‚¯ãƒ¼ãƒ³ãƒ›ãƒ¼ãƒ«ãƒ‡ã‚£ãƒ³ã‚°ã‚¹ 技術戦略部ブãƒã‚°]![MySQLã§ãƒ—ライマリã‚ーをUUIDã«ã™ã‚‹å‰ã«çŸ¥ã£ã¦ãŠã„ã¦æ¬²ã—ã„ã“㨠| Raccoon Tech Blog [æ ªå¼ä¼šç¤¾ãƒ©ã‚¯ãƒ¼ãƒ³ãƒ›ãƒ¼ãƒ«ãƒ‡ã‚£ãƒ³ã‚°ã‚¹ 技術戦略部ブãƒã‚°]](https://cdn-ak-scissors.b.st-hatena.com/image/square/5e9d48c3c6f38c2d5f71897d98efcb251289d1f9/height=288;version=1;width=512/https%3A%2F%2Ftechblog.raccoon.ne.jp%2Fwp-content%2Fuploads%2F2021%2F07%2Fboard-755792_800.jpg)
MySQL ã§ä½¿ç”¨ã™ã‚‹ãƒ¡ãƒ¢ãƒªã‚µã‚¤ã‚ºã®è¦‹ç©ã‚‚ã‚Š - å…ƒRX-7ä¹—ã‚Šã®é©å½“ãªæ—¥ã€…
Goã§SQLã«ãƒˆãƒ¬ãƒ¼ã‚·ãƒ³ã‚°ã‚³ãƒ¡ãƒ³ãƒˆã‚’埋ã‚込んã§å®Ÿè¡Œã™ã‚‹ | ãŠãらãã¯ãã‚Œã•ãˆã‚‚平凡ãªæ—¥ã€…
Googleã€ORMãŒç”Ÿæˆã™ã‚‹SQLãŒé…ã„ã¨ãã®èª¿æŸ»ã‚’容易ã«ã™ã‚‹ã€Œsqlcommenterã€ã‚’オープンソースã§å…¬é–‹ã€‚Railsã€Springã€Djangoãªã©ä¸»è¦ãªãƒ•ãƒ¬ãƒ¼ãƒ ワークã«å¯¾å¿œ
ç†å±ˆã§è€ƒãˆã‚‹ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° | Raccoon Tech Blog [æ ªå¼ä¼šç¤¾ãƒ©ã‚¯ãƒ¼ãƒ³ãƒ›ãƒ¼ãƒ«ãƒ‡ã‚£ãƒ³ã‚°ã‚¹ 技術戦略部ブãƒã‚°]![ç†å±ˆã§è€ƒãˆã‚‹ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° | Raccoon Tech Blog [æ ªå¼ä¼šç¤¾ãƒ©ã‚¯ãƒ¼ãƒ³ãƒ›ãƒ¼ãƒ«ãƒ‡ã‚£ãƒ³ã‚°ã‚¹ 技術戦略部ブãƒã‚°]](https://cdn-ak-scissors.b.st-hatena.com/image/square/2163d340456cff9037bacb3b1e5b6e672b06095e/height=288;version=1;width=512/https%3A%2F%2Ftechblog.raccoon.ne.jp%2Fwp-content%2Fuploads%2F2020%2F10%2Fdb_performance_slides-thumb.jpg)
{{#tags}}- {{label}}
{{/tags}}