InnoDB is a storage engine for MySQL databases, which is used by popular PHP-based software apps like Joomla™ 3.x and Magento. It is excellent for scalable apps, as it performs remarkably well when processing enormous amounts of data. Rather than locking the whole database table to insert new information in a database as many other engines do, InnoDB locks only one database row, so it can execute a lot more operations for the same length of time. Besides, InnoDB offers a much faster crash recovery and supports database transactions and foreign key constraints – a set of rules that prescribe how data inserts and updates should be handled. If a particular operation has not been thoroughly completed for some reason, the action will be rolled back. Thus, the content in the database will remain intact and will not be partially mixed with newly appended content.

InnoDB in Shared Website Hosting

Any open-source script-driven software application that requires InnoDB will function impeccably on our leading-edge cloud hosting platform and the database storage engine is available with all our shared website hosting plans. Whenever you create a database manually or our app installer creates one automatically and an app installation process is initiated, the engine that the database in question will make use of will be selected based on the app’s requirements without the need to modify any setting in your web hosting account. InnoDB will be chosen automatically for any app that requires this specific engine and you will be able to take advantage of its full capacity. We’ll keep daily backups of your content, so in case you unintentionally remove a database that you need or you overwrite specific parts of it, we’ll be able to restore the database the way it was just several hours earlier.

InnoDB in Semi-dedicated Hosting

If you set up a new MySQL database from the hosting Control Panel provided with all our semi-dedicated server plans and you start installing an open-source script-powered application either manually or using our single-click app installer tool, the storage engine for the database will be picked automatically depending on the prerequisites of the given application. As InnoDB is present on the cloud hosting platform where your new account will be created, it will be set as the default engine for each application that requires it without any manual intervention needed on your end at any point. To prevent any risk of losing data if you update an app or if you erase a database unintentionally, we will generate a backup of all your databases each day, so if something happens, we can recover your data.

InnoDB in VPS Hosting

If our in-house developed Hepsia hosting Control Panel is picked during the registration process for your new Linux VPS hosting packages , InnoDB will be installed on the Virtual Private Server along with other required software, so you will not need to do anything if you decide to manage PHP-based applications that need this MySQL database engine. The default MySQL engine – MyISAM, will be installed too. You can set up a brand-new MySQL database and start the app installation process manually or through our 1-click installation tool. The system will recognize the engine that the particular application requires and will set it for the specific MySQL database, so the installation will continue impeccably and the application can enter its content into that database. Thus, you can manage apps with different requirements in regard to the MySQL engine without having to make any modifications on your VPS server.

InnoDB in Dedicated Web Hosting

InnoDB is included as standard with all dedicated web hosting that are ordered with the Hepsia hosting Control Panel. It’s included in the default software bundle that will be pre-installed on all Hepsia-equipped dedicated servers, so as soon as your machine is up and running, you’ll be able to log in and to activate any kind of PHP-powered application that needs this MySQL database engine. When you create a new database via the hosting Control Panel, there won’t be any active engine until you start installing an application. Once the app activation wizard begins inserting content into the newly created database, the engine will be set automatically depending on the prerequisites of the particular application, so you can use both MyISAM and InnoDB without selecting either one specifically at any time. Thus, you can use a wide selection of apps for your Internet sites.