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

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

Transcript

1. ©
   2 0
   23
   Bitkey Inc.
   'JSFTUPSF͔Β"MMPZ%#ʹ
   αʔϏεແఀࢭͰҠߦͨ͠࿩
   גࣜձࣾϏοτΩʔ
   71PG5FDIOPMPHZ
   ന໦޹య
   "MMPZ%#$BTF4UVEZ.FFUVQ
   

   View Slide

2. ©
   2 0
   23
   Bitkey Inc.
   ന໦޹య
   5BLBOPSJ4IJSBLJ
   2
   2018 8
   
   
   GCP Firebase
   
   
   Web
   
   
   
   
   Firestore AlloyDB
   

   View Slide

3. ©
   2 0
   23
   Bitkey Inc.
   0VUMJOF
   Ҡߦͷഎܠ
   "MMPZ%#Λ࠾༻ͨ͠ཧ༝
   ͲͷΑ͏ʹҠߦ͔ͨ͠
   ݁Ռ
   3
   

   View Slide

4. ©
   2 0
   23
   Bitkey Inc.
   Ҡߦͷഎܠ
   4
   

   View Slide

5. ©
   2 0
   23
   Bitkey Inc.
   5
   ©
   2 0
   23
   Bitkey Inc.
   

   View Slide

6. ©
   2 0
   23
   Bitkey Inc.
   6
   
   ➢
   

   
   
   ➢
   
   
   ➢
   ࣄલʹݤΛ౉͢͜ͱ͕؆୯ʹͰ͖Ε͹
   ͜ΕΒΛશͯղܾͰ͖Δɻ
   

   View Slide

7. ©
   2 0
   23
   Bitkey Inc.
   ͳͥɺ'JSFTUPSFͩͬͨͷ͔
   ͳͥɺͦΕ͚ͩͩͱ೉͘͠ͳ͍ͬͯͬͨͷ͔
   7
   

   View Slide

8. ©
   2 0
   23
   Bitkey Inc.
   Firestore
   
   
   
   
   
   
   
   
   OK
   8
   

   View Slide

9. ©
   2 0
   23
   Bitkey Inc.
   9
   
   RDBMS NewSQL
   
   
   
   
   
   

   View Slide

10. ©
    2 0
    23
    Bitkey Inc.
    "MMPZ%#Λ࠾༻ͨ͠ཧ༝
    1
    0
    

    View Slide

11. ©
    2 0
    23
    Bitkey Inc.
    AlloyDBΛ࠾༻ͨ͠ཧ༝
    1
    1
    AlloyDB β / Cloud SQL / Cloud Spanner
    ͜ͷ3ͭΛൺֱ
    

    View Slide

12. ©
    2 0
    23
    Bitkey Inc.
    AlloyDBΛ࠾༻ͨ͠ཧ༝
    1
    2
    ➢ Cloud SQL PostgreSQL
    
    
    ➢
    
    
    ➢
    
    
    ➢ GA
    Cloud SQL
    

    View Slide

13. ©
    2 0
    23
    Bitkey Inc.
    AlloyDBΛ࠾༻ͨ͠ཧ༝
    1
    3
    ➢ DB
    
    
    ➢ Cloud SQL
    
    
    ➢
    
    
    ➢
    
    
    ➢ Spanner
    Spannerͱൺ΂ͯ
    

    View Slide

14. ©
    2 0
    23
    Bitkey Inc.
    ͲͷΑ͏ʹҠߦ͔ͨ͠
    1
    4
    

    View Slide

15. ©
    2 0
    23
    Bitkey Inc.
    1
    5
    ίϨΫγϣϯ୯ҐͷҠߦܭըʹͨ͠
    ܭըॳظ
    
    
    AlloyDB͕·ͩβͩͬͨͨΊ
    
    
    Firestore͔ΒCloud SQLʹҠߦ
    AlloyDBͷGAޙ
    
    
    Cloud SQL͸
    
    
    ͢΂ͯAlloyDBʹҠߦ
    Ҏ߱…
    
    
    Firestore͔ΒAlloyDB΁ͷҠߦΛܧଓ
    1
    . Firestore
    
    
    2
    .
    
    
    3
    .
    
    
    4
    .
    

    View Slide

16. ©
    2 0
    23
    Bitkey Inc.
    1
    6
    Cloud SQL͔ΒAlloyDB
    ؆୯͔ͭɺ៉ྷʹ׬ྃʂ
    Database Migration Service
    DB
    
    
    AlloyDB
    

    View Slide

17. ©
    2 0
    23
    Bitkey Inc.
    1
    7
    Firestore͔ΒAlloyDB
    มߋͷಉظΛ։࢝ͨ͠ޙɺطଘΛҠߦ͢Δͱ͍͏ॱ൪Ͱ࿙ΕΛͳͨ͘͠
    

    View Slide

18. ©
    2 0
    23
    Bitkey Inc.
    1
    8
    ϦΞϧλΠϜಉظʹ͍ͭͯ
    Firestore
    
    
    
    AlloyDB
    
    
    ➢
    
    
    ➢
    
    
    ➢
    
    
    ➢
    'JSFTUPSF͕มߋ͞ΕΔͱ"MMPZ%#ʹ
    ಉظ͞ΕΔΑ͏ʹɻ
    

    View Slide

19. ©
    2 0
    23
    Bitkey Inc.
    1
    9
    طଘσʔλͷϚΠάϨʔγϣϯʹ͍ͭͯ
    Firestore AlloyDB
    γϯϓϧ͕ͩྔ͕ଟ͍ͷͰɺ
    ్தͰதஅͯ͠΋࠶։Ͱ͖ΔΑ͏ʹɻ
    

    View Slide

20. ©
    2 0
    23
    Bitkey Inc.
    2
    0
    ิ଍ɿϚΠάϨʔγϣϯະ࣮ࢪͷظؒͷϦΞϧλΠϜಉظʹ͍ͭͯ
    update delete
    
    
    

    View Slide

21. ©
    2 0
    23
    Bitkey Inc.
    2
    1
    ͜͜·ͰͰ'JSFTUPSFͱ"MMPZ%#ͷͲͪΒ͔ΒͰ΋ɺ
    ৗʹಉ౳ͷ৘ใΛऔΓग़ͤΔঢ়ଶʹͳͬͨɻ
    Firestore
    AlloyDB
    Firestore
    
    
    AlloyDB
    
    
    
    

    View Slide

22. ©
    2 0
    23
    Bitkey Inc.
    ৼΓฦͬͯΈͯ
    2
    2
    

    View Slide

23. ©
    2 0
    23
    Bitkey Inc.
    2
    3
    ೉͔ͬͨ͜͠ͱ
    ➢
    
    
    ➢
    
    
    ➢
    EFMFUFJOTFSU΍ͦΕΒ൑ఆͷͨΊͷࣄલTFMFDUͱ͍ͬͨແବ͸ڐ༰
    ಉظΛܦ༝͠ͳ͘ͳΕ͹ૣ͘ͳΔͨΊɺҠߦظؒதݶఆͷ࿩ͱ͍͏ׂΓ੾Γ
    

    View Slide

24. ©
    2 0
    23
    Bitkey Inc.
    2
    4
    ➢
    
    
    ➢
    
    
    ➢
    
    
    ➢
    ྑ͔ͬͨ͜ͱ
    

    View Slide

25. ©
    2 0
    23
    Bitkey Inc.
    2
    5
    AlloyDB
    
    
    
    
    
    
    
    
    
    
    

    View Slide

26. View Slide