InnoDB is a database storage engine for MySQL relational databases, which is used by famous open-source script-powered web applications such as Joomla™ 3.x and Magento. It’s excellent for scalable apps, because it works remarkably well when managing large volumes of data. Rather than locking the entire database table to add new information to a database as many other engines do, InnoDB locks only one database row, so it can process a lot more tasks for the same period of time. Furthermore, InnoDB offers a much faster database failure recovery and supports database transactions and foreign keys – a set of rules that prescribe how data imports and modifications should be handled. If a certain operation hasn’t been thoroughly completed for whatever reason, the action will be rolled back. Thus, the information in the database will be retained safe and sound and won’t be partially mixed with newly imported content.

InnoDB in Shared Hosting

InnoDB is available with all our shared hosting plans by default, not upon request or as a paid upgrade, so you can activate and manage any script-based software application that requires the InnoDB storage engine without having to deal with any problem once you order your shared account. InnoDB will be selected automatically as the default engine for a certain MySQL database during the app installation process, regardless of whether you use our one-click installation tool or create the database and install the application manually, provided that the app requires InnoDB instead of the more popular MyISAM engine. We’ll maintain daily backups of all your databases, so you can rest assured that you’ll never lose any data in case you delete a database by mistake or you overwrite some important info – you will simply need to alert us and we’ll restore the database the way it was.

InnoDB in Semi-dedicated Servers

You can install an open-source script-driven software app that requires InnoDB with all of our semi-dedicated server packages, as all the accounts are set up on our innovative cloud web hosting platform where the storage engine is installed. A new database can be created in two ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you make use of our single-click application installer. In either case, the required engine will be selected automatically the moment the application’s activation starts, so you will not have to update anything manually, irrespective of whether the app requires InnoDB or the more commonly used MyISAM. On top of that, we will always be able to retrieve any of your MySQL databases if you remove one by mistake, as we create a few MySQL database backups every day, each of which is stored for 1 whole week.

InnoDB in VPS Servers

If you select a VPS server with our Hepsia hosting Control Panel, the InnoDB storage engine will be an indivisible part of the default software bundle that will be pre-installed on your server before we hand it over to you. You won’t have to activate anything manually and you will be able to install and run any script-based software app that requires InnoDB as soon as your VPS server is set up, which takes no more than 60 minutes after the order submission itself. A few engines are offered, so whenever you set up a database using the Hepsia Control Panel, a specific engine will be activated when the app installation process commences and our system will automatically recognize which engine is required by the app in question. In case you need to use MyISAM, for example, you won’t have to do anything different from installing the desired application, whether manually or using our app installer.

InnoDB in Dedicated Servers

When you obtain a new dedicated server, you will be able to select any of the 3 Control Panels that we’re offering – Hepsia, cPanel and DirectAdmin. Any server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you will not need to install this MySQL database engine manually to be able to use PHP-based web apps that require it. InnoDB is used for scalable apps and since a dedicated server will provide you with all the system resources that you need in order to run large-scale Internet sites, it is pretty likely that you’ll use InnoDB. You’ll be able to use other engines too, so in case a particular application needs MyISAM rather than InnoDB, you won’t run into any complication while running it. The engine that will be used will be recognized automatically as soon as the app installation commences, so you won’t need to configure any settings manually at any time.