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
98
February 13, 2025 02:24AM
50
February 13, 2025 03:15AM
34
February 13, 2025 06:48AM
37
February 13, 2025 06:52AM
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.