InnoDB is a MySQL database storage engine, which has been gaining popularity lately, because it offers a much better overall performance and an improved database crash recovery compared to the default engine that’s used by the MySQL DBMS – MyISAM. InnoDB is preferred by plenty of programmers that build highly scalable software applications, because it works better with huge amounts of data, while it keeps the server load at a minimum. In addition, it uses row-level locking in case any information should be modified, whereas many other engines lock the entire database table and hence need more time to handle several consecutive tasks. Last, but not least, InnoDB observes a set of "all-or-nothing" rules – in case the modification of the entire data cannot be completed successfully for any reason, the action is rolled back to prevent scrambling or data loss. Magento and the latest releases of Joomla are two instances of widespread PHP script-driven applications that have switched over to InnoDB.

InnoDB in Web Hosting

While InnoDB is either not offered or it is a paid upgrade with many other web hosting providers, it is an integral part of the standard set of features that we are offering with our web hosting packages. In case you wish to use a script-powered software application that requires InnoDB specifically, in order to be activated and to operate properly, you won’t encounter any problems since the InnoDB database engine is available on our custom-developed cloud hosting platform. Irrespective of whether you create a brand-new MySQL database and activate an app manually or take advantage of our single-click app installer software tool, InnoDB will be selected automatically by our platform as the default engine if the respective app requires InnoDB instead of MyISAM. Besides the remarkable crash recovery that InnoDB is offering, we also store regular backups of all databases, so we can swiftly recover any database in your shared hosting account.

InnoDB in Semi-dedicated Servers

If you create a new MySQL database through the hosting Control Panel offered with all our semi-dedicated server accounts and you begin installing a script-driven app either manually or using our single-click application installer, the MySQL database storage engine will be set automatically based on the requirements of the given app. As InnoDB is present on the cloud platform where your new semi-dedicated server account will be set up, it will be set as the default engine for any application that needs it without the need for any manual action on your end at any time. To prevent any risk of losing info if you update an application or if you remove a database accidentally, we’ll make backups of all your databases each and every day, so if something goes wrong, we can restore your data.

InnoDB in Dedicated Servers

When you order a new dedicated server, you’ll be able to pick one of the three Control Panels that we’re offering – Hepsia, DirectAdmin and cPanel. Each server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you won’t need to install this MySQL storage engine manually in order to be able to run open-source script-driven applications that require it. InnoDB is used by scalable apps and since a dedicated server will offer you all the resources that you need to manage very large Internet sites, it’s rather possible that you will resort to InnoDB. You will be able to use other engines too, so in case a certain app requires MyISAM rather than InnoDB, you won’t have any problem while using it. The engine that will be used will be recognized automatically the moment the app installation process begins, so you won’t have to modify any settings manually whatsoever.