InnoDB is a MySQL database storage engine, which has been gaining in popularity lately, as it provides a much better overall performance and an improved crash recovery compared to the default engine that is used by MySQL – MyISAM. InnoDB is preferred by lots of programmers that create highly scalable web applications, because it works much better with huge volumes of data, while it keeps the server processing load at a minimum. What’s more, it locks only a single database row in case any info should be updated, while lots of other engines lock the entire database table and hence need more time to complete several sequential tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – in case the entire data modification cannot be completed for some reason, the action is rolled back to prevent scrambling or the loss of data. Magento and the latest Joomla releases are two instances of popular script-powered software applications which have switched over to InnoDB.

InnoDB in Hosting

While InnoDB is either a paid upgrade or it is not available at all with other web hosts, it is included in the standard set of features offered with our hosting packages. In case you would like to use an open-source script-powered application that needs InnoDB in particular, in order to be installed and to operate properly, you won’t encounter any problems as the InnoDB database storage engine is available on our custom-built cloud platform. Regardless of whether you create a brand new MySQL database and activate an app manually or make use of our 1-click application installer instrument, InnoDB will be selected automatically by our system as the default engine if the particular app requires InnoDB rather than MyISAM. In addition to the remarkable crash recovery that InnoDB offers, we also store regular database backups, so that we can swiftly restore any MySQL database in your shared web hosting account.

InnoDB in Semi-dedicated Hosting

You can run a script-based web app that requires InnoDB with all of our semi-dedicated server plans, as all the accounts are created on our avant-garde cloud platform where the database storage engine is installed. A new database can be created in two separate ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you use our single-click application installer. Either way, the needed engine will be selected automatically once the installation of the application begins, so you won’t have to change anything manually, regardless of whether the app requires InnoDB or the more commonly used MyISAM. On top of that, we will always be able to restore any of your databases if you delete one by accident, as we make a couple of backups every day, each of which is stored for seven days.

InnoDB in VPS Hosting

If our custom Hepsia Control Panel is picked during the registration process for your new Linux virtual private servers , InnoDB will be installed on the server along with other needed software, so you won’t have to do anything if you decide to install PHP-powered applications that require this MySQL storage engine. The default MySQL engine – MyISAM, will be installed as well. You can create a brand new MySQL database and start installing the app manually or through our single-click installation tool. The system will automatically recognize which engine the application in question needs and will set it for the specific MySQL database, so the installation will continue flawlessly and the app can dump its data in that database. Therefore, you can use apps with different prerequisites about the MySQL engine without the need to make any changes on your server.