Add a feature to Percona Server to allow enforced use of a specific storage engine.

Registered by George Ormond Lorch III

Comsulting # 23310 :
Add a feature to Percona Server to allow enforced use of a specific storage engine.

The server option is --enforce_storage_engine (Ex: --enforce_storage_engine=Innodb) and it may not be changed at runtime.

When this option is specified and a user tries to create a table using an explicit storage engine that is not the specified enforced engine, they will get either an error if the no_engine_substitution SQL_MODE is set or a warinig if no_engine_substitution is OFF and the table will be created anyway using the enforced engine (this is consistent with the default MySQL way of creating as MyISAM if other engines aren't available unless no_engine_substitution is set).

Blueprint information

Status:
Complete
Approver:
Alexey Kopytov
Priority:
Undefined
Drafter:
George Ormond Lorch III
Direction:
Needs approval
Assignee:
George Ormond Lorch III
Definition:
Approved
Series goal:
Accepted for 5.5
Implementation:
Implemented
Milestone target:
milestone icon 5.5.24-26.0
Started by
Alexey Kopytov
Completed by
Alexey Kopytov

Sprints

Whiteboard

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.