InnoDB is a MySQL database storage engine, which has been gaining popularity lately, because it offers a significantly better overall performance and an improved database crash recovery compared to the default engine used by the MySQL database management system – MyISAM. InnoDB is endorsed by lots of developers that build scalable software apps, as it works more effectively with immense amounts of data, while it keeps the server processing load low. Additionally, it locks only a single database row in case anything should be updated, while lots of other engines lock the entire table and thus require much more time to fulfill several successive tasks. Last, but not least, InnoDB adheres to 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 latest Joomla™ versions are two instances of famous open-source script-powered apps which have switched to InnoDB.

InnoDB in Cloud Hosting

InnoDB is offered with all our cloud hosting by default, not as a paid upgrade or upon request, so you will be able to activate and manage any PHP script-powered web application that requires the MySQL storage engine without having to deal with any impediment as soon as you order your shared hosting account. InnoDB will be selected automatically as the default engine for a certain database during the app activation process, no matter if you make use of our single-click installation tool or create the MySQL database and activate the app manually, as long as the application requires InnoDB instead of the more popular MyISAM engine. We will make daily backups of all your MySQL databases, so you can be certain that you won’t ever lose any data in case you erase a database unintentionally or you overwrite some important info – you’ll simply need to notify us and we will restore the database the way it was.

InnoDB in Semi-dedicated Servers

If you set up a brand new MySQL database from the Control Panel provided with each of our semi-dedicated server plans and you start installing a PHP script-powered software application either manually or using our one-click application installer tool, the storage engine for the database will be selected automatically on the basis of the requirements of the app in question. Since InnoDB is available 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 erase a database by accident, we will perform a backup of all your MySQL databases every day, so if something happens, we can recover your data.

InnoDB in Dedicated Servers

If you acquire a new dedicated server, you will be able to pick one of the three Control Panels that we are offering – cPanel and Hepsia. Any dedicated server ordered with Hepsia comes with InnoDB pre-activated, so you will not need to activate this MySQL database engine manually in order to be able to run PHP-powered apps that require it. InnoDB is used by scalable applications and since a dedicated server will offer you all the server resources that you require in order to run large-size websites, it’s pretty likely that you will resort to InnoDB. You’ll be able to make use of other engines as well, so in case a particular application requires MyISAM instead of InnoDB, you will not experience any problem while running it. The engine that will be used will be detected automatically when the app installation procedure starts, so you will not need to modify any settings manually at any moment.