Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
FirestoreからAlloyDBにサービス無停止で移行した話
Search
株式会社ビットキー / Bitkey Inc.
PRO
August 03, 2023
Technology
0
310
FirestoreからAlloyDBにサービス無停止で移行した話
Google Cloud主催のAlloyDB Case Study Meetupにて発表
株式会社ビットキー / Bitkey Inc.
PRO
August 03, 2023
Tweet
Share
More Decks by 株式会社ビットキー / Bitkey Inc.
See All by 株式会社ビットキー / Bitkey Inc.
Pointer と向き合う / Facing the Pointer
bitkey
PRO
0
12
Best of こんなTypeScriptは嫌だ! / I don't like this TypeScript
bitkey
PRO
1
29
こんなTypeScriptはいやだ! / I hate this kind of TypeScript!
bitkey
PRO
0
58
DevOpsDays Tokyo 2024 〜デジタルとアナログのはざまに〜 スマートビルディング爆速開発を支える 自動化テスト戦略 / DevOpsDays Tokyo 2024 - Between Digital and Analog - Automated Testing Strategies to Support Smart Building Development.
bitkey
PRO
0
14
マルチプラットフォームを見据えるiOSのTCA設計|Designing iOS Apps with TCA for Multi-Platform Strategies
bitkey
PRO
2
97
また輝く瞳を取り戻すために / To get your eyes shining again.
bitkey
PRO
0
25
“持続可能な”開発を実現するためにスタートアップで実践したこと / What we did at the start to achieve 'sustainable' development.
bitkey
PRO
0
90
エンジニアのマネジメントキャリアにおける技術広報 / Technical Public Relations in Developers' Management Careers
bitkey
PRO
0
73
リリース速度10倍を実現したビットキー流DevOps - Argo CD との付き合い方 - / Bitkey-style DevOps with 10X faster release speed - How to work with Argo CD -
bitkey
PRO
0
270
Other Decks in Technology
See All in Technology
Dungeons and Dragons and Rails
joelq
0
230
動画配信サービスのフロントエンド実装に学ぶ設計原則
yud0uhu
0
130
大規模言語モデル (LLM)における低精度数値表現
pfn
PRO
3
800
PhpStorm超絶技巧40分集中講義 #phpconkagawa
yusuke
4
720
「できる!」を増やすGitHub Copilot活用法 / How to use GitHub Copilot to expand your possibilities
sansan_randd
1
230
TailwindCSSでUIライブラリを作る際のハマりどころ
shuta13
0
230
cgroup v2 で何が変わったのか / TechFeed Experts Night #28
tenforward
2
160
スムーズなエントリーで滞在を心地よくスタート_team 1@NOT A HOTEL
satomifukuda
0
100
パフォーマンス最適化のベストプラクティス
databricksjapan
0
200
【TSkaigi】2024/05/11 当日スライド
kimitashoichi
14
3.9k
能動学習のいろは:書籍「Human-in-the-Loop機械学習」3〜5章
hiroyoshiito
0
290
20240509 CloudWatch でいろいろなものを監視してみよう
masaruogura
1
120
Featured
See All Featured
Scaling GitHub
holman
457
140k
The Success of Rails: Ensuring Growth for the Next 100 Years
eileencodes
34
6.1k
"I'm Feeling Lucky" - Building Great Search Experiences for Today's Users (#IAC19)
danielanewman
221
21k
Done Done
chrislema
178
15k
VelocityConf: Rendering Performance Case Studies
addyosmani
321
23k
Unsuck your backbone
ammeep
664
57k
10 Git Anti Patterns You Should be Aware of
lemiorhan
649
58k
In The Pink: A Labor of Love
frogandcode
138
21k
Designing for Performance
lara
601
67k
Design and Strategy: How to Deal with People Who Don’t "Get" Design
morganepeng
117
18k
Designing Dashboards & Data Visualisations in Web Apps
destraynor
226
51k
The Language of Interfaces
destraynor
151
23k
Transcript
© 2 0 23 Bitkey Inc. 'JSFTUPSF͔Β"MMPZ%#ʹ αʔϏεແఀࢭͰҠߦͨ͠ גࣜձࣾϏοτΩʔ 71PG5FDIOPMPHZ
നయ "MMPZ%#$BTF4UVEZ.FFUVQ
© 2 0 23 Bitkey Inc. നయ 5BLBOPSJ4IJSBLJ 2 2018
8 GCP Firebase Web Firestore AlloyDB
© 2 0 23 Bitkey Inc. 0VUMJOF Ҡߦͷഎܠ
"MMPZ%#Λ࠾༻ͨ͠ཧ༝ ͲͷΑ͏ʹҠߦ͔ͨ͠ ݁Ռ 3
© 2 0 23 Bitkey Inc. Ҡߦͷഎܠ 4
© 2 0 23 Bitkey Inc. 5 © 2 0
23 Bitkey Inc.
© 2 0 23 Bitkey Inc. 6 ➢ ➢
➢ ࣄલʹݤΛ͢͜ͱ͕؆୯ʹͰ͖Ε ͜ΕΒΛશͯղܾͰ͖Δɻ
© 2 0 23 Bitkey Inc. ͳͥɺ'JSFTUPSFͩͬͨͷ͔ ͳͥɺͦΕ͚ͩͩͱ͘͠ͳ͍ͬͯͬͨͷ͔ 7
© 2 0 23 Bitkey Inc. Firestore OK 8
© 2 0 23 Bitkey Inc. 9 RDBMS NewSQL
© 2 0 23 Bitkey Inc. "MMPZ%#Λ࠾༻ͨ͠ཧ༝ 1 0
© 2 0 23 Bitkey Inc. AlloyDBΛ࠾༻ͨ͠ཧ༝ 1 1 AlloyDB
β / Cloud SQL / Cloud Spanner ͜ͷ3ͭΛൺֱ
© 2 0 23 Bitkey Inc. AlloyDBΛ࠾༻ͨ͠ཧ༝ 1 2 ➢
Cloud SQL PostgreSQL ➢ ➢ ➢ GA Cloud SQL
© 2 0 23 Bitkey Inc. AlloyDBΛ࠾༻ͨ͠ཧ༝ 1 3 ➢
DB ➢ Cloud SQL ➢ ➢ ➢ Spanner Spannerͱൺͯ
© 2 0 23 Bitkey Inc. ͲͷΑ͏ʹҠߦ͔ͨ͠ 1 4
© 2 0 23 Bitkey Inc. 1 5 ίϨΫγϣϯ୯ҐͷҠߦܭըʹͨ͠ ܭըॳظ
AlloyDB͕·ͩβͩͬͨͨΊ Firestore͔ΒCloud SQLʹҠߦ AlloyDBͷGAޙ Cloud SQL ͯ͢AlloyDBʹҠߦ Ҏ߱… Firestore͔ΒAlloyDBͷҠߦΛܧଓ 1 . Firestore 2 . 3 . 4 .
© 2 0 23 Bitkey Inc. 1 6 Cloud SQL͔ΒAlloyDB
؆୯͔ͭɺ៉ྷʹྃʂ Database Migration Service DB AlloyDB
© 2 0 23 Bitkey Inc. 1 7 Firestore͔ΒAlloyDB มߋͷಉظΛ։࢝ͨ͠ޙɺطଘΛҠߦ͢Δͱ͍͏ॱ൪Ͱ࿙ΕΛͳͨ͘͠
© 2 0 23 Bitkey Inc. 1 8 ϦΞϧλΠϜಉظʹ͍ͭͯ Firestore
AlloyDB ➢ ➢ ➢ ➢ 'JSFTUPSF͕มߋ͞ΕΔͱ"MMPZ%#ʹ ಉظ͞ΕΔΑ͏ʹɻ
© 2 0 23 Bitkey Inc. 1 9 طଘσʔλͷϚΠάϨʔγϣϯʹ͍ͭͯ Firestore
AlloyDB γϯϓϧ͕ͩྔ͕ଟ͍ͷͰɺ ్தͰதஅͯ͠࠶։Ͱ͖ΔΑ͏ʹɻ
© 2 0 23 Bitkey Inc. 2 0 ิɿϚΠάϨʔγϣϯະ࣮ࢪͷظؒͷϦΞϧλΠϜಉظʹ͍ͭͯ update
delete
© 2 0 23 Bitkey Inc. 2 1 ͜͜·ͰͰ'JSFTUPSFͱ"MMPZ%#ͷͲͪΒ͔ΒͰɺ ৗʹಉͷใΛऔΓग़ͤΔঢ়ଶʹͳͬͨɻ
Firestore AlloyDB Firestore AlloyDB
© 2 0 23 Bitkey Inc. ৼΓฦͬͯΈͯ 2 2
© 2 0 23 Bitkey Inc. 2 3 ͔ͬͨ͜͠ͱ ➢
➢ ➢ EFMFUFJOTFSUͦΕΒఆͷͨΊͷࣄલTFMFDUͱ͍ͬͨແବڐ༰ ಉظΛܦ༝͠ͳ͘ͳΕૣ͘ͳΔͨΊɺҠߦظؒதݶఆͷͱ͍͏ׂΓΓ
© 2 0 23 Bitkey Inc. 2 4 ➢ ➢
➢ ➢ ྑ͔ͬͨ͜ͱ
© 2 0 23 Bitkey Inc. 2 5 AlloyDB
None