InnoDB is a MySQL database engine, which has been gaining in popularity lately, because it offers a significantly better overall performance and an improved crash recovery compared to the default engine used by MySQL – MyISAM. InnoDB is endorsed by many devs that write scalable software applications, since it works more effectively with large amounts of data, while it keeps the server load at a minimum. Moreover, it locks only one database row if any info should be updated, while lots of other engines lock the entire table and thus require more time to perform multiple sequential tasks. Last, but not least, InnoDB obeys a set of "all-or-nothing" rules – in case the entire data modification process cannot be completed for some reason, the operation is rolled back to prevent confusion or the loss of data. Magento and the newest Joomla releases are two examples of popular script-powered software apps that have switched to InnoDB.

InnoDB in Shared Hosting

InnoDB is available with all our Linux shared hosting by default, not upon request or as a paid upgrade, so you will be able to activate and run any PHP-powered web application which needs the database engine without any impediments once you order your shared hosting account. InnoDB will be selected automatically as the default engine for a particular database during the app activation process, regardless of whether you use our 1-click installation tool or create the database and install the app manually, provided that the app requires it instead of the more famous MyISAM engine. We will perform daily backups of all your MySQL databases, so you can be certain that you will never lose any data if you erase a database accidentally or you overwrite some important info – you’ll simply need to contact us and we’ll restore your data back to normal.

InnoDB in Semi-dedicated Hosting

If you set up a brand new MySQL database from the Control Panel coming with all our semi-dedicated server plans and you begin installing a PHP script-based software app either manually or using our single-click application installer, the storage engine for the MySQL database will be selected automatically based on the requirements of the particular application. Since InnoDB is available on the cloud website hosting platform where your new semi-dedicated 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 avoid any chance of losing information if you update an application or if you delete a database unintentionally, we’ll perform backups of all your databases each day, so if anything happens, we can rescue your content.

InnoDB in Dedicated Hosting

All Linux dedicated hosting ordered with our custom-developed Hepsia hosting Control Panel include a software bundle that is pre-installed and among everything else, you’ll get the InnoDB database storage engine, so you will not have to install it manually if you want to use open-source scripts that need it. All it takes to activate such a script is to create a new MySQL database and to start the installation process – once the setup wizard obtains access to the database and begins importing data into it, InnoDB will be set as the default engine for this database as long as it is the one needed by the particular script. You will also be able to run scripts that need the other widely used MySQL engine, MyISAM, so you will not need to modify any settings on the dedicated server. This will allow you to run various scripts on one single physical machine and to use it to its maximum capacity.