Description:
To whom it may concern,
I'm writing to you to enquire about some troubles with the replication settings between two servers.
The problem is when master and slave synchronize the position of the binary log is updated in the slave but the data are not updated on the bases replicated slave.
I would like you can help me with this situation, because our proyect is in testing phase.
Thank you in advance for your help.
MySQL version:
Mater:5.5.19-enterprise-commercial-advanced-log
Slave:5.5.19-enterprise-commercial-advanced
The master server setting:
[mysqld]
# Configuracion de la replicacion
log-bin=mysql-bin
server-id=1
innodb_flush_log_at_trx_commit=1
sync_binlog=1
expire_logs_days = 10
max_binlog_size = 100M
replicate-do-db=nissanperu
replicate-do-db=nissanperu001
binlog-do-db=nissanperu
binlog-do-db=nissanperu001
The slave settings:
server-id = 2
log-bin=mysql-bin
relay_log=mysql-relay-bin
read_only=1
Yours faithfully.
Tania Ramírez
How to repeat:
To whom it may concern,
I'm writing to you to enquire about some troubles with the replication settings between two servers.
The problem is when master and slave synchronize the position of the binary log is updated in the slave but the data are not updated on the bases replicated slave.
I would like you can help me with this situation, because our proyect is in testing phase.
Thank you in advance for your help.
MySQL version:
Mater:5.5.19-enterprise-commercial-advanced-log
Slave:5.5.19-enterprise-commercial-advanced
The master server setting:
[mysqld]
# Configuracion de la replicacion
log-bin=mysql-bin
server-id=1
innodb_flush_log_at_trx_commit=1
sync_binlog=1
expire_logs_days = 10
max_binlog_size = 100M
replicate-do-db=nissanperu
replicate-do-db=nissanperu001
binlog-do-db=nissanperu
binlog-do-db=nissanperu001
The slave settings:
server-id = 2
log-bin=mysql-bin
relay_log=mysql-relay-bin
read_only=1
Yours faithfully.
Tania Ramírez
