InnoDB is a MySQL database engine, which has been gaining popularity lately, as it provides a much better overall performance and a faster crash recovery in comparison with the default engine used by the MySQL DBMS – MyISAM. InnoDB is used by many developers that build scalable software applications, due to the fact that it works more effectively with immense amounts of data, while it keeps the server processing load at a minimum. In addition, it locks only one database row if any info should be updated, whereas lots of other engines lock the entire table and thus require more time to accomplish several consecutive tasks. Last, but not least, InnoDB adheres to a set of "all-or-nothing" rules – in case the modification of the entire data cannot be completed successfully for any reason, the action is rolled back to avoid confusion or losing data. Magento and the newest releases of Joomla are two instances of famous PHP-based software apps which have shifted over to InnoDB.

InnoDB in Hosting

InnoDB is available with all our hosting by default, not upon request or as a paid upgrade, so you’ll be able to activate and manage any PHP script-based application which needs the MySQL database engine without having to deal with any problem once you order your shared account. InnoDB will be selected automatically as the default engine for a particular MySQL database during the app installation process, irrespective of whether you take advantage of our 1-click installation tool or create the database and set up the app manually, on the condition that the application requires InnoDB instead of the more famous MyISAM engine. We’ll keep regular backups of all your databases, so you can be sure that you won’t ever lose any data in case you erase a database unintentionally or you overwrite some vital info – you will just have to touch base with us and we will restore the database back to normal.

InnoDB in Semi-dedicated Servers

You can activate a PHP script-powered application that needs InnoDB with any of our semi-dedicated server packages, since all the accounts are set up on our advanced cloud web hosting platform where the database engine is installed. A new MySQL database can be set up in two ways – manually from the Database Manager section of the Hepsia web hosting Control Panel, or automatically – when you make use of our one-click app installer. Either way, the required engine will be chosen automatically the moment the activation of the app begins, so you won’t need to edit anything manually, regardless of whether the application needs InnoDB or the more regularly used MyISAM. Furthermore, we’ll always be able to retrieve any of your databases if you remove one by accident, as we generate several MySQL database backups every day, each of which is stored for 1 whole week.

InnoDB in VPS Servers

In case our custom-developed Hepsia hosting Control Panel is selected during the registration process for your new VPS servers , InnoDB will be activated on the Virtual Private Server along with other necessary software, so you will not need to do anything if you decide to install PHP script-powered software applications that require this MySQL storage engine. The default MySQL engine – MyISAM, will be activated too. You can create a new MySQL database and begin installing the application manually or using our 1-click installation tool. The system will detect the engine that the application in question needs and will assign it to the specific MySQL database, so the installation will continue impeccably and the app can insert its content into that database. Thus, you can make use of applications with various requirements concerning the MySQL engine without the need to make any modifications on your VPS.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is one of the options which you can select on the order form when you buy a dedicated server from our company. As this is the most powerful kind of hosting, it’s very likely that you’ll manage highly popular sites that will draw many people, and since InnoDB is one of the best options for such websites, we will enable it along with all the other software applications that are offered with a Hepsia-equipped server. When you set up a brand-new MySQL database in your dedicated account, there won’t be any active storage engine till you begin installing an open-source PHP script, whether manually via your browser or using the automatic scripts installer that is integrated into the hosting Control Panel. The necessary engine will be automatically detected and will be assigned to the database in question, so you can use scripts that require InnoDB, as well as ones that require the default MySQL engine – MyISAM, without any obstacle.