An issue with Master-slave database replication.

[Dhruvil Panchal]

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.

[mysqld]
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
datadir = /var/lib/mysql
log-error = /var/log/mysql/error.log
general_log = OFF
wait_timeout=280000
interactive_timeout = 280000
sql_mode=""
log_bin_trust_function_creators = 1
max_connections = 2000
server-id=1
auto-increment-increment = 2
auto-increment-offset = 2
log-slave-updates
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.