Bug #82284 Doesn't replicate data on slave server
Submitted: 19 Jul 2016 17:11
Reporter: Tania Ramirez Email Updates:
Status: Open Impact on me:
None 
Category:MySQL Server: Replication Severity:S4 (Feature request)
Version:5.5.19-enterprise-commercial-advanced-lo OS:Microsoft Windows (Microsoft Server 2008 R2 Standar)
Assigned to: CPU Architecture:Any
Tags: replication

[19 Jul 2016 17:11] Tania Ramirez
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