InnoDB is a storage engine for MySQL databases, which is used by widespread PHP script-based web applications like Magento and Joomla 3. It’s excellent for scalable apps, because it performs remarkably well when processing huge amounts of data. Rather than locking the whole database table to add new information to a database like many other engines do, InnoDB locks only one row, so it can carry out much more tasks for the same period of time. Also, InnoDB offers an improved database crash recovery and supports transactions and foreign keys – a set of rules that specify how data imports and modifications should be handled. If a particular operation has not been thoroughly completed for whatever reason, the action will be rolled back. Thus, the database content will stay safe and sound and won’t be partially merged with new content.
InnoDB in Shared Hosting
While InnoDB is either not offered or it is a paid upgrade with many hosting service providers, it’s an integral part of the default set of features that we’re offering with our shared hosting plans. If you’d like to make use of a PHP-based software application that requires InnoDB specifically, in order to be activated and to perform correctly, you won’t have any impediments because the InnoDB database storage engine is available on our in-house developed cloud Internet hosting platform. No matter if you create a new MySQL database and install an app manually or take advantage of our single-click app installer software instrument, InnoDB will be selected automatically by our system as the default engine if the app needs it instead of MyISAM. Besides the outstanding database failure recovery offered by InnoDB, we also generate daily database backups, so we can quickly recover any database in your shared account.
InnoDB in Semi-dedicated Servers
All our Linux semi-dedicated hosting service support InnoDB and you will be able to get the most out of all the features of this storage engine with any script-driven web application that requires it. It is one of the engines that are available on our cloud website hosting platform, so the one that will be used depends on the given app’s requirements. You will not need to do anything manually in order to activate InnoDB, since it will be set as the default engine whenever you install an application – whether manually or using our one-click app installer. To be on the safe side, we’ll perform daily database backups, so if something goes wrong after some update or if you remove some content unintentionally, we’ll be able to restore the database the way it was on any of the previous seven days.
InnoDB in VPS Servers
All Linux VPS hosting service that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-installed, so you will be able to run any PHP-powered web app that needs this particular MySQL database engine without installing anything manually. You can choose Hepsia on the VPS order page and your brand-new VPS server will be up and running within one hour, so you can log in and start setting up your web sites straight away. When you set up a new MySQL database and begin the app installation process, our system will set the engine for this database automatically. In this way, you can install different applications simultaneously without having to modify anything on the VPS server. You can have a WordPress-driven weblog that uses the default MySQL engine – MyISAM, and a Magento-driven online shopping portal that makes use of the InnoDB engine, for example.
InnoDB in Dedicated Servers
If you order a new dedicated server, you’ll be able to select one of the three hosting Control Panels that we are offering – cPanel, DirectAdmin and Hepsia. Any dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you won’t need to activate this database storage engine manually so as to be able to manage open-source script-driven web applications that require it. InnoDB is used by scalable apps and since a dedicated server will provide you with all the resources that you need in order to manage very large websites, it’s quite possible that you’ll use InnoDB. You’ll be able to make use of other engines too, so in case a specific application needs MyISAM instead of InnoDB, you will not experience any difficulty while managing it. The engine that will be used will be detected automatically once the app installation starts, so you will not need to fine-tune any settings manually at any moment.