MySQL 8.4 replication issues
Hi ,
I want to setup replication between 2 NDB Clusters V8,4 .
Primary Cluster
2 VMS are having data nodes and management nodes
2 VMs are having mysql API nodes
my.cnf:
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysql/mysqld.log
pid-file=/var/lib/mysql/mysqld.pid
log-bin = /var/lib/mysql/mysql-bin.log
max-binlog-size = 500M
server-id = 2
port = 3306
ndbcluster
ndb-nodeid = 51
max_connections=10000
table_open_cache=2000
relay_log = /var/log/mysql/mysql-relay-bin
relay_log_index = /var/log/mysql/mysql-relay-bin.index
ndb-connectstring=****,****
binlog_expire_logs_seconds = 2592000
binlog-format=ROW
replicate-do-db=<db name>
binlog-do-db=<db name>
[client]
socket=/var/lib/mysql/mysql.sock
Secondary Cluster
1 vm containing data node, management node and API node.
my.cnf is same as above .
But while doing the replication, the bulk data replication is not happening properly , may be some of the data is getting replicated. While doing small data set, the replication is happening. Can anybody help us to know , what is the issue
Subject
Views
Written By
Posted
MySQL 8.4 replication issues
929
February 13, 2025 02:24AM
693
February 13, 2025 03:15AM
274
February 13, 2025 06:48AM
567
February 13, 2025 06:52AM
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.