ワンキャリアにおける複数 Rails API サーバーの共通データベース運用事例/OneCareer's common database operation for multiple Rails API servers

プロダクト開発部部長の山口が、「プロダクト成長を支える技術選定と開発文化 〜現場の知見LT大会〜」に登壇した際の資料となります。

イベントURL：
https://sansan.connpass.com/event/352765/

Transcript

1. 2025/06/25ɹגࣜձࣾϫϯΩϟϦΞ ࢁޱ୓໻ ϫϯΩϟϦΞʹ͓͚Δෳ਺ Rails API αʔόʔͷ ڞ௨σʔλϕʔεӡ༻ࣄྫ
2. ONE CAREER Inc . Copyright © ONE CAREER Inc. All Rights Reserved. ࣗݾ঺հ Career झຯ ͻͱ͜ͱ 2 ࢁޱ ୓໻ ϓϩμΫτ։ൃ෦ ෦௕ ex޿ࠂ୅ཧళ / ex໊ݹ԰ͷελʔτΞοϓ / ݱ৬ ΞϝϦΧϯϑοτϘʔϧʢ͍·ͩʹݱ໾ʣ ຊ೔͸ΑΖ͓͘͠ئ͍͠·͢ʂ
3. Copyright © ONE CAREER Inc. All Rights Reserved. ໨࣍ • ϫϯΩϟϦΞʹ͍ͭͯ • ϫϯΩϟϦΞͷαʔϏεͱΞʔΩςΫνϟ • ݱঢ়ͷ՝୊ • ࠓޙͷվળʹ޲͚ͯ 3
4. Copyright © ONE CAREER Inc. All Rights Reserved. ໨࣍ • ϫϯΩϟϦΞʹ͍ͭͯ • ϫϯΩϟϦΞͷαʔϏεͱΞʔΩςΫνϟ • ݱঢ়ͷ՝୊ • ࠓޙͷվળʹ޲͚ͯ 4
5. Copyright © ONE CAREER Inc. MISSION ਓͷ਺͚ͩɺ ΩϟϦΞΛͭ͘Δɻ ࢲͨͪϫϯΩϟϦΞ͸ʮਓͷ਺͚ͩɺΩϟϦΞΛͭ͘ΔɻʯΛϛογϣϯʹܝ͛ɺ ݸਓɾاۀ͕࢓ࣄબͼʹؔ͢Δ͋ΒΏΔσʔλΛར༻Ͱ͖ΔϓϥοτϑΥʔϜͱͯ͠3ͭͷαʔϏεΛల։͓ͯ͠Γ·͢ɻ - ͸͡ΊͯͷΩϟϦΞΛબͿɺब׆αΠτʮONE CAREERʯ - ࣍ͷΩϟϦΞ͕ݟ͑Δɺస৬αΠτʮONE CAREER PLUSʯ - ࠾༻׆ಈͷDX1(σδλϧτϥϯεϑΥʔϝʔγϣϯ)ਪਐΛࢧԉ͢ΔʮONE CAREER CLOUDʯ ଟ͘ͷਓʹͱͬͯ࢓ࣄ͸ਓੜͰ࠷΋࣌ؒΛ౤ࢿ͢Δର৅Ͱ͋Δʹ΋ؔΘΒͣɺ ࢓ࣄબͼʹؔͯ͠͸ҙࢥܾఆͷج४ͱͳΔΑ͏ͳσʔλ͕গͳ͘ɺ͍·ͩʹब৬͔ͯ͠Βޙչ͢Δਓ͕ޙΛઈͨͳ͍ঢ়گͰ͢ɻ ࢲͨͪ͸ɺ͢΂ͯͷݸਓͷΩϟϦΞʹ޲͖߹͍ɺΩϟϦΞσʔλΛूΊɺଟ༷Խ͢Δੈͷதʹ͓͍ͯ࢓ࣄબͼͱ࠾༻׆ಈΛΞοϓσʔτ͍͖ͯ͠·͢ɻ 1. DX:اۀ׆ಈʹσʔλͱσδλϧٕज़Λ׆༻͢Δ͜ͱͰɺϏδωεϞσϧ΍ۀ຿ɺαʔϏεͳͲΛมֵ͠ɺڝ૪্ͷ༏ҐੑΛཱ֬͢Δ͜ͱ
6. Copyright © ONE CAREER Inc. ࣄۀ಺༰ ϫϯΩϟϦΞ͸ɺ࢓ࣄબͼʹؔ͢Δ͋ΒΏΔσʔλΛऩू͠ɺ͢΂ͯͷεςʔΫϗϧμʔ͕σʔλΛར༻Ͱ͖Δ ϓϥοτϑΥʔϜΛͭ͘Δ͜ͱͰɺະདྷʹΘͨͬͯਓʑ͕ଟ༷ͳಇ͖ํΛଚॏͰ͖ΔࣾձΛਪਐɻ ΩϟϦΞϓϥοτϑΥʔϜ
7. Copyright © ONE CAREER Inc. All Rights Reserved. ໨࣍ • ϫϯΩϟϦΞʹ͍ͭͯ • ϫϯΩϟϦΞͷαʔϏεͱΞʔΩςΫνϟ • ݱঢ়ͷ՝୊ • ࠓޙͷվળʹ޲͚ͯ 7
8. Copyright © ONE CAREER Inc. All Rights Reserved. ϫϯΩϟϦΞͷαʔϏεͱΞʔΩςΫνϟ 8 5 toCαʔϏεͱͯ͠ɺब׆αΠτʮONE CAREERʯస৬αΠτʮONE CAREER PLUSʯΛ ·ͨtoBαʔϏεͱͯ͠ɺਓࣄ޲͚࠾༻Ϋϥ΢υαʔϏεʮONE CAREER CLOUDʯΛӡӦɻ 1. த్࠾༻ͷސ٬޲͚αʔϏε͸ਓࡐ঺հɺϝσΟΞαʔϏε౳Λఏڙɻ ϫϯΩϟϦΞͷαʔϏε to Cʢ৽ଔʗத్ʣ to Bʢ৽ଔʣ
9. Copyright © ONE CAREER Inc. All Rights Reserved. ϫϯΩϟϦΞͷαʔϏεͱΞʔΩςΫνϟ 9 ݱঢ়ͷΞʔΩςΫνϟશମ૾
10. Copyright © ONE CAREER Inc. All Rights Reserved. ϫϯΩϟϦΞͷαʔϏεͱΞʔΩςΫνϟ 10 ಛ௃ᶃɿෳ਺ͷRailsAPIαʔόʔ͕1ͭͷڞ௨σʔλϕʔεΛར༻ ΞϓϦέʔγϣϯ͝ͱʹRails APIαʔόʔΛ༻ҙ͠όοΫΤϯυͷ໾ׂΛ෼͚ͭͭɺ1ͭͷσʔλϕʔεΛར༻ɻ ActiveRecord ͷϞσϧఆٛΛڞ௨ Gem ͱͯࣾ͠಺ެ։͓ͯ͠ΓɺΞϓϦέʔγϣϯؒͰڞ༗͍ͯ͠Δɻ
11. Copyright © ONE CAREER Inc. All Rights Reserved. ϫϯΩϟϦΞͷαʔϏεͱΞʔΩςΫνϟ 11 ಛ௃ᶄɿAPIαʔόʔ͸໾ׂ͝ͱʹ෼͚ͯίʔυ؅ཧ ڞ༗GemΛར༻͠΍͘͢͢ΔͨΊɺRails wayͳσΟϨΫτϦߏ଄Ͱ͸ͳ͍ܗΛ࣮૷͍ͯ͠Δɻ Controllerɿ ϧʔςΟϯάʹରԠ͢ΔॲཧΛهड़ͨ͠Γɺ ૹΒΕ͖ͯͨύϥϝʔλʔͷ੔ܗ΍ϨϯμϦϯάॲཧΛ୲౰ Serviceɿ Ϣʔβʔͷૢ࡞ʢϢʔεέʔεʣ୯ҐͷॲཧΛ୲౰ ඞཁʹԠͯ͡ෳ਺ͷDomainΛ·ͱΊ࣮ͯߦ͢Δ Domainɿ ۀ຿ϩδοΫΛू໿͍ͯ͠ΔɻActiveRecordʢڞ༗ GemʣΛ௚઀ ࢀর͢Δ͜ͱ͸ېࢭͰɺRepositoryܦ༝ͰσʔλʹΞΫηε͢Δ Repositoryɿ σʔλऔಘɾ֎෦࿈ܞΛ୲͏ɻActiveRecord΍APIݺͼग़͠Λ಺แ
12. Copyright © ONE CAREER Inc. All Rights Reserved. ྫɿRepository͔ΒRDBݺͼग़͠ʢڞ༗Gemʣ ϫϯΩϟϦΞͷαʔϏεͱΞʔΩςΫνϟ 12
13. Copyright © ONE CAREER Inc. All Rights Reserved. ྫɿRDB͔ΒͷσʔλऔಘʢRepositoryʣ ϫϯΩϟϦΞͷαʔϏεͱΞʔΩςΫνϟ 13
14. Copyright © ONE CAREER Inc. All Rights Reserved. ྫɿRepository͔ΒͷσʔλऔಘͱॲཧʢDomainʣ ϫϯΩϟϦΞͷαʔϏεͱΞʔΩςΫνϟ 14
15. Copyright © ONE CAREER Inc. All Rights Reserved. ϫϯΩϟϦΞͷαʔϏεͱΞʔΩςΫνϟ 15 σʔλͷଈ࣌ੑ΍੔߹ੑΛॏཁࢹ ྺ࢙తܦҢ΋.... ʮٻਓެ։͸ଈ࣌൓өͯ͠΄͍͠ʯ ʮΤϯτϦʔͱԠืऀ৘ใͱͷᴥᴪΛͳ͍ͨ͘͠ʯ ͱ͍ͬͨࣾ಺֎ͷχʔζΛߟྀ ब׆αΠτʮONE CAREERʯʹ͙࣍αʔϏεΛ ্ཱͪ͛ΔλΠϛϯάͰϦϙδτϦΛ෼ׂ ڞ௨σʔλϕʔεΛར༻͍ͯ͠Δഎܠ σϓϩΠઓུ΍αʔόʔͷεέʔϦϯάઓུΛ ߟ͑Δ্Ͱ΋ toB / toC / ؅ཧը໘Ͱ෼ׂ͢Δ͜ͱ͸ଥ౰ RDBᶃ RDBᶄ RDBᶅ ৽͍͠σʔλΛ௥Ճ σʔλͷॻ͖ࠐΈʢ׬ྃʣ σʔλͷॻ͖ࠐΈʢ్தʣ ৽͍͠σʔλ ৽͍͠σʔλ ݹ͍σʔλ DBΛ෼ׂ͢Δͱ σʔλͷ੔߹ੑ͕ औΕͳ͘ͳΔϦεΫ͕ʂ
16. Copyright © ONE CAREER Inc. All Rights Reserved. Ruby on Rails͔ͩΒͰ͖ͨɾࢧ͑ΒΕͨ఺ ϫϯΩϟϦΞͷαʔϏεͱΞʔΩςΫνϟ 16 RubyʗRailsͷγϯϓϧ͞ͱॊೈ͕͞ɺෳ਺αʔϏε × ڞ௨ઃܭͷ࣮ݱΛαϙʔτ
17. Copyright © ONE CAREER Inc. All Rights Reserved. ໨࣍ • ϫϯΩϟϦΞʹ͍ͭͯ • ϫϯΩϟϦΞͷαʔϏεͱΞʔΩςΫνϟ • ݱঢ়ͷ՝୊ • ࠓޙͷվળʹ޲͚ͯ 17
18. Copyright © ONE CAREER Inc. All Rights Reserved. ݱঢ়ͷ՝୊ 18 ՝୊ᶃɿσʔλͷҰ؏ੑʢSSoTɿSingle Source of Truthʣ͕कΕͳ͍ υϝΠϯ஌ࣝ͸ΞϓϦέʔγϣϯଆͰఆ͍ٛͯ͠ΔͨΊ ϦϙδτϦؒͰͷॏෳ࣮ͨ͠૷Λආ͚ΒΕͣɺσʔλͷҰ؏ੑ͕कΕͳ͍ঢ়ଶɻ
19. Copyright © ONE CAREER Inc. All Rights Reserved. ݱঢ়ͷ՝୊ 19 ՝୊ᶄɿσʔλϕʔεͷύϑΥʔϚϯε͕શαʔϏεʹӨڹ σʔλϕʔε͕ϘτϧωοΫʹͳͬͯύϑΥʔϚϯε͕ѱԽ͢ΔͱɺશαʔόʔʹӨڹ͕ٴͿɻ ಉ༷ʹσʔλϕʔεΛϝϯςφϯε͢Δࡍ΋ɺશαʔϏεΛఀࢭ͢Δඞཁ͕͋Δɻ
20. Copyright © ONE CAREER Inc. All Rights Reserved. ໨࣍ • ϫϯΩϟϦΞʹ͍ͭͯ • ϫϯΩϟϦΞͷαʔϏεͱΞʔΩςΫνϟ • ݱঢ়ͷ՝୊ • ࠓޙͷվળʹ޲͚ͯ 20
21. Copyright © ONE CAREER Inc. All Rights Reserved. Ԧಓͷબ୒ࢶʮϚΠΫϩαʔϏε + BFFʯ ࠓޙͷվળʹ޲͚ͯ 21 RDB for Company Company server RDB for User User server RDB for Message Message server Nuxt Vue.js Vue.js toC BFF toB BFF ؅ཧը໘ BFF ϚΠΫϩαʔϏεͱͯ͠ɺػೳ͝ͱʹಠཱͨ͠খ͞ͳαʔϏεΛ࡞Γઐ༻ͷσʔλϕʔεΛ࣋ͭɻ BFF͸ը໘͝ͱʹAPIΛ࠷దԽ͠ɺϑϩϯτΤϯυͱ࿈ܞ͠΍͘͢ͳΔɻ toC ϦϙδτϦ toB ϦϙδτϦ ؅ཧը໘ ϦϙδτϦ
22. Copyright © ONE CAREER Inc. All Rights Reserved. ࠓޙͷվળʹ޲͚ͯ 22 Ԧಓͷબ୒ࢶʮϚΠΫϩαʔϏε + BFFʯ ணखͷλΠϛϯά͸ɺ౤ࢿରޮՌ΍ࣄۀͷల๬Λ౿·͑ͯݕ౼͍ͯ͘͠ඞཁ͕͋Δɻ ઌਓͨͪͷ஌ܙΛࢀߟʹɺଞͷબ୒ࢶ΋ؚΊ৻ॏʹਐΊ͍͖͍ͯͨɻ https://zenn.dev/search?q=ϚΠΫϩαʔϏε https://zenn.dev/search?q=BFF
23. Copyright © ONE CAREER Inc. All Rights Reserved. ࠓޙͷվળʹ޲͚ͯ 23 ࿦఺ɿϚΠΫϩαʔϏε + BFFʹͳͬͨͱ͖ɺRails Λ࢖͍͚ͭͮΔͷ͔...ʁ RailsΛ࢖͍ଓ͚Δ͔͸Ұͭͷ࿦఺ɻThe One Person Framework Ͱ͋Δ Rails Λେن໛ʹ͍ͯ͘͜͠ͱ͸ɺ ے͕ѱ͍͕ɺThe Rails DoctrineΛڞ༗Ͱ͖ΔνʔϜͰͷ։ൃεϐʔυ͸ߴ͘ɺ෼ׂޙ΋RailsΛબͿબ୒ࢶ͸͋Δɻ ͜͏͍ͬͨߏ੒΍ٕज़બఆʹڵຯͷ͋Δํ͸ɺͥͻೖࣾͯ͠Ұॹʹߟ͑·͠ΐ͏ʂ https://world.hey.com/dhh/the-one-person-framework-711e6318 https://rubyonrails.org/doctrine
24. Copyright © ONE CAREER Inc. All Rights Reserved. XɺnoteɺEntranceBookͰ৘ใΛൃ৴த 🚀 ڵຯͷ͋Δํ͸ͥͻʂ
25. Copyright © ONE CAREER Inc. All Rights Reserved. 25 We are hiringʂ Rails ͕޷͖ʗج൫ΛҰॹʹ࡞͍͖͍ͬͯͨʗϚΠΫϩαʔϏε΍Γ͍ͨ ͱ͍͏ํɺͥͻ͓࿩͠͠·͠ΐ͏ʂ