InnoDB is a MySQL storage engine, which has been gaining in popularity lately, as it provides a significantly better overall performance and a faster database crash recovery in comparison with the default engine used by the MySQL RDBMS – MyISAM. InnoDB is used by a lot of developers that write highly scalable software applications, as it works more effectively with immense amounts of data, while it keeps the server load at a minimum. Additionally, it uses row-level locking in case any information should be updated, whereas lots of other engines lock the entire table and thus require much more time to fulfill several consecutive tasks. Last, but not least, InnoDB adheres to the "all-or-nothing" rule – if the modification of the entire data cannot be completed successfully for whatever reason, the operation is rolled back to prevent scrambling or the loss of data. Magento and the newest Joomla versions are two instances of widespread PHP-driven web apps which have moved to InnoDB.
InnoDB in Cloud Website Hosting
Any PHP-driven application that needs InnoDB will function impeccably on our advanced cloud web hosting platform and the storage engine is available with all our cloud website hosting packages. Each time you create a MySQL database manually or our app installer creates one automatically and an app installation process is initiated, the engine that the database in question will make use of will be selected based on the app’s prerequisites without the need to modify any setting in your shared account. InnoDB will be picked automatically for any application that requires this specific engine and you will be able to make the most of its full potential. We will maintain daily content backups, so in case you unintentionally remove a database that’s important to you or you overwrite a certain part of it, we will be able to restore your content the way it was only a couple of hours earlier.
InnoDB in Semi-dedicated Hosting
All our Linux semi-dedicated hosting support InnoDB and you’ll be able to get the most out of all the options offered by this MySQL database engine with any PHP script-driven app that requires it. InnoDB is one of the engines that are available on our cloud web hosting platform, so the one that will be used depends on the prerequisites of the given app. You will not have to do anything manually in order to activate InnoDB, because it will be set as the default engine when you install an app – whether manually or using our single-click app installer tool. To avoid any risk, we’ll store daily database backups, so if something goes wrong after some update or if you remove some data accidentally, we’ll be able to get the database back to the way it was on any of the previous 7 days.
InnoDB in VPS
In case our custom-developed Hepsia Control Panel is selected during the registration process for a new Linux virtual private servers , InnoDB will be installed on the VPS server along with other needed pieces of software, so you won’t have to do anything if you decide to activate PHP script-based software applications that need this MySQL database storage engine. The default MySQL engine, MyISAM, will be activated as well. You can create a new MySQL database and start installing the application manually or using our 1-click installer tool. The system will automatically recognize the engine that the application in question requires and will set it for the specific database, so the installation will proceed flawlessly and the app can dump its data in that database. Therefore, you can use applications with various requirements regarding the MySQL engine without the need to make any changes on your VPS.
InnoDB in Dedicated Hosting
All Linux dedicated hosting that are ordered with our in-house developed Hepsia Control Panel include a software package that is pre-activated and besides everything else, you’ll get the InnoDB storage engine, so you will not need to install it manually if you’d like to use open-source PHP scripts that require it. All it takes to use such a script is to set up a new MySQL database and to initiate the installation process – as soon as the script setup wizard obtains access to the database and begins entering content 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’ll also be able to install scripts that require the other popular MySQL engine – MyISAM, so you will not have to modify any settings on the server. This will allow you to activate a variety of scripts on a single server and to use it to its maximum capacity.