InnoDB is a storage engine for MySQL databases, which is used by widespread PHP script-powered software apps like Joomla 3 and Magento. It’s perfect for scalable apps, because it works astonishingly well when managing large amounts of data. Instead of locking the whole table to enter new information into a database like many other engines do, InnoDB locks only one row, so it can process a lot more operations for the same period of time. Besides, InnoDB offers an improved database crash recovery and supports database transactions and foreign key constraints – a set of rules that indicate how data inserts and modifications should be handled. If a certain operation has not been entirely completed for whatever reason, the action will be rolled back. In this way, the database content will remain intact and won’t be partially merged with new content.

InnoDB in Cloud Hosting

While InnoDB is either not offered or it is a paid upgrade with many other web hosting providers, it is part of the default set of features offered with our cloud hosting plans. If you would like to use a script-powered application that needs InnoDB particularly, in order to be installed and to perform correctly, you won’t have any obstacles because the InnoDB database engine is available on our custom cloud hosting platform. Irrespective of whether you create a brand new database and install an app manually or use our 1-click app installer software instrument, InnoDB will be selected automatically by our system as the default engine if the app needs InnoDB rather than MyISAM. Besides the outstanding crash recovery that InnoDB offers, we also store daily database backups, so that we can quickly recover any database in your shared account.

InnoDB in Semi-dedicated Servers

All our semi-dedicated hosting service include InnoDB and you can make the most of all the options offered by this storage engine with any PHP-based web app that requires it. InnoDB is among the engines that are available on our cloud website hosting platform, so the one that will be picked depends on the prerequisites of the particular application. You won’t have to do anything manually in order to activate InnoDB, since it will be set as the default engine when you install an app – whether manually or using our 1-click application installer tool. To be on the safe side, we will make regular MySQL database backups, so if something goes wrong after some update or if you delete some content accidentally, we will be able to get your database back to the way it was on any of the previous 7 days.

InnoDB in VPS Servers

All VPS web hosting service that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-installed, so you’ll be able to run any open-source script-driven app that needs this storage engine without needing to activate anything manually. You can select Hepsia on the VPS configuration page and your brand-new VPS server will be up and running within sixty minutes, so you can sign in and begin building your web sites right away. When you create a brand-new MySQL database and begin the app installation process, our system will set the engine for this MySQL database automatically. Thus, you can activate different applications simultaneously without the need to edit anything on the server. You can have a WordPress-driven online blog that makes use of the default MySQL engine – MyISAM, and a Magento-based online shop that uses the InnoDB engine, for example.

InnoDB in Dedicated Servers

All Linux dedicated servers ordered with our custom Hepsia hosting Control Panel come with a software package that’s pre-activated and among everything else, you’ll get the InnoDB storage engine, so you won’t have to add it manually if you want to activate scripts that require it. All it takes to run such a script is to set up a new database and to initiate the installation process – as soon as the installation wizard obtains access to the database and starts entering content into it, InnoDB will be set as the default engine for this database as long as it is the one required by the particular script. You will also be able to run scripts that require MyISAM – the other widely used MySQL engine, so you will not need to edit any settings on the dedicated server. This will allow you to install a variety of scripts on one single machine and to use the latter to its fullest capabilities.