InnoDB is a MySQL database engine, which has been gaining popularity in recent years, because it provides a significantly better overall performance and an improved database crash recovery in comparison to the default engine that is used by the MySQL RDBMS – MyISAM. InnoDB is endorsed by lots of web developers that build scalable software apps, since it works more effectively with huge volumes of data, while it keeps the server load at a minimum. Also, it it locks only one row in the database in case any info should be modified, whereas many other engines lock the entire table and therefore need more time to accomplish several consecutive tasks. Last, but not least, InnoDB adheres to a set of "all-or-nothing" rules – if the entire data modification process cannot be completed successfully for any reason, the action is rolled back to prevent confusion or losing data. Magento and the latest editions of Joomla are two instances of famous PHP script-driven software applications that have moved to InnoDB.

InnoDB in Shared Hosting

While InnoDB is either not available or a paid upgrade with other web hosts, it is an integral part of the default set of features that we’re offering with our shared hosting plans. If you wish to use a PHP-based software application that needs InnoDB particularly, in order to be activated and to operate correctly, you won’t need to deal with any obstacles since the database storage engine is available on our in-house built cloud hosting platform. Regardless of whether you create a brand new database and install an app manually or use our 1-click application installer software tool, InnoDB will be selected automatically by our system as the default engine if the specific app needs it instead of MyISAM. In addition to the exceptional database crash recovery offered by InnoDB, we also keep regular database backups, so we can swiftly restore any MySQL database in your shared account.

InnoDB in Semi-dedicated Servers

InnoDB comes with all our Linux semi-dedicated servers by default, so as soon as you create a new semi-dedicated account, you can move on and activate any script-powered software application that needs this database storage engine. A couple of engines are installed on our cloud web hosting platform, so when you set up a new database and start installing an app manually, or opt to take advantage of the Hepsia Control Panel-integrated app installer tool, the engine for the database will be selected depending on the given app’s prerequisites. This will permit you to activate and manage InnoDB-specific applications without the need to cope with any obstacle and without needing to change any settings in your semi-dedicated account. To avoid any risk, we’ll always have a one-week-old backup of all your databases, so if you delete or change any content unintentionally, we can quickly restore it.

InnoDB in VPS Servers

All VPS servers that are ordered with the Hepsia Control Panel come with InnoDB pre-activated, so you will be able to make use of any open-source script-based software application that requires this MySQL database storage engine without the need to install anything manually. You can choose Hepsia on the VPS order page and your new Virtual Private Server will be ready within the hour, so you can log in and begin building your websites right away. When you create a new MySQL database and start the app installation process, our system will choose the engine for this database automatically. In this way, you can make use of different apps at the same time without updating anything on the server. You can set up a WordPress-powered weblog that makes use of MyISAM – the default MySQL engine, and a Magento-driven online store that uses InnoDB, for example.

InnoDB in Dedicated Servers

If you buy a new dedicated server, you will be able to choose any of the 3 hosting Control Panels that we’re offering – DirectAdmin, Hepsia and cPanel. Any dedicated server ordered with Hepsia comes with InnoDB pre-activated, so you will not need to add this MySQL database storage engine manually to be able to use PHP script-powered software applications that need it. InnoDB is used by scalable applications and since a dedicated server will offer you all the server resources that you need to run very large websites, it’s pretty possible that you’ll resort to InnoDB. You will be able to make use of other engines too, so in case a particular app needs MyISAM rather than InnoDB, you will not have any obstacle while using it. The engine that will be used will be detected automatically once the app installation procedure commences, so you will not have to configure any setting manually at any point.