[B! database] krrrrã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

krrrr id:krrrr

databaseã«é–¢ã™ã‚‹krrrrã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (11)

${{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}}

ã¯ã¦ãªãƒ–ãƒã‚°ã® DB ã‚’ RDS for MySQL 8.0 ã«ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã—ãŸè©± - Hatena Developer Blog
ã“ã®è¨˜äº‹ã¯ã€ã¯ã¦ãª ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ Advent Calendar 2023ã®2024å¹´1æœˆ17æ—¥ã®è¨˜äº‹ã§ã™ã€‚ ã¯ã¦ãª ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ Advent Calendar 2023 - Hatena Developer Blog id:hagihala ã§ã™ã€‚å…ˆæ—¥ã€ã¯ã¦ãªãƒ–ãƒã‚°ã® DB ã‚’ RDS for MySQL 5.7 ã‹ã‚‰ 8.0 ã¸ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã—ãŸã®ã§ã€å·¥å¤«ã—ãŸç‚¹ãªã©ã‚’å…±æœ‰ã—ã¾ã™ã€‚ Aurora MySQL 3.x ã«ã—ãªã‹ã£ãŸç†ç”± MySQL 5.7 -> 8.0 ã§å¯¾å¿œã—ãŸå¤‰æ›´ç‚¹ character set ã‚„ collation ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆãŒå¤‰æ›´ã•ã‚Œã‚‹ explicit_defaults_for_timestamp ãŒãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§æœ‰åŠ¹ã«ãªã‚‹ SQL mode ã®å¤‰æ›´ ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®èªè¨¼ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ãŒ caching_sha2_password ã«ãªã‚Šã€ mysql_native_passw
krrrr 2024/01/20
RDS

mysql

database

aws
ãƒªãƒ³ã‚¯
Join the preview of Amazon Aurora Limitless Database | Amazon Web Services
AWS News Blog Join the preview of Amazon Aurora Limitless Database Today, we are announcing the preview of Amazon Aurora Limitless Database, a new capability supporting automated horizontal scaling to process millions of write transactions per second and manage petabytes of data in a single Aurora database. Amazon Aurora read replicas allow you to increase the read capacity of your Aurora cluster
krrrr 2023/11/28
amazon

database

aurora
ãƒªãƒ³ã‚¯
Skeema.io
Skeema is a pure-SQL schema management utility. Simply track your desired schema state in a repo of CREATE statements, and the tool figures out how to apply any changes to your tables and routines. You won't need to code migrations, use obscure DSLs, or write verbose XML ever again. Skeemaâ€™s open source CLI tool supports all modern versions of MySQL, MariaDB, and Percona Server. Written in Golang,
krrrr 2022/10/23
mysql

SQL

database
ãƒªãƒ³ã‚¯
Announcing D1: our first SQL database
We announced Cloudflare Workers in 2017, giving developers access to compute on our network. We were excited about the possibilities this unlocked, but we quickly realized â€” most real world applications are stateful. Since then, weâ€™ve delivered KV, Durable Objects, and R2, giving developers access to various types of storage. Today, we're excited to announce D1, our first SQL database. While the w
krrrr 2022/05/12
database

CDN

