Replicacion de MySQL [Master to Master]

Mysql ofrece la posibilidad de Replicar de una Base de Datos.

Archivos de configuracion:

[mysqld]
....
log-bin
binlog-do-db=remises
binlog-ignore-db=mysql
binlog-ignore-db=test
server-id=1
auto_increment_increment=2
auto_increment_offset=1
slave-skip-errors=1062,1053,1049,1194,1146,1050
master-host=192.168.0.x
master-user=replication
master-password=slave
master-port=3306
master-connect-retry=60
...

Comando MySQL

GRANT REPLICATION SLAVE ON *.* TO 'replication'@'%' IDENTIFIED BY 'slave';
CHANGE MASTER TO MASTER_HOST='192.168.0.x', MASTER_USER='replication', MASTER_PASSWORD='password', MASTER_PORT=3306

Verificacion del estado de MySQL

show master status;
show slave status\G