InnoDB is a popular database engine for the MySQL RDBMS. It is an alternative to the default engine – MyISAM, and it has got many advantages which have made it the preferred engine for numerous PHP-powered web applications, among them Magento and Joomla, which have switched over to InnoDB permanently. For example, adding large volumes of data will be much faster with InnoDB, because it locks only a single database row to perform a particular operation, not the entire table, which makes the engine ideal for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the manner in which the data is handled. In simpler words, adding new or editing existing data will either be thoroughly completed, or will be canceled and the procedure will be rolled back in case any issue occurs in the meantime, which is why the content that remains in the database won’t be damaged.
InnoDB in Shared Web Hosting
InnoDB is available with all our Linux shared web hosting by default, not as a paid upgrade or upon request, so you’ll be able to install and manage any PHP script-driven app which needs the MySQL database storage engine without any difficulties once you order your shared web hosting account. InnoDB will be selected automatically as the default engine for a given database during the app installation, no matter if you make use of our single-click installation tool or create the database and activate the application manually, provided that the app requires it instead of the more famous MyISAM engine. We’ll make daily MySQL database backups, so you can be sure that you’ll never lose any data if you delete a database unintentionally or you overwrite some key information – you’ll just have to contact us and we will restore the database back to normal.