How do I set the default table type as innodb in my.cnf?

Question

For mysql...is there a way to set it so that every table that gets created is innodb?

Answer 1

Edit your my.cnf file to set following in the [mysqld] section (or the section your MySQLd reads):

default-storage-engine=InnoDB

After restarting the MySQL server, InnoDB should be the new default. To verify this, run the SQL statement:

SHOW ENGINES;

...The InnoDB line should be indicated as DEFAULT.

Note that the default-storage-engine option is just an alternate name for default-table-type.

Answer 2

Yes, you can

default-storage-engine=InnoDB

default-table-type=InnoDB

Answer 3

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?