InnoDB is a database storage engine for MySQL databases, which is used by famous open-source script-based software apps such as Magento and Joomla 3. It is excellent for scalable apps, because it works very well when managing enormous amounts of data. Rather than locking the entire table to enter new information into a database as many other engines do, InnoDB locks only one database row, so it can carry out much more operations for the same length of time. Moreover, InnoDB offers a better database crash recovery and supports transactions and foreign key constraints – rules that specify how data imports and updates should be treated. If a specific operation hasn’t been thoroughly completed for any reason, the action will be rolled back. In this way, the information in the database will stay intact and won’t be partially mixed with newly imported content.

InnoDB in Cloud Hosting

Any PHP script-driven application that needs InnoDB will function impeccably on our avant-garde cloud hosting platform and the database storage engine comes with all our cloud hosting packages. Whenever you create a MySQL database manually or our app installer creates one automatically and an app installation process is started, the engine that the database will make use of will be selected in accordance with the app’s prerequisites without having to configure any setting in your account. InnoDB will be selected automatically for any application that requires this specific engine and you will be able to make the most of its full potential. We will create daily content backups, so if you unintentionally erase a database that is important to you or you overwrite certain parts of it, we’ll be able to restore your content the way it was only a few hours earlier.

InnoDB in Semi-dedicated Hosting

InnoDB comes with each of our Linux semi-dedicated hosting packages by default, so the moment you order a new semi-dedicated account, you can go ahead and activate any open-source script-driven software application that requires this storage engine. A couple of engines are installed on our cloud web hosting platform, so when you set up a new database and start installing an application manually, or opt to make use of the Hepsia Control Panel-integrated app installer tool, the engine for the database will be selected on the basis of the given app’s prerequisites. This will allow you to install and manage InnoDB-specific apps without experiencing any problem and without the need to change any settings in your semi-dedicated account. To take no chances, we will always keep a 1-week-old backup of all your MySQL databases, so if you delete or edit any content by mistake, we can swiftly restore it.

InnoDB in VPS

If you pick a virtual private server with our Hepsia Control Panel, the InnoDB database engine will be part of the default software package that will be pre-installed on your VPS server before we hand it over to you. You will not need to configure anything manually and you’ll be able to install and manage any PHP script-powered software application that needs InnoDB once your VPS server is set up, which takes no more than 60 minutes after the order submission itself. A couple of engines are offered, so anytime you set up a database via the Hepsia Control Panel, a specific engine will be selected once the app activation starts and our system will detect which engine is required by the application in question. In case you need to use MyISAM, for instance, you will not have to do anything different from installing the chosen application, whether manually or using our application installer tool.

InnoDB in Dedicated Hosting

All Linux dedicated servers hosting packages that are ordered with our in-house developed Hepsia Control Panel come with a software package that’s pre-installed and among everything else, you’ll get the InnoDB database engine, so you won’t need to add it manually if you wish to activate PHP scripts that need it. All it takes to activate such a script is to set up a new MySQL database and to start the installation process – as soon as the script installation wizard obtains access to the database and begins entering data into it, InnoDB will be set as the default MySQL engine for this database as long as it is the one needed by the script. You’ll also be able to use scripts that require the other popular MySQL engine – MyISAM, so you will not have to change any settings on the dedicated server. This will permit you to use various scripts on a single physical server and to use it to its fullest potential.