468x60

venerdì 10 novembre 2017

How To Secure MySQL Replication Using SSH

https://www.digitalocean.com/community/tutorials/how-to-secure-mysql-replication-using-ssh-on-a-vps

http://makandracards.com/makandra/573-mysql-replication-how-to

http://www.somacon.com/p567.php


Bi-directional SSH tunnel

local$: ssh -N -R 33061:localhost:3306 remote_host_ip

remote$: ssh -p 33061 localhost


Create/restore a slave using GTID replication
https://www.percona.com/blog/2013/02/08/how-to-createrestore-a-slave-using-gtid-replication-in-mysql-5-6/


MySQL Multi-Source Replication
http://www.xenialab.it/meo/web/white/oracle/myrepl_multi.htm

If we have a chain of slaves, it's important to enable slave update logging, on config file:
log-slave-updates = 1

Nessun commento:

Posta un commento

468x60

Cerca su Google

Cerca nel Blog con Google