Setting Up Slave with rsync

[michaelcaplan]

Hello,

I’m looking to set up a new slave and wonder about the viability of using rsync to set up the slave (see: https://www.stephenrlang.com/2016/08/setting-up-mysql-master-slave-replication-with-rsync/)

One twist is that I’m looking to set up the new slave with a newer version of MySQL. Master is MySQL 5.6, and slave will be Percona 5.7 (or MariaDB 10.2). if a mysql_upgrade process was thrown into the mix, how safe is this?

Thanks,

Mike

[sayeedanas]

michaelcaplan you can take a mysql dump and then rsync to new server in order to setup slave. But i would suggest if you use xtrabackup percona toolkit, it is pretty faster and reliable for large size databases if you have.
You can setup downstream servers on newer version without any issue. MySQL -> MariaDB also work fine but i doubt it would go MariaDB -> MySQL, need to do few test on this.