What data types are supported by MySQL Cluster?
MySQL Cluster supports all of the usual MySQL data types, with the exception of those associated with MySQL’s spatial extensions. (See Chapter 16, Spatial Extensions.) In addition, there are some differences with regard to indexes when used with NDB tables. Note: MySQL Cluster tables (that is, tables created with ENGINE=NDBCLUSTER) have only fixed-width rows. This means that (for example) each record containing a VARCHAR(255) column will require space for 255 characters (as required for the character set and collation being used for the table), regardless of the actual number of characters stored therein. This issue is expected to be fixed in a future MySQL release series. See Section 15.11, “Known Limitations of MySQL Cluster”, for more information about these issues.
MySQL Cluster 5.1, including MySQL CLuster NDB 6.2 and 6.3, supports all of the usual MySQL data types, including those associated with MySQL’s spatial extensions; however, the NDBCLUSTER storage engine does not support spatial indexes. (Spatial indexes are supported only by MyISAM; see Chapter 22, Spatial Extensions, for more information.) In addition, there are some differences with regard to indexes when used with NDB tables.
MySQL Cluster NDB 6.x and later supports all of the usual MySQL data types, including those associated with MySQL’s spatial extensions; however, the NDB storage engine does not support spatial indexes. (Spatial indexes are supported only by MyISAM; see Section 11.13, “Spatial Extensions”, for more information.) In addition, there are some differences with regard to indexes when used with NDB tables.
In MySQL 5.0, MySQL Cluster supports all of the usual MySQL data types, including (beginning with MySQL 5.0.16) those associated with MySQL’s spatial extensions; however, the NDB storage engine does not support spatial indexes. (Spatial indexes are supported only by MyISAM; see Section 11.12, “Spatial Extensions”, for more information.) In addition, there are some differences with regard to indexes when used with NDB tables.
