MySQL Forums
Forum List  »  General

An issue with Master-slave database replication.
Posted by: Dhruvil Panchal
Date: October 13, 2023 12:13AM

The master and slave databases have been replicated. Some tables have been ignored between the two databases.

In both databases, we have optimised the read and write operations so they can be performed separately. When traffic is started on the master database, replication will work as expected eventually.

If we check the replication after some time, we find that it is broken without any errors.

In both databases, we found a mismatch in the data. We have also performed query optimization at the code level, but we have not been able to resolve this issue.

The below paramters we have added in mysql conf file for both databses.

pid-file = /var/run/mysqld/
socket = /var/run/mysqld/mysqld.sock
datadir = /var/lib/mysql
log-error = /var/log/mysql/error.log
general_log = OFF
interactive_timeout = 280000
log_bin_trust_function_creators = 1
max_connections = 2000
auto-increment-increment = 2
auto-increment-offset = 2
log_bin = /var/log/mysql/mysql-bin.log
log_bin_index = /var/log/mysql/mysql-bin.log.index
relay_log = /var/log/mysql/mysql-relay-bin
relay_log_index = /var/log/mysql/mysql-relay-bin.index
expire_logs_days = 10
max_binlog_size = 100M

Can anybody help me to resolve the issue? Thanks in advance.

Options: ReplyQuote

Written By
An issue with Master-slave database replication.
October 13, 2023 12:13AM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.