Limitations Relating to Multiple MySQL Cluster Nodes-opracowanie

Limitations Relating to Multiple MySQL Cluster Nodes
Multiple SQL nodes.
The following are issues relating to the use of multiple MySQL servers as MySQL Cluster SQL nodes,
and are specific to the NDBCLUSTER storage engine:
• No distributed table locks. A LOCK TABLES works only for the SQL node on which the lock is
issued; no other SQL node in the cluster “sees” this lock. This is also true for a lock issued by any
statement that locks tables as part of its operations. (See next item for an example.)
• ALTER TABLE operations. ALTER TABLE is not fully locking when running multiple MySQL
servers (SQL nodes). (As discussed in the previous item, MySQL Cluster does not support
distributed table locks.)
... zobacz całą notatkę