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 to the default engine used by the MySQL relational database management system – MyISAM. InnoDB is endorsed by many devs that run highly scalable applications, because it works much more efficiently with immense volumes of data, while it keeps the server processing load at a minimum. Additionally, it uses row-level locking in case any info should be modified, while lots of other engines lock the entire database table and therefore require more time to carry out multiple consecutive tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – in case the entire data modification procedure cannot be completed successfully for any reason, the action is rolled back to avoid scrambling or losing data. Magento and the latest releases of Joomla™ are two instances of popular PHP script-powered apps that have switched over to InnoDB.
InnoDB in Shared Hosting
InnoDB is offered with all our Linux shared hosting by default, not as a paid upgrade or upon request, so you’ll be able to activate and run any script-driven application that needs the InnoDB database engine without any impediments as soon as you order your account. InnoDB will be pre-selected as the default engine for a given MySQL database during the app installation process, irrespective of whether you use our 1-click installation tool or create the database and set up the application manually, on the condition that the application requires it instead of the more famous MyISAM engine. We will create daily backups of all your MySQL databases, so you can rest assured that you’ll never lose any data in case you erase a database by mistake or you overwrite some key information – you simply need to touch base with us and we will restore your content back to normal.
InnoDB in Semi-dedicated Hosting
All our semi-dedicated packages come with InnoDB and you can make use of all the options offered by this storage engine with any script-driven software app that needs it. InnoDB is among the engines that are available on our cloud web hosting platform, so the one that will be used depends on the requirements of the application in question. You will not need to do anything manually to activate InnoDB, since it will be set as the default engine whenever you install an application – whether manually or using our single-click app installer tool. To avoid any risk, we will keep regular MySQL database backups, so if something goes wrong following an upgrade or if you delete some content unintentionally, we will be able to restore the database the way it was on any of the previous 7 days.
InnoDB in VPS Hosting
If you get a virtual private server from us, you’ll be able to take advantage of our custom-built Hepsia hosting Control Panel to manage your web content. A Hepsia-managed Virtual Private Server will allow you to run any PHP-powered web app which requires InnoDB, as this particular storage engine is an integral part of the standard software package that will be pre-installed on your server during its setup. When you create a brand-new MySQL database using the Control Panel, you’ll simply have to start installing an app – manually or using our application installer tool. InnoDB will be set as the default engine in case the application in question requires it, so you won’t have to do anything else in your account. Similarly, if an app needs MyISAM, it will be automatically set as the default engine for this specific MySQL database.
InnoDB in Dedicated Web Hosting
All dedicated servers hosting packages that are ordered with our custom-developed Hepsia Control Panel come with a software package that’s pre-installed and besides everything else, you will get the InnoDB storage engine, so you won’t have to add it manually in case you would like to run open-source PHP scripts that require it. All it takes to run such a script is to set up a new database and to begin the setup – once the script configuration wizard gains access to the database and begins inserting content into it, InnoDB will be set as the default engine for this database on the condition that it is the one needed by the particular script. You will also be able to use scripts that require the other widely used MySQL engine, MyISAM, so you will not need to update any settings on the dedicated server. This will permit you to activate various scripts on one single physical server and to use the latter to its maximum capacity.