InnoDB is a database engine for MySQL relational databases, which is used by widespread open-source script-based web apps like Magento and Joomla v3. It’s ideal for scalable apps, as it works exceptionally well when managing large amounts of data. Rather than locking the entire database table to add new information to a database like many other engines do, InnoDB locks only one row, so it can complete much more operations for the same period of time. Plus, InnoDB offers an improved database crash recovery and supports database transactions and foreign keys – a set of rules that prescribe how data imports and updates should be handled. If a certain operation hasn’t been thoroughly completed for some reason, the action will be rolled back. In this way, the database content will stay safe and sound and will not be partially mixed with newly appended content.

InnoDB in Shared Website Hosting

InnoDB is available with all our shared website hosting by default, not upon request or as a paid upgrade, so you can install and manage any PHP script-based application which needs the InnoDB storage engine without having to deal with any difficulty as soon as you order your shared website hosting account. InnoDB will be selected automatically as the default engine for a given database during the app installation, regardless of whether you take advantage of our one-click installer or create the database and install the application manually, as long as the application requires InnoDB instead of the more popular MyISAM engine. We will create daily backups of all your MySQL databases, so you can rest assured that you’ll never lose any content if you delete a database by accident or you overwrite some essential information – you will simply have to touch base with us and we’ll restore your database the way it was.

InnoDB in Semi-dedicated Servers

You can run a PHP script-driven app that needs InnoDB with any of our semi-dedicated server packages, since all the accounts are set up on our cutting-edge cloud web hosting platform where the storage engine is installed. A new database can be set up in two ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you take advantage of our single-click app installer. Either way, the required engine will be picked automatically the moment the installation of the application starts, so you won’t have to change anything manually, irrespective of whether the app requires InnoDB or the more regularly used MyISAM. Also, we’ll always be able to recover any of your databases in case you unintentionally delete one, as we generate several database backups every day, each of which is stored for one week.

InnoDB in VPS Servers

If you pick a VPS server with our Hepsia hosting Control Panel, the InnoDB database engine will be included in the software pack that will be pre-installed on your VPS server before we give it to you. You will not have to set up anything manually and you’ll be able to enable and manage any script-powered app that needs InnoDB when your Virtual Private Server is up and running, which takes no more than sixty minutes after the order procedure itself. A few engines are available, so whenever you set up a MySQL database via the Hepsia hosting Control Panel, a specific engine will be selected once the app installation process commences and our system will recognize the engine that is required by the application in question. If you need to use MyISAM, for instance, you won’t have to do anything different from installing the app of your preference, whether manually or using our application installer.

InnoDB in Dedicated Servers

All dedicated servers ordered with our in-house developed Hepsia hosting Control Panel include a software package that’s pre-installed and among everything else, you will get the InnoDB database engine, so you won’t need to add it manually in case you wish to use open-source PHP scripts that require it. All it takes to use such a script is to create a new database and to initiate the setup – once the script configuration wizard acquires access to the database and starts entering content into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one needed by the script. You’ll also be able to use scripts that need the other widely used MySQL engine – MyISAM, so you won’t need to edit any settings on the dedicated server. This will permit you to activate different scripts on one single physical machine and to use the latter to its maximum capabilities.