InnoDB is a popular database storage engine for the MySQL database management system. It’s an alternative to the default engine – MyISAM, and it has a lot of pluses that have made it the preferred engine for many open-source script-powered software apps, including Magento and Joomla, which have switched to InnoDB permanently. For instance, importing enormous amounts of data will be much faster with InnoDB, due to the fact that it locks only a single row to accomplish a specific operation, not the entire database table, which makes the engine perfect for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the way in which the data is tackled. In simpler words, importing new or updating existing data will either be fully completed, or will be annulled and the procedure will be rolled back if a certain problem shows up during the process, hence the content that remains in the database will not be lost.

InnoDB in Shared Web Hosting

While InnoDB is either not available or a paid upgrade with other website hosting service providers, it is part of the standard set of services that we’re offering with our shared web hosting plans. In case you want to make use of an open-source script-powered software application that needs InnoDB specifically, in order to be installed and to work correctly, you will not have to deal with any impediments as the InnoDB database storage engine is available on our custom-built cloud Internet hosting platform. Regardless of whether you create a brand-new database and install an app manually or use our one-click application installer software instrument, InnoDB will be selected automatically by our system as the default engine if the respective application requires InnoDB instead of MyISAM. In addition to the amazing database crash recovery that InnoDB is offering, we also generate regular database backups, so that we can easily restore any database in your shared account.

InnoDB in Semi-dedicated Hosting

You can activate a script-powered web app that needs InnoDB with all of our semi-dedicated server packages, as all the accounts are created on our leading-edge cloud platform where the MySQL storage engine is installed. A new database can be set up in two different ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you make use of our single-click app installer tool. Either way, the required engine will be selected automatically as soon as the activation of the app begins, so you will not need to edit anything manually, irrespective of whether the app requires InnoDB or the more regularly used MyISAM. In addition, we’ll always be able to recover any of your MySQL databases if you remove one by accident, as we make a few database backups every day, each of which is preserved for 7 days.

InnoDB in VPS Web Hosting

In case our custom-developed Hepsia hosting Control Panel is selected during the signup process for your new Linux VPS web hosting packages , InnoDB will be activated on the Virtual Private Server together with other required pieces of software, so you will not have to do anything if you decide to make use of PHP script-powered software apps that require this MySQL database storage engine. MyISAM, the default MySQL engine, will be activated as well. You can set up a new database and start installing the app manually or using our one-click installer tool. The system will recognize which engine the particular application requires and will assign it to the specific MySQL database, so the installation will proceed impeccably and the application can insert its content into that database. Thus, you can run apps with various prerequisites about the MySQL engine without having to make any changes on your VPS.

InnoDB in Dedicated Servers Hosting

All dedicated servers hosting ordered with our in-house built Hepsia Control Panel come with a software package that’s pre-installed and among everything else, you will get the InnoDB database storage engine, so you will not need to activate it manually if you would like to run scripts that need it. All it takes to install such a script is to create a new database and to start the installation – as soon as the installer wizard gets access to the database and starts entering content into it, InnoDB will be set as the default engine for this database on the condition that it is the one required by the particular script. You’ll also be able to install scripts that require MyISAM – the other widely used MySQL engine, so you will not need to configure any settings on the dedicated server. This will permit you to use various scripts on a single machine and to use the latter to its fullest potential.