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
360
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.
スタートアップにおける Platform Engineering の 片鱗 / A glimpse of platform engineering in startups
bitkey
PRO
2
110
Node.js のサーバーをなるべく自動生成に頼って Go にリプレイスした話 / A story about replacing a Node.js server with Go, relying on automatic generation as much as possible.
bitkey
PRO
2
92
スマートロック開発におけるSLI/SLOを用いた解錠体験の改善 / Improving the unlocking experience using SLI/SLO in smart lock development
bitkey
PRO
3
190
Bitkeyのモバイルアプリを進化させるための歩き方 / Walking the evolution of Bitkey's mobile apps
bitkey
PRO
1
290
Pointer と向き合う / Facing the Pointer
bitkey
PRO
1
46
Best of こんなTypeScriptは嫌だ! / I don't like this TypeScript
bitkey
PRO
1
69
こんなTypeScriptはいやだ! / I hate this kind of TypeScript!
bitkey
PRO
0
100
DevOpsDays Tokyo 2024 〜デジタルとアナログのはざまに〜 スマートビルディング爆速開発を支える 自動化テスト戦略 / DevOpsDays Tokyo 2024 - Between Digital and Analog - Automated Testing Strategies to Support Smart Building Development.
bitkey
PRO
0
120
マルチプラットフォームを見据えるiOSのTCA設計|Designing iOS Apps with TCA for Multi-Platform Strategies
bitkey
PRO
2
120
Other Decks in Technology
See All in Technology
AOAI Dev Day - Opening Session
yoshidashingo
2
470
LLMアプリケーションの評価の実践と課題 ~PharmaXにおける今後の展望~
pharma_x_tech
2
170
【基調講演】変える、今ここから ― IoTとAIで紡ぐ未来
soracom
PRO
0
320
データベース研修 分析向けSQL入門【MIXI 24新卒技術研修】
mixi_engineers
PRO
0
110
データベース研修 DB基礎【MIXI 24新卒技術研修】
mixi_engineers
PRO
0
220
ここがすごいよ! AWS Systems Manager!
saichan11
0
1.8k
さらに高品質・高速化を目指すAI時代のテスト設計支援と、めざす先 / AI Test Lab vol.1
shift_evolve
0
190
What if...? 처음부터 다시 LLM 어플리케이션을 개발한다면
huffon
0
1k
データ分析基盤を作ってみよう~設計編~
nrinetcom
PRO
1
110
簡単に始めるSnowflakeの機械学習
nayuts
1
190
20240724_cm_odyssey_hibiyatech
hiashisan
0
110
コンテナ・K8s研修 - 前半 コンテナ基礎・ハンズオン【MIXI 24新卒技術研修】
mixi_engineers
PRO
0
170
Featured
See All Featured
RailsConf & Balkan Ruby 2019: The Past, Present, and Future of Rails at GitHub
eileencodes
129
32k
Templates, Plugins, & Blocks: Oh My! Creating the theme that thinks of everything
marktimemedia
23
1.9k
The Psychology of Web Performance [Beyond Tellerrand 2023]
tammyeverts
24
1.8k
Web development in the modern age
philhawksworth
203
10k
Designing Experiences People Love
moore
136
23k
Creatively Recalculating Your Daily Design Routine
revolveconf
214
11k
Gamification - CAS2011
davidbonilla
78
4.9k
Ruby is Unlike a Banana
tanoku
96
10k
[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails
eileencodes
17
1.5k
The Cost Of JavaScript in 2023
addyosmani
31
4.7k
Visualizing Your Data: Incorporating Mongo into Loggly Infrastructure
mongodb
36
9.1k
GraphQLとの向き合い方2022年版
quramy
36
13k
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