$30 off During Our Annual Pro Sale. View Details »

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

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

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

More Decks by 株式会社ビットキー / Bitkey Inc.

Other Decks in Technology

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