Opened 7 years ago

Last modified 7 years ago

#405 new defect

storage_engine is not replicated for CREATE TABLE

Reported by: andersk Owned by:
Priority: normal Milestone:
Component: sql Keywords:
Cc:

Description

It turns out MySQL doesn’t replicate the storage_engine variable. So if a CREATE TABLE statement with no ENGINE specified is issued from a session with a different storage_engine than the session where the replication slave was started, then the primary and secondary end up creating tables with different engines. This could cause applications to break when we fail over, and could potentially lead to replication conflicts before then.

Change History (1)

comment:1 Changed 7 years ago by andersk

Also observed at http://trac.buildbot.net/ticket/2492. We should probably file an upstream bug (if it isn’t fixed already in more current versions).

Note: See TracTickets for help on using tickets.