WL#3939: Replicate ENGINE=
Affects: Server-7.x — Status: Un-Assigned — Priority: Low
DESCRIPTION ----------- Engine information should be replicated to slave per default NEW OPTION ---------- CHANGE MASTER SET REPLICATE_ENGINE=NO, meaning that engine information should not be replicated to slave (some users want to use other engine type on slave; for example they want to use a transactional engine on the master and replicate that to a MyISAM table to benefit from fulltext search). The default is currently (5.0, 5.1) to NOT replicate the ENGINE clause of CREATE TABLE; as this task would change the default, it would require a note in the list of incompatible changes. APPROACHES ---------- There are three approaches: 1. Never include the engine in the create table clause; 2. Always include the engine in the create table clause; 3. Include the engine in the create table clause, if and only if the user explicitly sets it.
Copyright (c) 2000, 2017, Oracle Corporation and/or its affiliates. All rights reserved.