Find out more on InnoDB and find out why it’s been selected as the default MySQL database engine.
InnoDB is a MySQL storage engine, which has been gaining in popularity in recent years, because it offers a significantly better overall performance and a faster crash recovery in comparison with the default engine that is used by the MySQL RDBMS – MyISAM. InnoDB is preferred by a lot of developers that create scalable software apps, because it works better with immense amounts of data, while it keeps the server load at a minimum. In addition, it uses row-level locking if any info should be updated, while lots of other engines lock the entire database table and hence require much more time to complete several consecutive tasks. Last, but not least, InnoDB observes a set of "all-or-nothing" rules – if the entire data modification procedure cannot be completed for any reason, the action is rolled back to avoid confusion or the loss of data. Magento and the newest Joomla™ versions are two examples of popular open-source script-powered web apps that have switched to InnoDB.
InnoDB in Shared Web Hosting
While InnoDB is either a paid upgrade or it is not available at all with many other hosting service providers, it’s an integral part of the default set of features offered with our shared web hosting
packages. In case you want to make use of a script-driven software app that needs InnoDB in particular, in order to be activated and to operate correctly, you will not have any obstacles since the MySQL database storage engine is available on our in-house developed cloud hosting platform. Irrespective of whether you create a brand-new database and activate an app manually or take advantage of our 1-click application installer tool, InnoDB will be selected automatically by our platform as the default engine if the given app needs it instead of MyISAM. Besides the remarkable database crash recovery that InnoDB offers, we also carry out daily backups of all databases, so that we can quickly recover any database in your shared account.
InnoDB in Semi-dedicated Hosting
All our Linux semi-dedicated hosting services
include InnoDB and you will be able to use all the features of this MySQL database storage engine with any script-driven app that needs it. InnoDB is among the engines that are available on our cloud hosting platform, so the one that will be selected depends on the requirements of the app in question. You will not 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 single-click application installer. To be on the safe side, we’ll store daily MySQL database backups, so if something goes wrong after some update or if you remove some data accidentally, we’ll be able to restore the database the way it was on any of the past seven days.
InnoDB in VPS Web Hosting
All Linux VPS web hosting services
that are ordered with the Hepsia Control Panel come with InnoDB already activated, so you’ll be able to run any PHP-driven web application that needs the database engine without the need to set up anything manually. You can select Hepsia on the VPS order form and your new VPS server will be up and running within one hour, so you can sign in and start setting up your sites right away. When you set up a new database and begin the app installation process, our system will choose the engine for that MySQL database automatically. Thus, you can use different apps at the same time without having to update anything on the Virtual Private Server. You can create a WordPress-based online blog that makes use of the default MySQL engine – MyISAM, and a Magento web store that uses InnoDB, for example.
InnoDB in Dedicated Servers Hosting
If you purchase a new dedicated server
, you will be able to pick any of the 3 Control Panels offered by our company – DirectAdmin, cPanel and Hepsia. Any dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you will not need to activate this MySQL database storage engine manually in order to be able to manage script-driven apps that need it. InnoDB is used for scalable apps and since a dedicated server will provide you with all the system resources that you require in order to manage large-size sites, it’s very possible that you’ll use InnoDB. You will be able to use other engines as well, so in case a certain app requires MyISAM rather than InnoDB, you will not have any problem while running it. The engine that will be used will be recognized automatically the moment the app installation process starts, so you won’t need to modify any settings manually at any time.