Merge lp:~hrvojem/percona-server/enforce_engine_docs into lp:percona-server/5.5

[Hrvoje Matijakovic]

[Alexey Kopytov (akopytov)]

In 5.5, the default storage engine is InnoDB rather than MyISAM unless specified otherwise with default_storage_engine. I suggest to s/MyISAM/the default storage engine/

See:

http://dev.mysql.com/doc/refman/5.5/en/server-sql-mode.html#sqlmode_no_engine_substitution
http://dev.mysql.com/doc/refman/5.5/en/server-options.html#option_mysqld_default-storage-engine

review: Needs Fixing

[Alexey Kopytov (akopytov)]

Note that the MySQL manual uses uppercase for SQL modes, i.e. NO_ENGINE_SUBSTITUTION, but lowercase for variable names, i.e. sql_mode.

[Laurynas Biveinis (laurynas-biveinis)]

LGTM, thanks.

(Please wait for Alexey's review too)

review: Approve

[Stewart Smith (stewart)]

review: Approve

[Stewart Smith (stewart)]

FYI, I've pushed this to the 5.5.24-26.0 release branch so that docs will be included in the release.

[Alexey Kopytov (akopytov)]

Hrvoje,

I don't understand why you have removed all mentions of SQL modes. It may not be obvious what enabling "NO_ENGINE_SUBSTITUTION`" refers to. Perhaps you meant to say "the NO_ENGINE_SUBSTITUTION SQL mode"?

review: Needs Fixing

[Alexey Kopytov (akopytov)]

review: Approve

[Stewart Smith (stewart)]

 review approve
--
Stewart Smith

review: Approve

=== modified file 'doc/source/index.rst'
--- doc/source/index.rst	2012-03-27 09:09:14 +0000
+++ doc/source/index.rst	2012-05-21 06:50:26 +0000
@@ -122,6 +122,7 @@
    management/udf_maatkit
    management/innodb_fake_changes
    management/innodb_kill_idle_trx
+   management/enforce_engine
 
 Diagnostics Improvements
 ========================

=== added file 'doc/source/management/enforce_engine.rst'
--- doc/source/management/enforce_engine.rst	1970-01-01 00:00:00 +0000
+++ doc/source/management/enforce_engine.rst	2012-05-21 06:50:26 +0000
@@ -0,0 +1,36 @@
+.. _enforce_engine:
+
+========================
+Enforcing Storage Engine
+========================
+
+|Percona Server| has implemented variable which can be used for enforcing the use of a specific storage engine.
+
+When this variable is specified and a user tries to create a table using an explicit storage engine that is not the specified enforced engine, he will get either an error if the ``NO_ENGINE_SUBSTITUTION`` SQL mode is enabled or a warning if ``NO_ENGINE_SUBSTITUTION`` is disabled and the table will be created anyway using the enforced engine (this is consistent with the default |MySQL| way of creating the default storage engine if other engines aren't available unless ``NO_ENGINE_SUBSTITUTION`` is set).
+
+In case user tries to enable enforce_storage_engine with engine that isn't available, system will not start.
+
+Version Specific Information
+============================
+
+  * 5.5.24-26.0
+    Variable :variable:`enforce_storage_engine` implemented.
+
+System Variables
+================
+
+.. variable:: enforce_storage_engine
+
+     :cli: No
+     :conf: Yes
+     :scope: Global
+     :dyn: No
+     :vartype: String
+     :default: NULL
+
+Example
+=======
+
+Adding following option to :term:`my.cnf` will start the server with InnoDB as enforced storage engine. ::  
+
+ enforce_storage_engine=InnoDB