InnoDB is a database storage engine for MySQL relational databases, which is used by well known PHP-based software apps like Magento and Joomla™ v3. It’s ideal for scalable applications, since it performs remarkably well when managing enormous data volumes. Rather than locking the entire database table to add new information to a database as many other engines do, InnoDB locks only one database row, so it can process much more operations for the same period of time. Additionally, InnoDB offers a faster database failure recovery and supports database transactions and foreign key constraints – a set of rules that determine how data inserts and updates should be handled. In case a certain task hasn’t been thoroughly completed for some reason, the action will be rolled back. Thus, the content in the database will be kept intact and won’t be partially merged with newly entered content.

InnoDB in Cloud Web Hosting

While InnoDB is either not offered or it is a paid upgrade with many hosting companies, it’s part of the default set of features that we’re offering with our cloud web hosting plans. If you want to use an open-source script-powered app that needs InnoDB in particular, in order to be installed and to perform correctly, you will not experience any impediments because the MySQL database storage engine is available on our custom-built cloud website hosting platform. Regardless of whether you set up a brand-new database and install an application manually or make use of our 1-click app installer software tool, InnoDB will be selected automatically by our system as the default engine if the respective application needs InnoDB rather than MyISAM. In addition to the remarkable database crash recovery offered by InnoDB, we also store daily database backups, so we can easily restore any MySQL database in your shared web hosting account.

InnoDB in Semi-dedicated Hosting

All our Linux semi-dedicated hosting support InnoDB and you’ll be able to make the most of all the features offered by this MySQL database engine with any PHP script-driven web app that requires it. It’s among the engines that are available on our cloud web hosting platform, so the one that will be used depends on the requirements of the app in question. You won’t need to do anything manually to activate InnoDB, because it will be set as the default engine when you install an application – whether manually or using our 1-click app installer tool. To avoid any risk, we’ll make regular MySQL database backups, so if anything goes wrong after some update or if you remove some content by mistake, we’ll be able to restore your database the way it was on any of the past seven days.

InnoDB in VPS

All Linux VPS services that are ordered with the Hepsia hosting Control Panel come with InnoDB already activated, so you will be able to take advantage of any open-source script-based app that needs this database engine without installing anything manually. You can pick Hepsia on the VPS order page and your brand new server will be ready within 60 minutes, so you can sign in and begin building your Internet sites right away. When you set up a brand new database and begin the app installation process, our system will set the engine for that MySQL database automatically. In this way, you can make use of various apps simultaneously without the need to edit anything on the Virtual Private Server. You can set up a WordPress-driven personal blog that uses MyISAM – the default MySQL engine, and a Magento-driven e-commerce portal that uses the InnoDB engine, for example.

InnoDB in Dedicated Hosting

If you acquire a new dedicated server, you’ll be able to pick one of the 3 hosting Control Panels that we are offering – cPanel, DirectAdmin and Hepsia. Each server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you will not need to add this storage engine manually to be able to use PHP script-based web apps that need it. InnoDB is used by scalable apps and since a dedicated server will offer you all the server resources that you require in order to run large-scale Internet sites, it is rather possible that you will use InnoDB. You will be able to make use of other engines too, so if a certain application requires MyISAM rather than InnoDB, you won’t have to deal with any predicament while managing it. The engine that will be used will be automatically detected once the app installation begins, so you will not have to modify any setting manually at any moment.