InnoDB is a MySQL storage engine, which has been gaining in popularity lately, as it offers a better overall performance and an improved database crash recovery in comparison with the default engine that’s used by the MySQL DBMS – MyISAM. InnoDB is used by many web developers that write highly scalable apps, as it works more effectively with enormous amounts of data, while it keeps the server processing load low. In addition, it locks only one database row if any info should be edited, while many other engines lock the entire table and therefore need much more time to accomplish several consecutive tasks. Last, but not least, InnoDB follows the "all-or-nothing" rule – if the entire data modification process cannot be completed for whatever reason, the operation is rolled back to avoid confusion or data loss. Magento and the latest Joomla releases are two instances of popular PHP-based software platforms which have shifted over to InnoDB.

InnoDB in Cloud Hosting

You’ll be able to activate any open-source script-powered application that requires InnoDB if you’ve got a cloud hosting with us, as the storage engine is available on our avant-garde cloud hosting platform as standard. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue flawlessly in case this engine is needed. You can activate apps that require the MyISAM engine without any obstacles as well and, once again, the engine will be pre-selected, so you will not have to update anything manually at any time. Furthermore, we will also carry out regular backups of all the MySQL databases that you have in your shared account, so if you delete or overwrite anything, we can quickly get it back to the way it was on any of the past seven days.

InnoDB in Semi-dedicated Servers

You can run a PHP-driven web app that requires InnoDB with all of our semi-dedicated server plans, because all the accounts are created on our cutting-edge cloud platform where the MySQL database storage engine is installed. A new MySQL database can be set up in two different ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – if you take advantage of our single-click application installer tool. In either case, the required engine will be picked automatically once the activation of the application starts, so you won’t need to configure anything manually, regardless of whether the app needs InnoDB or the more frequently used MyISAM. Also, we will always be able to restore any of your MySQL databases if you erase one by accident, as we create several database backups every day, each of which is kept for seven days.

InnoDB in VPS Servers

If you order a VPS server with our Hepsia hosting Control Panel, the InnoDB database storage engine will be an essential part of the default software pack that will be installed on your Virtual Private Server before we hand it over to you. You won’t need to configure anything manually and you’ll be able to install and use any open-source script-powered app that needs InnoDB as soon as your Virtual Private Server is up and running, which takes no more than sixty minutes after the order procedure itself. A couple of engines are available, so every time you create a database through the Hepsia hosting Control Panel, a particular engine will be selected once the app installation process commences 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 won’t need to do anything different than installing the application of your preference, whether manually or using our app installer tool.

InnoDB in Dedicated Servers

When you obtain a new dedicated server, you will be able to choose any of the 3 Control Panels offered by our company – cPanel, Hepsia and DirectAdmin. Each server ordered with the Hepsia Control Panel comes with InnoDB pre-installed, so you won’t need to install this MySQL storage engine manually to be able to use script-driven software apps that need it. InnoDB is used by scalable apps and since a dedicated server will offer you all the system resources that you require in order to run very large sites, it’s quite likely that you’ll resort to InnoDB. You will be able to make use of other engines too, so in case a specific app needs MyISAM rather than InnoDB, you will not have any difficulty while running it. The engine that will be used will be automatically detected the moment the app installation begins, so you won’t have to change any settings manually at any moment.