An issue with Master-slave database replication.
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.
Subject
Written By
Posted
An issue with Master-slave database replication.
October 13, 2023 12:13AM
Sorry, you can't reply to this topic. It has been closed.
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.