InnoDB is a database storage engine for MySQL databases, which is used by famous PHP script-driven software applications such as Joomla™ 3 and Magento. It is excellent for scalable applications, because it excels in managing immense volumes of data. Rather than locking the whole table to insert new information in a database as many other engines do, InnoDB locks only one row, so it can execute a lot more operations for the same length of time. In addition, InnoDB offers a faster crash recovery and supports database transactions and foreign keys – a set of rules that define how data inserts and modifications should be handled. In case a particular task has not been entirely completed for any reason, the action will be rolled back. In this way, the database content will be retained intact and won’t be partially mixed with newly inserted content.

InnoDB in Web Hosting

You will be able to activate any open-source script-based web application that requires InnoDB if you’ve got a web hosting with us, as the database storage engine is available on our innovative cloud web hosting platform by default. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably if this engine is needed. You can run apps that need the MyISAM engine without encountering any obstacle as well and, again, the engine will be pre-selected, so you will not have to modify any setting manually at any point. What’s more, we will also create daily backups of all the MySQL databases that you have in the shared hosting account, so in case you erase or overwrite anything, we can swiftly get it back to the way it was on any of the previous seven days.

InnoDB in Semi-dedicated Hosting

You can install a PHP-powered app that needs InnoDB with any of our semi-dedicated server packages, due to the fact that all the accounts are set up on our avant-garde cloud web hosting platform where the MySQL database engine is installed. A new MySQL database can be set up in two different ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – if you take advantage of our single-click application installer tool. Either way, the required engine will be chosen automatically as soon as the application’s installation starts, so you won’t need to modify anything manually, no matter if the app needs InnoDB or the more widely used MyISAM. In addition, we’ll always be able to retrieve any of your databases in case you erase one by accident, as we generate several MySQL database backups every day, each of which is preserved for seven days.

InnoDB in VPS

When you get a virtual private server from us, you’ll be able to use our custom-developed Hepsia hosting Control Panel to manage your content. A Hepsia-equipped VPS will allow you to manage any script-based app that needs InnoDB, as this database engine is part of the standard software bundle that will be pre-installed on the VPS server during its creation. When you set up a brand-new database through the hosting Control Panel, you will just have to begin installing an application – manually or using our app installer. InnoDB will be set as the default engine as long as the app in question requires it, so you won’t need to do anything else in your VPS account. In the same manner, if a given app requires MyISAM, it will be automatically set as the default engine for this specific MySQL database.

InnoDB in Dedicated Hosting

When you order a new dedicated server, you’ll be able to select one of the three Control Panels that we’re offering – Hepsia and cPanel. Any server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you will not have to add this database engine manually to be able to manage PHP script-powered web applications that require it. InnoDB is used for scalable apps and since a dedicated server will offer you all the resources that you require in order to manage large-scale Internet sites, it’s rather likely that you’ll use InnoDB. You will be able to use other engines as well, so if a particular app needs MyISAM rather than InnoDB, you will not have to deal with any complication while using it. The engine that will be used will be detected automatically the moment the app installation procedure commences, so you won’t have to configure any setting manually at any moment.