InnoDB is a database engine for MySQL databases, which is used by widely used open-source script-based software applications like Magento and Joomla 3. It is perfect for scalable apps, because it performs astonishingly well when handling enormous data volumes. Rather than locking the whole table to import new information into a database as many other engines do, InnoDB locks only one row, so it can execute much more operations for the same length of time. Besides, InnoDB offers a better database crash recovery and supports database transactions and foreign key constraints – rules that indicate how data imports and updates should be handled. If a specific task has not been entirely completed for any reason, the action will be rolled back. In this way, the content in the database will be kept undamaged and won’t be partially mixed with newly imported content.
InnoDB in Web Hosting
InnoDB is available with all our Linux web hosting packages by default, not as a paid upgrade or upon request, so you can install and run any open-source script-powered application which needs the InnoDB database storage engine without the need to deal with any complication once you order your account. InnoDB will be pre-selected as the default engine for a given MySQL database during the app activation process, regardless of whether you take advantage of our single-click installer or create the MySQL database and activate the app manually, as long as the application requires InnoDB instead of the more popular MyISAM engine. We’ll maintain daily backups of all your databases, so you can be certain that you’ll never lose any content in case you erase a database unintentionally or you overwrite some vital info – you will simply need to touch base with us and we will restore the database back to normal.
InnoDB in Semi-dedicated Hosting
All our semi-dedicated hosting support InnoDB and you will be able to use all the features of this storage engine with any script-powered software app that requires it. It’s among the engines that we have on our cloud website hosting platform, so the one that will be selected depends on the particular app’s requirements. You will not have to do anything manually in order to enable InnoDB, as 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 maintain regular backups of all your databases, so if something goes wrong after an upgrade or if you delete some data accidentally, we will be able to get the database back to the way it was on any of the previous 7 days.
InnoDB in VPS
When you acquire a virtual private server from us, you will be able to use our custom Hepsia hosting Control Panel to manage your web content. A Hepsia-equipped VPS will allow you to manage any script-powered web app which requires InnoDB, as the MySQL database storage engine is included in the default software package that will be installed on your Virtual Private Server during its configuration. When you create a new MySQL database through the Control Panel, you will simply need to begin installing an app – manually or using our application installer tool. InnoDB will be set as the default engine on the condition that the application in question requires it, so you will not have to do anything else in your VPS account. In the same manner, if a given application requires MyISAM, it will be automatically set as the default engine for this particular database.
InnoDB in Dedicated Hosting
When you get a new dedicated server, you’ll be able to choose one of the three hosting Control Panels that we’re offering – DirectAdmin, cPanel and Hepsia. Each dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you won’t have to add this MySQL database engine manually in order to be able to use script-based software apps that need it. InnoDB is used for scalable apps and since a dedicated server will provide you with all the server resources that you require in order to manage large-scale websites, it is pretty possible that you will resort to InnoDB. You will be able to use other engines too, so if a specific application requires MyISAM rather than InnoDB, you won’t experience any complication while using it. The engine that will be used will be recognized automatically as soon as the app installation starts, so you will not need to tweak any setting manually at any moment.