Before a migration to a MySQL Cluster, it is likely that you will want to be sure that the resources available are sufficient to handle the proposed cluster. Generally, MySQL Clusters are more memory intensive than anything else, and this recipe explains how you can estimate your memory usage in advance.
Note
The script that is used in this recipe, ndb_size.pl
, is provided by MySQL Cluster in a cluster binary. In the See also section, an alternative and more accurate tool is mentioned. ndb_size.pl
is excellent for estimates, but it is worth remembering that it is only an estimate based on, sometimes inaccurate, assumptions.
This recipe demonstrates how to estimate, from a table scheme or an existing non-clustered table, the memory-usage of that table in the NDB (MySQL Cluster) storage engine. We will use a script, ndb_size.pl
, provided in the MySQL-Cluster-gpl-tools
package that is installed as part of the storage node installation in the...