InnoDB is a MySQL database engine, which has been gaining in popularity lately, because it provides a much 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 many programmers that build highly scalable web applications, as it works much more efficiently with large data volumes, while it keeps the server processing load at a minimum. Also, it locks only a single row in the database if anything should be edited, whereas lots of other engines lock the entire table and hence require more time to complete several successive tasks. Last, but not least, InnoDB follows the "all-or-nothing" rule – if the entire data modification procedure cannot be completed successfully for any reason, the action is rolled back to prevent scrambling or the loss of data. Magento and the newest Joomla editions are two examples of famous open-source script-based web apps which have shifted over to InnoDB.
InnoDB in Shared Web Hosting
InnoDB is offered with all our Linux shared web hosting by default, not as a paid upgrade or upon request, so you’ll be able to install and run any PHP script-driven software application that requires the database storage engine without having to deal with any problem once you activate your shared website hosting account. InnoDB will be pre-selected as the default engine for a specific database during the app activation, irrespective of whether you use our one-click installation tool or create the MySQL database and activate the app manually, provided that the application requires InnoDB instead of the more popular MyISAM engine. We’ll keep regular MySQL database backups, so you can rest assured that you won’t ever lose any content in case you delete a database by mistake or you overwrite some important info – you simply need to get in touch with us and we’ll restore the database the way it was.
InnoDB in Semi-dedicated Hosting
InnoDB is available with all our Linux semi-dedicated hosting by default, so as soon as you buy a new account, you can go on and activate any open-source script-powered app that needs this particular MySQL storage engine. A number of engines are installed on our cloud hosting platform, so when you set up a brand new MySQL database and begin installing an app manually, or decide to use the Hepsia hosting Control Panel-integrated application installer, the engine for the database will be picked on the basis of the prerequisites of the given app. This will allow you to activate and manage InnoDB-specific apps without experiencing any complication and without the need to edit any settings in your semi-dedicated account. To be on the safe side, we will always keep a seven-day-old backup of all your databases, so if you erase or edit any content by accident, we can quickly recover it.
InnoDB in Dedicated Servers Hosting
All Linux dedicated servers hosting that are ordered with our in-house built Hepsia hosting Control Panel come with a software package that’s pre-activated and besides everything else, you’ll get the InnoDB database storage engine, so you will not need to activate it manually in case you’d like to use open-source PHP scripts that require it. All it takes to run such a script is to set up a new database and to initiate the installation – once the script installation wizard gets access to the database in question 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 script. You will also be able to use scripts that require the other very popular MySQL engine – MyISAM, so you will not need to update any settings on the dedicated server. This will enable you to install a variety of scripts on one single physical machine and to use the latter to its fullest capabilities.