R/W Splitting in Rails

Eec11c7d221770d15a4b16104f3cf07e?s=47 Kohei Suzuki
September 19, 2014
Programming
2
1.1k

R/W Splitting in Rails

RubyKaigi 2014 LT

https://github.com/eagletmt/switch_point

Eec11c7d221770d15a4b16104f3cf07e?s=128

Kohei Suzuki

September 19, 2014
Tweet

More Decks by Kohei Suzuki

See All by Kohei Suzuki
Eec11c7d221770d15a4b16104f3cf07e?s=48 eagletmt
1
1.8k
Eec11c7d221770d15a4b16104f3cf07e?s=48 eagletmt
20
8.6k
Eec11c7d221770d15a4b16104f3cf07e?s=48 eagletmt
12
5.2k
Eec11c7d221770d15a4b16104f3cf07e?s=48 eagletmt
3
1.1k
Eec11c7d221770d15a4b16104f3cf07e?s=48 eagletmt
0
380
Eec11c7d221770d15a4b16104f3cf07e?s=48 eagletmt
14
6.3k

Other Decks in Programming

See All in Programming
70ae2d149767d4198aac83453481b8dd?s=48 amaotone
9
1.4k
D1dd88d67a1b17b9d2ad981b75d205f3?s=48 myamashii
1
510
C0eb1445cda9489ebf8c31c367fec3fb?s=48 exoego
1
320
4861686276b2f990387eaef28b099db0?s=48 niyarin
1
370
3cfad86677c5966ecfe9b81955fa3489?s=48 youkan2002
0
270
Bb49e68eb46070029845fb3022d9026f?s=48 yukilabo
1
180
3f4e0340909015791f1712c52b116da7?s=48 tamadon
1
320
29fafe10f8a2fefb98671421260aaa65?s=48 steinkel
1
160
F0493f5bcb4cc9fdccc54ae3e8ab6bd0?s=48 matsu7874
0
250
6c6b60f0440e030040a9141cab781ed0?s=48 hiboma
0
420
9eed44f137609e6ce3b6f1e14f80b9e1?s=48 izumin5210
6
3k
44f37c1fe3a6a56376bb41a338741355?s=48 ahiru
3
300

Featured

See All Featured
465724d73fe3a92c0879fdfb43a3a6f3?s=48 philhawksworth
190
17k
Dad095ea7038f89f760419ce475d5d14?s=48 michaelherold
224
8.3k
Fde6c3a50ca518a909ef35c22c0ee0e4?s=48 destraynor
222
47k
C7393b7ba7ec9c8890dd77d209fbb3c9?s=48 maltzj
499
36k
95d9f37115fbb0d13135d0f77132f856?s=48 morganepeng
11
690
A60068bce2e73de3a37ca9d2dbe36092?s=48 bryan
29
3.2k
433acaea1012b25d97ae66da9b998dad?s=48 malarkey
392
60k
78b475797a14c84799063c7cd073962f?s=48 holman
459
270k
2bb923c57a1fdc3a2eb484bb8d565fd2?s=48 ufuk
55
5.2k
4394ceb8b277f35ee3da7030384efb5d?s=48 davidbonilla
69
3.5k
E14f55d3f939977cecbf51b64ff6f861?s=48 keithpitt
399
20k
C4de88ea47538e4594750e3861a341c8?s=48 brettharned
91
2.8k

