WL#3939: Replicate ENGINE=
Affects: Server-7.x
—
Status: Un-Assigned
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, 2025, Oracle Corporation and/or its affiliates. All rights reserved.