Find out about InnoDB and find out why it’s been picked out as the default MySQL database engine.
InnoDB is a very popular database storage engine for the MySQL RDBMS. It is an alternative to the default MyISAM engine and it has a lot of pluses that have made it the engine of choice for a lot of PHP-based apps, among them Magento and Joomla™, which have switched to InnoDB permanently. For example, adding immense amounts of data will be much faster with InnoDB, as it locks only a single database row to carry out a certain task, not the entire table, which makes the engine perfect for scalable apps. It also supports foreign keys and transactions – these refer to the manner in which the data is handled. Put simply, importing new or editing existent data will either be thoroughly completed, or will be canceled and the procedure will be rolled back if any problem appears in the meantime, thus the content that remains in the database won’t be lost.
InnoDB in Shared Website Hosting
InnoDB is offered with all our Linux shared website hosting packages by default, not upon request or as a paid upgrade, so you can activate and run any open-source script-driven web application which requires the MySQL database storage engine without encountering any problem once you activate your shared website hosting account. InnoDB will be pre-selected as the default engine for a specific database during the app activation, no matter if you take advantage of our one-click installation tool or create the MySQL database and activate the application manually, as long as the application requires it instead of the more popular MyISAM engine. We’ll store daily database backups, so you can be certain that you won’t ever lose any content if you erase a database accidentally or you overwrite some essential information – you just have to inform us and we will restore the database back to normal.