InnoDB is a database storage engine for MySQL relational databases, which is used by widespread open-source script-driven apps like Magento and Joomla 3.x. It is ideal for scalable apps, since it excels in managing huge amounts of data. Rather than locking the whole table to append new information to a database as many other engines do, InnoDB locks only one row, so it can process much more tasks for the same period of time. Furthermore, InnoDB offers a better database failure recovery and supports transactions and foreign key constraints – rules that determine how data imports and updates should be handled. In case a certain task has not been fully completed for any reason, the action will be rolled back. In this way, the database content will be preserved intact and will not be partially mixed with newly imported content.
InnoDB in Shared Website Hosting
You will be able to activate any PHP script-driven software application that requires InnoDB if you’ve got a shared website hosting package with us, as the MySQL database engine is present on our innovative cloud hosting platform by default. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably if this engine is required. You can run applications which require the MyISAM engine without the need to deal with any complication as well and, again, the engine will be pre-selected, so you won’t have to configure any setting manually at any point. Furthermore, we will also carry out daily backups of all the MySQL databases that you’ve got in the account, so in case you erase or overwrite something, we can swiftly get it back to the way it was on any of the previous seven days.
InnoDB in Semi-dedicated Hosting
All our semi-dedicated hosting packages include InnoDB and you can make use of all the features offered by this MySQL database engine with any PHP-based app that needs it. InnoDB is one of the engines that we have on our cloud platform, so the one that will be selected depends on the prerequisites of the particular app. You will not need to do anything manually to enable InnoDB, because it will be set as the default engine whenever you install an app – whether manually or using our single-click application installer. To be on the safe side, we’ll carry out daily database backups, so if something goes wrong following some update or if you delete some data unintentionally, we’ll be able to get the database back to the way it was on any of the past seven days.
InnoDB in VPS
In case our custom-developed Hepsia hosting Control Panel is selected during the registration process for your new Linux VPS packages , InnoDB will be activated on the VPS server together with other needed pieces of software, so you will not have to do anything if you choose to activate open-source script-powered web applications that need this MySQL storage engine. The default MySQL engine – MyISAM, will be activated too. You can set up a brand-new database and start installing the application manually or through our single-click installer. The system will automatically detect which engine the app in question needs and will set it for the specific MySQL database, so the installation will continue flawlessly and the application can dump its content in that database. Therefore, you can use apps with different prerequisites about the MySQL engine without the need to make any changes on your Virtual Private Server.
InnoDB in Dedicated Hosting
If you purchase a new dedicated server, you’ll be able to choose one of the 3 Control Panels offered by us – cPanel, DirectAdmin and Hepsia. Each server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you won’t have to enable this MySQL database storage engine manually in order to be able to run PHP script-driven software apps that need it. InnoDB is used by scalable apps and since a dedicated server will supply you with all the resources that you need to manage very large Internet sites, it’s pretty possible that you’ll use InnoDB. You’ll be able to use other engines as well, so in case a certain application needs MyISAM rather than InnoDB, you won’t experience any problem while managing it. The engine that will be used will be detected automatically as soon as the app installation process starts, so you won’t have to edit any settings manually at any moment.