InnoDB is a database storage engine for MySQL databases, which is used by widely used script-powered web apps such as Magento and Joomla 3.x. It is perfect for scalable applications, because it performs very well when processing huge volumes of data. Instead of locking the entire table to import new information into a database as many other engines do, InnoDB locks only one row, so it can handle a lot more operations for the same length of time. Besides, InnoDB offers an improved database failure recovery and supports transactions and foreign keys – a set of rules that define how data imports and updates should be treated. If a particular operation has not been fully completed for whatever reason, the action will be rolled back. Thus, the content in the database will remain undamaged and will not be partially merged with newly added content.

InnoDB in Shared Hosting

You’ll be able to make use of any open-source script-based software application that needs InnoDB if you’ve got a shared service with our company, as the storage engine is present on our innovative cloud web hosting platform by default. During 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 activate applications which require the MyISAM engine without having to deal with any problem as well and, again, the engine will be pre-selected, so you will not need to modify anything manually at any moment. What’s more, we’ll also create daily backups of all the databases that you have in your shared 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 7 days.

InnoDB in Semi-dedicated Hosting

If you set up a brand new MySQL database from the hosting Control Panel offered with all our semi-dedicated server plans and you begin installing a PHP script-powered web app either manually or using our single-click application installer tool, the storage engine for the database will be set automatically based on the particular app’s requirements. As InnoDB is present on the cloud web hosting platform where your new account will be set up, it will be set as the default engine for any app that needs it without the need for any manual action on your end at any point. To avoid any chance of losing info if you update an app or if you delete a database unintentionally, we will carry out backups of all your databases every day, so if anything goes wrong, we can recover your content.

InnoDB in VPS Hosting

If you pick a virtual private server with our Hepsia Control Panel, the InnoDB storage engine will be part of the default software pack that will be installed on your VPS server before we hand it over to you. You won’t have to activate anything manually and you’ll be able to install and use any PHP script-driven web app that requires InnoDB when your VPS is set up, which takes no more than 60 minutes after the order process itself. A couple of engines are available, so anytime you set up a MySQL database via the Hepsia Control Panel, a specific engine will be selected once the app installation process starts and our system will recognize the engine that is required by the application in question. If you need MyISAM, for instance, you won’t have to do anything different from installing the desired application, whether manually or using our application installer tool.

InnoDB in Dedicated Web Hosting

If you obtain a new dedicated server, you’ll be able to pick one of the 3 hosting Control Panels that we’re offering – cPanel, DirectAdmin and Hepsia. Each dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you will not need to enable this database storage engine manually in order to be able to run open-source script-driven apps that need it. InnoDB is used by scalable apps and since a dedicated server will provide you with all the server resources that you need in order to run very large sites, it’s pretty likely that you will resort to InnoDB. You’ll be able to use other engines too, so in case a certain application needs MyISAM instead of InnoDB, you won’t encounter 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 need to configure any settings manually at any point.