Transcript

  1. 384QMJUUJOHJO3BJMT ,PIFJ4V[VLJ

  2. 4FMGJOUSPEVDUJPO ,PIFJ4V[VLJ !FBHMFUNU 5XJUUFS (JU)VC ʜ  ! $PPLQBE*OD

  3. 3BJMTBOENVMUJQMF%#T 3BJMTTVQQPSUTUPFTUBCMJTIDPOOFDUJPOTUPEJ⒎FSFOU EBUBCBTFTGPSFBDINPEFMT class BlogBase < ActiveRecord::Base self.abstract_class = true

    establish_connection :production_blog end ! class Article < BlogBase; end class Category < BlogBase; end ! class Comment < ActiveRecord::Base establish_connection :production_comment end

  4. 3BJMTBOENVMUJQMF%#T 38TQMJUUJOHJT/05TVQQPSUFE XSJUFUPUIFNBTUFS SFBEGSPNUIFTMBWF 5IFSF`TTFWFSBMHFNTUPEP38TQMJUUJOHJO3BJMT PDUPQVT ECDIBSNFS NVMUJ@EC  BDUT@BT@SFBEPOMZBCMF

    

  5. PDUPQVT IUUQTHJUIVCDPNUDIBOEZPDUPQVT 4IBSEJOHBOE38TQMJUUJOHBSFTVQQPSUFE .JHSBUJPOJTBMTPTVQQPSUFE "DUJWFMZNBJOUBJOFE *UXPSLTXJUI3BJMT  .BOZGFBUVSFT MBSHFDPEFCBTF

  6. BDUT@BT@SFBEPOMZBCMF IUUQTSVCZHFNTPSHHFNTBDUT@BT@SFBEPOMZBCMF 0MEHFN MBTUVQMPBE  $PPLQBEVTFEJUVOUJMSFDFOUUJNFT )FBWJMZNPEJpFEUPTVQQPSU3BJMT %P38TQMJUUJOHPOMZ +VTU-0$ BTPGPVS3BJMTTVQQPSUFE

    WFSTJPO

  7. 38TQMJUUJOH 8FOFFE38TQMJUUJOHPOMZ BDUT@BT@SFBEPOMZBCMFJTUPPPMEBOEGSBHJMFUP BHHSFTTJWFDIBOHFTPG3BJMT *SFJOWFOUFEBOFXHFNMJLFBDUT@BT@SFBEPOMZBCMF IUUQTHJUIVCDPNFBHMFUNUTXJUDI@QPJOU

  8. TXJUDI@QPJOU %P38TQMJUUJOHPOMZ /PTIBSEJOH /PNJHSBUJPOT 'FXFSNPOLFZQBUDIFT JOBXFMMPSEFSFE NBOOFS IUUQTXXXqJDLSDPNQIPUPTFMMSCSPXO

  9. $POpHVSBUJPO EBUBCBTFZNM production_blog_master: adapter: mysql2 database: blog username: blog_writable host:

    db-blog-master ! production_blog_slave: adapter: mysql2 database: blog username: blog_readonly host: db-blog-slave

  10. $POpHVSBUJPO *OJUJBMJ[FS SwitchPoint.configure do |config| config.define_switch_point :blog, readonly: :"#{Rails.env}_blog_slave", writable:

    :"#{Rails.env}_blog_master" end

  11. $POpHVSBUJPO .PEFMT class Article < ActiveRecord::Base use_switch_point :blog end !

    class Category < ActiveRecord::Base use_switch_point :blog end ! class Comment < ActiveRecord::Base use_switch_point :comment end

  12. 1SPYZ 5IFSF`TBQSPYZCFUXFFONPEFMTBOEEBUBCBTFT BOEJUEPFT38TQMJUUJOH Article Category Comment blog comment db-blog-master db-blog-slave

    db-comment-master db-comment-slave .PEFM 1SPYZ TXJUDIQPJOU %BUBCBTF

  13. 4XJUDIJOH Model.with_readonly {}$POOFDUUPUIFTMBWF Model.with_writable {}$POOFDUUPUIFNBTUFS with_readonlyBOEwith_writableDBOCFOFTUFE "MNPTUUIFTBNFTFNBOUJDTXJUIfrom_slaveBOE from_masterPGBDUT@BT@SFBEPOMZBCMF

  14. 5ZQJDBMVTBHF 6TFwith_readonlyJOBSPVOE@BDUJPOPG(&5 SFRVFTU 6TFwith_writableGPSXSJUJOHPS4&-&$5GSPN UIFNBTUFS 6TFwith_readonlyGPSTPNFCMPDLTFOEQPJOUT UIBUFYFDVUFTIFBWZRVFSZ

  15. *OQSPEVDUJPO $PPLQBEJTVTJOHTXJUDI@QPJOUGPSUIFNBJO BQQMJDBUJPO -PUTPG"DUJWF3FDPSENPEFMT   JOUPUBM  .VMUJQMFNBTUFSTMBWFEBUBCBTFT 5IPVTBOETPGEBUBCBTFDPOOFDUJPOT

  16. 1PMJDZ ,FFQGFXFSEFQFOEFODJFTPO3BJMTJNQMFNFOUBUJPO /PCSBODIJOHEFQFOEJOHPO ActiveRecord::VERSION 6TFDPNNPOMZVTFEGFBUVSFTBOECFIBWJPST %PPOFKPCŠ38TQMJUUJOH %PJUBUUIFSJHIUMBZFS

  17. $PODMVTJPO *DSFBUFEBTJNQMFHFNUIBUFOBCMFT38TQMJUUJOH JO3BJMT IUUQTHJUIVCDPNFBHMFUNUTXJUDI@QPJOU