InnoDB is a very popular database storage engine for MySQL. It is an alternative to the default MyISAM engine and it has got lots of strengths that make it the preferred engine for plenty of PHP-based web applications, including Magento and Joomla, which have moved to InnoDB permanently. For example, adding huge amounts of data will be much faster with InnoDB, as it locks only a single database row to execute a task, not the entire table, which makes the engine perfect for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the way in which the info is handled. To put it simply, adding new or editing existing data will either be fully completed, or will be annulled and the operation will be rolled back in case any issue appears during the process, which means that the content that remains in the database won’t be lost.

InnoDB in Shared Hosting

You will be able to use any script-based application that needs InnoDB if you’ve got a shared hosting service with our company, as the MySQL database engine is present on our cutting-edge cloud web hosting platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue flawlessly if this engine is required. You can activate apps which need the MyISAM engine without the need to deal with any problem as well and, again, the engine will be selected automatically, so you won’t need to configure anything manually at any moment. What’s more, we will also generate daily backups of all the databases that you have in your shared web hosting account, so in case you erase or overwrite anything, we can easily restore it the way it was on any of the past seven days.

InnoDB in Semi-dedicated Hosting

All our Linux semi-dedicated hosting include InnoDB and you will be able to use all the options offered by this storage engine with any open-source script-driven app that needs it. It is among the engines that are available on our cloud hosting platform, so the one that will be used depends on the given app’s requirements. You will not have to do anything manually to enable InnoDB, as it will be set as the default engine whenever you install an app – whether manually or using our one-click application installer. To avoid any risk, we will perform regular backups of all your MySQL databases, so if something goes wrong following some update or if you erase some data accidentally, we’ll be able to restore your database the way it was on any of the past seven days.

InnoDB in VPS

In case our custom-developed Hepsia hosting Control Panel is chosen during the signup process for your new Linux virtual private servers , InnoDB will be installed on the Virtual Private Server together with other required software, so you will not have to do anything if you decide to manage script-powered software applications that require this MySQL database storage engine. MyISAM, the default MySQL engine, will be installed too. You can set up a brand-new database and begin installing the app manually or using our one-click installer. The system will recognize which engine the particular app requires and will set it for the specific database, so the installation process will continue impeccably and the app can dump its content in that database. Thus, you can activate applications with different prerequisites about the MySQL engine without the need to make any modifications on your VPS server.

InnoDB in Dedicated Hosting

When you obtain a new dedicated server, you will be able to pick any of the 3 hosting Control Panels offered by us – DirectAdmin, cPanel and Hepsia. Each server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you will not need to activate this database engine manually so as to be able to use PHP-based software apps that need it. InnoDB is used for scalable apps and since a dedicated server will give you all the server resources that you require in order to manage large-size websites, it is quite likely that you’ll use InnoDB. You will be able to use other engines too, so in case a specific app needs MyISAM rather than InnoDB, you won’t have any obstacle while managing it. The engine that will be used will be recognized automatically the moment the app installation commences, so you will not have to alter any setting manually at any time.