In this talk, René will change a regular database to a master database and create a slave replica with it. Once done, he simulates the master crashing and switches Joomla site to use the replica.

** Joomla London User Group (#JUGL) Online meetups: 3rd Tuesday of EVERY Month (19:00) **

Useful links from the presentation:
René's slides: https://renekreijveld.nl/slides/juglondon/JUGLondon_Master_Slave.pdf
Commands to setup replication:
https://renekreijveld.nl/slides/juglondon/jugl.demo.txt
Other resources on replication:
https://renekreijveld.nl/slides/juglondon/replication_other_resources.txt

René’s Socials:
https://twitter.com/renekreijveld
https://renekreijveld.nl/

Joomla User Group London (#JUGL?)
Site & Socials: https://www.joomlalondon.co.uk
Twitter: https://twitter.com/joomlalondon
Facebook: https://facebook.com/joomlausergrouplondon
Meetup: https://www.meetup.com/Joomla-User-Group-London

Useful Joomla! Docs & Links:
Joomla! https://www.joomla.org

News: https://www.joomla.org/announcements.html
Try Joomla!4 yourself: https://launch.joomla.org
Joomla Nightly Builds: https://developer.joomla.org/nightly-builds.html
Joomla Extensions Directory(JED): https://extensions.joomla.org



00:00 Start
02:23 Set Master/Slave DB Replica
04:23 Server setup
06:53 Load balancing
08:03 Redundance: Quick effect with master/slave setup
08:14 How does it work?
08:43 What is a binary log?
09:29 Demo: Master/Slave setup
11:13 Steps taken
11:43 data used
12:15 demo time
50:19 Question time