Find out more on InnoDB and see why it’s recently been picked out as the default MySQL database engine.
InnoDB is a MySQL database engine, which has been gaining popularity in recent years, as it provides a significantly better overall performance and an improved database failure recovery compared with the default engine used by the MySQL database management system – MyISAM. InnoDB is preferred by many web developers that build scalable apps, due to the fact that it works much better with huge amounts of data, while it keeps the server processing load low. In addition, it it locks only one row in the database in case anything should be updated, while many other engines lock the entire database table and hence need much more time to execute several sequential tasks. Last, but not least, InnoDB observes a set of "all-or-nothing" rules – in case the entire data modification process cannot be completed successfully for whatever reason, the operation is rolled back to avoid confusion or losing data. Magento and the latest releases of Joomla™ are two examples of widely used open-source script-powered software applications which have switched to InnoDB.
InnoDB in Cloud Hosting
While InnoDB is either not available or a paid upgrade with other website hosting service providers, it’s part of the default set of features that we’re offering with our cloud hosting
plans. If you’d like to use a PHP script-driven web application that needs InnoDB particularly, in order to be activated and to work correctly, you won’t face any obstacles as the InnoDB storage engine is available on our custom cloud web hosting platform. No matter if you set up a brand-new database and install an application manually or use our 1-click app installer instrument, InnoDB will be selected automatically by our platform as the default engine if the app needs InnoDB rather than MyISAM. In addition to the outstanding crash recovery that InnoDB offers, we also make regular database backups, so that we can swiftly restore any MySQL database in your shared account.
InnoDB in Semi-dedicated Servers
All our semi-dedicated servers
support InnoDB and you will be able to get the most out of all the features of this database engine with any script-driven application that needs it. InnoDB is one of the engines that are available on our cloud web hosting platform, so the one that will be picked depends on the given app’s prerequisites. You won’t need to do anything manually to enable InnoDB, as it will be set as the default engine whenever you install an app – whether manually or using our 1-click application installer tool. To avoid any risk, we will perform regular MySQL database backups, so if something goes wrong following an update or if you delete some content by accident, we’ll be able to restore your database the way it was on any of the previous 7 days.
InnoDB in VPS Servers
If our in-house built Hepsia hosting Control Panel is selected during the signup process for your new VPS servers
, InnoDB will be installed on the VPS server along with other needed pieces of software, so you will not have to do anything if you decide to run PHP-driven software applications that need this MySQL database engine. The default MySQL engine, MyISAM, will be activated as well. You can set up a new MySQL database and begin installing the application manually or through our 1-click installer tool. The system will recognize the engine that the particular application requires and will assign it to the specific MySQL database, so the installation process will continue impeccably and the application can dump its content in that database. Therefore, you can manage apps with various prerequisites in regard to the MySQL engine without having to make any modifications on your server.
InnoDB in Dedicated Servers
If you buy a new dedicated server
, you will be able to choose one of the 3 hosting Control Panels that we are offering – DirectAdmin, cPanel and Hepsia. Each dedicated server ordered with Hepsia comes with InnoDB pre-installed, so you will not have to activate this MySQL storage engine manually in order to be able to use PHP-powered web apps that need it. InnoDB is used by scalable applications and since a dedicated server will supply you with all the resources that you require in order to manage large-size sites, it’s pretty possible that you’ll use InnoDB. You will be able to use other engines too, so if a particular application needs MyISAM instead of InnoDB, you won’t need to deal with any predicament while managing it. The engine that will be used will be recognized automatically as soon as the app installation commences, so you will not need to edit any setting manually at any time.