InnoDB is a MySQL database storage engine, which has been gaining in popularity in recent years, as it offers a significantly better overall performance and an improved database failure recovery in comparison with the default engine that’s used by the MySQL DBMS – MyISAM. InnoDB is preferred by many developers that run highly scalable software applications, because it works better with large amounts of data, while it keeps the server load at a minimum. Additionally, it locks only a single database row if any info should be modified, while many other engines lock the entire database table and hence need more time to execute multiple sequential tasks. Last, but not least, InnoDB follows the "all-or-nothing" rule – in case the modification of the entire data cannot be completed for any reason, the action is rolled back to avoid confusion or data loss. Magento and the latest Joomla releases are two instances of popular script-driven web applications which have moved to InnoDB.

InnoDB in Hosting

You can install any script-powered web app that needs InnoDB if you’ve got a Linux hosting with our company, as the MySQL database storage engine is present on our advanced cloud web hosting platform as standard. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed flawlessly if this engine is required. You can activate apps which use the MyISAM engine without the need to deal with any problem as well and, again, the engine will be pre-selected, so you won’t have to change any setting manually at any moment. Furthermore, we’ll also carry out daily backups of all the databases that you’ve got in your shared account, so if you delete or overwrite something, we can swiftly get it back to the way it was on any of the past seven days.

InnoDB in Semi-dedicated Hosting

All our semi-dedicated hosting come with InnoDB and you will be able to get the most out of all the features offered by this database storage engine with any PHP script-powered software application that needs it. InnoDB is among the engines that are available on our cloud hosting platform, so the one that will be used depends on the requirements of the particular application. You won’t need to do anything manually in order to activate InnoDB, because it will be set as the default engine whenever you install an app – whether manually or using our single-click app installer. To avoid any risk, we’ll make daily backups of all your MySQL databases, so if anything goes wrong following some update or if you delete some data accidentally, we will be able to restore your database the way it was on any of the past 7 days.

InnoDB in VPS Web Hosting

If you order a virtual private server with our Hepsia hosting Control Panel, the InnoDB storage engine will be an essential part of the default software bundle that will be installed on your VPS server before we hand it over to you. You won’t need to set up anything manually and you’ll be able to install and use any PHP-powered web app that requires InnoDB when your Virtual Private Server is ready, which takes no more than one hour after the order submission procedure itself. A couple of engines are available, so anytime you create a MySQL database using the Hepsia hosting Control Panel, a specific engine will be picked once the app activation begins and our system will automatically detect which engine is required by the application in question. In case you need MyISAM, for instance, you won’t need to do anything different than installing the chosen application, whether manually or using our app installer tool.

InnoDB in Dedicated Servers Hosting

InnoDB is included as standard with all dedicated servers hosting packages that are ordered with the Hepsia hosting Control Panel. It’s part of the default software package that will be pre-installed on all Hepsia-managed dedicated servers, so once your physical machine is assembled, you will be able to log in and to install any script-powered web app that requires this particular database storage engine. When you create a new MySQL database via the Control Panel, there won’t be any active engine till you start installing an application. Once the app installation wizard begins entering information into the newly created database, the engine will be set automatically depending on the specific app’s prerequisites, so you can use both MyISAM and InnoDB without the need to select either one explicitly at any time. Therefore, you can use a huge variety of applications for your websites.