Preventing execution of unsupported statements. In order to prevent execution of statements
that would cause GTID-based replication to fail, all servers must be started with the --enforcegtid-
consistency [2056] option when enabling GTIDs. This causes statements of any of the types
discussed previously in this section to fail with an error.
For information about other required startup options when enabling GTIDs, see Section 16.1.3.2,
“Setting Up Replication Using GTIDs”.
sql_slave_skip_counter [2034] is not supported when using GTIDs. If you need to skip
transactions, use the value of the master's gtid_executed [2059] variable instead; see Injecting
empty transactions, for more information.
... zobacz całą notatkę
Komentarze użytkowników (0)