InnoDB is a MySQL database storage engine, which has been gaining in popularity lately, because it provides a better overall performance and an improved crash recovery in comparison to the default engine that is used by MySQL – MyISAM. InnoDB is endorsed by lots of devs that create scalable software apps, due to the fact that it works much better with large volumes of data, while it keeps the server load at a minimum. In addition, it uses row-level locking if any information should be updated, while many other engines lock the entire database table and therefore require much more time to execute multiple sequential tasks. Last, but not least, InnoDB adheres to 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 confusion or the loss of data. Magento and the newest Joomla™ releases are two examples of widely used script-powered software applications that have moved to InnoDB.
InnoDB in Shared Website Hosting
Any script-powered web app that requires InnoDB will function flawlessly on our cutting-edge cloud web hosting platform and the database storage engine comes with all our shared website hosting packages. Every time you create a MySQL database manually or our app installer tool creates one automatically and an app installation is initiated, the engine that the database in question will make use of will be selected in accordance with the app’s specifications without the need to update any setting in your shared account. InnoDB will be picked automatically for any application that requires this specific engine and you will be able to take advantage of its full capacity. We will perform daily content backups, so in case you accidentally remove a MySQL database that you need or you overwrite certain parts of it, we’ll be able to restore everything the way it was only a few hours ago.
InnoDB in Semi-dedicated Hosting
You can activate a script-driven web app that requires InnoDB with all of our semi-dedicated server plans, since all the accounts are set up on our innovative cloud hosting platform where the storage engine is installed. A new database can be created in two ways – manually from the Database Manager section of the Hepsia web hosting Control Panel, or automatically – in case you take advantage of our 1-click app installer tool. In either case, the required engine will be chosen automatically as soon as the activation of the application begins, so you won’t need to change anything manually, irrespective of whether the app requires InnoDB or the more widely used MyISAM. On top of that, we’ll always be able to retrieve any of your MySQL databases if you unintentionally erase one, as we perform a few backups every day, each of which is stored for 1 week.
InnoDB in VPS Web Hosting
If our in-house built Hepsia hosting Control Panel is picked during the registration process for your new Linux VPS web hosting packages , InnoDB will be installed on the server along with other needed pieces of software, so you won’t need to do anything if you choose to manage PHP script-powered software applications that require this MySQL database storage engine. The default MySQL engine – MyISAM, will be activated as well. You can create a brand new MySQL database and start the app installation manually or using our 1-click installer. The system will detect the engine that the particular application requires and will assign it to the specific MySQL database, so the installation process will proceed flawlessly and the app can insert its data into that database. Thus, you can manage apps with different requirements with regard to the MySQL engine without the need to make any changes on your server.
InnoDB in Dedicated Servers Hosting
If you order a new dedicated server, you’ll be able to select one of the 3 Control Panels that we offer – DirectAdmin, Hepsia and cPanel. Any dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you will not have to enable this MySQL database storage engine manually so as to be able to manage PHP script-powered web apps that require it. InnoDB is used for scalable applications and since a dedicated server will supply you with all the server resources that you need to manage large-size sites, it is pretty possible that you’ll resort to InnoDB. You will be able to make use of other engines too, so if a given application needs MyISAM rather than InnoDB, you will not have to deal with any predicament while managing it. The engine that will be used will be detected automatically the moment the app installation begins, so you won’t have to tweak any settings manually at any point.