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
39
November 21, 2022 12:43PM
11
November 21, 2022 01:24PM


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.