InnoDB is a database storage engine for MySQL relational databases, which is used by popular open-source script-driven software applications like Magento and Joomla 3. It’s excellent for scalable apps, because it performs amazingly well when handling huge data volumes. Instead of locking the entire table to insert new information in a database like many other engines do, InnoDB locks only one database row, so it can complete much more tasks for the same length of time. Besides, InnoDB offers an improved crash recovery and supports transactions and foreign keys – rules that determine how data inserts and updates should be handled. If a certain task has not been fully completed for any reason, the action will be rolled back. In this way, the content in the database will remain undamaged and will not be partially merged with newly entered content.

InnoDB in Cloud Hosting

You will be able to run any PHP script-based web application that needs InnoDB in case you have a cloud hosting with our company, as the MySQL database engine is available on our leading-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 proceed impeccably in case this engine is required. You can run applications that use the MyISAM engine without encountering any difficulty as well and, again, the engine will be selected automatically, so you will not have to modify anything manually at any moment. Furthermore, we will also make regular backups of all the MySQL databases that you’ve got in the shared hosting account, so if you erase or overwrite anything, we can quickly restore it the way it was on any of the previous seven days.

InnoDB in Semi-dedicated Servers

All our semi-dedicated servers include InnoDB and you will be able to take full advantage of all the features of this database engine with any PHP-powered software app that requires it. InnoDB is one of the engines that are available on our cloud website hosting platform, so the one that will be used depends on the requirements of the app in question. You will not need to do anything manually in order to activate InnoDB, because it will be set as the default engine when you install an app – whether manually or using our one-click app installer tool. To avoid any risk, we will store daily database backups, so if something goes wrong after an update or if you delete some content by accident, we will be able to get your database back to the way it was on any of the previous 7 days.

InnoDB in VPS Servers

If you choose a VPS server with our Hepsia Control Panel, the InnoDB storage engine will be included in the default software package that will be pre-installed on your VPS server before we hand it over to you. You won’t need to activate anything manually and you’ll be able to install and use any script-driven software application that requires InnoDB as soon as your Virtual Private Server is ready, which takes no more than 60 minutes after the order submission process itself. A couple of engines are offered, so anytime you set up a database via the Hepsia Control Panel, a specific engine will be picked once the app activation begins and our system will automatically detect the engine that is required by the application in question. In case you need MyISAM, for instance, you will not have to do anything different from installing the app of your preference, whether manually or using our application installer.

InnoDB in Dedicated Servers

If you buy a new dedicated server, you’ll be able to select one of the three Control Panels that we’re offering – cPanel, DirectAdmin and Hepsia. Each dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you will not have to enable this MySQL database engine manually in order to be able to run PHP script-driven web applications that require it. InnoDB is used for scalable applications and since a dedicated server will offer you all the system resources that you need in order to manage large-size websites, it is pretty likely that you’ll use InnoDB. You’ll be able to use other engines as well, so if a certain application requires MyISAM rather than InnoDB, you will not run into any problem while managing it. The engine that will be used will be automatically detected the moment the app installation process commences, so you will not need to change any setting manually at any point.