InnoDB is a MySQL storage engine, which has been gaining in popularity lately, as it provides a significantly better overall performance and a faster database crash recovery compared with the default engine that’s used by MySQL – MyISAM. InnoDB is used by lots of devs that run highly scalable apps, as it works much more efficiently with huge data volumes, while it keeps the server load low. Moreover, it locks only a single row in the database if any information should be updated, whereas many other engines lock the entire table and thus require more time to carry out several successive tasks. Last, but not least, InnoDB abides by a set of "all-or-nothing" rules – if the modification of the entire data cannot be completed for any reason, the action is rolled back to avoid scrambling or losing data. Magento and the latest Joomla releases are two instances of widespread PHP-based apps that have moved to InnoDB.

InnoDB in Shared Web Hosting

InnoDB is offered with all our Linux shared web hosting services by default, not as a paid upgrade or upon request, so you will be able to install and run any PHP-based web app that needs the InnoDB database storage engine without any impediments as soon as you open your account. InnoDB will be pre-selected as the default engine for a particular database during the app activation, irrespective of whether you take advantage of our one-click installation tool or create the MySQL database and install the application manually, provided that the application requires InnoDB instead of the more popular MyISAM engine. We will store regular MySQL database backups, so you can be sure that you won’t ever lose any data if you erase a database accidentally or you overwrite some crucial information – you will just have to notify us and we will restore the database the way it was.

InnoDB in Semi-dedicated Hosting

If you create a new MySQL database through the Control Panel provided with all our semi-dedicated server packages and you start installing a PHP-powered software app either manually or using our single-click app installer tool, the MySQL database storage engine will be set automatically on the basis of the particular app’s requirements. Since InnoDB is available on the cloud web 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 intervention needed on your end at any moment. To avoid any chance of losing data if you update an app or if you erase a database by mistake, we’ll carry out backups of all your MySQL databases every day, so if anything goes wrong, we can retrieve your data.

InnoDB in VPS

If you get a virtual private server from us, you’ll be able to take advantage of our in-house built Hepsia hosting Control Panel to manage your content. A Hepsia-equipped Virtual Private Server will allow you to use any PHP-driven software app that requires InnoDB, as this particular storage engine is part of the standard software package that will be installed on your VPS server during its creation. When you create a new database via the Control Panel, you just need to begin installing an application – manually or using our application installer. InnoDB will be set as the default engine on the condition that the app in question requires it, so you won’t need to do anything else in your VPS account. Equivalently, if a given app requires MyISAM, it will be automatically set as the default engine for this particular MySQL database.

InnoDB in Dedicated Hosting

Our Hepsia hosting Control Panel is among the options which you can pick on the order page when you buy a dedicated server from our company. As this is the most powerful type of website hosting, it’s very likely that you’ll manage very popular sites that will draw many visitors, and since InnoDB is among the best options for such sites, we’ll enable it together with all the other software applications that are available with a Hepsia-managed server. When you create a brand new MySQL database in your account, there won’t be any active MySQL database engine until you begin installing an open-source PHP script, whether manually through your Internet browser or using the automatic scripts installation tool that is included in the hosting Control Panel. The needed engine will be automatically detected and will be assigned to that database, so you can run scripts that need InnoDB, as well as ones that need MyISAM, the default MySQL engine, without coming across any problem.