Find out more on InnoDB and find out why it’s already been selected as the default MySQL database engine.
InnoDB is a MySQL storage engine, which has been gaining popularity lately, because it provides a much better overall performance and an improved database failure recovery compared with the default engine that’s used by MySQL – MyISAM. InnoDB is used by numerous web developers that write highly scalable software apps, as it works much more efficiently with enormous volumes of data, while it keeps the server load low. Additionally, it locks only a single database row in case any information should be updated, whereas many other engines lock the entire table and therefore require much more time to execute multiple sequential tasks. Last, but not least, InnoDB adheres to a set of "all-or-nothing" rules – in case the entire data modification process cannot be completed successfully for some reason, the action is rolled back to prevent scrambling or data loss. Magento and the latest editions of Joomla™ are two examples of famous PHP script-based web applications which have shifted over to InnoDB.
InnoDB in Shared Hosting
Every PHP-powered software app that needs InnoDB will function impeccably on our innovative cloud web hosting platform and the MySQL storage engine is available with all our shared hosting
packages. Whenever you create a database manually or our app installer creates one automatically and an app installation is initiated, the engine that the database will make use of will be selected on the basis of the app’s specifications without having to update any setting in your shared web hosting 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 potential. We’ll create daily content backups, so if you accidentally erase a database that is important to you or you overwrite some part of it, we will be able to restore everything the way it was just several hours earlier.
InnoDB in Semi-dedicated Servers
All our semi-dedicated plans
come with InnoDB and you can make the most of all the features of this MySQL storage engine with any script-powered web app that requires it. It’s one of the engines that are available on our cloud platform, so the one that will be picked depends on the requirements of the application in question. You will not have to do anything manually in order to enable InnoDB, because it will be set as the default engine when you install an app – whether manually or using our single-click application installer. To be on the safe side, we’ll create daily backups of all your MySQL databases, so if anything goes wrong after an upgrade or if you erase some data accidentally, we will be able to restore your database the way it was on any of the previous 7 days.
InnoDB in VPS Servers
In case our custom-developed Hepsia Control Panel is selected during the signup process for a new VPS plans
, InnoDB will be installed on the server along with other essential software, so you won’t have to do anything if you choose to use script-driven software apps that require this MySQL storage engine. MyISAM – the default MySQL engine, will be installed as well. You can create a brand new MySQL database and start installing the application manually or using our one-click installer tool. The system will automatically detect which engine the app in question needs and will set it for the specific database, so the installation will continue flawlessly and the app can insert its content into that database. Therefore, you can activate apps with various requirements in regard to the MySQL engine without making any changes on your Virtual Private Server.
InnoDB in Dedicated Servers
All dedicated web hosting plans
that are ordered with our custom-developed Hepsia hosting Control Panel come with a software bundle that is pre-installed and among everything else, you will get the InnoDB storage engine, so you won’t need to add it manually in case you’d like to run open-source PHP scripts that require it. All it takes to run such a script is to set up a new MySQL database and to initiate the installation process – as soon as the script installation wizard obtains access to the database in question and begins inserting content into it, InnoDB will be set as the default engine for this database as long as it is the one required by the particular script. You’ll also be able to run scripts that need MyISAM, the other widely used MySQL engine, so you won’t need to configure any settings on the dedicated server. This will allow you to use different scripts on one single physical machine and to use it to its fullest capabilities.