InnoDB is a MySQL database storage engine, which has been gaining popularity in recent years, as it offers a much better overall performance and a faster crash recovery compared with the default engine that is used by the MySQL relational database management system – MyISAM. InnoDB is endorsed by lots of programmers that create scalable applications, because it works better with large data volumes, while it keeps the server processing load at a minimum. Moreover, it uses row-level locking if any information should be modified, while lots of other engines lock the entire table and therefore need more time to accomplish several successive tasks. Last, but not least, InnoDB observes a set of "all-or-nothing" rules – if the entire data modification cannot be completed successfully for some reason, the action is rolled back to avoid confusion or losing data. Magento and the newest Joomla releases are two examples of popular script-based apps that have moved to InnoDB.
InnoDB in Hosting
You will be able to install any PHP-powered app that needs InnoDB in case you’ve got a hosting with our company, as the database storage engine is available on our innovative cloud hosting platform by default. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue flawlessly if this engine is required. You can activate applications that need the MyISAM engine without having to deal with any obstacle as well and, again, the engine will be selected automatically, so you will not have to modify any setting manually at any moment. On top of that, we will also generate daily backups of all the MySQL databases that you have in the shared web hosting account, so in case you delete or overwrite anything, we can easily get it back to the way it was on any of the past seven days.
InnoDB in Semi-dedicated Servers
All our semi-dedicated servers support InnoDB and you’ll be able to take full advantage of all the options offered by this database engine with any script-driven software application that needs it. InnoDB is among the engines that are available on our cloud platform, so the one that will be used depends on the prerequisites of the application in question. You will not need to do anything manually to enable InnoDB, as it will be set as the default engine whenever you install an app – whether manually or using our single-click application installer. To be on the safe side, we will carry out daily backups of all your MySQL databases, so if anything goes wrong following an upgrade or if you delete some data unintentionally, we will be able to get the database back to the way it was on any of the past seven days.
InnoDB in Dedicated Servers
All dedicated servers ordered with our custom-developed Hepsia hosting Control Panel come with a software bundle that’s pre-activated and besides everything else, you’ll get the InnoDB database storage engine, so you won’t need 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 process – as soon as the script configuration wizard receives access to the database in question and starts 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 particular script. You’ll also be able to run scripts that need the other very popular MySQL engine, MyISAM, so you won’t need to modify any settings on the server. This will allow you to install different scripts on one single physical machine and to use it to its fullest potential.