InnoDB is a database engine for MySQL databases, which is used by widespread PHP-powered apps such as Magento and Joomla v3. It’s excellent for scalable applications, since it performs very well when managing huge volumes of data. Rather than locking the whole database table to append new information to a database like many other engines do, InnoDB locks only one database row, so it can execute a lot more tasks for the same length of time. Additionally, InnoDB offers a better database crash recovery and supports database transactions and foreign key constraints – rules that indicate how data imports and modifications should be treated. If a specific task has not been entirely completed for whatever reason, the action will be rolled back. In this way, the database content will be preserved safe and sound and won’t be partially mixed with newly imported content.

InnoDB in Cloud Web Hosting

You’ll be able to activate any script-powered software application that requires InnoDB in case you’ve got a Linux cloud web hosting plan with us, as the MySQL storage engine is available on our advanced cloud platform by default. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed impeccably in case this engine is needed. You can run applications that require the MyISAM engine without encountering any problem as well and, once again, the engine will be selected automatically, so you won’t need to modify any setting manually at any moment. In addition, we’ll also perform regular backups of all the databases that you’ve got in your shared account, so if you delete or overwrite anything, we can easily restore it the way it was on any of the past seven days.

InnoDB in Semi-dedicated Servers

You can make use of a PHP script-powered software application that needs InnoDB with all of our semi-dedicated server packages, due to the fact that all the accounts are set up on our leading-edge cloud web hosting platform where the database engine is installed. A new database can be set up in two different ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – if you use our one-click application installer. In either case, the required engine will be picked automatically the moment the app’s activation starts, so you won’t need to edit anything manually, regardless of whether the application needs InnoDB or the more widely used MyISAM. Also, we will always be able to recover any of your databases in case you unintentionally delete one, as we carry out several MySQL database backups every day, each of which is preserved for 1 whole week.

InnoDB in VPS Servers

If you pick a VPS server with our Hepsia hosting Control Panel, the InnoDB storage engine will be an indivisible part of the standard software package that will be installed on your Virtual Private Server before we give it to you. You won’t need to activate anything manually and you’ll be able to enable and manage any script-powered software app that needs InnoDB once your VPS is set up, which takes no more than 60 minutes after the order submission process itself. A couple of engines are available, so anytime you set up a MySQL database through the Hepsia Control Panel, a specific engine will be activated once the app activation process begins and our system will detect the engine that is required by the application in question. In case you have to use MyISAM, for instance, you will not have to do anything different from installing the desired application, whether manually or using our app installer tool.

InnoDB in Dedicated Servers

If you buy a new dedicated server, you will be able to pick any of the three hosting Control Panels offered by our company – Hepsia, cPanel and DirectAdmin. Any dedicated server ordered with Hepsia comes with InnoDB pre-activated, so you won’t need to enable this database engine manually in order to be able to run open-source script-based software applications that require it. InnoDB is used by scalable apps and since a dedicated server will give you all the server resources that you require in order to manage large-size sites, it’s rather likely that you’ll resort to InnoDB. You will be able to use other engines too, so in case a given app needs MyISAM instead of InnoDB, you won’t have to deal with any complication while using it. The engine that will be used will be automatically recognized the moment the app installation process commences, so you won’t need to edit any setting manually at any moment.