Read more about InnoDB and see why it’s already been selected as the default MySQL database engine.
InnoDB is a MySQL storage engine, which has been gaining popularity in recent years, as it offers a much better overall performance and an improved database crash recovery compared to the default engine that is used by MySQL – MyISAM. InnoDB is used by numerous developers that build highly scalable apps, because it works much more effectively with large volumes of data, while it keeps the server load at a minimum. What’s more, it it locks only one row in the database if anything should be edited, whereas many other engines lock the entire database table and hence require more time to carry out several sequential tasks. Last, but not least, InnoDB complies with a set of "all-or-nothing" rules – if the entire data modification process cannot be completed for any reason, the operation is rolled back to avoid confusion or data loss. Magento and the latest Joomla™ releases are two examples of widely used script-driven web apps which have switched to InnoDB.
InnoDB in Hosting
While InnoDB is either not offered or it is a paid upgrade with many other hosting providers, it’s an integral part of the standard set of features that we are offering with our hosting
plans. In case you want to use a PHP script-powered software application that requires InnoDB specifically, in order to be activated and to perform correctly, you won’t face any obstacles since the MySQL database storage engine is available on our in-house built cloud Internet hosting platform. Irrespective of whether you set up a brand new MySQL database and activate an application manually or use our single-click application installer software tool, InnoDB will be selected automatically by our system as the default engine if the app requires it rather than MyISAM. Besides the excellent database failure recovery offered by InnoDB, we also perform regular backups of all databases, so we can swiftly restore any MySQL database in your shared website hosting account.
InnoDB in Semi-dedicated Hosting
All our semi-dedicated hosting services
support InnoDB and you’ll be able to make use of all the features of this MySQL storage engine with any script-powered software application that needs it. InnoDB is one of the engines that we have on our cloud hosting platform, so the one that will be picked depends on the prerequisites of the given application. You will not have to do anything manually in order to activate InnoDB, as it will be set as the default engine when you install an app – whether manually or using our one-click application installer. To be on the safe side, we will generate daily MySQL database backups, so if something goes wrong following some update or if you erase some data unintentionally, we will be able to restore the database the way it was on any of the past seven days.
InnoDB in VPS Web Hosting
If you order a virtual private server
with our Hepsia hosting Control Panel, the InnoDB database storage engine will be an indivisible part of the standard software bundle that will be pre-installed on your VPS server before we give it to you. You won’t need to activate anything manually and you will be able to enable and run any PHP script-driven software application that needs InnoDB as soon as your VPS is ready, which takes no more than one hour after the order submission process itself. A few engines are available, so whenever you create a database via the Hepsia Control Panel, a specific engine will be selected once the app activation starts and our system will automatically detect the engine that is required by the app in question. If you have to use MyISAM, for instance, you won’t need to do anything different than installing the preferred application, whether manually or using our application installer tool.
InnoDB in Dedicated Servers Hosting
If you get a new dedicated server
, you’ll be able to choose one of the 3 Control Panels that we’re offering – cPanel, Hepsia and DirectAdmin. Any dedicated server ordered with Hepsia comes with InnoDB pre-installed, so you won’t need to install this storage engine manually to be able to use script-powered software applications that require it. InnoDB is used for scalable apps and since a dedicated server will give you all the server resources that you need to run large-size Internet sites, it’s rather possible that you’ll resort to InnoDB. You’ll be able to make use of other engines too, so in case a specific app needs MyISAM instead of InnoDB, you won’t have any impediment while managing it. The engine that will be used will be recognized automatically as soon as the app installation procedure commences, so you will not have to tweak any settings manually at any moment.