InnoDB is a database storage engine for MySQL relational databases, which is used by famous PHP-driven web apps like Magento and Joomla 3.x. It’s ideal for scalable apps, because it works unbelievably well when handling huge volumes of data. Instead of locking the entire table to import new information into 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. Moreover, InnoDB offers a faster database failure recovery and supports transactions and foreign key constraints – a set of rules that prescribe how data inserts and updates should be handled. If a particular task hasn’t been entirely completed for some reason, the action will be rolled back. In this way, the database content will be retained intact and won’t be partially merged with newly inserted content.

InnoDB in Shared Hosting

Any script-powered application that needs InnoDB will function flawlessly on our advanced cloud website hosting platform and the MySQL database engine is offered with all our shared hosting packages. Each time you create a database manually or our app installer creates one automatically and an app installation is initiated, the engine that the database in question will make use of will be selected based on the app’s specifications without the need to change any setting in your shared hosting account. InnoDB will be picked automatically for any application that requires this particular engine and you will be able to make the most of its full capacity. We will store daily content backups, so if you unintentionally delete a database that is important to you or you overwrite some part of it, we will be able to restore your content the way it was only a few hours earlier.

InnoDB in Semi-dedicated Hosting

You can activate a script-powered web application that needs InnoDB with all of our semi-dedicated server plans, since all the accounts are set up on our leading-edge cloud hosting platform where the MySQL database engine is installed. A new MySQL database can be created in two different ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – if you take advantage of our 1-click app installer. In either case, the required engine will be picked automatically the moment the installation of the app begins, so you won’t need to edit anything manually, no matter if the app needs InnoDB or the more frequently used MyISAM. Also, we’ll always be able to restore any of your MySQL databases in case you erase one by accident, as we generate a few MySQL database backups every day, each of which is kept for one whole week.

InnoDB in VPS

If you order a virtual private server with our Hepsia Control Panel, the InnoDB database engine will be included in the default software package that will be installed on your server before we hand it over to you. You won’t need to activate anything manually and you will be able to enable and use any script-powered software application that needs InnoDB when your Virtual Private Server is ready, which takes no more than sixty minutes after the order submission procedure itself. Several engines are available, so anytime you create a MySQL database using the Hepsia Control Panel, a particular engine will be activated once the app installation process starts and our system will detect the engine that is required by the application in question. If you need MyISAM, for example, you won’t have to do anything different than installing the application of your preference, whether manually or using our app installer tool.

InnoDB in Dedicated Hosting

When you purchase a new dedicated server, you will be able to select any of the 3 hosting Control Panels that we offer – Hepsia, cPanel and DirectAdmin. Each dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you won’t have to install this MySQL database engine manually in order to be able to manage PHP-based web applications that require it. InnoDB is used for scalable applications and since a dedicated server will give you all the system resources that you require to run very large websites, it’s quite possible that you will resort to InnoDB. You will be able to use other engines too, so in case a specific app needs MyISAM rather than InnoDB, you won’t need to deal with any difficulty while running it. The engine that will be used will be detected automatically the moment the app installation process commences, so you will not have to modify any setting manually at any point.