Google Cloud主催のAlloyDB Case Study Meetupにて発表
©2 023Bitkey Inc.'JSFTUPSF͔Β"MMPZ%#ʹαʔϏεແఀࢭͰҠߦͨ͠גࣜձࣾϏοτΩʔ71PG5FDIOPMPHZനయ"MMPZ%#$BTF4UVEZ.FFUVQ
View Slide
©2 023Bitkey Inc.നయ5BLBOPSJ4IJSBLJ22018 8GCP FirebaseWebFirestore AlloyDB
©2 023Bitkey Inc.0VUMJOF Ҡߦͷഎܠ "MMPZ%#Λ࠾༻ͨ͠ཧ༝ ͲͷΑ͏ʹҠߦ͔ͨ͠ ݁Ռ3
©2 023Bitkey Inc.Ҡߦͷഎܠ4
©2 023Bitkey Inc.5©2 023Bitkey Inc.
©2 023Bitkey Inc.6 ➢ ➢➢ࣄલʹݤΛ͢͜ͱ͕؆୯ʹͰ͖Ε͜ΕΒΛશͯղܾͰ͖Δɻ
©2 023Bitkey Inc.ͳͥɺ'JSFTUPSFͩͬͨͷ͔ͳͥɺͦΕ͚ͩͩͱ͘͠ͳ͍ͬͯͬͨͷ͔7
©2 023Bitkey Inc.Firestore OK8
©2 023Bitkey Inc.9 RDBMS NewSQL
©2 023Bitkey Inc."MMPZ%#Λ࠾༻ͨ͠ཧ༝10
©2 023Bitkey Inc.AlloyDBΛ࠾༻ͨ͠ཧ༝11AlloyDB β / Cloud SQL / Cloud Spanner͜ͷ3ͭΛൺֱ
©2 023Bitkey Inc.AlloyDBΛ࠾༻ͨ͠ཧ༝12➢ Cloud SQL PostgreSQL➢➢➢ GACloud SQL
©2 023Bitkey Inc.AlloyDBΛ࠾༻ͨ͠ཧ༝13➢ DB➢ Cloud SQL➢➢➢ SpannerSpannerͱൺͯ
©2 023Bitkey Inc.ͲͷΑ͏ʹҠߦ͔ͨ͠14
©2 023Bitkey Inc.15ίϨΫγϣϯ୯ҐͷҠߦܭըʹͨ͠ܭըॳظAlloyDB͕·ͩβͩͬͨͨΊFirestore͔ΒCloud SQLʹҠߦAlloyDBͷGAޙCloud SQLͯ͢AlloyDBʹҠߦҎ߱…Firestore͔ΒAlloyDBͷҠߦΛܧଓ1. Firestore2.3.4.
©2 023Bitkey Inc.16Cloud SQL͔ΒAlloyDB؆୯͔ͭɺ៉ྷʹྃʂDatabase Migration ServiceDBAlloyDB
©2 023Bitkey Inc.17Firestore͔ΒAlloyDBมߋͷಉظΛ։࢝ͨ͠ޙɺطଘΛҠߦ͢Δͱ͍͏ॱ൪Ͱ࿙ΕΛͳͨ͘͠
©2 023Bitkey Inc.18ϦΞϧλΠϜಉظʹ͍ͭͯFirestore AlloyDB➢➢➢➢'JSFTUPSF͕มߋ͞ΕΔͱ"MMPZ%#ʹಉظ͞ΕΔΑ͏ʹɻ
©2 023Bitkey Inc.19طଘσʔλͷϚΠάϨʔγϣϯʹ͍ͭͯFirestore AlloyDBγϯϓϧ͕ͩྔ͕ଟ͍ͷͰɺ్தͰதஅͯ͠࠶։Ͱ͖ΔΑ͏ʹɻ
©2 023Bitkey Inc.20ิɿϚΠάϨʔγϣϯະ࣮ࢪͷظؒͷϦΞϧλΠϜಉظʹ͍ͭͯupdate delete
©2 023Bitkey Inc.21͜͜·ͰͰ'JSFTUPSFͱ"MMPZ%#ͷͲͪΒ͔ΒͰɺৗʹಉͷใΛऔΓग़ͤΔঢ়ଶʹͳͬͨɻFirestoreAlloyDBFirestoreAlloyDB
©2 023Bitkey Inc.ৼΓฦͬͯΈͯ22
©2 023Bitkey Inc.23͔ͬͨ͜͠ͱ➢➢➢EFMFUFJOTFSUͦΕΒఆͷͨΊͷࣄલTFMFDUͱ͍ͬͨແବڐ༰ಉظΛܦ༝͠ͳ͘ͳΕૣ͘ͳΔͨΊɺҠߦظؒதݶఆͷͱ͍͏ׂΓΓ
©2 023Bitkey Inc.24➢➢➢➢ྑ͔ͬͨ͜ͱ
©2 023Bitkey Inc.25AlloyDB