InnoDB is a storage engine for MySQL relational databases, which is used by widespread PHP-based software apps such as Magento and Joomla 3.x. It is perfect for scalable apps, as it performs very well when handling enormous amounts of data. Rather than locking the whole database table to import new information into a database like many other engines do, InnoDB locks only one row, so it can handle much more tasks for the same length of time. Also, InnoDB offers a faster database crash recovery and supports database transactions and foreign keys – a set of rules that define how data imports and updates should be treated. In case a particular operation has not been thoroughly completed for any reason, the action will be rolled back. Thus, the content in the database will remain undamaged and won’t be partially mixed with new content.

InnoDB in Cloud Website Hosting

InnoDB is offered with all our cloud website hosting plans by default, not as a paid upgrade or upon request, so you can activate and run any script-driven web app that requires the InnoDB database storage engine without having to deal with any impediment as soon as you activate your shared hosting account. InnoDB will be pre-selected as the default engine for a particular MySQL database during the app installation, regardless of whether you use our one-click installer or create the MySQL database and activate the app manually, as long as the application requires it instead of the more popular MyISAM engine. We will keep regular backups of all your databases, so you can be sure that you won’t ever lose any data if you erase a database unintentionally or you overwrite some key information – you will simply have to touch base with us and we’ll restore your data back to normal.

InnoDB in Semi-dedicated Servers

If you create a brand-new MySQL database from the Control Panel coming with all our semi-dedicated server accounts and you start installing an open-source script-based software application either manually or using our 1-click application installer tool, the storage engine for the MySQL database will be selected automatically based on the requirements of the specific application. As InnoDB is available on the cloud website hosting platform where your new semi-dedicated server account will be created, it will be set as the default engine for any application that requires it without any manual action required on your end at any point. To prevent any risk of losing data if you update an app or if you erase a database accidentally, we’ll make backups of all your databases each and every day, so if anything goes wrong, we can recover your data.

InnoDB in VPS Servers

If you choose a VPS server with our Hepsia Control Panel, the InnoDB database storage engine will be part of the default software pack that will be pre-installed on your server before we hand it over to you. You will not have to activate anything manually and you’ll be able to enable and use any open-source script-powered software application that needs InnoDB when your VPS server is ready, which takes no more than sixty minutes after the order procedure itself. A number of engines are available, so anytime you create a database using the Hepsia hosting Control Panel, a specific engine will be picked when the app activation process starts and our system will detect which engine is required by the application in question. If you need MyISAM, for instance, you won’t need to do anything different than installing the chosen application, whether manually or using our application installer.

InnoDB in Dedicated Servers

If you buy a new dedicated server, you will be able to select any of the 3 hosting Control Panels that we’re offering – DirectAdmin, Hepsia and cPanel. Any dedicated server ordered with Hepsia comes with InnoDB pre-activated, so you will not need to activate this MySQL database engine manually to be able to use open-source script-driven web applications that require it. InnoDB is used by scalable apps and since a dedicated server will offer you all the system resources that you need to run large-size Internet sites, it’s quite likely that you will resort to InnoDB. You will be able to make use of other engines as well, so if a given application needs MyISAM instead of InnoDB, you will not run into any impediment while running it. The engine that will be used will be automatically recognized as soon as the app installation starts, so you will not need to configure any setting manually whatsoever.