InnoDB is a MySQL storage engine, which has been gaining popularity in recent years, because it offers a better overall performance and an improved database failure recovery in comparison to the default engine used by the MySQL RDBMS – MyISAM. InnoDB is used by many developers that build highly scalable web apps, because it works more effectively with enormous volumes of data, while it keeps the server load at a minimum. Furthermore, it it locks only one row in the database in case anything should be modified, whereas many other engines lock the entire table and hence require more time to process several sequential tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – in case the entire data modification process cannot be completed for whatever reason, the action is rolled back to avoid confusion or data loss. Magento and the newest Joomla releases are two instances of widely used open-source script-driven web apps that have shifted over to InnoDB.
InnoDB in Website Hosting
Every PHP script-driven web application that requires InnoDB will function flawlessly on our cutting-edge cloud website hosting platform and the MySQL storage engine is available with all our website hosting plans. Whenever you create a MySQL database manually or our app installer tool creates one automatically and an app installation process is initiated, the engine that the database in question will use will be selected on the basis of the app’s specifications without having to modify any setting in your hosting account. InnoDB will be chosen automatically for any application that requires this particular engine and you’ll be able to get the most out of its full potential. We will perform daily backups of your content, so in case you unintentionally delete a MySQL database that’s important to you or you overwrite specific parts of it, we’ll be able to restore everything the way it was just a couple of hours ago.
InnoDB in Semi-dedicated Servers
You can run a PHP-powered software app that requires InnoDB with all of our semi-dedicated server packages, since all the accounts are created on our avant-garde cloud web hosting platform where the MySQL database engine is installed. A new MySQL database can be set up in two ways – manually from the Database Manager section of the Hepsia web hosting Control Panel, or automatically – in case you use our single-click application installer tool. In either case, the needed engine will be chosen automatically the moment the app’s installation starts, so you will not need to configure anything manually, irrespective of whether the application needs InnoDB or the more widely used MyISAM. In addition, we’ll always be able to retrieve any of your MySQL databases if you delete one by accident, as we carry out a couple of database backups every day, each of which is preserved for 7 days.
InnoDB in Dedicated Servers
When you order a new dedicated server, you’ll be able to pick one of the 3 Control Panels that we offer – cPanel, DirectAdmin and Hepsia. Any dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-installed, so you won’t need to enable this database storage engine manually to be able to use PHP script-driven applications that need it. InnoDB is used for scalable applications and since a dedicated server will supply you with all the system resources that you require to manage large-size sites, it is rather possible that you’ll resort to InnoDB. You’ll be able to use other engines as well, so if a particular application needs MyISAM rather than InnoDB, you will not come across any complication while using it. The engine that will be used will be automatically recognized once the app installation starts, so you will not have to modify any settings manually whatsoever.