CloudFlare
ãƒªãƒ³ã‚¯
MySQLã§INå¥ã®ä¸ã«å¤§é‡ã®å€¤ã®å…¥ã£ãŸã‚¯ã‚¨ãƒªãŒãƒ•ãƒ«ã‚¹ã‚ãƒ£ãƒ³ã‚’èµ·ã“ã™è©± - freee Developers Hub
ã“ã‚“ã«ã¡ã¯ã€freee Developers Advent Calendar 2021ã€19æ—¥ç›®ã®id:shallow1729ã§ã™ã€‚æ˜¨æ—¥ã¯tdtdsã•ã‚“ã§ã€ãƒžã‚¸ã§ã€‘ã‚µã‚¤ãƒãƒ¼æ¼”ç¿’ã‚·ãƒŠãƒªã‚ªã®ä½œã‚Šæ–¹ã€æ€–ã„ã€‘ã§ã—ãŸï¼éšœå®³è¨“ç·´å¾Œã«æ”»æ’ƒæ–¹æ³•ã‚’è§£èª¬ã•ã‚ŒãŸæ™‚ã¯ãƒªã‚¢ãƒªãƒ†ã‚£ã®é«˜ã•ã«é©šãã¾ã—ãŸã€‚ åƒ•ã¯MySQLã‚’ä½¿ã£ã¦ã„ã¦ç™ºç”Ÿã—ãŸä¸æ€è°ãªæŒ™å‹•ã®èª¿æŸ»ã®è©±ã‚’ã—ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ ä»Šå›žå•é¡Œã¨ãªã£ãŸã‚¯ã‚¨ãƒª ä»Šå›žè©±é¡Œã«ã™ã‚‹ã‚¯ã‚¨ãƒªã¯ä»¥ä¸‹ã®ã‚ˆã†ãªã‚·ãƒ³ãƒ—ãƒ«ãªã‚‚ã®ã§ã™ã€‚ SELECT * FROM hoge WHERE id IN (...) MySQLã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ãƒ¼æ¬¡ç¬¬ã§ã™ãŒã€ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®è¨å®šã ã¨ã“ã®INå¥ã®ä¸ã®å€¤ã®æ•°ãŒæ•°ä¸‡ã«ãªã‚‹ã¨é©åˆ‡ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒç”¨æ„ã•ã‚Œã¦ã„ã¦ã‚‚ãƒ•ãƒ«ã‚¹ã‚ãƒ£ãƒ³ãŒç™ºç”Ÿã™ã‚‹äº‹ãŒã‚ã‚Šã¾ã—ãŸã€‚ã“ã®ã‚¯ã‚¨ãƒªãŒãƒ†ãƒ¼ãƒ–ãƒ«ã®ã»ã¨ã‚“ã©ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’ç¶²ç¾…ã™ã‚‹ã‚ˆã†ãªå ´åˆã‚„é«˜é€Ÿã§ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’å¤§é‡ã«insertã—ã¦çµ±è¨ˆæƒ…å ±ãŒè¿½ã„ã¤ã‹ãªã„ã‚±ãƒ¼
krrrr 2021/12/19
é™çš„è§£æžã§åˆ†å‰²ã—ã¦ãªã„ã¨CIã§ã‚¨ãƒ©ãƒ¼ã«ã™ã‚‹ã¿ãŸã„ãªlintå…¥ã‚ŒãŸã‚Šã—ã¦å¯¾å¿œã—ã¦ã‚‹ã‚“ã ã‘ã©ã€ä»–ã®çš†ã©ã†ã—ã¦ã‚“ã®

mysql

SQL

performance

database
ãƒªãƒ³ã‚¯
Bizgram (ãƒ“ã‚ºã‚°ãƒ©ãƒ ) | ãƒ“ã‚¸ãƒã‚¹ãƒ¢ãƒ‡ãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
Bizgram (ãƒ“ã‚ºã‚°ãƒ©ãƒ ) ã¯ãƒ“ã‚¸ãƒã‚¹ãƒ¢ãƒ‡ãƒ«ã‚’å›³è§£ã§ç´¹ä»‹ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã™ã€‚ãƒ“ã‚¸ãƒã‚¹ãƒ¢ãƒ‡ãƒ«2.0å›³é‘‘ã‚’åŸ·ç†ã—ãŸæ ªå¼ä¼šç¤¾å›³è§£ç·ç ”ãŒé‹å–¶ã—ã¦ã„ã¾ã™ã€‚
krrrr 2021/09/23
database
ãƒªãƒ³ã‚¯
Why Uber Engineering Switched from Postgres to MySQL
Weâ€™ve represented the old version in red and the new row version in green. Under the hood, Postgres uses another field holding the row version to determine which tuple is most recent. This added field letsÂ the database determine which row tuple to serve to a transaction that may not be allowed to see the latest row version. With Postgres, the primary index and secondary indexes all point directly
krrrr 2021/08/18
mysql

postgresql

