InnoDB is a MySQL database storage engine, which has been gaining popularity lately, because it provides a significantly better overall performance and an improved database failure recovery in comparison with the default engine used by the MySQL DBMS – MyISAM. InnoDB is endorsed by numerous developers that write scalable applications, as it works much more efficiently with huge amounts of data, while it keeps the server load at a minimum. What’s more, it locks only a single database row if any info should be edited, whereas lots of other engines lock the entire database table and thus require much more time to execute multiple consecutive tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – if the entire data modification cannot be completed for whatever reason, the operation is rolled back to avoid confusion or the loss of data. Magento and the latest versions of Joomla™ are two instances of widespread PHP script-driven software apps which have switched to InnoDB.

InnoDB in Hosting

Any PHP script-powered application that needs InnoDB will function flawlessly on our innovative cloud platform and the database storage engine is offered with all our hosting packages. Every time you create a MySQL database manually or our app installer creates one automatically and an app installation process is started, the engine that the database in question will make use of will be selected in accordance with the app’s specifications without having to change any setting in your shared hosting account. InnoDB will be chosen automatically for any app that requires this particular engine and you will be able to get the most out of its full capacity. We will create regular content backups, so if you unintentionally delete a MySQL database that is important to you or you overwrite some part of it, we’ll be able to restore your data the way it was only a few hours earlier.

InnoDB in Semi-dedicated Hosting

All our semi-dedicated services include InnoDB and you’ll be able to take advantage of all the options offered by this database storage engine with any PHP script-powered software app that needs it. It is one of the engines that we have on our cloud platform, so the one that will be used depends on the prerequisites of the particular app. You won’t have to do anything manually to enable InnoDB, because it will be set as the default engine whenever you install an app – whether manually or using our 1-click app installer tool. To be on the safe side, we’ll keep daily MySQL database backups, so if anything goes wrong after an update or if you delete some content by accident, we’ll be able to get the database back to the way it was on any of the previous 7 days.

InnoDB in VPS Web Hosting

When you buy a virtual private server from our company, you’ll be able to make use of our custom-developed Hepsia Control Panel to manage your web content. A Hepsia-managed Virtual Private Server will allow you to run any open-source script-based web app that needs InnoDB, as the MySQL database storage engine is part of the standard software package that will be installed on the VPS server during its configuration. When you set up a brand new MySQL database via the hosting Control Panel, you’ll simply have to begin installing an app – manually or using our app installer tool. InnoDB will be set as the default engine given that the application in question requires it, so you will not have to do anything else in your account. Analogously, if a given application requires MyISAM, it will be automatically set as the default engine for this specific database.

InnoDB in Dedicated Servers Hosting

All Linux dedicated hosting services ordered with our custom Hepsia hosting Control Panel include a software bundle that’s pre-activated and among everything else, you will get the InnoDB storage engine, so you won’t need to activate it manually in case you’d like to run open-source scripts that require it. All it takes to activate such a script is to set up a new database and to begin the installation – once the script configuration wizard obtains access to the database 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 required by the particular script. You will also be able to install scripts that need the other widely used MySQL engine, MyISAM, so you will not have to configure any settings on the server. This will allow you to use a variety of scripts on a single server and to use it to its fullest capacity.