Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Sign up for free
Menu
Search
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Pricing
Search
Sign in
Sign up for free
FirestoreからAlloyDBにサービス無停止で移行した話
Search
Sponsored
·
Ship Features Fearlessly
Turn features on and off without deploys. Used by thousands of Ruby developers.
→
株式会社ビットキー / Bitkey Inc.
PRO
August 03, 2023
Technology
650
0
Share
Embed
Copy iframe code
Copy JS code
Copy link
Start on current slide
FirestoreからAlloyDBにサービス無停止で移行した話
Google Cloud主催のAlloyDB Case Study Meetupにて発表
株式会社ビットキー / Bitkey Inc.
PRO
August 03, 2023
Transcript
26 slides
© 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
More Decks by 株式会社ビットキー / Bitkey Inc.
See All by 株式会社ビットキー / Bitkey Inc.
デザイナーとして体験を磨き込むためのエンジニアリング / Engineering as a Designer: Polishing the Experience
bitkey
PRO
0
34
スマートロックを支えるFlutter × ネイティブ連携の実践 / Flutter and Native Integration in Practice: Powering Smart Locks
bitkey
PRO
0
200
関数型ドメインモデリングの理想と現実 / Domain Modeling Made Functional: Ideals vs. Reality
bitkey
PRO
0
150
10年後、Engineering 行為を剥奪されるとして、わたしたちは、どう、何を創ればいいだろうか。 / If Engineering Is Taken Away in 10 Years, How and What Should We Create?
bitkey
PRO
1
340
Flutter × BLE Centralを自前Pluginで実装する設計パターン - MethodChannel / EventChannelで作る双方向ブリッジの実践 / Building Custom Flutter BLE Central Plugins: Bidirectional Bridging with Method & Event Channels
bitkey
PRO
0
510
Swift&Xcodeのバージョンアップにまつわる怖かった思い出 / Scary Memories of Swift and Xcode Updates
bitkey
PRO
0
250
iOS/Androidの二刀流エンジニアがFlutter & TypeScriptへ越境後の現在地 - Flutterがメインになって見えた景色と現在の醍醐味 / Dual-Platform Mobile Engineer Shifts to Flutter & TypeScript - The View and Real Thrill of Going Flutter-First
bitkey
PRO
0
700
個人開発で育てる「大規模設計の苗床」 - AI時代の1人開発から始める業務への知識接続 / The Seedbed for Large-Scale Design - From AI-Era Solo Projects to Professional Knowledge
bitkey
PRO
1
650
失敗を経て、Harness Engineering で 大切にしたいことを考える / Learning from Failure: What Matters in Harness Engineering
bitkey
PRO
1
720
Other Decks in Technology
See All in Technology
Kiro を使うコツ (頼み方、覚えさせ方、任せ方) | 目指せ Kiro マスター 09
inariku
PRO
3
170
こんなに変わった! AWSネットワークの常識
shotashiratori
10
6.7k
Oracle Base Database Service 技術詳細
oracle4engineer
PRO
17
120k
3文字略語に騙されない! 世界一わかりやすい『EDR』超入門
kamadamakoto
1
180
Quick Automate | 目指せ Quick マスター 12
inariku
PRO
1
120
エンタープライズ事業未経験のデータ屋、 AI時代にN回撃沈する.pdf
ryoskdara_
0
130
少ない人手 限られた予算 それでも守る 消せない・見つける・戻れる オールハザード型BCP on AWS / 20261107 Mitsutoshi Matsuo
shift_evolve
PRO
0
390
Linuxネットワークスタック進化の軌跡: 過去10年の歩みと最新トレンド
orimanabu
4
730
小さなエージェントから始めてみよう!実践コンテキストエンジニアリング
iwamot
PRO
0
130
Go初心者のクラウドエンジニアが、デプロイを通して旨味を知っていく話
ryudai
1
230
_マネジメントする人される人ナイト_2026__良いチームを作っていきたい_お気持ち_.pdf
xkxaxkx
0
650
LLM 基盤と kagent v0 を全部 k8s に入れてみた / Deploy both LLM and kagent v0 in k8s
kota2and3kan
0
230
Featured
See All Featured
Paper Plane (Part 1)
katiecoart
PRO
3
12k
Organizational Design Perspectives: An Ontology of Organizational Design Elements
kimpetersen
PRO
1
880
Claude Code のすすめ
schroneko
67
230k
The Art of Programming - Codeland 2020
erikaheidi
57
14k
Exploring the Power of Turbo Streams & Action Cable | RailsConf2023
kevinliebholz
37
6.7k
Impact Scores and Hybrid Strategies: The future of link building
tamaranovitovic
0
480
Music & Morning Musume
bryan
48
7.5k
Tell your own story through comics
letsgokoyo
1
1.1k
16th Malabo Montpellier Forum Presentation
akademiya2063
PRO
0
460
Rebuilding a faster, lazier Slack
samanthasiow
85
9.8k
Introduction to Domain-Driven Design and Collaborative software design
baasie
1
1.1k
Leadership Guide Workshop - DevTernity 2021
reverentgeek
1
430