Find out about InnoDB and find out why it’s recently been chosen as the default MySQL database engine.
InnoDB is a popular storage engine for the MySQL database management system. It is an alternative to the default engine – MyISAM, and it has got lots of upsides that have made it the engine of choice for lots of open-source script-powered software apps, including Joomla™ and Magento, which have shifted over to InnoDB for good. For example, importing enormous amounts of data will be much faster with InnoDB, due to the fact that it locks only a single database row to execute a certain task, not the entire table, which makes the engine ideal for scalable apps. InnoDB also supports foreign keys and database transactions – these refer to the manner in which the information is tackled. To put it simply, appending new or modifying existent data will either be entirely completed, or will be annulled and the procedure will be rolled back if a given issue occurs in the meantime, hence the content that remains in the database won’t be damaged.
InnoDB in Shared Hosting
InnoDB is available with all our shared hosting by default, not upon request or as a paid upgrade, so you will be able to install and manage any PHP script-based application that requires the MySQL storage engine without encountering any impediment once you open your shared web hosting account. InnoDB will be pre-selected as the default engine for a certain MySQL database during the app installation process, irrespective of whether you use our one-click installer or create the database and install the application manually, as long as the application requires it instead of the more famous MyISAM engine. We will keep daily backups of all your databases, so you can be certain that you’ll never lose any content in case you delete a database accidentally or you overwrite some crucial information – you’ll simply have to alert us and we’ll restore everything back to normal.