InnoDB is a MySQL storage engine, which has been gaining in popularity lately, because it provides a better overall performance and an improved crash recovery compared to the default engine that is used by the MySQL RDBMS – MyISAM. InnoDB is used by plenty of web developers that run highly scalable software apps, due to the fact that it works more efficiently with enormous volumes of data, while it keeps the server processing load at a minimum. What’s more, it locks only one database row in case any information should be edited, whereas lots of other engines lock the entire database table and hence require more time to fulfill several consecutive tasks. Last, but not least, InnoDB follows the "all-or-nothing" rule – if the modification of the entire data cannot be completed for whatever reason, the action is rolled back to prevent scrambling or data loss. Magento and the latest Joomla releases are two examples of widespread PHP-powered apps which have switched to InnoDB.
InnoDB in Cloud Web Hosting
InnoDB is available with all our Linux cloud web hosting packages by default, not upon request or as a paid upgrade, so you will be able to install and run any PHP-based web app which requires the InnoDB database storage engine without having any difficulty as soon as you order your shared website hosting account. InnoDB will be pre-selected as the default engine for a given database during the app installation, no matter if you take advantage of our one-click installer or create the MySQL database and activate the application manually, provided that the application requires it instead of the more popular MyISAM engine. We’ll maintain regular database backups, so you can be certain that you won’t ever lose any data in case you erase a database by accident or you overwrite some crucial info – you simply have to touch base with us and we will restore the database back to normal.
InnoDB in Semi-dedicated Hosting
All our Linux semi-dedicated packages include InnoDB and you will be able to make use of all the features of this MySQL database storage engine with any PHP script-powered software app that requires it. It’s among the engines that we have on our cloud website hosting platform, so the one that will be used depends on the particular app’s prerequisites. You won’t have to do anything manually to enable InnoDB, because it will be set as the default engine whenever you install an app – whether manually or using our 1-click application installer. To be on the safe side, we’ll generate daily MySQL database backups, so if anything goes wrong following an upgrade or if you erase some content accidentally, we will be able to restore your database the way it was on any of the past seven days.
InnoDB in VPS Hosting
All Linux VPS hosting packages that are ordered with the Hepsia Control Panel come with InnoDB already installed, so you will be able to use any script-based software app that needs this storage engine without activating anything manually. You can choose Hepsia on the VPS configuration page and your new Virtual Private Server will be ready within 60 minutes, so you can log in and start building your Internet sites straight away. When you set up a new database and start the app activation process, our system will pick the engine for this MySQL database automatically. In this way, you can make use of various apps simultaneously without updating anything on the Virtual Private Server. You can create a WordPress-driven blog that uses MyISAM – the default MySQL engine, and a Magento-driven online shopping portal that uses InnoDB, for example.
InnoDB in Dedicated Web Hosting
All Linux dedicated servers hosting packages ordered with our custom-developed Hepsia Control Panel come with a software package that’s pre-activated and besides everything else, you will get the InnoDB storage engine, so you will not have to activate it manually if you would like to use open-source scripts that require it. All it takes to run such a script is to set up a new database and to begin the setup – as soon as the script configuration wizard accesses the database and begins inserting data into it, InnoDB will be set as the default engine for this database as long as it is the one needed by the script. You will also be able to use scripts that require MyISAM, the other very popular MySQL engine, so you won’t have to change any settings on the dedicated server. This will permit you to activate various scripts on a single physical machine and to use the latter to its full potential.