InnoDB is a MySQL storage engine, which has been gaining in popularity in recent years, as it provides a much better overall performance and a faster crash recovery in comparison with the default engine that’s used by the MySQL relational database management system – MyISAM. InnoDB is endorsed by many devs that run highly scalable software applications, since it works more effectively with huge data volumes, while it keeps the server processing load at a minimum. Also, it locks only one database row if anything should be edited, whereas many other engines lock the entire database table and hence need much more time to process multiple successive tasks. Last, but not least, InnoDB follows the "all-or-nothing" rule – in case the modification of the entire data cannot be completed successfully for any reason, the action is rolled back to avoid scrambling or the loss of data. Magento and the latest versions of Joomla are two examples of widespread script-driven applications that have switched to InnoDB.

InnoDB in Website Hosting

You’ll be able to use any open-source script-based application that needs InnoDB in case you have a Linux website hosting with our company, as the MySQL database engine is present on our advanced cloud hosting platform by default. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably in case this engine is required. You can run applications which need the MyISAM engine without having any problem as well and, again, the engine will be selected automatically, so you will not have to change anything manually at any moment. On top of that, we will also generate regular backups of all the MySQL databases that you’ve got in your shared hosting account, so if you erase or overwrite something, we can easily restore it the way it was on any of the previous seven days.

InnoDB in Semi-dedicated Hosting

If you create a new MySQL database from the hosting Control Panel coming with each of our semi-dedicated server plans and you begin installing a script-based software application either manually or using our one-click app installer, the storage engine for the database will be set automatically on the basis of the particular app’s prerequisites. As InnoDB is available on the cloud web hosting platform where your new account will be created, it will be set as the default engine for any app that requires it without any manual action required on your end at any time. To avoid any chance of losing data if you update an application or if you delete a database by accident, we will make backups of all your databases each and every day, so if anything happens, we can restore your content.

InnoDB in Dedicated Web Hosting

All Linux dedicated web hosting that are ordered with our custom-built Hepsia Control Panel come with a software package that’s pre-activated and besides everything else, you will get the InnoDB storage engine, so you will not need to install it manually in case you wish to run PHP scripts that need it. All it takes to activate such a script is to set up a new database and to start the setup process – as soon as the script setup wizard obtains access to the database in question and starts entering content into it, InnoDB will be set as the default engine for this database as long as it is the one required by the particular script. You’ll also be able to install scripts that require the other very popular MySQL engine, MyISAM, so you will not need to update any settings on the dedicated server. This will allow you to activate a variety of scripts on a single machine and to use the latter to its maximum capacity.