How to setup MySQL Replication using SSL on Ubuntu

Let’s setup MySQL replication using SSL on Ubuntu. We’ll be using Ubuntu 22.04 LTS and whatever version of MySQL it wants to install by default.

To be fair, the differences in MySQL versions won’t really change how we approach this.

📖 Read more about this below:

----------------------------------------------------------------------------------------------------------

🎉 Subscribe to help support my channel

► Socials

----------------------------------------------------------------------------------------------------------

► Chapters

00:00 Overview
00:34 Install MySQL, initialise and root passwords
01:55 MySQL1 firewall and MySQL config
02:42 MySQL1 SSL certificates
04:41 MySQL2 MySQL config
05:09 MySQL2 SSL certificates and scp
06:20 MySQL1 replication user
06:53 MySQL1 database export and scp
07:15 MySQL2 database import
07:45 MySQL change master command
08:45 Start the slave server and check it's status
09:05 Testing replication
09:41 Like, comment and subscribe!

----------------------------------------------------------------------------------------------------------

#mysql #database #ubuntu #ssl #replication #sslcertificate