InnoDB is a database engine for MySQL relational databases, which is used by popular PHP script-based apps like Magento and Joomla v3. It’s ideal for scalable apps, because it excels in processing enormous volumes of data. Rather than locking the whole database table to enter new information into a database like many other engines do, InnoDB locks only one database row, so it can perform a lot more operations for the same period of time. Moreover, InnoDB offers a better database crash recovery and supports database transactions and foreign key constraints – a set of rules that indicate how data imports and updates should be treated. If a given task hasn’t been entirely completed for some reason, the action will be rolled back. Thus, the database content will be preserved safe and sound and will not be partially mixed with newly appended content.

InnoDB in Website Hosting

Any PHP-based app that needs InnoDB will function flawlessly on our cutting-edge cloud web hosting platform and the storage engine is available with all our website hosting plans. Every time you create a database manually or our app installer tool creates one automatically and an app installation is initiated, the engine that the database in question will use will be selected on the basis of the app’s requirements without the need to configure any setting in your account. InnoDB will be selected automatically for any app that requires this particular engine and you’ll be able to take advantage of its full capacity. We will make daily content backups, so in case you unintentionally remove a database that’s important to you or you overwrite a specific part of it, we’ll be able to restore your data the way it was just a few hours earlier.

InnoDB in Semi-dedicated Servers

If you create a brand new MySQL database from the Control Panel included with each of our semi-dedicated server plans and you begin installing a PHP-driven web application either manually or using our one-click application installer, the database storage engine will be selected automatically depending on the prerequisites of the particular app. Since InnoDB is present on the cloud hosting platform where your new semi-dedicated account will be set up, 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 avoid any risk of losing info if you update an app or if you erase a database accidentally, we’ll carry out backups of all your MySQL databases every day, so if something goes wrong, we can recover your content.

InnoDB in VPS Servers

When you buy a VPS server from us, you will be able to take full advantage of our custom-developed Hepsia hosting Control Panel to manage your web content. A Hepsia-managed Virtual Private Server will allow you to activate any open-source script-based software application that needs InnoDB, as the MySQL database engine is an integral part of the software package that will be installed on your VPS server during its configuration. When you create a brand-new MySQL database through the Control Panel, you will just need to begin installing an application – manually or using our application installer tool. InnoDB will be set as the default engine if the application in question requires it, so you won’t have to do anything else in your account. Identically, if a given application requires MyISAM, it will be automatically set as the default engine for this concrete database.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is among the features which you can select on the server order page when you buy a dedicated server from our company. Since this is the most powerful type of website hosting, it is rather likely that you’ll run highly popular Internet sites that will attract plenty of people, and since InnoDB is among the best choices for such Internet sites, we will enable it together with all the other software apps that are available with a Hepsia-equipped server. When you set up a brand new database in your account, there won’t be any active database storage engine till you start installing an open-source script, whether manually through your web browser or using the automatic script installer that is integrated into the hosting Control Panel. The needed engine will be automatically detected and will be assigned to that database, so you can install scripts that require InnoDB, as well as ones that need the default MySQL engine – MyISAM, without experiencing any impediment.