Made test suite compatible with MySQL following #20392

Simplified MySQL engine detection using INFORMATION_SCHEMA.ENGINES (see http://dev.mysql.com/doc/refman/5.1/en/engines-table.html), avoiding a table creation within a rollbacked transaction, which is unsupported (can_rollback_ddl = False).