Slide 1
Slide 1 text
8PSLJOHXJUI
%BUBCBTF3FQMJDBUJPOT
CZ5.0500,"
$BLF'FTUJO5PLZP
Slide 2
Slide 2 text
"CPVUUIF4QFBLFS
w 5BEBIJTB.0500,"
w 5XJUUFS!U@NPUPPLB
w (JU)VCNPUPPLB
w $3."QQMJDBUJPO%FWFMPQFS
w EFQFOETPO$BLF1)1
TJODF
w MPWFT47(1%'pMFT
Slide 3
Slide 3 text
"HFOEB
w 8IBUT3FQMJDBUJPOT
w )PXUP6TF
w 1JUGBMMT
w -PDBM%FWFMPQNFOU&OWJSPONFOU
Slide 4
Slide 4 text
8IBUT3FQMJDBUJPO
Slide 5
Slide 5 text
"QQMJDBUJPOXJUI3FQMJDBUJPO
.BTUFS
%BUBCBTF
3FQMJDB
%BUBCBTF
"QQMJDBUJPO
4FSWFST
6TFST
BDDFTT
*/4&3561%"5&
TUBUFNFOUT
SFQMJDBUJPO
Slide 6
Slide 6 text
"QQMJDBUJPOXJUI3FQMJDBUJPO
.BTUFS
%BUBCBTF
3FQMJDB
%BUBCBTF
"QQMJDBUJPO
4FSWFST
6TFST
BDDFTT
*/4&3561%"5&
TUBUFNFOUT
☠
Slide 7
Slide 7 text
"QQMJDBUJPOXJUI3FQMJDBUJPO
.BTUFS
%BUBCBTF
3FQMJDB
%BUBCBTF
"QQMJDBUJPO
4FSWFST
6TFST
BDDFTT
4&-&$5TUBUFNFOU
Slide 8
Slide 8 text
)PXUP6TF
Slide 9
Slide 9 text
1SPYZ4FSWFS
.BTUFS
%BUBCBTF
3FQMJDB
%BUBCBTF
"QQMJDBUJPO
4FSWFST
6TFST
BDDFTT
*/4&3561%"5&
TUBUFNFOUT
SFQMJDBUJPO
1SPYZ
4FSWFS
4&-&$5
TUBUFNFOU
Slide 10
Slide 10 text
"QQMJDBUJPO$PEF
.BTUFS
%BUBCBTF
3FQMJDB
%BUBCBTF
"QQMJDBUJPO
4FSWFST
6TFST
BDDFTT
4&-&$5TUBUFNFOU
*/4&3561%"5&4&-&$5
TUBUFNFOUT
SFQMJDBUJPO
Slide 11
Slide 11 text
4USBUFHJFT
w %FGBVMU.BTUFS4USBUFHZ
w %FGBVMU3FQMJDB4USBUFHZ
Slide 12
Slide 12 text
8IFSFUP*NQMFNFOU
w BQQQIQ
w 3FRVJSFE.FUIPET
w changeConnectionToMaster
w changeConnectionToReadReplica
w 8IFSF
w *OKFDUJOHBOBCTUSBDUTVCDMBTTPG5BCMF
w #FIBWJPVS
Slide 13
Slide 13 text
BQQQIQFYBNQMF
Slide 14
Slide 14 text
"CTUSBDU4VCDMBTTPG5BCMF
w *UMPPLTMJLF"QQ.PEFMPO$BLF1)1Y
w &BTZUPHFUIFMQPG*%&TDPEFDPNQMFUJPO
Slide 15
Slide 15 text
#FIBWJPVS
w -FTT#SFBLJOHDIBOHF
w &BTZUPSFVTFUIFDPEF
Slide 16
Slide 16 text
$PEF&YBNQMF
w %FGBVMU.BTUFS4USBUFHZ
w 6TFUIFSFQMJDBPOMZPOIFBWZRVFSJFT
w *NQMFNFOUUIFTXJUDIJOHNFUIPETJOB#FIBWJPVS
w "XIPMFBQQMJDBUJPOSFQPTJUPSZ
IUUQTHJUIVCDPNNPUPPLBDBLFQIQXJUI
SFQMJDBUJPO
Slide 17
Slide 17 text
1JUGBMMT
w 5SBOTBDUJPOT
w .JHSBUJPOT
w 3FQMJDBUJPO-BH
Slide 18
Slide 18 text
5SBOTBDUJPOT
w %0/05
w DIBOHFDPOOFDUJPOEVSJOHBUSBOTBDUJPO
w FYFD4&-&$5TUBUFNFOUPO3FQMJDB
Slide 19
Slide 19 text
.JHSBUJPOT
w PO%FGBVMU3FQMJDB4USBUFHZ
w bin/cake migrations migrate --connection master
w PO%FGBVMU.BTUFS4USBUFHZ
w
Slide 20
Slide 20 text
3FQMJDBUJPO-BH
w 5JNFDPOTVNFECFGPSFOFXEBUBBSSJWFTUP3FQMJDB
w T
UZQJDBMMZ
w %FQFOETPOMPBE
Slide 21
Slide 21 text
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'));
}
Slide 22
Slide 22 text
-PDBM%FW&OWJSPONFOUT
w *EFBMMZ
QSFQBSF.Z42-TFSWFSTPOZPVSMPDBM
w XJUIBTFUUJOHPG%FMBZFE3FQMJDBUJPO
w
Slide 23
Slide 23 text
3FBE0OMZ6TFS
w JTIFMQGVMUPEFUFDUUIFCVHXSJUJOHPOSFQMJDB
w JTFBTZUPTFUVQ
w DBOUTJNVMBUFSFQMJDBUJPOMBHT
Slide 24
Slide 24 text
6OJU5FTU
w UFTUEBUBTPVSDFBMTPTIPVMECFSFQMJDBUFE
JGZPVSFQMJDBUF
w $*DPOTJEFSBUJPOT
w :PVS$*FOWTVQQPSUTSFQMJDBUJPO
w SFBEPOMZVTFSNJHIUIFMQ
Slide 25
Slide 25 text
3FGFSFODFT
w 3'$3FBE8SJUFEBUBCBTFTQMJUUJOH
IUUQTHJUIVCDPNDBLFQIQDBLFQIQJTTVFT
w &YBNQMF*NQMFNFOUBUJPO
IUUQTHJUIVCDPNNPUPPLBDBLFQIQXJUI
SFQMJDBUJPO
w .Z42-3FGFSFODF.BOVBM
%FMBZFE3FQMJDBUJPO
IUUQTEFWNZTRMDPNEPDSFGNBOFO
SFQMJDBUJPOEFMBZFEIUNM
Slide 26
Slide 26 text
5IBOL:PV
&OKPZ3FQMJDBUJPOT