[B! TiDB] nekoruriã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

nekoruri id:nekoruri

TiDBã«é–¢ã™ã‚‹nekoruriã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

å¤šæ®µProxySQLã«ã‚ˆã‚‹ã‚¹ã‚ãƒ¼ãƒžçµ±åˆãŠã‚ˆã³TiDBç§»è¡Œ | ãƒ¡ãƒ«ã‚«ãƒªã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°
Mercari DBRE(DataBase Reliability Engineering Team)ã®taka-hã§ã™ã€‚ æœ¬ã‚¨ãƒ³ãƒˆãƒªã§ã¯ã€ãƒ¡ãƒ«ã‚«ãƒªã®é–‹ç™ºç’°å¢ƒã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç§»è¡Œã®äº‹ä¾‹ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ãªãŠè¨˜äº‹ã¯ã€MySQL Advent Calendar 2024ã€ãŠã‚ˆã³TiDB Advent Calendar 2024ã¨ã®ã‚¯ãƒã‚¹ãƒã‚¹ãƒˆã«ãªã‚Šã¾ã™ã€‚ ã“ã®è¨˜äº‹ã®æ‰‹æ³•ã‚’ç”¨ã„ã¦ã€é–‹ç™ºç’°å¢ƒã§ã¯ã€MySQLã‹ã‚‰TiDBã¸ç§»è¡Œã™ã‚‹ã¨åŒæ™‚ã«ã€ã‚¹ã‚ãƒ¼ãƒžçµ±åˆã™ã‚‹ã¨ã„ã†ã“ã¨ã‚’é”æˆã—ã¦ã„ã¾ã™ã€‚æœ¬è¨˜äº‹ã«ã‚ˆã‚Šã€èªè€…ã®æ–¹ã€…ãŒProxySQLã‚„ã€TiDBã®ã‚¨ã‚³ã‚·ã‚¹ãƒ†ãƒ ã«èˆˆå‘³ã‚’æŒã£ã¦ã„ãŸã ã‘ã‚‹ã“ã¨ã‚’æœŸå¾…ã—ã¦ã„ã¾ã™ã€‚ TL;DR TiDBã®Data Migration(ä»¥å¾Œã€TiDB DMã¨å‘¼ã³ã¾ã™)ã®Table Routingã‚’ç”¨ã„ã‚‹ã¨ã€TiDBã«ã‚¹ã‚ãƒ¼ãƒžçµ±åˆã—ãŸã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚’ä½œæˆã§ãã‚‹ 2æ®µã®ProxySQLã‚’æ§‹æˆã—ã€1æ®µ
nekoruri 2024/12/19
database

mysql

tidb

proxysql
ãƒªãƒ³ã‚¯
TiDBã«ã¯é¢ç™½ã„ä»•æ§˜/æ©Ÿèƒ½ãŒè‰²ã€…ã‚ã‚‹ã¨ã„ã†è©± - pospomeã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°æ—¥è¨˜
TiDBã‚’è§¦ã£ã¦ã¿ã¦å€‹äººçš„ã«é¢ç™½ã„ã¨æ€ã£ãŸã‚‚ã®ã‚’é›‘ã«ã¾ã¨ã‚ã¾ã™ã€‚ TiDBã®ã“ã¨ã¯ã‚ã‚‹ç¨‹åº¦çŸ¥ã£ã¦ã„ã‚‹äººå‘ã‘ã®è©±ã§ã™ã€‚ HTAPï¼ˆTiFlashï¼‰ ãƒªã‚½ãƒ¼ã‚¹åˆ¶å¾¡æ©Ÿèƒ½ Stale Read Follower Read ãƒ—ãƒƒã‚·ãƒ¥ãƒ€ã‚¦ãƒ³ ãƒ¬ã‚³ãƒ¼ãƒ‰TTL ã‚³ãƒ¡ãƒ³ãƒˆæ§‹æ–‡ sync-diff-inspector ãƒãƒ¼ã‚«ãƒ«PCã§TiDBã‚’èµ·å‹•ã™ã‚‹ ã¾ã¨ã‚ HTAPï¼ˆTiFlashï¼‰ TiDBã¨ã„ãˆã°ã€HTAPãŒæœ‰åã ã¨æ€ã†ã€‚ https://docs.pingcap.com/ja/tidb/stable/explore-htap https://docs.pingcap.com/ja/tidbcloud/tiflash-overview TiDBãŒè‹¦æ‰‹ã¨ã™ã‚‹OLAPã‚’é«˜é€Ÿã«å‡¦ç†ã™ã‚‹ãŸã‚ã«ã€ TiFlashã¨ã„ã†åˆ—æŒ‡å‘NoSQLã‚’å¤–ä»˜ã‘ã—ã€ OLAPç³»ã®ã‚¯ã‚¨ãƒªã‚’ãã“ã«å¯¾ã—ã¦å®Ÿè¡Œã™ã‚‹ã¨ã„ã†ã€ ãªã‚“ã¨ã‚‚åŠ›æŠ€æ„ŸãŒ
nekoruri 2024/08/21
tidb
ãƒªãƒ³ã‚¯
Serverless Meetup Re:boot ç¦å²¡ TiDB Serverlessã®ç´¹ä»‹
nekoruri 2024/02/17
serverless

TiDB

mysql

serverlessfukuoka
ãƒªãƒ³ã‚¯
TiDB Cloud CLI (ticloud) ã®ç´¹ä»‹ - Qiita
ã¯ã˜ã‚ã« TiDB Serverlessã¯å®Ÿã¯CLIã‹ã‚‰ã‚‚æ“ä½œã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ã“ã®è¨˜äº‹ã§ã¯ä¾¿åˆ©ãªTiDB Cluod CLIã®ç´¹ä»‹ã‚’ã—ã¾ã™ã€‚MacOSã‚’åˆ©ç”¨ã—ã¦ã„ã¾ã™ãŒã€Linux/WSLã§ã‚‚åŒã˜ã‚ˆã†ã«ä½¿ãˆã‚‹ã¨æ€ã„ã¾ã™ã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¨è¨å®š TiDB Cloud CLIã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« TiDB Cloud CLIã®ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã†æ–¹æ³•ã¨ã€TiUPã‚’åˆ©ç”¨ã™ã‚‹æ–¹æ³•ãŒã‚ã‚Šã¾ã™ã€‚TiUPã‚’åˆ©ç”¨ã—ãŸå ´åˆã¯TiUPã®ã‚µãƒ–ã‚³ãƒžãƒ³ãƒ‰ã¨ã—ã¦åˆ©ç”¨ã™ã‚‹ã“ã¨ã«ãªã‚Šã¾ã™ã€‚ä»Šå›žã¯ã€ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ãƒ„ãƒ¼ãƒ«ã‚’åˆ©ç”¨ã—ã¦ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ã—ã¾ã™ã€‚ã‚¿ãƒ¼ãƒŸãƒŠãƒ«ã‹ã‚‰curlã§ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’å–å¾—ã—å®Ÿè¡Œã—ã¾ã™ã€‚ curl https://raw.githubusercontent.com/tidbcloud/tidbcloud-cli/main/install.sh | sh
nekoruri 2024/02/12
æ™®é€šã«ã§ããŒè‰¯ã•ãã†

TiDB
ãƒªãƒ³ã‚¯
1