社内アプリで Cloudflare D1を プロダクト運用してみた体験談(Tokyo)

Transcript

1. Haochen Kotoi-Xie on 2024-04-12 (bd15w5) ࣾ಺ΞϓϦͰ Cloudflare D1Λ ϓϩμΫτӡ༻ͯ͠Έͨମݧஊ @Cloudflare Meetup Nagoya @ฐࣾ Haochen Kotoi-Xie on 2024-04-24 (bd17w3) @Cloudflare Meetup Tokyo ϋΦνΣϯ
2. Cloudflare D1࢖ͬͯΈͨ ࠷ۙ GA ʹͳͬͨ
3. + 㱺 Cloudflare D1 ͬ͘͟Γ D1
4. 㱺 Cloudflare D1 Region = Global! ΦϨϯδ৭ͷ SQLite! ͬ͘͟Γ D1 +
5. ެࣜʹΑΔͱ? Cloudflare D1 ग़య: https://www.cloudflare.com/developer-platform/d1/
6. ฐࣾ homepage: kxc.inc • Target: ʮଧࠁγεςϜʯ • Status: ϓϩμΫγϣϯӡ༻ • Tech Stack: Workers + D1 • Complexity: ௿͍ • Total Satisfaction: ·͊·͊ • Code Matuality: ࡶ • Code Performance: ͱͯ΋Α͍ D1 ࢖ͬͯΈͨ
7. ฐࣾ homepage: kxc.inc • Target: ʮଧࠁγεςϜʯ • Status: ϓϩμΫγϣϯӡ༻ • Tech Stack: Workers + D1 • Complexity: ௿͍ • Total Satisfaction: ·͊·͊ • Code Matuality: ࡶ • Code Performance: ͱͯ΋Α͍ ར༻Πϝʔδ D1 ࢖ͬͯΈͨ KXC Utility Shell made with OCaml
8. ฐࣾ homepage: kxc.inc • Target: ʮଧࠁγεςϜʯ • Status: ϓϩμΫγϣϯӡ༻ • Tech Stack: Workers + D1 • Complexity: ௿͍ • Total Satisfaction: ·͊·͊ • Code Matuality: ࡶ • Code Performance: ͱͯ΋Α͍ ར༻Πϝʔδ D1 ࢖ͬͯΈͨ Web൛΋͋ΔΑ͒ " KXC Utility Shell made with OCaml
9. D1 ࢖ͬͯΈͨ • Target: ʮଧࠁγεςϜʯ • Status: ϓϩμΫγϣϯӡ༻ • Tech Stack: Workers + D1 (+ ZT) • Code Matuality: Ұ੾࠷దԽͯ͠ͳ͍ • Complexity: ௿͍ • System Performance: ͱͯ΋Α͍ # • User Satisfaction: ͱͯ΋ߴ͍ $ ฐࣾ homepage: kxc.inc
10. ར༻Πϝʔδʢଧࠁʣ Request Journey 1. Cmd: ʮpunch ...ʯ 2. HTTP POST 㱺
 api1.kxc.inc/worklogger/v0/punching 3. ZT 㱺 Cloudflare Workers (api1.kxc.inc)
 ɹ㱺 Cloudflare D1 db = env.D1_WORKLOGGER st = db.prepare(`...sql..(?, ?, ?1)..`)
 .bind(param1, param2) await db.exec(st) D1 ࢖ͬͯΈͨ 1෼ؒͰ෼͔Δ D1 db = env.D1_WORKLOGGER st = db.prepare(`...sql..(?, ?, ?1)..`)
 .bind(param1, param2) await db.exec(st)
11. ར༻Πϝʔδʢଧࠁʣ Request Journey 1. Cmd: ʮpunch ...ʯ 2. HTTP POST 㱺
 api1.kxc.inc/worklogger/v0/punching 3. ZT 㱺 Cloudflare Workers (api1.kxc.inc)
 ɹ㱺 Cloudflare D1 db = env.D1_WORKLOGGER st = db.prepare(`...sql..(?, ?, ?1)..`)
 .bind(param1, param2) await db.exec(st) D1 ࢖ͬͯΈͨ 1෼ؒͰ෼͔Δ D1 db = env.D1_WORKLOGGER st = db.prepare(`...sql..(?, ?, ?1)..`)
 .bind(param1, param2) await db.exec(st)
12. ײ૝ • ͱʹ͔͘࢖͍΍͍͢ (Workers ͔Βͩͱ) • ૣ͍! ͍҆! • 㱺 listing ͷࡶίʔυͰ΋ CPU Time ~30ms • ~2,200ߦ૯ͳΊ + JSσʔλ͝ʹΐ͝ʹΐ, etc • D1 latency 2ܻmsɺແࢹͰ͖ΔϨϕϧ ར༻Πϝʔδʢlistingʣ D1 ࢖ͬͯΈͨ
13. Usage Stat ײ૝ • ͱʹ͔͘࢖͍΍͍͢ (Workers ͔Βͩͱ) • ૣ͍! ͍҆! • 㱺 listing ͷࡶίʔυͰ΋ CPU Time ~30ms • ~2,200ߦ૯ͳΊ + JSσʔλ͝ʹΐ͝ʹΐ, etc • D1 latency 2ܻmsɺແࢹͰ͖ΔϨϕϧ • 1೔ >5k Request Ͱ΋ແྉʹͳΔݟࠐΈ (Paid Workers) • ࠷େ 1 DB 10GB ·ͰΒ͍͠ • Transaction ͳ͍ͷ͕ਏ͍.. (SQLite ͳͷͰɺ stored function ΋ͳ͍..) • Batch ͞Εͨ΋ͷ͸ 1 txn Ͱ͕͢.. D1 ࢖ͬͯΈͨ (ݱঢ়794.62k; @04/24 18:36) ୯७ܭࢉͩͱ ͋ͱ75,950೥͍͚Δ!
14. • 1DB 10GB ·Ͱ! (ࠓ·Ͱ 100MB → 1GB) • λΠϜτϥϕϧ! • σʔλ Export / Import ※ͳΜͱࠓ·ͰͰ͖ͳ͔ͬͨ :D • άϩʔόϧɾϨϓϦΧ to come • Account͝ͱ: 50,000 DB! (max storage = 250GB) ※ιϑτϦϛοτΒ͍͠ • ແྉͰ࢝ΊΒΕΔ! • ແྉ࿮: 10DB, 500MB/DB, 5GB/Account, 5M read /day, 100K write /day ࠷ۙ GA (General Available) ʹͳͬͨΒ͍͠ Cloudflare D1
15. Cloudflare D1 ݁࿦ (Txn ͸΄͍͚͠Ͳ..) D1 ͸͍͍ͧ!
16. Cloudflare D1 Region = Global! ΦϨϯδ৭ͷ SQLite! ͓ΘΓ
17. Bonus Smart Placement Δ࣮ଌ Source: ຊ೔ Cloudflare Developers Discord #d1-database