FirestoreからAlloyDBにサービス無停止で移行した話

Google Cloud主催のAlloyDB Case Study Meetupにて発表

Transcript

1. © 2 0 23 Bitkey Inc. 'JSFTUPSF͔Β"MMPZ%#ʹ
   αʔϏεແఀࢭͰҠߦͨ͠࿩ גࣜձࣾϏοτΩʔ
   71
   PG
   5FDIOPMPHZ
   ന໦
   ޹య "MMPZ%#
   $BTF
   4UVEZ
   .FFUVQ
2. © 2 0 23 Bitkey Inc. ന໦
   ޹య 5BLBOPSJ
   4IJSBLJ 2 2018 8 GCP Firebase Web Firestore AlloyDB
3. © 2 0 23 Bitkey Inc. 0VUMJOF  Ҡߦͷഎܠ
    "MMPZ%#Λ࠾༻ͨ͠ཧ༝
    ͲͷΑ͏ʹҠߦ͔ͨ͠
    ݁Ռ 3
4. © 2 0 23 Bitkey Inc. Ҡߦͷഎܠ 4
5. © 2 0 23 Bitkey Inc. 5 © 2 0 23 Bitkey Inc.
6. © 2 0 23 Bitkey Inc. 6 ➢ 
 ➢ ➢ ࣄલʹݤΛ౉͢͜ͱ͕؆୯ʹͰ͖Ε͹
   ͜ΕΒΛશͯղܾͰ͖Δɻ
7. © 2 0 23 Bitkey Inc. ͳͥɺ'JSFTUPSFͩͬͨͷ͔ ͳͥɺͦΕ͚ͩͩͱ೉͘͠ͳ͍ͬͯͬͨͷ͔ 7
8. © 2 0 23 Bitkey Inc. Firestore OK 8
9. © 2 0 23 Bitkey Inc. 9 RDBMS NewSQL
10. © 2 0 23 Bitkey Inc. "MMPZ%#Λ࠾༻ͨ͠ཧ༝ 1 0
11. © 2 0 23 Bitkey Inc. AlloyDBΛ࠾༻ͨ͠ཧ༝ 1 1 AlloyDB β / Cloud SQL / Cloud Spanner ͜ͷ3ͭΛൺֱ
12. © 2 0 23 Bitkey Inc. AlloyDBΛ࠾༻ͨ͠ཧ༝ 1 2 ➢ Cloud SQL PostgreSQL ➢ ➢ ➢ GA Cloud SQL
13. © 2 0 23 Bitkey Inc. AlloyDBΛ࠾༻ͨ͠ཧ༝ 1 3 ➢ DB ➢ Cloud SQL ➢ ➢ ➢ Spanner Spannerͱൺ΂ͯ
14. © 2 0 23 Bitkey Inc. ͲͷΑ͏ʹҠߦ͔ͨ͠ 1 4
15. © 2 0 23 Bitkey Inc. 1 5 ίϨΫγϣϯ୯ҐͷҠߦܭըʹͨ͠ ܭըॳظ AlloyDB͕·ͩβͩͬͨͨΊ Firestore͔ΒCloud SQLʹҠߦ AlloyDBͷGAޙ Cloud SQL͸ ͢΂ͯAlloyDBʹҠߦ Ҏ߱… Firestore͔ΒAlloyDB΁ͷҠߦΛܧଓ 1 . Firestore 2 . 3 . 4 .
16. © 2 0 23 Bitkey Inc. 1 6 Cloud SQL͔ΒAlloyDB ؆୯͔ͭɺ៉ྷʹ׬ྃʂ Database Migration Service DB AlloyDB
17. © 2 0 23 Bitkey Inc. 1 7 Firestore͔ΒAlloyDB มߋͷಉظΛ։࢝ͨ͠ޙɺطଘΛҠߦ͢Δͱ͍͏ॱ൪Ͱ࿙ΕΛͳͨ͘͠
18. © 2 0 23 Bitkey Inc. 1 8 ϦΞϧλΠϜಉظʹ͍ͭͯ Firestore AlloyDB ➢ ➢ ➢ ➢ 'JSFTUPSF͕มߋ͞ΕΔͱ"MMPZ%#ʹ
    ಉظ͞ΕΔΑ͏ʹɻ
19. © 2 0 23 Bitkey Inc. 1 9 طଘσʔλͷϚΠάϨʔγϣϯʹ͍ͭͯ Firestore AlloyDB γϯϓϧ
    ͕ͩྔ͕ଟ͍ͷͰɺ
    ్தͰதஅͯ͠΋࠶։Ͱ͖ΔΑ͏ʹɻ
20. © 2 0 23 Bitkey Inc. 2 0 ิ଍ɿϚΠάϨʔγϣϯະ࣮ࢪͷظؒͷϦΞϧλΠϜಉظʹ͍ͭͯ update delete
21. © 2 0 23 Bitkey Inc. 2 1 ͜͜·ͰͰ'JSFTUPSFͱ"MMPZ%#ͷͲͪΒ͔ΒͰ΋ɺ
    ৗʹಉ౳ͷ৘ใΛऔΓग़ͤΔঢ়ଶʹͳͬͨɻ Firestore AlloyDB Firestore AlloyDB
22. © 2 0 23 Bitkey Inc. ৼΓฦͬͯΈͯ 2 2
23. © 2 0 23 Bitkey Inc. 2 3 ೉͔ͬͨ͜͠ͱ ➢ ➢ ➢ EFMFUFJOTFSU΍ͦΕΒ൑ఆͷͨΊͷࣄલTFMFDUͱ͍ͬͨແବ͸ڐ༰
    ಉظΛܦ༝͠ͳ͘ͳΕ͹ૣ͘ͳΔͨΊɺҠߦظؒதݶఆͷ࿩ͱ͍͏ׂΓ੾Γ
24. © 2 0 23 Bitkey Inc. 2 4 ➢ ➢ ➢ ➢ ྑ͔ͬͨ͜ͱ
25. © 2 0 23 Bitkey Inc. 2 5 AlloyDB