To protect data while it is transferred throughout the Internet can be done using SSL. For example if you need to replicate mysql data from one datacenter to another. This is the instruction how to setup MySQL master-slave replication with ssl.
Mysql master-slave replication with percona xtrabackup This replication will be seted up with Percona tools and xtrabackup. The replication in MySQL performs via binary logs. Replication is only asynchronous. In version Mysql-5.6 GTID (Global Transaction IDentifier) appeared. In theory replication is the process when master servers sends updates to slave server. Next I’m going to … Continue reading Mysql master-slave replication with percona xtrabackup