InnoDB is a database engine for MySQL databases, which is used by famous PHP-driven web applications like Magento and Joomla v3. It is perfect for scalable apps, since it excels in managing huge data volumes. Instead of locking the whole table to import new information into a database as many other engines do, InnoDB locks only one row, so it can perform a lot more tasks for the same period of time. Also, InnoDB offers an improved database crash recovery and supports database transactions and foreign key constraints – a set of rules that specify how data inserts and modifications should be treated. In case a particular task hasn’t been entirely completed for some reason, the action will be rolled back. Thus, the content in the database will be retained undamaged and will not be partially merged with newly added content.

InnoDB in Cloud Website Hosting

InnoDB is available with all our Linux cloud website hosting service by default, not as a paid upgrade or upon request, so you’ll be able to activate and run any script-powered app which needs the InnoDB storage engine without encountering any problem as soon as you activate your account. InnoDB will be selected automatically as the default engine for a specific database during the app activation process, irrespective of whether you make use of our one-click installer or create the MySQL database and install the app manually, as long as the application requires InnoDB instead of the more popular MyISAM engine. We’ll create regular backups of all your MySQL databases, so you can rest assured that you won’t ever lose any data if you delete a database unintentionally or you overwrite some key info – you’ll simply have to notify us and we’ll restore your content back to normal.

InnoDB in Semi-dedicated Servers

All our semi-dedicated hosting service come with InnoDB and you’ll be able to take full advantage of all the options offered by this MySQL database engine with any open-source script-driven application that needs it. It is one of the engines that are available on our cloud web hosting platform, so the one that will be picked depends on the requirements of the given application. You will not need to do anything manually in order to enable InnoDB, since it will be set as the default engine when you install an application – whether manually or using our single-click application installer tool. To be on the safe side, we’ll perform regular backups of all your MySQL databases, so if anything goes wrong following an upgrade or if you erase some data by mistake, we’ll be able to get your database back to the way it was on any of the previous 7 days.

InnoDB in VPS Servers

All Linux VPS servers that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-activated, so you will be able to use any PHP-driven application that requires this particular database storage engine without having to activate anything manually. You can select Hepsia on the VPS order form and your new VPS server will be up and running within 1 hour, so you can sign in and start building your websites right away. Once you create a brand-new MySQL database and start the app installation process, our system will pick the engine for that MySQL database automatically. In this way, you can run different applications at the same time without the need to edit anything on the VPS server. You can create a WordPress-powered online journal that uses the default MySQL engine – MyISAM, and a Magento web store 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 3 Control Panels that we’re offering – DirectAdmin, cPanel and Hepsia. Any dedicated server ordered with Hepsia comes with InnoDB pre-activated, so you won’t have to install this storage engine manually to be able to use open-source script-driven software applications that need it. InnoDB is used for scalable applications and since a dedicated server will offer you all the server resources that you need in order to manage large-size sites, it is pretty likely that you’ll use InnoDB. You’ll be able to use other engines as well, so if a certain app requires MyISAM rather than InnoDB, you will not run into any problem while using it. The engine that will be used will be detected automatically when the app installation process starts, so you won’t need to tweak any setting manually at any time.