InnoDB is a MySQL database storage engine, which has been gaining popularity in recent years, because it provides a much better overall performance and an improved database crash recovery compared to the default engine that’s used by the MySQL database management system – MyISAM. InnoDB is preferred by lots of web developers that build highly scalable web apps, because it works much more effectively with huge volumes of data, while it keeps the server load low. In addition, it locks only a single database row in case anything should be modified, while many other engines lock the entire table and thus need more time to fulfill several sequential tasks. Last, but not least, InnoDB obeys the "all-or-nothing" rule – if the modification of the entire data cannot be completed for any reason, the action is rolled back to avoid confusion or losing data. Magento and the newest releases of Joomla are two instances of widely used PHP-powered software applications which have moved to InnoDB.

InnoDB in Cloud Web Hosting

You’ll be able to install any script-based application that requires InnoDB in case you’ve got a cloud web hosting plan with us, as the MySQL storage engine is present on our avant-garde cloud web hosting platform as standard. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed flawlessly if this engine is required. You can install apps that require the MyISAM engine without any difficulties as well and, again, the engine will be pre-selected, so you won’t have to update any setting manually at any moment. In addition, we’ll also make daily backups of all the MySQL databases that you have in the shared account, so if you delete or overwrite something, we can quickly restore it the way it was on any of the past 7 days.

InnoDB in Semi-dedicated Servers

If you create a new MySQL database through the Control Panel offered with all our semi-dedicated server accounts and you begin installing a script-driven software app either manually or using our one-click app installer, the storage engine for the database will be picked automatically based on the prerequisites of the specific app. Since InnoDB is present on the cloud hosting platform where your new semi-dedicated server account will be created, it will be set as the default engine for any app that requires it without the need for any manual action on your end at any moment. To avoid any risk of losing info if you update an app or if you remove a database by mistake, we will generate a backup of all your MySQL databases each day, so if something goes wrong, we can restore your data.

InnoDB in VPS Servers

If you choose a VPS server with our Hepsia hosting Control Panel, the InnoDB database storage engine will be an indivisible part of the software pack that will be pre-installed on your Virtual Private Server before we give it to you. You won’t need to activate anything manually and you’ll be able to enable and use any PHP-based web application that needs InnoDB as soon as your VPS is up and running, which takes no more than 60 minutes after the order submission itself. Several engines are offered, so anytime you create a MySQL database via the Hepsia hosting Control Panel, a particular engine will be picked when the app installation starts and our system will automatically recognize the engine that is required by the application in question. If you have to use MyISAM, for instance, you will not have to do anything different from installing the app of your preference, whether manually or using our app installer.

InnoDB in Dedicated Servers

InnoDB is available by default with all Linux dedicated servers ordered with the Hepsia Control Panel. It’s part of the standard software package that will be installed on all Hepsia-equipped servers, so once your machine is up and running, you will be able to sign in and to activate a various PHP script-powered web app that needs this MySQL storage engine. When you set up a new MySQL database through the Control Panel, there won’t be any active engine until you begin installing an application. As soon as the app setup wizard starts inserting information into the database, the engine will be selected automatically on the basis of the requirements of the particular app, so you can use both MyISAM and InnoDB without having to select either one of them specifically at any point. In this way, you can make use of a vast selection of apps for your sites.