MySQL Forums
Forum List  »  NDB clusters

About High availability
Posted by: domenico pandolfino
Date: November 21, 2022 12:43PM

Hi all, i've installed mysql cluster via deb and apt.
i followed this guide: https://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/#repo-qg-apt-cluster-install
-----------------------------------------------------
i want to have 2 VM running management and SQL together
and 2 VM for data node on.

So it's possible to have mysqld and ndb_mgmd running on same VM x 2?
i've tried but it's not working.
----------------------------------------------------------
here my /etc/my.cnf on VM1 and VM2:
[mysqld]
ndbcluster

[mysql_cluster]
ndb-connectstring=dbmng1,dbmng2
-----------------------------------------------------------
here my config.ini on VM1 and VM2:
[ndbd default]
NoOfReplicas=2
DataMemory=98M

[ndb_mgmd]
NodeId=1
HostName=dbmng1
DataDir=/var/lib/mysql-cluster

[ndb_mgmd]
NodeId=2
HostName=dbmng2
DataDir=/var/lib/mysql-cluster

[ndbd]
NodeId=3
HostName=dbdata1
DataDir=/usr/local/mysql/data

[ndbd]
NodeId=4
HostName=dbdata2
DataDir=/usr/local/mysql/data

[mysqld]
HostName=dbmng1

[mysqld]
HostName=dbmng2
--------------------------------------------------

Options: ReplyQuote


Subject
Views
Written By
Posted
About High availability
291
November 21, 2022 12:43PM
214
November 21, 2022 01:24PM
166
November 29, 2022 03:56AM


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.