database
ãƒªãƒ³ã‚¯
Pythonã§MySQLã®ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚°ã‚’é›†è¨ˆ | å¤–é“çˆ¶ã®åŒ
ä¹…ã€…ã«æºœã¾ã£ãŸãƒ–ãƒã‚°ãƒã‚¿æ”¾å‡ºã‚’ã—ã‚ˆã†ã‹ãªã¨ã€ãã®å‰ã«ä¸‹æ›¸ãã‹ã‚‰æŽ˜ã‚Šèµ·ã“ã—ã¦ããŸã€ã„ã¾ã•ã‚‰ãªã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªé–¢é€£ã§æº–å‚™é‹å‹•ã§ã™ã€‚ RDSã®ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªæƒ…å ±ã¯å½“ç„¶ã€é›†è¨ˆã‚’è‡ªå‹•åŒ–ã—ã¦ã„ã¤ã§ã‚‚è¦‹ã‚Œã‚‹ã‚ˆã†ã«ã—ã¦ã‚ã‚‹ã®ã§ã™ãŒã€ã¡ã‚‡ã„ã¨å¿…è¦ãŒã‚ã£ãŸã®ã§ã€ä»Šå›žã¯ã‚ãˆã¦å˜ç™ºãƒã‚°ã‚’é›†è¨ˆã™ã‚‹å½¢ã«åˆ‡ã‚Šå‡ºã—ãŸã‚‚ã®ã‚’ç”¨æ„ã—ã¦ã¿ã¾ã—ãŸã€‚ ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚°ã®å¿…è¦æ€§ æœ€è¿‘ã¯NewRelicã¨ã‹ã§ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®å‡¦ç†ã‚’åˆ†åˆ¥ã—ã¦å‡¦ç†æ™‚é–“ãªã©ã‚’é›†è¨ˆã™ã‚‹ã®ã§ã€ãã‚Œã§èª²é¡Œã¨ãªã‚‹ã‚¯ã‚¨ãƒªã‚’ç¢ºèªã—ãŸã‚Šã‚‚ã—ã¾ã™ã€‚ éžå¸¸ã«ä¾¿åˆ©ãªä»•çµ„ã¿ã§ã™ãŒã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å¤–ã®ã‚¸ãƒ§ãƒ–ãªã©ãŒå®Ÿè¡Œã—ãŸã‚¯ã‚¨ãƒªã¯é›†è¨ˆã•ã‚Œãªã„ã“ã¨ã‚„ã€è² è·è©¦é¨“ã§èª²é¡Œã‚’ç‚™ã‚Šå‡ºã™ã¨ãã ã¨ãƒ†ã‚¹ãƒˆç’°å¢ƒã«ã‚¨ãƒ¼ã‚¸ã‚§ãƒ³ãƒˆã‚„ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’ä»•è¾¼ã‚€å¿…è¦ãŒã‚ã‚‹ã€ã¨ã„ã£ãŸãƒ‡ãƒ¡ãƒªãƒƒãƒˆã¨ã¾ã§ã¯è¨€ã‚ãªã„ã¾ã§ã‚‚é¢å€’ã•ãŒã‚ã‚Šã¾ã™ã€‚ ãã®ç‚¹ã€ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªã¯ã‚µãƒ¼ãƒãƒ¼å´ã§è¨˜éŒ²ã™ã‚‹ã‚‚ã®ãªã®ã§ã€0.1ç§’ã¨ã‹ã§ONã«ã—ã¦ãŠã‘ã°ã€å¯¾è±¡
krrrr 2021/08/09
mysql

database
ãƒªãƒ³ã‚¯
October 21 post-incident analysis | The GitHub Blog
AI & MLLearn about artificial intelligence and machine learning across the GitHub ecosystem and the wider industry. Generative AILearn how to build with generative AI. GitHub CopilotChange how you work with GitHub Copilot. LLMsEverything developers need to know about LLMs. Machine learningMachine learning tips, tricks, and best practices. How AI code generation worksExplore the capabilities and be
krrrr 2021/07/04
incident

éšœå®³

database
ãƒªãƒ³ã‚¯
Building globally distributed MySQL applications using write forwarding in Amazon Aurora Global Database | Amazon Web Services
AWS Database Blog Building globally distributed MySQL applications using write forwarding in Amazon Aurora Global Database AWS released Amazon Aurora Global Database in 2018. Aurora Global Database enables two primary use cases. The first use case is supporting a disaster recovery solution that can handle a full regional failure with a low recovery point objective (RPO) and a low recovery time obj
krrrr 2020/06/22
aws

database
ãƒªãƒ³ã‚¯
GitHub - Percona-Lab/mysql_random_data_load: MySQL random data loader
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
krrrr 2019/07/06
mysql

database
ãƒªãƒ³ã‚¯
1