What?s InnoDB? Why has it been selected as the default MySQL storage engine?
InnoDB is a MySQL database storage engine, which has been gaining popularity lately, because it offers a better overall performance and a faster crash recovery in comparison to the default engine used by the MySQL DBMS – MyISAM. InnoDB is endorsed by many developers that create highly scalable software applications, as it works much more efficiently with huge volumes of data, while it keeps the server processing load low. Moreover, it uses row-level locking if any information should be updated, whereas lots of other engines lock the entire database table and thus require more time to accomplish multiple consecutive tasks. Last, but not least, InnoDB adheres to the "all-or-nothing" rule – if the entire data modification cannot be completed for some reason, the action is rolled back to avoid confusion or the loss of data. Magento and the newest Joomla™ releases are two examples of widespread PHP script-powered web apps that have switched to InnoDB.
InnoDB in Hosting
While InnoDB is either not offered or it is a paid upgrade with other hosting service providers, it is part of the default set of services that we are offering with our hosting
plans. If you wish to use a PHP-based web app that needs InnoDB in particular, in order to be activated and to work properly, you won’t face any problems as the InnoDB database storage engine is available on our in-house built cloud website hosting platform. Irrespective of whether 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 system as the default engine if the given application needs it instead of MyISAM. Besides the incredible database crash recovery that InnoDB is offering, we also perform daily database backups, so that we can swiftly recover any database in your shared website hosting account.
InnoDB in Semi-dedicated Hosting
InnoDB is offered with all our semi-dedicated hosting
by default, so the moment you purchase a new semi-dedicated account, you can move on and install any script-based app that requires the MySQL database engine. Several engines are pre-installed on our cloud web hosting platform, so when you create a new database and begin installing an app manually, or opt to take advantage of the Hepsia Control Panel-integrated application installer tool, the engine for the database will be picked on the basis of the given app’s prerequisites. This will permit you to activate and run InnoDB-specific applications without needing to deal with any obstacle and without needing to update any settings in your semi-dedicated account. To be on the safe side, we will always keep a 7-day-old backup of all your MySQL databases, so if you remove or change any content by mistake, we can quickly recover it.
InnoDB in VPS
All Linux VPS services
that are ordered with the Hepsia Control Panel come with InnoDB already activated, so you’ll be able to take advantage of any open-source script-driven software app that requires this particular database storage engine without having to set up anything manually. You can choose Hepsia on the VPS order form and your brand new Virtual Private Server will be set up within one hour, so you can log in and start setting up your websites right away. Once you create a brand new database and begin the app installation process, our system will select the engine for this MySQL database automatically. In this way, you can run various applications simultaneously without having to modify anything on the VPS server. You can create a WordPress-driven blog that makes use of the default MySQL engine – MyISAM, and a Magento e-store that makes use of the InnoDB engine, for instance.
InnoDB in Dedicated Hosting
InnoDB is available by default with all dedicated hosting
that are ordered with the Hepsia hosting Control Panel. It is an essential part of the default software bundle that will be installed on all Hepsia-managed servers, so as soon as your physical machine is ready, you will be able to log in and to install any kind of PHP-based software application that requires this particular MySQL database storage engine. If you set up a new database through the Control Panel, there won’t be any active engine until you begin installing an app. As soon as the app installation wizard starts importing data into the newly created database, the engine will be picked automatically on the basis of the requirements of the specific application, so you can run both InnoDB and MyISAM without selecting either of them explicitly at any time. In this way, you can make use of a large range of apps for your sites.