InnoDB is a MySQL database engine, which has been gaining in popularity lately, because it offers a significantly better overall performance and an improved database crash recovery in comparison to the default engine used by the MySQL DBMS – MyISAM. InnoDB is used by a lot of programmers that write highly scalable web applications, because it works more efficiently with huge data volumes, while it keeps the server processing load at a minimum. Furthermore, it uses row-level locking if any info should be edited, while lots of other engines lock the entire table and therefore require much more time to complete multiple sequential tasks. Last, but not least, InnoDB follows the "all-or-nothing" rule – if the entire data modification process cannot be completed successfully for whatever reason, the action is rolled back to avoid confusion or the loss of data. Magento and the latest releases of Joomla™ are two examples of famous script-driven software platforms that have switched over to InnoDB.

InnoDB in Cloud Hosting

InnoDB is available with all our cloud hosting plans by default, not as a paid upgrade or upon request, so you can activate and run any PHP-driven software app that needs the MySQL database storage engine without having to deal with any impediment once you activate your shared website hosting account. InnoDB will be selected automatically 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 install the app manually, as long as the application requires it instead of the more popular MyISAM engine. We’ll perform daily database backups, so you can rest assured that you’ll never lose any data in case you delete a database accidentally or you overwrite some important info – you will simply need to inform us and we will restore the database back to normal.

InnoDB in Semi-dedicated Servers

If you set up a brand-new MySQL database through the Control Panel coming with each of our semi-dedicated server plans and you start installing a PHP-based web app either manually or using our one-click app installer tool, the storage engine for the database will be selected automatically based on the specific app’s prerequisites. As InnoDB is available on the cloud web hosting platform where your new semi-dedicated server account will be set up, it will be set as the default engine for any application that needs it without any manual action required on your end at any time. To avoid any chance of losing info if you update an app or if you delete a database accidentally, we will generate backups of all your MySQL databases every day, so if anything happens, we can retrieve your data.

InnoDB in VPS Servers

If you obtain a VPS server from our company, you’ll be able to make use of our in-house developed Hepsia hosting Control Panel to manage your content. A Hepsia-managed VPS will allow you to activate any PHP script-based application which requires InnoDB, as the MySQL database storage engine is part of the default software package that will be installed on the server during its creation. When you create a brand new database through the Control Panel, you’ll simply have to begin installing an app – manually or using our app installer tool. InnoDB will be set as the default engine if the app in question needs it, so you will not have to do anything else in your VPS account. Likewise, if an application needs MyISAM, it will be automatically set as the default engine for this particular MySQL database.

InnoDB in Dedicated Servers

All Linux dedicated servers that are ordered with our custom-developed Hepsia Control Panel come with a software package that is pre-activated and among everything else, you’ll get the InnoDB database engine, so you will not need to activate it manually if you’d like to use open-source PHP scripts that need it. All it takes to install such a script is to set up a new database and to initiate the installation – as soon as the installer wizard receives access to the database in question and starts inserting data into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one needed by the particular script. You’ll also be able to run scripts that require the other popular MySQL engine – MyISAM, so you will not need to configure any settings on the server. This will enable you to activate different scripts on a single server and to use it to its fullest capabilities.