Details
-
Bug
-
Status: Done
-
Medium
-
Resolution: Invalid
-
5.7.23-23
-
None
-
None
-
CentOS 6
Description
we want to build a blackhole slave
so we use the variable enforce_storage_engine
but ,we create an Innodb table in master ,and the slave get an Error
Worker 1 failed executing transaction '9a382326-236d-11e8-ae2b-0022ec3c7f10:1126' at master log mysql-bin.000001, end_log_pos 1206767; Error 'Unknown storage engine 'InnoDB'' on query. Default database: 'aaa'. Query: 'CREATE TABLE `mmm`(
`a` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci'
[email protected](none)05:41:10>show variables like "%engine%";
-------------------------------------------+
| Variable_name | Value |
-------------------------------------------+
| default_storage_engine | BLACKHOLE |
| default_tmp_storage_engine | BLACKHOLE |
| disabled_storage_engines | |
| enforce_storage_engine | blackhole |
| internal_tmp_disk_storage_engine | InnoDB |
-------------------------------------------+
[email protected](none)05:41:48>show engines;
-------------------------------------------------------------------------------------------------------------------------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
-------------------------------------------------------------------------------------------------------------------------------+
| PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | NO |
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| CSV | YES | CSV storage engine | NO | NO | NO |
| BLACKHOLE | DEFAULT | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO |
| MyISAM | YES | MyISAM storage engine | NO | NO | NO |
| InnoDB | YES | Percona-XtraDB, Supports transactions, row-level locking, and foreign keys | YES | YES | YES |
| ARCHIVE | YES | Archive storage engine | NO | NO | NO |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
| FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL |
-------------------------------------------------------------------------------------------------------------------------------+
select @@sql_mode
-> ;
------------
| @@sql_mode |
------------
------------