InnoDB is a database storage engine for MySQL relational databases, which is used by famous script-powered web apps like Magento and Joomla™ 3.x. It is excellent for scalable applications, as it works unbelievably well when handling enormous amounts of data. Instead of locking the entire table to import new information into a database as many other engines do, InnoDB locks only one row, so it can perform much more tasks for the same length of time. Additionally, InnoDB offers an improved database failure recovery and supports database transactions and foreign key constraints – a set of rules that prescribe how data imports and modifications should be handled. If a specific operation hasn’t been fully completed for some reason, the action will be rolled back. Thus, the content in the database will be retained intact and won’t be partially mixed with new content.

InnoDB in Shared Website Hosting

InnoDB is available with all our shared website hosting by default, not as a paid upgrade or upon request, so you will be able to install and run any open-source script-driven web application that needs the InnoDB database storage engine without having to deal with any obstacle as soon as you order your shared account. InnoDB will be pre-selected as the default engine for a certain MySQL database during the app installation, no matter if you make use of our 1-click installer or create the MySQL database and set up the application manually, on the condition that the application requires it instead of the more popular MyISAM engine. We will make daily database backups, so you can rest assured that you’ll never lose any data if you erase a database by mistake or you overwrite some vital info – you’ll just have to touch base with us and we’ll restore everything the way it was.

InnoDB in Semi-dedicated Servers

If you set up a new MySQL database through the hosting Control Panel coming with each of our semi-dedicated server accounts and you begin installing a PHP script-based application either manually or using our 1-click application installer, the storage engine for the database will be set automatically based on the prerequisites of the given application. Since InnoDB is available on the cloud website hosting platform where your new semi-dedicated server account will be set up, it will be set as the default engine for each application that requires it without any manual action required on your end at any moment. To avoid any chance of losing info if you update an app or if you delete a database by accident, we will perform backups of all your databases every day, so if something goes wrong, we can recover your data.

InnoDB in VPS Servers

All VPS hosting plans that are ordered with the Hepsia Control Panel come with InnoDB pre-activated, so you will be able to run any script-driven web app that requires this MySQL storage engine without needing to activate anything manually. You can select Hepsia on the VPS configuration page and your new server will be set up within sixty minutes, so you can log in and start building your Internet sites right away. Once you create a brand-new database and begin the app activation process, our system will pick the engine for that MySQL database automatically. In this way, you can make use of various applications simultaneously without the need to configure anything on the server. You can create a WordPress-driven personal journal that makes use of MyISAM – the default MySQL engine, and a Magento-driven online shop that uses the InnoDB engine, for instance.

InnoDB in Dedicated Servers

All dedicated web hosting plans ordered with our custom-built Hepsia Control Panel include a software bundle that is pre-activated and besides everything else, you will get the InnoDB database engine, so you won’t have to add it manually if you want to run open-source scripts that need it. All it takes to activate such a script is to create a new MySQL database and to initiate the setup process – as soon as the script configuration wizard receives access to the database in question and begins importing data into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one required by the particular script. You will also be able to activate scripts that need MyISAM, the other very popular MySQL engine, so you will not have to modify any settings on the server. This will allow you to run a variety of scripts on a single machine and to use it to its full capabilities.