Re: The location where mysql cluster save the data

[Wiest Wang]

Hi Andrew


I reinitial the cluster and then do the script my_install_db.

now I found some files and directories.


before initial

/data/data

-rw-r--r-- 1 mysql mysql 16732 2012-02-10 20:56 ndb_11_out.log
-rw-r--r-- 1 mysql mysql 4 2012-02-10 20:50 ndb_11.pid

after initial

mysql@mysqlc1:/data/data$ ls -l
total 1112
drwx------ 2 mysql mysql 4096 2012-02-20 03:58 mysql
-rw-rw---- 1 mysql mysql 56252 2012-02-20 03:58 mysql-bin.000001
-rw-rw---- 1 mysql mysql 1029083 2012-02-20 03:58 mysql-bin.000002
-rw-rw---- 1 mysql mysql 38 2012-02-20 03:58 mysql-bin.index
-rw-r--r-- 1 mysql mysql 8733 2012-02-20 04:03 ndb_11_out.log
-rw-r--r-- 1 mysql mysql 4 2012-02-20 03:58 ndb_11.pid
-rw-r--r-- 1 mysql mysql 5944 2012-02-20 04:03 ndb_21_out.log
-rw-r--r-- 1 mysql mysql 4 2012-02-20 03:58 ndb_21.pid
drwx------ 2 mysql mysql 4096 2012-02-20 03:58 ndbinfo
drwx------ 2 mysql mysql 4096 2012-02-20 03:58 performance_schema
drwx------ 2 mysql mysql 4096 2012-02-20 03:58 test


but I think the directory name test or mysql was created by do the scripts my_install_db.

If I create a new database named like wiest, I can't find the files and directories about "wiest" in the datadir.


BTW,my data node and sql node is different physical server.





ths



Edited 1 time(s). Last edit at 02/20/2012 09:39PM by Wiest Wang.