On "What's New in MySQL 5.1" page of the documentation (http://dev.mysql.com/doc/refman/5.1/en/mysql-nutshell.html) I see this statement :
"In MySQL versions previous to 5.1.6, the NDBCluster storage engine was strictly in-memory; beginning with MySQL 5.1.6, it is possible to store Cluster data (but not indexes) on disk."
This makes me think that ALL data, including indexed columns, is completely stored on the disk. However on "Disk Data Storage Requirements" page of the documentation (http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-disk-data-storage-requirements.html) I see this statement :
"In a Disk Data table, the first 256 bytes of a TEXT or BLOB column are stored in memory; only the remainder is stored on disk."
If text/blog type columns are used, I wonder if data recovery is 100% possible when power is lost to all NDB nodes.
Also some some other documentation pages states that only 'non-indexed' columns are stored on disk. Does this also mean that data recovery is not 100% in case of a complete power failure even though disk based ndb clustering is setup?
August 22, 2007 02:38PM
August 23, 2007 06:22PM
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.