MySQL Cluster Question

[fixx]

Hi Guys

I setup a MySQL cluster today for the first time. Everything seems to work fine, the actual replication of the databases work 100% but the storage is where my question comes in.

From the output below, you can see that both storage servers are connected: (10.10.50.32 and 10.10.50.33)

-- NDB Cluster -- Management Client --
ndb_mgm> show;
Connected to Management Server at: mysql-node1.starbright.co.za:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @10.10.50.32 (mysql-5.6.11 ndb-7.3.2, Nodegroup: 0, Master)
id=3 @10.10.50.33 (mysql-5.6.11 ndb-7.3.2, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @10.10.50.30 (mysql-5.6.11 ndb-7.3.2)

[mysqld(API)] 3 node(s)
id=4 @10.10.50.30 (mysql-5.6.11 ndb-7.3.2)
id=5 @10.10.50.31 (mysql-5.6.11 ndb-7.3.2)
id=6 @10.10.50.32 (mysql-5.6.11 ndb-7.3.2)

Now the issue is, when I create a new database, the actual database data files are stored on the MySQL node servers in the default location of /var/lib/mysql/<dbname> (10.10.50.30 and 10.10.50.31) and not on the storage servers under /var/lib/mysql-cluster as expected.

The question is, is this the way it is supposed to be? Should the MySQL daemon also run on the storage servers? I doubt it.

Thanks for any assistance.

 

[fixx]

I now shut down both my storage servers and the nodes also automatically shut down so they are definitely in contention here. I don't know. I would just think that the actual data files should be stored on the storage servers's disks?

 

[fixx]

Nevermind, I found the problem :wtf:

 

[fixx]

FileSystemPath

Effective Version Type/Units Default Range/Values
NDB 7.3.0 path DataDir ...
Restart Type: IN
This parameter specifies the directory where all files created for metadata, REDO logs, UNDO logs (for Disk Data tables), and data files are placed. The default is the directory specified by DataDir.

Note
This directory must exist before the ndbd process is initiated.

The recommended directory hierarchy for MySQL Cluster includes /var/lib/mysql-cluster, under which a directory for the node's file system is created. The name of this subdirectory contains the node ID. For example, if the node ID is 2, this subdirectory is named ndb_2_fs.