InnoDB is a MySQL database engine, which has been gaining popularity in recent years, because it provides a better overall performance and an improved database failure recovery in comparison to the default engine that’s used by MySQL – MyISAM. InnoDB is used by plenty of developers that write highly scalable software applications, due to the fact that it works much better with huge amounts of data, while it keeps the server processing load low. Additionally, it it locks only one row in the database if any info should be modified, while many other engines lock the entire database table and thus require much more time to complete multiple successive tasks. Last, but not least, InnoDB complies with the "all-or-nothing" rule – if the entire data modification procedure cannot be completed for some reason, the action is rolled back to avoid scrambling or data loss. Magento and the latest editions of Joomla are two instances of famous PHP-based software applications which have switched over to InnoDB.

InnoDB in Shared Hosting

InnoDB is offered with all our shared hosting by default, not as a paid upgrade or upon request, so you will be able to install and manage any PHP script-based web app which requires the MySQL database engine without encountering any difficulty once you order your shared account. InnoDB will be pre-selected as the default engine for a certain database during the app installation, irrespective of whether you take advantage of our single-click installer or create the MySQL database and set up the app manually, provided that the app requires it instead of the more famous MyISAM engine. We’ll maintain regular backups of all your MySQL databases, so you can be certain that you will never lose any content if you erase a database unintentionally or you overwrite some crucial info – you will just need to inform us and we will restore your content back to normal.

InnoDB in Semi-dedicated Servers

You can make use of a script-based app that needs InnoDB with any of our semi-dedicated server plans, because all the accounts are set up on our leading-edge cloud platform where the storage engine is installed. A new MySQL database can be created in two different ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you take advantage of our one-click app installer tool. Either way, the required engine will be selected automatically the moment the activation of the application starts, so you won’t have to modify anything manually, regardless of whether the app needs InnoDB or the more frequently used MyISAM. Furthermore, we’ll always be able to restore any of your MySQL databases in case you remove one by mistake, as we generate a couple of database backups every day, each of which is preserved for one week.

InnoDB in VPS Servers

In case our custom Hepsia Control Panel is picked during the signup process for your new VPS servers , InnoDB will be activated on the server along with other necessary software, so you won’t need to do anything if you decide to manage script-powered web applications that need this MySQL storage engine. MyISAM, the default MySQL engine, will be installed too. You can set up a brand-new MySQL database and start the app installation manually or using our single-click installer. The system will recognize the engine that the particular app requires and will set it for the specific MySQL database, so the installation will continue flawlessly and the app can import its data into that database. Therefore, you can make use of apps with different prerequisites about the MySQL engine without the need to make any modifications on your server.

InnoDB in Dedicated Servers

All dedicated servers that are ordered with our custom-built Hepsia hosting Control Panel include a software bundle that’s pre-activated and among everything else, you will get the InnoDB database storage engine, so you will not need to activate it manually if you wish to run PHP scripts that require it. All it takes to install such a script is to set up a new MySQL database and to start the installation process – once the installation wizard gains access to the database and starts importing data into it, InnoDB will be set as the default engine for this database provided that it is the one needed by the particular script. You’ll also be able to use scripts that need the other popular MySQL engine – MyISAM, so you will not need to update any settings on the server. This will allow you to install different scripts on a single physical server and to use it to its maximum capacity.