InnoDB is a MySQL database engine, which has been gaining popularity in recent years, because it offers a significantly better overall performance and an improved database crash recovery compared to the default engine that’s used by the MySQL RDBMS – MyISAM. InnoDB is endorsed by lots of developers that create scalable software apps, since it works more efficiently with immense data volumes, while it keeps the server processing load at a minimum. Moreover, it it locks only one row in the database if anything should be modified, whereas many other engines lock the entire database table and therefore require more time to perform multiple consecutive tasks. Last, but not least, InnoDB follows a set of "all-or-nothing" rules – in case the entire data modification procedure cannot be completed for whatever reason, the operation is rolled back to avoid confusion or data loss. Magento and the newest Joomla releases are two instances of famous open-source script-based web apps that have moved to InnoDB.

InnoDB in Cloud Web Hosting

You can install any open-source script-powered web application that requires InnoDB if you have a cloud web hosting plan with us, as the storage engine is present on our innovative cloud web hosting platform as standard. 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 install applications which need the MyISAM engine without having to deal with any obstacle as well and, once again, the engine will be pre-selected, so you won’t have to modify anything manually at any point. Furthermore, we will also make daily backups of all the databases that you’ve got in the shared web hosting account, so in case you erase or overwrite anything, we can easily restore it the way it was on any of the previous seven days.

InnoDB in Semi-dedicated Servers

If you set up a brand new MySQL database from the hosting Control Panel offered with all our semi-dedicated server packages and you begin installing a PHP-based software application either manually or using our single-click app installer tool, the storage engine for the MySQL database will be set automatically depending on the given app’s requirements. Since InnoDB is present on the cloud hosting platform where your new semi-dedicated account will be created, it will be set as the default engine for each application that needs it without any manual action required on your end at any time. To avoid any risk of losing information if you update an app or if you remove a database by accident, we’ll perform backups of all your databases every day, so if anything goes wrong, we can recover your data.

InnoDB in Dedicated Servers

All dedicated web hosting plans ordered with our in-house developed Hepsia Control Panel come with a software package that’s pre-installed and among everything else, you will get the InnoDB storage engine, so you will not have to install it manually in case you want to use scripts that need it. All it takes to use such a script is to create a new database and to begin the installation process – as soon as the installer wizard gains access to the database in question and begins dumping data in it, InnoDB will be set as the default MySQL engine for this database as long as it is the one needed by the script. You’ll also be able to install scripts that need MyISAM, the other very popular MySQL engine, so you will not need to edit any settings on the server. This will permit you to use various scripts on a single server and to use the latter to its maximum potential.