InnoDB is a popular database engine for the MySQL database management system. It is an alternative to the default MyISAM engine and it has a number of upsides which have made it the engine of choice for lots of PHP-based web applications, including Joomla and Magento, which have moved to InnoDB permanently. For instance, importing enormous data volumes will be faster with InnoDB, as it locks only a single row to execute a specific task, not the entire table, which makes the engine excellent for scalable apps. It also supports foreign keys and transactions – these refer to the manner in which the information is handled. To put it simply, appending new or updating existing data will either be fully completed, or will be aborted and the procedure will be rolled back if a certain problem shows up in the meantime, therefore the content that remains in the database will not be damaged.

InnoDB in Shared Hosting

InnoDB is offered with all our Linux shared hosting by default, not as a paid upgrade or upon request, so you can install and run any open-source script-driven application which requires the InnoDB storage engine without encountering any problem as soon as you open your shared account. InnoDB will be pre-selected as the default engine for a specific MySQL database during the app installation, regardless of whether you make use of our 1-click installer or create the MySQL database and install the application manually, on the condition that the application requires InnoDB instead of the more popular MyISAM engine. We’ll store regular MySQL database backups, so you can be sure that you’ll never lose any data in case you delete a database accidentally or you overwrite some crucial info – you’ll simply need to touch base with us and we’ll restore your content the way it was.