InnoDB is a MySQL storage engine, which has been gaining in popularity in recent years, because it offers a better overall performance and a faster database failure recovery compared with the default engine that’s used by the MySQL relational database management system – MyISAM. InnoDB is endorsed by numerous devs that create highly scalable software apps, as it works more effectively with immense data volumes, while it keeps the server processing load at a minimum. What’s more, it locks only a single row in the database if any information should be edited, while lots of other engines lock the entire database table and thus require much more time to process several sequential tasks. Last, but not least, InnoDB abides by the "all-or-nothing" rule – in case the entire data modification cannot be completed for whatever reason, the operation is rolled back to avoid scrambling or the loss of data. Magento and the latest versions of Joomla are two examples of popular PHP script-driven software platforms that have moved to InnoDB.

InnoDB in Shared Hosting

InnoDB is offered with all our Linux shared hosting by default, not as a paid upgrade or upon request, so you can install and manage any PHP script-based web application that needs the database engine without having any difficulty as soon as you activate your shared web hosting account. InnoDB will be pre-selected as the default engine for a given database during the app installation, regardless of whether you use our one-click installer or create the database and activate the app manually, provided that the app requires it instead of the more popular MyISAM engine. We will make daily database backups, so you can be certain that you’ll never lose any data in case you delete a database unintentionally or you overwrite some key information – you simply need to inform us and we will restore your content the way it was.

InnoDB in Semi-dedicated Hosting

If you create a new MySQL database through the Control Panel coming with each of our semi-dedicated server packages and you start installing a PHP script-based app either manually or using our 1-click app installer, the storage engine for the database will be set automatically on the basis of the prerequisites of the app in question. As InnoDB is available on the cloud hosting platform where your new semi-dedicated server account will be created, it will be set as the default engine for each app that needs it without any manual action needed on your end at any time. To prevent any chance of losing information if you update an application or if you delete a database unintentionally, we’ll generate backups of all your MySQL databases each and every day, so if something happens, we can rescue your data.

InnoDB in VPS Hosting

If our in-house developed Hepsia Control Panel is chosen during the signup process for your new Linux virtual private servers , InnoDB will be installed on the server together with other essential pieces of software, so you won’t have to do anything if you choose to activate PHP-based web applications that require this MySQL database storage engine. The default MySQL engine – MyISAM, will be activated as well. You can set up a new database and start installing the application manually or through our one-click installer. The system will automatically detect the engine that the application in question needs and will set it for the specific MySQL database, so the installation will proceed flawlessly and the app can insert its content into that database. In this way, you can manage applications with different prerequisites in regard to the MySQL engine without the need to make any changes on your VPS.

InnoDB in Dedicated Web Hosting

Our Hepsia Control Panel is among the features that you can choose on the order form when you buy a dedicated server from our company. As this is the most powerful kind of web hosting, it is pretty likely that you will manage highly popular websites that will attract many visitors, and since InnoDB is among the very best options for such Internet sites, we’ll enable it along with all the other software applications that come with a Hepsia-equipped server. When you create a brand-new database in your dedicated server account, there won’t be any activated database storage engine till you begin installing a PHP script, whether manually through your web browser or using the automatic script installation tool that is included in the Control Panel. The needed engine will be recognized and will be assigned to the database in question, so you can run scripts that need InnoDB, as well as ones that need MyISAM – the default MySQL engine, without running into any problem.