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.