I just created a new WordPress site in my server. Normally, WordPress uses MyISAM as the database type. But this time, it created all InnoDB tables! Is this normal? Has WordPress switched to InnoDB in the latest versions?
WordPress actually specifies no table type in the create statements, so it uses MySQL's default table engine which is InnoDB from version 5.5 onwards.
It matters when it comes to backing up your Wordpress site. I learned this the hard way. If the DB is innodb then R1 cloud restore type backups won't save all the data because it has to be shut down first in order to back it up. Whereas MYISAM can be backed up no problem.