après copie du contenu du répertoire mysql d’un serveur vers un autre pour corrigé les évolutions du format
mysql_upgrade --force -uuser -ppassword
Réplication
slave my.cnf
slave-parallel-threads=4
server-id = 03
relay-log-index = /home/mysql/mysql_log/slave-relay-bin.index
relay-log = /home/mysql/mysql_log/slave-relay-bin
replicate-do-db = base1
replicate-do-db = base2
replicate-do-db = base3
replicate-ignore-table = base1.table_pas_ok
replicate-ignore-table = base2.table_pa_ok
slave-skip-errors = 1236,1146,1032
master show master status; -> noter file et pos exmaster1-bin.030648, 50302757
slave
STOP SLAVE;
change master to
master_host='hostname',
master_user='user_copy',
master_password='user_pass',
master_port=3306,
master_log_file='master1-bin.030648',
master_log_pos=50302757,
master_connect_retry=10;
START SLAVE;