Upgrade to Pro — share decks privately, control downloads, hide ads and more …

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
0
240
Eec11c7d221770d15a4b16104f3cf07e?s=48 eagletmt
1
2.1k
Eec11c7d221770d15a4b16104f3cf07e?s=48 eagletmt
20
8.8k
Eec11c7d221770d15a4b16104f3cf07e?s=48 eagletmt
12
5.6k
Eec11c7d221770d15a4b16104f3cf07e?s=48 eagletmt
3
1.3k
Eec11c7d221770d15a4b16104f3cf07e?s=48 eagletmt
0
410
Eec11c7d221770d15a4b16104f3cf07e?s=48 eagletmt
14
6.5k

Other Decks in Programming

See All in Programming
Cb504213a5310e01faabbc0b3fca3d39?s=48 napple29
0
150
Bf04d1ee6fa2216133b23af8f609c70a?s=48 gatchan0807
0
980
Baaa72bd2671a244ba9211e015f72d28?s=48 eliasnogueira
0
140
119659c28d16f22d01eb48a6f3ee1391?s=48 iwatatomoya
0
3.1k
9b70cb91fa334ab6a8bf8712b40a772f?s=48 mrtry
0
1.4k
E86b46be0f4e61db6b28becc5493bbab?s=48 januswel
0
1.1k
91812763826e2319128c245b94dc78e5?s=48 fanf42
0
150
09923d8b0c79423a289b7d5dc31a59e4?s=48 mururu
0
570
0881bf028854bea223770e6bfc0a4065?s=48 martin_lover
7
3.5k
30e63a1ad21d3944b288fc3d33d1e920?s=48 amrrs
0
130
E37b4344ef4bfd0fc4826c04971e54fb?s=48 nrslib
7
1.7k
52c76fb01bb5d1908f91b0231a44a7b5?s=48 boriswilhelms
0
100

Featured

See All Featured
A60068bce2e73de3a37ca9d2dbe36092?s=48 bryan
35
3.8k
Af6a12710770ad9a7cfd08c97efd40d3?s=48 pedronauck
655
120k
F716e5f737fcfb03f2cf8d1a184f1dbe?s=48 nonsquared
84
3.6k
8081b26e05bb4354f7d65ffc34cbbd67?s=48 chriscoyier
780
240k
812e1705ff0f8bc1bcf18587bde687d5?s=48 62gerente
594
210k
766b9746b59e6f09e280cd33cf4ed419?s=48 skipperchong
13
1k
2bb923c57a1fdc3a2eb484bb8d565fd2?s=48 ufuk
61
7.2k
C9b18d9dff88a9dd2393364c2b3b21bd?s=48 colly
190
14k
0bce06bd06ee7a2c4f5500f25dcf7f18?s=48 paulrobertlloyd
72
3.9k
651dcfe41723207fbb0aa044a4f7c07f?s=48 dotmariusz
99
5.7k
433acaea1012b25d97ae66da9b998dad?s=48 malarkey
396
61k
168ccec72eee0530b818d44f3fedaacf?s=48 shlominoach
177
8.1k

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