InnoDB is a MySQL database storage engine, which has been gaining in popularity in recent years, as it provides a better overall performance and a faster crash recovery in comparison to the default engine used by the MySQL RDBMS – MyISAM. InnoDB is endorsed by many web developers that build highly scalable software apps, as it works much more effectively with enormous amounts of data, while it keeps the server processing load low. In addition, it it locks only one row in the database in case any information should be edited, whereas lots of other engines lock the entire database table and therefore need more time to process multiple sequential tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – in case the entire data modification process cannot be completed successfully for some reason, the operation is rolled back to prevent scrambling or data loss. Magento and the newest editions of Joomla™ are two instances of famous PHP-driven software platforms that have moved to InnoDB.

InnoDB in Cloud Web Hosting

Any script-powered app that needs InnoDB will function flawlessly on our advanced cloud web hosting platform and the MySQL database engine is offered with all our cloud web hosting plans. Each time you create a database manually or our app installer creates one automatically and an app installation is started, the engine that the database in question will make use of will be selected on the basis of the app’s requirements without the need to edit any setting in your hosting account. InnoDB will be selected automatically for any app that requires this specific engine and you’ll be able to make the most of its full capacity. We’ll store daily content backups, so if you accidentally delete a MySQL database that’s important to you or you overwrite specific parts of it, we will be able to restore everything the way it was just a few hours earlier.

InnoDB in Semi-dedicated Servers

You can activate a PHP-based app that needs InnoDB with any of our semi-dedicated server plans, since all the accounts are set up on our innovative 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 hosting Control Panel, or automatically – if you use our one-click application installer tool. In either case, the needed engine will be selected automatically once the activation of the application starts, so you won’t need to update anything manually, no matter if the app needs InnoDB or the more frequently used MyISAM. Also, we will always be able to restore any of your MySQL databases if you accidentally delete one, as we generate a couple of database backups every day, each of which is stored for 1 whole week.

InnoDB in VPS Servers

If you choose a VPS server with our Hepsia Control Panel, the InnoDB database storage engine will be part of the default software pack that will be installed on your server before we hand it over to you. You won’t have to set up anything manually and you’ll be able to enable and run any PHP-driven software application that needs InnoDB once your Virtual Private Server is ready, which takes no more than sixty minutes after the order process itself. A number of engines are offered, so anytime you set up a database via the Hepsia Control Panel, a particular engine will be selected when the app activation starts and our system will detect which engine is required by the app in question. In case you need to use MyISAM, for instance, you will not need to do anything different from installing the desired app, whether manually or using our application installer.

InnoDB in Dedicated Servers

All Linux dedicated servers ordered with our custom Hepsia hosting Control Panel include a software bundle that is pre-installed and besides everything else, you will get the InnoDB database storage engine, so you will not have to add it manually in case you’d like to activate open-source PHP scripts that require it. All it takes to activate such a script is to set up a new database and to initiate the setup process – once the script setup wizard receives access to the database in question and starts inserting content into it, InnoDB will be set as the default MySQL engine for this database as long as it is the one required by the script. You will also be able to use scripts that require the other popular MySQL engine, MyISAM, so you will not need to change any settings on the server. This will permit you to activate a variety of scripts on a single server and to use the latter to its fullest capabilities.