Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
Description
We should support enforce_storage_engine, like Percona Server 5.5/5.6 has. Description: http://www.percona.com/doc/percona-server/5.6/management/enforce_engine.html
Use case: To improve management – eg. enforce_storage_engine=InnoDB – this ensures that people don't create MyISAM tables by accident.
Customer requests: There have been no customer requests for this yet from MariaDB Corporation.
1. It is however likely used in HPCloud, DBaaS – see: https://github.com/saurabhsurana/trove-installer/blob/f7cf7824fb7536b16da073ba7fdb0e717da26fb1/saltstack/states/trove/taskmanager/mysql.config.template
2. We have had a migration from MariaDB 10 to Percona Server 5.6 at a bank in Germany performed by FromDual for this very reason – http://www.fromdual.ch/de/node/1074
Attachments
Issue Links
- is duplicated by
-
MDEV-8357 Ability to disable creation of MyISAM tables
-
- Closed
-
- relates to
-
MDEV-8219 enforce_storage_engine cannot be set globally
-
- Closed
-
-
MDEV-8576 Bootstrap should ignore --enforce-storage-engine option
-
- Closed
-
-
MDEV-8577 With enforce-storage-engine mysql_upgrade corrupts the schema: ALTER TABLE should either bypass enforce-storage-engine, or mysql_upgrade should refuse to run
-
- Closed
-
-
MDEV-8578 Wrong error code/message with enforce_storage_engine and NO_ENGINE_SUBSTITUTION
-
- Stalled
-
-
MDEV-34812 Storage engine set by enforce_storage_engine is not enforced for partioned tables
-
- Open
-
-
MDEV-26372 enforce-storage-engine=InnoDB has no usability as an option to mysqld-install-db
-
- Closed
-
-
MDEV-30065 "mariadb-install-db --enforce-storage-engine=InnoDB" fails with InnoDB errors
-
- Stalled
-
-
MDEV-30074 DROP PROCEDURE assertion sql/sql_parse.cc:5909: int mysql_execute_command(THD*): Assertion `thd->transaction.stmt.is_empty()' failed
-
- Open
-