Default partitioning scheme-opracowanie

Default partitioning scheme. All MySQL Cluster tables are by default partitioned by KEY using
the table's primary key as the partitioning key. If no primary key is explicitly set for the table, the
“hidden” primary key automatically created by the NDB storage engine is used instead. For additional
discussion of these and related issues, see Section 18.2.5, “KEY Partitioning”.
CREATE TABLE and ALTER TABLE statements that would cause a user-partitioned NDBCLUSTER
table not to meet either or both of the following two requirements are not permitted, and fail with an
error:
1. The table must have an explicit primary key.
2. All columns listed in the table's partitioning expression must be part of the primary key.
... zobacz całą notatkę