InnoDB is a MySQL storage engine, which has been gaining in popularity in recent years, because it provides a much better overall performance and an improved database failure recovery compared to the default engine used by MySQL – MyISAM. InnoDB is endorsed by lots of web developers that run scalable software apps, because it works much more effectively with enormous data volumes, while it keeps the server load low. Also, it locks only a single row in the database in case any information should be edited, while many other engines lock the entire database table and therefore require much more time to process several consecutive tasks. Last, but not least, InnoDB adheres to the "all-or-nothing" rule – if the entire data modification cannot be completed successfully for any reason, the operation is rolled back to prevent scrambling or the loss of data. Magento and the latest editions of Joomla are two instances of popular open-source script-powered web apps which have switched over to InnoDB.
InnoDB in Shared Hosting
InnoDB is offered with all our Linux shared service by default, not as a paid upgrade or upon request, so you can install and run any open-source script-powered application which requires the database storage engine without having to deal with any obstacle once you open your account. InnoDB will be pre-selected as the default engine for a particular database during the app activation process, irrespective of whether you take advantage of our single-click installer or create the MySQL database and activate the app manually, on the condition that the app requires InnoDB instead of the more popular MyISAM engine. We will perform regular MySQL database backups, so you can be sure that you won’t ever lose any content if you delete a database unintentionally or you overwrite some vital information – you simply need to get in touch with us and we’ll restore your content the way it was.
InnoDB in Semi-dedicated Servers
InnoDB is available with all our Linux semi-dedicated servers by default, so as soon as you create a new account, you can move on and install any PHP-powered web app that requires this MySQL database engine. A couple of engines are installed on our cloud hosting platform, so when you set up a brand-new database and start installing an application manually, or opt to make use of the Hepsia hosting Control Panel-integrated application installer tool, the engine for the database will be set based on the prerequisites of the application in question. This will permit you to activate and run InnoDB-specific applications without having to deal with any problem and without having to configure any settings in your account. To be on the safe side, we’ll always have a 1-week-old backup of all your databases, so if you erase or change any content unintentionally, we can quickly restore it.
InnoDB in VPS Servers
When you acquire a VPS server from us, you will be able to take advantage of our custom-built Hepsia hosting Control Panel to manage your web content. A Hepsia-equipped VPS will permit you to run any PHP-powered app that needs InnoDB, as the storage engine is included in the default software package that will be installed on the Virtual Private Server during its setup. When you set up a new database using the hosting Control Panel, you’ll simply have to begin installing an application – manually or using our application installer. InnoDB will be set as the default engine given that the application in question requires it, so you won’t have to do anything else in your account. In the same manner, if an app requires MyISAM, it will be automatically set as the default engine for this concrete database.
InnoDB in Dedicated Servers
When you buy a new dedicated server, you’ll be able to choose any of the 3 Control Panels offered by our company – Hepsia, cPanel and DirectAdmin. Any dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you will not need to add this MySQL storage engine manually so as to be able to use script-powered web apps that require it. InnoDB is used by scalable applications and since a dedicated server will provide you with all the server resources that you require to run large-scale websites, it’s very possible that you’ll use InnoDB. You will be able to make use of other engines as well, so if a particular application requires MyISAM rather than InnoDB, you will not have to deal with any complication while using it. The engine that will be used will be recognized automatically when the app installation starts, so you will not need to alter any setting manually whatsoever.