MySQL 8.4 Replication with SSL on Ubuntu 22.02

So I recently wrote a post and made a YouTube video on setting up MySQL replication with SSL on Ubuntu, but that was using MySQL 8.0. You can find that here!

But I recently had a comment on that YouTube video to show MySQL 8.4 replication with SSL on Ubuntu 22.02. I know, it’s quite specific but I do aim to please. So thank you Mohammed for suggesting this!

Similar to last time, I will be referring to the 2 MySQL servers as MySQL1 and MySQL2. With these being the master and replication slave respectively.

You can also check this out on my website, and I have a YouTube video coming soon!

YouTube video coming soon!

How to Setup MySQL 8.4 Replication with SSL on Ubuntu 22.02

Setting up MySQL replication on version 8.4 of MySQL is slightly different as some of the config and commands have been changed. Not necessarily made better, just different.

You’ll also need 2 or more systems to setup this up, 1 to be the master MySQL system and then more systems to be replication slaves. All the replication slave systems will listen to changes from the MySQL master system.