Opened 9 years ago
Last modified 9 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.
Note: See
TracTickets for help on using
tickets.
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).