InnoDB is a MySQL storage engine, which has been gaining in popularity lately, because it offers a much better overall performance and a faster database failure recovery in comparison with the default engine that is used by the MySQL relational database management system – MyISAM. InnoDB is preferred by many web developers that write scalable web apps, as it works better with large volumes of data, while it keeps the server processing load at a minimum. Moreover, it it locks only one row in the database if any info should be modified, while many other engines lock the entire table and hence need more time to perform multiple sequential tasks. Last, but not least, InnoDB adheres to a set of "all-or-nothing" rules – if the entire data modification procedure cannot be completed successfully for some reason, the action is rolled back to prevent scrambling or losing data. Magento and the latest versions of Joomla™ are two instances of widely used PHP script-based web apps that have switched over to InnoDB.
InnoDB in Web Hosting
You will be able to use any PHP-powered software application that requires InnoDB if you’ve got a web hosting plan with us, as the MySQL database engine is present on our avant-garde cloud hosting platform as standard. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably if this engine is required. You can run apps that use the MyISAM engine without the need to deal with any problem as well and, once again, the engine will be pre-selected, so you will not need to change anything manually at any point. In addition, we’ll also create regular backups of all the databases that you’ve got in your shared web hosting account, so if you erase or overwrite anything, we can swiftly restore it the way it was on any of the past 7 days.
InnoDB in Semi-dedicated Servers
If you create a new MySQL database through the Control Panel provided with each of our semi-dedicated server accounts and you begin installing a PHP script-powered software app either manually or using our one-click application installer tool, the database storage engine will be selected automatically based on the prerequisites of the given app. As InnoDB is present on the cloud hosting platform where your new semi-dedicated hosting account will be created, it will be set as the default engine for each app that needs it without the need for any manual intervention on your end at any moment. To prevent any risk of losing data if you update an application or if you erase a database unintentionally, we will carry out backups of all your MySQL databases every day, so if anything goes wrong, we can recover your data.
InnoDB in Dedicated Servers
All dedicated web hosting plans that are ordered with our custom Hepsia Control Panel include a software bundle that is pre-activated and besides everything else, you’ll get the InnoDB storage engine, so you won’t need to install it manually if you’d like to run PHP scripts that need it. All it takes to use such a script is to set up a new MySQL database and to start the installation process – once the installation wizard gains access to the database and begins entering content into it, InnoDB will be set as the default engine for this database as long as it is the one required by the script. You’ll also be able to install scripts that need the other very popular MySQL engine – MyISAM, so you will not have to edit any settings on the dedicated server. This will enable you to install a variety of scripts on a single physical machine and to use the latter to its maximum potential.