Why does wpforo use MyISAM engine and not INNODB?
Here is response from production host:
After deeply investigating your issue, I managed to successfully activate WPforo on your staging environment. The problem with it is the explicit declaration of MyISAM engine in some of the plugin's tables creation code as ******'s Highly Available database layer accepts only the option InnoDB as engine.
We are missing several db tables as well, due to not installing.
Another response from host just now:
Let me follow up on this, regarding the "fix" I applied to make the plugin work, it's just temporary - any plugin update will probably cause problems / break your installation.
As this is a development issue of a plugin we can't take responsibility that everything will work without any issues.
This is why you have to contact the plugin's developer team and ask them to resolve this bug as we at ***** among most major managed WordPress providers, prohibit the use of MyISAM tables.
wpForo supports both, you can check it in installation files. wpForo may use InnoDB on installation, it depends on your MySQL version and on InnoDB support. Also, not all tables should be InnoDB. Each of this engine types is good for certain data storage. InnoDB is not a best and universal for everything.
Please use the instruction explained here. just execute the query. If your server doesn't support MyISAM (which is too strange) you should change all MyISAM words to innoDB in query then execute it:
which is too strange
Hi Robert. Just to complement the information, an example of an application where MyISAM is not supported: https://mariadb.com/kb/en/mariadb-galera-cluster-known-limitations/
this MariaDB cluster for high availability does not support replication of MyISAM tables.
MyISAM must have other incompatible environments, but the INNODB standard is always compatible because practically all Wordpress (and other CMS) and plugins use it.
honestly in my opinion INNODB should be the default in WPForo installation to avoid compatibility problems. On the contrary, whoever prefers MyISAM is who must execute a query manually 😉