InnoDB is a database storage engine for MySQL relational databases, which is used by popular open-source script-powered software applications such as Joomla 3.x and Magento. It is excellent for scalable apps, because it works amazingly well when managing enormous volumes of data. Instead of locking the whole table to insert new information in a database like many other engines do, InnoDB locks only one row, so it can execute much more operations for the same period of time. What’s more, InnoDB offers a better database crash recovery and supports transactions and foreign keys – rules that specify how data inserts and updates should be handled. If a particular operation has not been thoroughly completed for any reason, the action will be rolled back. In this way, the information in the database will be retained intact and will not be partially mixed with newly appended content.

InnoDB in Website Hosting

While InnoDB is either not offered or it is a paid upgrade with many hosting companies, it is included in the default set of services that we are offering with our website hosting plans. In case you’d like to use a PHP script-powered web application that requires InnoDB particularly, in order to be activated and to work correctly, you won’t have to deal with any difficulties because the MySQL database engine is available on our in-house built cloud web hosting platform. No matter if you create a new MySQL database and activate an app manually or use our one-click app installer tool, InnoDB will be selected automatically by our platform as the default engine if the application requires InnoDB rather than MyISAM. In addition to the exceptional database crash recovery offered by InnoDB, we also maintain regular database backups, so that we can easily restore any MySQL database in your shared website hosting account.

InnoDB in Semi-dedicated Servers

All our semi-dedicated hosting plans support InnoDB and you can get the most out of all the options offered by this storage engine with any PHP script-powered app that requires it. It’s one of the engines that are available on our cloud hosting platform, so the one that will be selected depends on the requirements of the particular application. You won’t need to do anything manually in order to activate InnoDB, as it will be set as the default engine whenever you install an application – whether manually or using our 1-click app installer tool. To avoid any risk, we’ll create regular database backups, so if anything 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 7 days.

InnoDB in VPS Servers

If our in-house developed Hepsia Control Panel is selected during the signup process for your new VPS web hosting plans , InnoDB will be installed on the server together with other essential software, so you will not need to do anything if you choose to make use of open-source script-driven applications that require this MySQL storage engine. The default MySQL engine – MyISAM, will be installed as well. You can set up a brand-new MySQL database and start the app installation procedure manually or through our single-click installer. The system will recognize which engine the particular application needs and will set it for the specific database, so the installation process will continue impeccably and the application can import its data into that database. Thus, you can make use of apps with various prerequisites about the MySQL engine without making any changes on your server.

InnoDB in Dedicated Servers

InnoDB is available by default with all dedicated web hosting plans that are ordered with the Hepsia Control Panel. It’s an integral part of the software package that we install on all Hepsia-equipped servers, so as soon as your physical machine is assembled, you’ll be able to log in and to install any type of script-based web app that requires this MySQL database engine. When you set up a new MySQL database through the hosting Control Panel, there won’t be any active engine until you begin installing an application. Once the app setup wizard begins importing data into the database, the engine will be selected automatically based on the prerequisites of the specific application, so you can run both MyISAM and InnoDB without selecting either of them specifically at any time. In this way, you can use a large range of applications for your sites.