InnoDB is a database storage engine for MySQL relational databases, which is used by widespread PHP-powered apps such as Joomla 3 and Magento. It is excellent for scalable apps, since it works astonishingly well when handling large amounts of data. Instead of locking the whole database table to import new information into a database like many other engines do, InnoDB locks only one database row, so it can carry out a lot more tasks for the same period of time. Besides, InnoDB offers a faster database crash recovery and supports database transactions and foreign key constraints – a set of rules that indicate how data inserts and updates should be treated. If a specific task has not been fully completed for whatever reason, the action will be rolled back. In this way, the information in the database will be retained undamaged and will not be partially mixed with newly entered content.

InnoDB in Shared Hosting

You’ll be able to install any PHP-based application that requires InnoDB in case you have a shared plan with our company, as the database engine is present on our innovative cloud platform as standard. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed impeccably if this engine is needed. You can run applications that use the MyISAM engine without encountering any impediment as well and, again, the engine will be selected automatically, so you won’t need to change anything manually at any moment. What’s more, we’ll also make daily backups of all the MySQL databases that you’ve got in the shared account, so in case you delete or overwrite anything, we can swiftly get it back to the way it was on any of the past seven days.

InnoDB in Semi-dedicated Servers

You can use a PHP script-based software app that requires InnoDB with all of our semi-dedicated server packages, because all the accounts are set up on our avant-garde cloud web hosting platform where the storage engine is installed. A new database can be set up in two separate ways – manually from the Database Manager section of the Hepsia web hosting Control Panel, or automatically – if you use our 1-click application installer. In either case, the required engine will be picked automatically as soon as the activation of the app starts, so you will not need to modify anything manually, no matter if the application needs InnoDB or the more regularly used MyISAM. On top of that, we will always be able to retrieve any of your MySQL databases in case you delete one by accident, as we carry out a few backups every day, each of which is preserved for seven days.

InnoDB in Dedicated Servers

When you order a new dedicated server, you will be able to choose any of the three hosting Control Panels offered by us – Hepsia, cPanel and DirectAdmin. Each dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you will not have to enable this database engine manually so as to be able to use PHP-based web apps that need it. InnoDB is used by scalable apps and since a dedicated server will supply you with all the resources that you need to run very large Internet sites, it is rather possible that you’ll resort to InnoDB. You will be able to use other engines as well, so if a particular application needs MyISAM rather than InnoDB, you won’t need to deal with any predicament while managing it. The engine that will be used will be automatically detected the moment the app installation begins, so you won’t need to edit any setting manually at any point.