InnoDB is a MySQL database storage engine, which has been gaining in popularity in recent years, because it provides a significantly better overall performance and an improved database crash recovery in comparison with the default engine that’s used by MySQL – MyISAM. InnoDB is endorsed by numerous devs that write highly scalable applications, because it works much more efficiently with large volumes of data, while it keeps the server processing load low. Furthermore, it uses row-level locking in case any info should be modified, while lots of other engines lock the entire database table and thus require much more time to perform multiple consecutive tasks. Last, but not least, InnoDB abides by the "all-or-nothing" rule – in case the entire data modification process cannot be completed for some reason, the action is rolled back to prevent scrambling or losing data. Magento and the newest editions of Joomla are two instances of popular PHP-driven software apps which have moved to InnoDB.
InnoDB in Cloud Hosting
InnoDB is offered with all our Linux cloud hosting by default, not upon request or as a paid upgrade, so you’ll be able to install and run any open-source script-based software application that needs the InnoDB database engine without having any difficulty once you activate your shared hosting account. InnoDB will be pre-selected as the default engine for a certain MySQL database during the app installation, regardless of whether you use our 1-click installer or create the database and activate the application manually, provided that the application requires InnoDB instead of the more famous MyISAM engine. We’ll store daily database backups, so you can rest assured that you won’t ever lose any data in case you delete a database by accident or you overwrite some key info – you will just need to touch base with us and we’ll restore everything back to normal.
InnoDB in Semi-dedicated Hosting
InnoDB is offered with each of our Linux semi-dedicated hosting by default, so once you create a new semi-dedicated account, you can move on and install any PHP script-powered software app that needs the MySQL database engine. A few engines are pre-installed on our cloud web hosting platform, so when you set up a new database and start installing an application manually, or decide to make use of the Hepsia hosting Control Panel-integrated app installer, the engine for the database will be selected on the basis of the concrete app’s requirements. This will permit you to activate and run InnoDB-specific apps without having to cope with any difficulty and without needing to change any settings in your semi-dedicated account. To avoid any risk, we’ll always have a one-week-old backup of all your databases, so if you remove or alter any content accidentally, we can quickly retrieve it.
InnoDB in Dedicated Hosting
All Linux dedicated hosting that are ordered with our custom-developed Hepsia Control Panel come with a software package that is pre-installed and besides everything else, you will get the InnoDB storage engine, so you will not need to add it manually if you wish to use scripts that need it. All it takes to activate such a script is to set up a new MySQL database and to start the installation process – once the installer wizard gets access to the database and starts inserting data into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one required by the particular script. You will also be able to install scripts that need MyISAM – the other widely used MySQL engine, so you won’t need to modify any settings on the server. This will permit you to activate different scripts on one single server and to use the latter to its full potential.