InnoDB is a very popular database storage engine for the MySQL relational database management system. It’s an alternative to the default MyISAM engine and it has numerous strengths that make it the engine of choice for a lot of PHP script-powered apps, such as Magento and Joomla, which have switched to InnoDB for good. For example, adding immense amounts of data will be faster with InnoDB, due to the fact that it locks only a single database row to perform a given 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 information is treated. Put simply, adding new or updating existent data will either be entirely completed, or will be canceled and the procedure will be rolled back in case a given issue appears during the process, which is why the content that remains in the database won’t be damaged.

InnoDB in Website Hosting

InnoDB is available with all our Linux website hosting by default, not as a paid upgrade or upon request, so you’ll be able to install and run any PHP-based web application that needs the InnoDB storage engine without having to deal with any impediment once you open your shared web hosting account. InnoDB will be selected automatically as the default engine for a certain MySQL database during the app activation, regardless of whether you make use of our single-click installer or create the database and activate the application manually, on the condition that the app requires InnoDB instead of the more popular MyISAM engine. We’ll store daily backups of all your MySQL databases, so you can be sure that you will never lose any content if you erase a database by mistake or you overwrite some important information – you will simply have to notify us and we’ll restore everything back to normal.

InnoDB in Semi-dedicated Hosting

If you set up a brand-new MySQL database from the hosting Control Panel offered with each of our semi-dedicated server packages and you begin installing a script-driven software app either manually or using our single-click app installer tool, the storage engine for the database will be set automatically based on the requirements of the given app. As InnoDB is available on the cloud web hosting platform where your new semi-dedicated server account will be created, it will be set as the default engine for any application that requires it without any manual action required on your end at any moment. To prevent any chance of losing information if you update an app or if you remove a database unintentionally, we will generate backups of all your MySQL databases each and every day, so if anything goes wrong, we can retrieve your data.