InnoDB is a MySQL database storage engine, which has been gaining popularity in recent years, because it provides a significantly better overall performance and a faster database crash recovery in comparison with the default engine that’s used by MySQL – MyISAM. InnoDB is used by plenty of programmers that write highly scalable web applications, since it works more efficiently with immense data volumes, while it keeps the server processing load low. Furthermore, it it locks only one row in the database in case any information should be edited, while many other engines lock the entire table and therefore require much more time to fulfill several consecutive tasks. Last, but not least, InnoDB adheres to a set of "all-or-nothing" rules – in case the entire data modification process cannot be completed successfully for any reason, the operation is rolled back to prevent confusion or data loss. Magento and the latest editions of Joomla™ are two examples of widespread open-source script-based web applications that have shifted over to InnoDB.

InnoDB in Cloud Hosting

InnoDB is available with all our Linux cloud packages by default, not upon request or as a paid upgrade, so you’ll be able to activate and manage any PHP-powered software application which requires the InnoDB storage engine without any problem once you activate your shared web hosting account. InnoDB will be pre-selected as the default engine for a certain database during the app activation, no matter if you take advantage of our 1-click installation tool or create the MySQL database and install the application manually, as long as the app requires it instead of the more famous MyISAM engine. We will carry out daily backups of all your databases, so you can be sure that you will never lose any data in case you erase a database accidentally or you overwrite some vital info – you simply have to contact us and we will restore everything back to normal.

InnoDB in Semi-dedicated Hosting

You can use a PHP script-driven software app that requires InnoDB with any of our semi-dedicated server plans, as all the accounts are created on our innovative cloud web hosting platform where the database storage engine is installed. A new database can be set up in two different ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you take advantage of our 1-click app installer. In either case, the needed engine will be selected automatically once the installation of the application begins, so you won’t need to edit anything manually, no matter if the application requires InnoDB or the more frequently used MyISAM. On top of that, we will always be able to retrieve any of your MySQL databases if you accidentally erase one, as we carry out a few MySQL database backups every day, each of which is kept for 1 week.

InnoDB in VPS

If our in-house built Hepsia hosting Control Panel is chosen during the signup process for a new Linux VPS packages , InnoDB will be activated on the server together with other necessary pieces of software, so you will not need to do anything if you decide to activate script-driven web apps that need this MySQL storage engine. The default MySQL engine, MyISAM, will be activated too. You can set up a new MySQL database and start the app installation manually or through our 1-click installation tool. The system will recognize the engine that the app in question needs and will set it for the specific MySQL database, so the installation will continue impeccably and the application can import its data into that database. Thus, you can activate applications with various requirements about the MySQL engine without having to make any changes on your VPS.

InnoDB in Dedicated Hosting

If you purchase a new dedicated server, you’ll be able to choose any of the 3 Control Panels offered by us – Hepsia, cPanel and DirectAdmin. Any server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you won’t need to activate this database storage engine manually to be able to run PHP-based software apps that need it. InnoDB is used by scalable apps and since a dedicated server will give you all the server resources that you need to run large-size sites, it is pretty likely that you’ll resort to InnoDB. You will be able to make use of other engines as well, so in case a given app needs MyISAM rather than InnoDB, you won’t have any difficulty while managing it. The engine that will be used will be detected automatically the moment the app installation starts, so you won’t need to update any settings manually whatsoever.