InnoDB is a very popular database storage engine for the MySQL relational database management system. It is an alternative to the default engine – MyISAM, and it has got a number of advantages which make it the preferred engine for a lot of PHP-powered web apps, including Joomla and Magento, which have switched over to InnoDB permanently. For instance, importing huge amounts of data will be faster with InnoDB, because it locks only a single row to accomplish a specific task, not the entire table, which makes the engine excellent for scalable applications. It also supports foreign keys and database transactions – these refer to the way in which the information is handled. To put it simply, appending new or modifying existent data will either be thoroughly completed, or will be annulled and the operation will be rolled back in case a certain issue occurs during the process, thus the content that remains in the database won’t be lost.
InnoDB in Website Hosting
InnoDB is available with all our Linux website hosting packages by default, not upon request or as a paid upgrade, so you’ll be able to activate and manage any PHP-powered app which needs the MySQL storage engine without having to deal with any problem as soon as you open your account. InnoDB will be pre-selected as the default engine for a given MySQL database during the app installation, irrespective of whether you take advantage of our one-click installer or create the database and activate the app manually, on the condition that the application requires InnoDB instead of the more popular MyISAM engine. We’ll create daily MySQL database backups, so you can rest assured that you will never lose any content if you erase a database by accident or you overwrite some vital info – you will just have to notify us and we’ll restore your content back to normal.