Read more about InnoDB and find out why it’s been picked out as the default MySQL database engine.
InnoDB is a MySQL database storage engine, which has been gaining popularity lately, because it offers a better overall performance and an improved database crash recovery in comparison with the default engine that is used by the MySQL DBMS – MyISAM. InnoDB is preferred by plenty of devs that build scalable software apps, since it works much more effectively with huge amounts of data, while it keeps the server load at a minimum. Additionally, it locks only one database row if any information should be updated, whereas many other engines lock the entire database table and hence require more time to perform several successive tasks. Last, but not least, InnoDB adheres to the "all-or-nothing" rule – if the modification of the entire data cannot be completed successfully for whatever reason, the action is rolled back to avoid confusion or losing data. Magento and the latest Joomla™ releases are two examples of popular script-based software applications which have switched over to InnoDB.
InnoDB in Web Hosting
While InnoDB is either a paid upgrade or it is not available at all with other web hosting providers, it’s part of the standard set of services that we are offering with our web hosting
plans. In case you want to make use of a PHP script-powered application that requires InnoDB specifically, in order to be activated and to operate correctly, you will not have any difficulties as the InnoDB database storage engine is available on our in-house developed cloud web hosting platform. Regardless of whether you set up a brand new MySQL database and activate an application manually or make use of our one-click app installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the application needs InnoDB rather than MyISAM. Besides the amazing crash recovery that InnoDB is offering, we also keep regular database backups, so we can swiftly restore any database in your shared account.
InnoDB in Semi-dedicated Servers
All our semi-dedicated servers
include InnoDB and you will be able to take full advantage of all the features offered by this MySQL database engine with any script-driven application that needs it. InnoDB is one of the engines that we have on our cloud website hosting platform, so the one that will be used depends on the prerequisites of the particular application. You won’t need to do anything manually in order to activate InnoDB, since it will be set as the default engine when you install an app – whether manually or using our 1-click application installer tool. To be on the safe side, we’ll carry out regular database backups, so if anything goes wrong after some update or if you delete some data unintentionally, we’ll be able to get the database back to the way it was on any of the past seven days.
InnoDB in VPS Servers
In case our in-house developed Hepsia Control Panel is selected during the signup process for your new VPS servers
, InnoDB will be installed on the server along with other required software, so you won’t have to do anything if you choose to activate open-source script-powered web applications that require this MySQL database storage engine. The default MySQL engine – MyISAM, will be installed too. You can set up a brand new MySQL database and begin the app installation process manually or through our 1-click installer tool. The system will automatically detect which engine the app in question needs and will set it for the specific MySQL database, so the installation will continue flawlessly and the app can insert its data into that database. In this way, you can manage applications with different prerequisites concerning the MySQL engine without having to make any changes on your VPS server.
InnoDB in Dedicated Servers
If you get a new dedicated server
, you’ll be able to pick one of the three hosting Control Panels that we’re offering – DirectAdmin, cPanel and Hepsia. Any dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-installed, so you will not have to activate this storage engine manually so as to be able to manage PHP-based software applications that need it. InnoDB is used for scalable applications and since a dedicated server will supply you with all the resources that you require in order to run large-scale sites, it is quite likely that you will resort to InnoDB. You’ll be able to make use of other engines as well, so if a particular app needs MyISAM instead of InnoDB, you will not come across any impediment while running it. The engine that will be used will be automatically detected once the app installation process begins, so you will not have to update any setting manually at any moment.