For mysql...is there a way to set it so that every table that gets created is innodb?
Edit your my.cnf file to set following in the [mysqld] section (or the section your MySQLd reads):
After restarting the MySQL server, InnoDB should be the new default. To verify this, run the SQL statement:
...The InnoDB line should be indicated as DEFAULT.
Note that the default-storage-engine option is just an alternate name for default-table-type.
I want to my Clustered Node to work like when I create a new database It won't get replicated. Normally after having the above mentioned attribute set 'default-storage-engine=INNODB', When I create a table without mentioning the engine it is not replicated to the other node, that is fine. But Why does the database gets created on other nodes?