Binary logging-opracowanie

Binary logging.
MySQL Cluster has the following limitations or restrictions with regard to binary logging:
• sql_log_bin [557] has no effect on data operations; however, it is supported for schema
operations.
• MySQL Cluster cannot produce a binary log for tables having BLOB columns but no primary key.
• Only the following schema operations are logged in a cluster binary log which is not on the
mysqld executing the statement:
• CREATE TABLE
• ALTER TABLE
• DROP TABLE
• CREATE DATABASE / CREATE SCHEMA
• DROP DATABASE / DROP SCHEMA
• CREATE TABLESPACE
• ALTER TABLESPACE
• DROP TABLESPACE
• CREATE LOGFILE GROUP
• ALTER LOGFILE GROUP
• DROP LOGFILE GROUP
See also Section 17.1.6.10, “Limitations Relating to Multiple MySQL Cluster Nodes”.
... zobacz całą notatkę