Is a mixture of both MyISAM and InnoDB table types on the same MariaDB 10.3 database 'bad'?

[spaceman]

Hi All,

I notice that some of our MariaDB 10.3 database have a mixture of MyISAM and InnoDB table types on them.

Is it inherently "bad" to have both types of table on the same database? Or doesn't/shouldn't it make any difference?

If it is ill-advised, then I guess we'll look into converting all tables to InnoDB, as this seems to be the preferred?

https://mariadb.com/kb/en/choosing-the-right-storage-engine/
https://stackoverflow.com/questions/15678406/when-to-use-myisam-and-innodb/15678615#15678615

Thx for your thoughts.

 

[cPRex]

Hey there! From a MySQL standpoint, there's no reason you can't have both working in the same database just fine. It could potentially cause confusion down the road with administration, but the server doesn't mind at all.

 

[spaceman]

Thanks for that cPRex. It still "feels weird" to have both, though! I'm a big "less is more" fan