Not the answer you need?
Register and ask your own question!

Setting Up Slave with rsync

michaelcaplanmichaelcaplan EntrantCurrent User Role Beginner

I'm looking to set up a new slave and wonder about the viability of using rsync to set up the slave (see:

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?




  • sayeedanassayeedanas Entrant Current User Role Contributor
    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.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.