InnoDB is a MySQL storage engine, which has been gaining popularity in recent years, because it provides a better overall performance and a faster database crash recovery compared to the default engine that is used by the MySQL relational database management system – MyISAM. InnoDB is preferred by a lot of programmers that write highly scalable software applications, due to the fact that it works more effectively with immense amounts of data, while it keeps the server processing load low. Also, it it locks only one row in the database if any information should be updated, whereas many other engines lock the entire database table and hence need more time to accomplish multiple sequential tasks. Last, but not least, InnoDB follows a set of "all-or-nothing" rules – if the entire data modification procedure cannot be completed successfully for any reason, the action is rolled back to avoid confusion or the loss of data. Magento and the newest versions of Joomla are two examples of popular PHP script-driven web apps which have switched to InnoDB.
InnoDB in Cloud Hosting
InnoDB is available with all our Linux cloud hosting by default, not upon request or as a paid upgrade, so you’ll be able to install and run any script-driven web application that needs the InnoDB database storage engine without having to deal with any impediment once you open your shared account. InnoDB will be pre-selected as the default engine for a particular MySQL database during the app activation process, no matter if you use our 1-click installer or create the MySQL database and activate the application manually, on the condition that the app requires InnoDB instead of the more popular MyISAM engine. We will carry out regular database backups, so you can rest assured that you won’t ever lose any data in case you delete a database by accident or you overwrite some essential info – you will just need to inform us and we’ll restore your database the way it was.
InnoDB in Semi-dedicated Servers
InnoDB is included with all our Linux semi-dedicated hosting plans by default, so once you purchase a new semi-dedicated account, you can go ahead and install any open-source script-powered software application that requires this MySQL storage engine. A couple of engines are pre-installed on our cloud web hosting platform, so when you create a brand new database and begin installing an application manually, or opt to take advantage of the Hepsia Control Panel-integrated app installer tool, the engine for the database will be set on the basis of the requirements of the given app. This will allow you to activate and run InnoDB-specific apps without the need to deal with any complication and without needing to modify any settings in your account. To avoid any risk, we will always have a 1-week-old backup of all your databases, so if you erase or change any content accidentally, we can easily recover it.
InnoDB in VPS Servers
If you choose a VPS server with our Hepsia Control Panel, the InnoDB storage engine will be an indivisible part of the software pack that will be pre-installed on your VPS server before we give it to you. You won’t have to set up anything manually and you’ll be able to enable and run any PHP-powered application that needs InnoDB once your Virtual Private Server is set up, which takes no more than one hour after the order procedure itself. Several engines are available, so whenever you create a MySQL database through the Hepsia hosting Control Panel, a particular engine will be activated once the app activation process commences and our system will detect the engine that is required by the app in question. In case you need to use MyISAM, for instance, you won’t need to do anything different from installing the chosen app, whether manually or using our application installer tool.
InnoDB in Dedicated Servers
All Linux dedicated web hosting plans ordered with our custom Hepsia hosting Control Panel include a software bundle that’s pre-activated and among everything else, you will get the InnoDB storage engine, so you will not need to install it manually if you need to activate open-source PHP scripts that require it. All it takes to install such a script is to set up a new MySQL database and to initiate the installation process – once the script installation wizard gains access to the database in question and starts importing data into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one required by the script. You will also be able to use scripts that need MyISAM – the other very popular MySQL engine, so you won’t need to configure any settings on the dedicated server. This will allow you to run different scripts on a single physical machine and to use the latter to its maximum capabilities.