What?s InnoDB? Why has it been selected as the standard MySQL storage engine?
InnoDB is a MySQL database engine, which has been gaining in popularity lately, as it offers a much better overall performance and a faster crash recovery compared to the default engine that’s used by the MySQL relational database management system – MyISAM. InnoDB is preferred by many web developers that create scalable applications, since it works more effectively with huge data volumes, while it keeps the server load low. Also, it locks only one database row if anything should be edited, while lots of other engines lock the entire database table and therefore require more time to execute multiple consecutive tasks. Last, but not least, InnoDB observes a set of "all-or-nothing" rules – if the entire data modification process cannot be completed for some reason, the action is rolled back to avoid scrambling or data loss. Magento and the latest versions of Joomla™ are two examples of famous script-based apps that have shifted over to InnoDB.
InnoDB in Web Hosting
InnoDB is available with all our Linux web hosting
by default, not upon request or as a paid upgrade, so you will be able to install and run any open-source script-based app which requires the InnoDB storage engine without any problem as soon as you activate your shared website hosting account. InnoDB will be selected automatically as the default engine for a certain MySQL database during the app activation process, regardless of whether you make use of our one-click installer or create the MySQL database and set up the app manually, provided that the application requires it instead of the more popular MyISAM engine. We will generate daily backups of all your MySQL databases, so you can be certain that you’ll never lose any data in case you erase a database by mistake or you overwrite some crucial information – you will simply have to contact us and we will restore everything back to normal.
InnoDB in Semi-dedicated Hosting
InnoDB comes with each of our Linux semi-dedicated hosting packages
by default, so the moment you order a new semi-dedicated account, you can go ahead and install any PHP script-based web application that requires this particular database storage engine. A couple of engines are installed on our cloud platform, so when you create a brand new MySQL database and start installing an app manually, or decide to use the Hepsia Control Panel-integrated application installer, the engine for the database will be picked based on the requirements of the respective app. This will allow you to install and run InnoDB-specific apps without needing to cope with any difficulty and without needing to change any settings in your account. To take no chances, we’ll always have a one-week-old backup of all your databases, so if you erase or alter any content accidentally, we can swiftly rescue it.
InnoDB in VPS
If you select a virtual private server
with our Hepsia hosting Control Panel, the InnoDB database storage engine will be an essential part of the software bundle that will be pre-installed on your Virtual Private Server before we hand it over to you. You will not need to activate anything manually and you’ll be able to install and manage any PHP-driven app that needs InnoDB as soon as your VPS server is ready, which takes no more than sixty minutes after the order procedure itself. A few engines are offered, so anytime you create a database through the Hepsia hosting Control Panel, a specific engine will be selected when the app activation 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 need to do anything different than installing the chosen application, whether manually or using our application installer tool.
InnoDB in Dedicated Hosting
When you purchase a new dedicated server
, you will be able to choose one of the three hosting Control Panels that we are offering – DirectAdmin, cPanel and Hepsia. Any dedicated server ordered with Hepsia comes with InnoDB pre-installed, so you will not have to install this MySQL database engine manually so as to be able to manage PHP-driven applications that need it. InnoDB is used for scalable apps and since a dedicated server will supply you with all the server resources that you require in order to manage large-size sites, it’s very possible that you will use InnoDB. You’ll be able to use other engines too, so in case a specific app needs MyISAM rather than InnoDB, you will not run into any problem while using it. The engine that will be used will be automatically recognized once the app installation procedure begins, so you won’t have to modify any settings manually whatsoever.