It looks like MySQL5InnoDBDialect uses "ENGINE=InnoDB" and MySQL5Dialect does not. With MySQL5Dialect, I think that you should get the default MySQL storage engine.
MySQL also has configuration settings (database and server level) for the default storage engine which would be used if no storage engine is specified for the created database or table. See https://dev.mysql.com/doc/refman/5.1/en/storage-engine-setting.html
Thank you, I just needed to set the default engine setting to NDBCLUSTER. I found an alternative solution, where I created a custom dialect class by extending the MySQL5Dialect class, but the solution you suggested is much better for my project.