Re: How to verify work of Data Node in MySQL cluster?

[Mikael Ronström]

Below is the data directories for an NDB data node after running a simple
test case in our test suite:

(ls -R under ndb_1_fs)

D1 and D2 contains metadata about tables.
D1/DBDIH and D2/DBDIH contains information table distribution
D1/DBDICT and D2/DBDICT contains information about the schema
D1(2)/DBDICT/P0.SchemaLog is the set of table objects existing in the cluster
D1(2)/DBDIH/P0.sysfile is important startup information for the cluster
Also D1(2)/NDBCNTR/P0.sysfile is important startup info for the cluster

D8, D9, D10, D11 contains the REDO log files
LCP directory contains checkpoint information
LG contains Logfile Group files
TS contains Tablespace files

D1 D10 D11 D2 D8 D9 LCP LG TS

./D1:
DBDICT DBDIH NDBCNTR

./D1/DBDICT:
P0.SchemaLog T12 T16 T2 T4 T8
T1 T13 T17 T20 T5 T9
T10 T14 T18 T21 T6
T11 T15 T19 T3 T7

./D1/DBDICT/T1:
S0.TableList

./D1/DBDICT/T10:
S0.TableList

./D1/DBDICT/T11:
S0.TableList

./D1/DBDICT/T12:
S0.TableList

./D1/DBDICT/T13:
S0.TableList

./D1/DBDICT/T14:
S0.TableList

./D1/DBDICT/T15:
S0.TableList

./D1/DBDICT/T16:
S0.TableList

./D1/DBDICT/T17:
S0.TableList

./D1/DBDICT/T18:
S0.TableList

./D1/DBDICT/T19:
S0.TableList

./D1/DBDICT/T2:
S0.TableList

./D1/DBDICT/T20:
S0.TableList

./D1/DBDICT/T21:
S0.TableList

./D1/DBDICT/T3:
S0.TableList

./D1/DBDICT/T4:
S0.TableList

./D1/DBDICT/T5:
S0.TableList

./D1/DBDICT/T6:
S0.TableList

./D1/DBDICT/T7:
S0.TableList

./D1/DBDICT/T8:
S0.TableList

./D1/DBDICT/T9:
S0.TableList

./D1/DBDIH:
P0.sysfile S11.FragList S2.FragList S4.FragList S6.FragList S8.FragList
S10.FragList S12.FragList S3.FragList S5.FragList S7.FragList S9.FragList

./D1/NDBCNTR:
P0.sysfile

./D10:
DBLQH

./D10/DBLQH:
S0.FragLog S1.FragLog S2.FragLog S3.FragLog

./D11:
DBLQH

./D11/DBLQH:
S0.FragLog S1.FragLog S2.FragLog S3.FragLog

./D2:
DBDICT DBDIH NDBCNTR

./D2/DBDICT:
P0.SchemaLog T12 T16 T2 T4 T8
T1 T13 T17 T20 T5 T9
T10 T14 T18 T21 T6
T11 T15 T19 T3 T7

./D2/DBDICT/T1:
S0.TableList

./D2/DBDICT/T10:
S0.TableList

./D2/DBDICT/T11:
S0.TableList

./D2/DBDICT/T12:
S0.TableList

./D2/DBDICT/T13:
S0.TableList

./D2/DBDICT/T14:
S0.TableList

./D2/DBDICT/T15:
S0.TableList

./D2/DBDICT/T16:
S0.TableList

./D2/DBDICT/T17:
S0.TableList

./D2/DBDICT/T18:
S0.TableList

./D2/DBDICT/T19:
S0.TableList

./D2/DBDICT/T2:
S0.TableList

./D2/DBDICT/T20:
S0.TableList

./D2/DBDICT/T21:
S0.TableList

./D2/DBDICT/T3:
S0.TableList

./D2/DBDICT/T4:
S0.TableList

./D2/DBDICT/T5:
S0.TableList

./D2/DBDICT/T6:
S0.TableList

./D2/DBDICT/T7:
S0.TableList

./D2/DBDICT/T8:
S0.TableList

./D2/DBDICT/T9:
S0.TableList

./D2/DBDIH:
P0.sysfile S11.FragList S2.FragList S4.FragList S6.FragList S8.FragList
S10.FragList S12.FragList S3.FragList S5.FragList S7.FragList S9.FragList

./D2/NDBCNTR:
P0.sysfile

./D8:
DBLQH

./D8/DBLQH:
S0.FragLog S1.FragLog S2.FragLog S3.FragLog

./D9:
DBLQH

./D9/DBLQH:
S0.FragLog S1.FragLog S2.FragLog S3.FragLog

./LCP:
0 1

./LCP/0:
T2F0.Data T2F3.Data T2F6.Data T3F1.Data T3F4.Data T3F7.Data
T2F0.ctl T2F3.ctl T2F6.ctl T3F1.ctl T3F4.ctl T3F7.ctl
T2F1.Data T2F4.Data T2F7.Data T3F2.Data T3F5.Data
T2F1.ctl T2F4.ctl T2F7.ctl T3F2.ctl T3F5.ctl
T2F2.Data T2F5.Data T3F0.Data T3F3.Data T3F6.Data
T2F2.ctl T2F5.ctl T3F0.ctl T3F3.ctl T3F6.ctl

./LCP/1:

./LG:

./TS: