Working with Database Replications in CakePHP

9 Nov 2019
CakeFest 2019 in Tokyo, Japan

Transcript

1. 8PSLJOH
   XJUI
   %BUBCBTF
   3FQMJDBUJPOT CZ
   5
   .0500," $BLF'FTU
   
   JO
   5PLZP
2. "CPVU
   UIF
   4QFBLFS w 5BEBIJTB
   .0500,"
   w 5XJUUFS
   
   !U@NPUPPLB
   w (JU)VC
   
   NPUPPLB
   w $3.
   "QQMJDBUJPO
   %FWFMPQFS
   w EFQFOET
   PO
   $BLF1)1
 TJODF
   
   w MPWFT
   47(
   
   1%'
   pMFT
3. "HFOEB w 8IBUT
   3FQMJDBUJPOT
   w )PX
   UP
   6TF
   w 1JUGBMMT
   w -PDBM
   %FWFMPQNFOU
   &OWJSPONFOU
4. 8IBUT
   3FQMJDBUJPO
5. "QQMJDBUJPO
   XJUI
   3FQMJDBUJPO .BTUFS
   %BUBCBTF 3FQMJDB
   %BUBCBTF "QQMJDBUJPO
   4FSWFST 6TFST BDDFTT */4&35
   
   61%"5&
   TUBUFNFOUT SFQMJDBUJPO
6. "QQMJDBUJPO
   XJUI
   3FQMJDBUJPO .BTUFS
   %BUBCBTF 3FQMJDB
   %BUBCBTF "QQMJDBUJPO
   4FSWFST 6TFST BDDFTT */4&35
   
   61%"5&
   TUBUFNFOUT ☠
7. "QQMJDBUJPO
   XJUI
   3FQMJDBUJPO .BTUFS
   %BUBCBTF 3FQMJDB
   %BUBCBTF "QQMJDBUJPO
   4FSWFST 6TFST BDDFTT 4&-&$5
   TUBUFNFOU
8. )PX
   UP
   6TF
9. 1SPYZ
   4FSWFS .BTUFS
   %BUBCBTF 3FQMJDB
   %BUBCBTF "QQMJDBUJPO
   4FSWFST 6TFST BDDFTT */4&35
   
   61%"5&
   TUBUFNFOUT SFQMJDBUJPO 1SPYZ
   4FSWFS 4&-&$5
   TUBUFNFOU
10. "QQMJDBUJPO
    $PEF .BTUFS
    %BUBCBTF 3FQMJDB
    %BUBCBTF "QQMJDBUJPO
    4FSWFST 6TFST BDDFTT 4&-&$5
    TUBUFNFOU */4&35
    
    61%"5&
    
    4&-&$5
    TUBUFNFOUT SFQMJDBUJPO
11. 4USBUFHJFT w %FGBVMU.BTUFS
    4USBUFHZ
    w %FGBVMU3FQMJDB
    4USBUFHZ
12. 8IFSF
    UP
    *NQMFNFOU w BQQQIQ
    w 3FRVJSFE
    .FUIPET
    w
    changeConnectionToMaster
    w
    changeConnectionToReadReplica
    w 8IFSF
    w *OKFDUJOH
    BO
    BCTUSBDU
    TVCDMBTT
    PG
    5BCMF
    w #FIBWJPVS
13. BQQQIQ
    FYBNQMF
14. "CTUSBDU
    4VCDMBTT
    PG
    5BCMF w *U
    MPPLT
    MJLF
    "QQ.PEFM
    PO
    $BLF1)1
    Y
    w &BTZ
    UP
    HFU
    IFMQ
    PG
    *%&T
    DPEF
    DPNQMFUJPO
15. #FIBWJPVS w -FTT
    #SFBLJOH
    DIBOHF
    w &BTZ
    UP
    SFVTF
    UIF
    DPEF
16. $PEF
    &YBNQMF w %FGBVMU.BTUFS
    4USBUFHZ
    w 6TF
    UIF
    SFQMJDB
    POMZ
    PO
    IFBWZ
    RVFSJFT
    w *NQMFNFOU
    UIF
    TXJUDIJOH
    NFUIPET
    JO
    B
    #FIBWJPVS
    w "
    XIPMF
    BQQMJDBUJPO
    SFQPTJUPSZ
 IUUQTHJUIVCDPNNPUPPLBDBLFQIQXJUI SFQMJDBUJPO
17. 1JUGBMMT
    w 5SBOTBDUJPOT
    w .JHSBUJPOT
    w 3FQMJDBUJPO
    -BH
18. 5SBOTBDUJPOT w %0
    /05
    w DIBOHF
    DPOOFDUJPO
    EVSJOH
    B
    USBOTBDUJPO
    w FYFD
    4&-&$5
    TUBUFNFOU
    PO
    3FQMJDB
19. .JHSBUJPOT w PO
    %FGBVMU3FQMJDB
    4USBUFHZ
    w
    bin/cake migrations migrate --connection master
    w PO
    %FGBVMU.BTUFS
    4USBUFHZ
    w
20. 3FQMJDBUJPO
    -BH
     w 5JNF
    DPOTVNFE
    CFGPSF
    OFX
    EBUB
    BSSJWFT
    UP
    3FQMJDB
    w T
    UZQJDBMMZ
    w %FQFOET
    PO
    MPBE
21. 3FQMJDBUJPO
    -BH
     // Controller public function add() { $article = $this->Articles->newEntity(); if ($this->request->is('post')) { $article = $this->Articles->patchEntity($article, $this->request->getData()); if ($this->Articles->save($article)) { $this->Flash->success(__('Your article has been saved.')); return $this->redirect(['action' => 'index']); } .... } public function index() { // use ReadReplica for this action $this->Articles->changeConnectionToReadReplica(); $articles = $this->Paginator->paginate($this->Articles->find()); $this->set(compact('articles')); }
22. -PDBM
    %FW
    &OWJSPONFOUT w *EFBMMZ
    QSFQBSF
    
    .Z42-
    TFSWFST
    PO
    ZPVS
    MPDBM
    w XJUI
    B
    TFUUJOH
    PG
    %FMBZFE
    3FQMJDBUJPO
    w
23. 3FBE0OMZ
    6TFS w JT
    IFMQGVM
    UP
    EFUFDU
    UIF
    CVH
    XSJUJOH
    PO
    SFQMJDB
    w JT
    FBTZ
    UP
    TFUVQ
    w DBOU
    TJNVMBUF
    SFQMJDBUJPO
    MBHT
24. 6OJU
    5FTU w UFTU
    EBUBTPVSDF
    BMTP
    TIPVME
    CF
    SFQMJDBUFE
 JG
    ZPV
    SFQMJDBUF
    w $*
    DPOTJEFSBUJPOT
    w :PVS
    $*
    FOW
    TVQQPSUT
    SFQMJDBUJPO
    w SFBEPOMZ
    VTFS
    NJHIU
    IFMQ
25. 3FGFSFODFT w 3'$
    3FBE8SJUF
    EBUBCBTF
    TQMJUUJOH
    
 IUUQTHJUIVCDPNDBLFQIQDBLFQIQJTTVFT
    w &YBNQMF
    *NQMFNFOUBUJPO
 IUUQTHJUIVCDPNNPUPPLBDBLFQIQXJUI SFQMJDBUJPO
    w .Z42-
    
    3FGFSFODF
    .BOVBM
 
    %FMBZFE
    3FQMJDBUJPO
 IUUQTEFWNZTRMDPNEPDSFGNBOFO SFQMJDBUJPOEFMBZFEIUNM
26. 5IBOL
    :PV
    &OKPZ
    3FQMJDBUJPOT