InnoDB

InnoDB is a MySQL storage engine, which has been gaining in popularity lately, because it offers a significantly better overall performance and a faster database crash recovery compared to the default engine that is used by the MySQL RDBMS – MyISAM. InnoDB is preferred by lots of web developers that create scalable web applications, as it works much more effectively with enormous data volumes, while it keeps the server load low. Moreover, it locks only a single row in the database in case any information should be edited, while many other engines lock the entire table and thus need much more time to fulfill multiple sequential tasks. Last, but not least, InnoDB complies with a set of "all-or-nothing" rules – in case the modification of the entire data cannot be completed for some reason, the operation is rolled back to avoid scrambling or data loss. Magento and the latest Joomla^™ editions are two instances of widely used open-source script-powered software applications that have shifted over to InnoDB.

InnoDB in Website Hosting

InnoDB is offered with all our website hosting by default, not as a paid upgrade or upon request, so you can install and run any PHP script-based software application which needs the InnoDB storage engine without having to deal with any impediment once you order your shared website hosting account. InnoDB will be pre-selected as the default engine for a specific MySQL database during the app installation process, irrespective of whether you take advantage of our single-click installer or create the MySQL database and activate the application manually, as long as the application requires InnoDB instead of the more famous MyISAM engine. We will keep daily backups of all your MySQL databases, so you can be certain that you will never lose any content if you erase a database accidentally or you overwrite some crucial info – you just need to touch base with us and we’ll restore your database the way it was.

InnoDB in Semi-dedicated Servers

All our Linux semi-dedicated hosting plans come with InnoDB and you can take full advantage of all the features of this database engine with any PHP script-based app that requires it. InnoDB is among the engines that are available on our cloud web hosting platform, so the one that will be picked depends on the prerequisites of the app in question. You will not need to do anything manually in order to enable InnoDB, as it will be set as the default engine when you install an application – whether manually or using our 1-click app installer tool. To avoid any risk, we will store daily backups of all your databases, so if anything goes wrong after some update or if you remove some data unintentionally, we’ll be able to get your database back to the way it was on any of the previous 7 days.

InnoDB in VPS Servers

If you order a VPS server with our Hepsia hosting Control Panel, the InnoDB storage engine will be included in the standard software package that will be pre-installed on your server before we hand it over to you. You will not need to configure anything manually and you’ll be able to enable and use any PHP script-driven software app that needs InnoDB as soon as your VPS server is set up, which takes no more than one hour after the order submission procedure itself. A couple of engines are available, so whenever you set up a database through the Hepsia hosting Control Panel, a specific engine will be selected when the app installation process begins and our system will recognize which engine is required by the application in question. In case you need MyISAM, for example, you won’t have to do anything different than installing the preferred app, whether manually or using our app installer tool.

InnoDB in Dedicated Servers

All dedicated web hosting plans ordered with our custom-built Hepsia hosting Control Panel include a software package that is pre-installed and among everything else, you will get the InnoDB storage engine, so you won’t have to activate it manually in case you wish to use open-source scripts that require it. All it takes to run such a script is to set up a new MySQL database and to initiate the setup – once the script setup wizard gets access to the database and starts inserting data into it, InnoDB will be set as the default engine for this database as long as it is the one required by the script. You will also be able to run scripts that require MyISAM, the other widely used MySQL engine, so you won’t need to edit any settings on the server. This will allow you to activate various scripts on one single physical server and to use the latter to its maximum capacity.