InnoDB
Find what a database engine is, what exactly are the pros of the InnoDB engine and why it is gaining so much worldwide popularity.
InnoDB is a MySQL storage engine, which has been gaining popularity in recent years, as it offers a significantly better overall performance and a faster crash recovery in comparison with the default engine that’s used by the MySQL database management system – MyISAM. InnoDB is preferred by many programmers that write scalable apps, due to the fact that it works much more efficiently with huge data volumes, while it keeps the server load low. Also, it it locks only one row in the database if anything should be modified, while many other engines lock the entire database table and thus need more time to carry out multiple sequential tasks. Last, but not least, InnoDB follows the "all-or-nothing" rule – in case the modification of the entire data cannot be completed for whatever reason, the operation is rolled back to avoid confusion or the loss of data. Magento and the newest Joomla™ editions are two instances of widespread script-based software applications that have shifted over to InnoDB.
-
InnoDB in Shared Website Hosting
InnoDB is available with all our
Linux shared website hosting by default, not upon request or as a paid upgrade, so you will be able to install and run any PHP script-based application that needs the InnoDB database storage engine without any impediments as soon as you open your account. InnoDB will be pre-selected as the default engine for a certain MySQL database during the app installation process, no matter if you use our 1-click installation tool or create the database and activate the app manually, on the condition that the app requires InnoDB instead of the more famous MyISAM engine. We’ll carry out daily MySQL database backups, so you can be certain that you won’t ever lose any data in case you delete a database accidentally or you overwrite some vital info – you will just need to touch base with us and we will restore everything back to normal.
-
InnoDB in Semi-dedicated Hosting
If you create a new MySQL database through the Control Panel coming with each of our
semi-dedicated server packages and you begin installing a PHP-powered web app either manually or using our single-click app installer tool, the storage engine for the MySQL database will be selected automatically on the basis of the requirements of the specific app. As InnoDB is available on the cloud web hosting platform where your new account will be set up, it will be set as the default engine for any app that requires it without the need for any manual intervention on your end at any time. To prevent any risk of losing information if you update an app or if you delete a database by accident, we’ll carry out a backup of all your MySQL databases each and every day, so if something goes wrong, we can recover your content.
-
InnoDB in VPS Hosting
If you order a
virtual private server with our Hepsia Control Panel, the InnoDB database storage engine will be part of the standard software bundle that will be pre-installed on your server before we hand it over to you. You will not have to set up anything manually and you will be able to install and use any script-based web app that requires InnoDB as soon as your VPS server is ready, which takes no more than 1 hour after the order submission process itself. A couple of engines are offered, so anytime you create a MySQL database through the Hepsia hosting Control Panel, a specific engine will be picked when the app installation process begins and our system will automatically recognize the engine that is required by the application in question. In case you need MyISAM, for instance, you won’t have to do anything different from installing the app of your preference, whether manually or using our app installer.
-
InnoDB in Dedicated Web Hosting
All
Linux dedicated web hosting ordered with our in-house built Hepsia Control Panel include a software package that’s pre-installed and among everything else, you will get the InnoDB database engine, so you won’t need to activate it manually if you wish to use open-source scripts that need it. All it takes to use such a script is to create a new database and to initiate the installation – as soon as the installer wizard gets access to the database in question and starts entering data into 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’ll also be able to install scripts that require the other widely used MySQL engine, MyISAM, so you won’t have to update any settings on the server. This will permit you to install a variety of scripts on one single physical server and to use the latter to its full capacity.