InnoDB is a MySQL storage engine, which has been gaining in popularity lately, as it offers a better overall performance and a faster database crash recovery in comparison with the default engine that is used by the MySQL RDBMS – MyISAM. InnoDB is preferred by many developers that run highly scalable web applications, because it works much more efficiently with immense volumes of data, while it keeps the server processing load low. Additionally, it it locks only one row in the database in case any info should be updated, whereas many other engines lock the entire table and therefore require more time to fulfill multiple consecutive tasks. Last, but not least, InnoDB abides by a set of "all-or-nothing" rules – in case the entire data modification procedure cannot be completed successfully for some reason, the operation is rolled back to prevent scrambling or data loss. Magento and the latest versions of Joomla™ are two examples of widespread open-source script-powered applications which have moved to InnoDB.
InnoDB in Cloud Website Hosting
While InnoDB is either a paid upgrade or it is not available at all with many other hosting providers, it’s part of the default set of services offered with our cloud website hosting
packages. In case you want to use a PHP script-driven app that needs InnoDB particularly, in order to be activated and to operate properly, you will not face any obstacles as the storage engine is available on our custom-developed cloud platform. Regardless of whether you create a brand new MySQL database and install an application manually or take advantage of our one-click application installer software tool, InnoDB will be selected automatically by our system as the default engine if the specific app needs InnoDB rather than MyISAM. In addition to the excellent database crash recovery that InnoDB is offering, we also maintain regular database backups, so we can swiftly restore any MySQL database in your shared website hosting account.
InnoDB in Semi-dedicated Servers
All our semi-dedicated servers
come with InnoDB and you can use all the features of this MySQL database engine with any PHP-based software 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 requirements of the particular application. You won’t have to do anything manually in order to enable InnoDB, since it will be set as the default engine when you install an application – whether manually or using our single-click application installer. To be on the safe side, we will make daily database backups, so if anything goes wrong following some update or if you delete some content by mistake, we will be able to restore your database the way it was on any of the previous seven days.
InnoDB in VPS Servers
In case our custom Hepsia Control Panel is picked during the registration process for a new VPS servers
, InnoDB will be activated on the Virtual Private Server along with other essential pieces of software, so you will not have to do anything if you choose to install open-source script-based web applications that need this MySQL database storage engine. MyISAM, the default MySQL engine, will be activated too. You can set up a brand-new MySQL database and start the app installation manually or using our 1-click installer. The system will recognize which engine the app in question requires and will assign it to the specific MySQL database, so the installation process will proceed impeccably and the app can insert its content into that database. Therefore, you can manage applications with different requirements regarding the MySQL engine without having to make any changes on your server.
InnoDB in Dedicated Servers
All Linux dedicated service
that are ordered with our in-house developed Hepsia hosting Control Panel come with a software bundle that is pre-installed and besides everything else, you will get the InnoDB database engine, so you will not need to install it manually if you want to use scripts that need it. All it takes to install such a script is to create a new database and to initiate the installation – once the installer wizard obtains access to the database and starts dumping data in it, InnoDB will be set as the default engine for this database as long as it is the one needed by the particular script. You will also be able to install scripts that need the other widely used MySQL engine, MyISAM, so you won’t need to modify any settings on the server. This will permit you to install various scripts on one single physical machine and to use the latter to its full capacity.