What?s InnoDB? Why has it been used as the default MySQL storage engine?
InnoDB is a very popular database engine for the MySQL DBMS. It’s an alternative to the default engine – MyISAM, and it has got a number of pluses which make it the preferred engine for lots of PHP script-driven web apps, among them Joomla™ and Magento, which have switched over to InnoDB for good. For instance, adding enormous data volumes will be much faster with InnoDB, because it locks only one row to execute a specific task, not the entire table, which makes the engine excellent for scalable applications. It also supports foreign keys and database transactions – these refer to the way in which the information is handled. Put simply, importing new or editing existing data will either be thoroughly completed, or will be aborted and the operation will be rolled back if some issue occurs during the process, therefore the content that remains in the database won’t be damaged.
InnoDB in Shared Web Hosting
While InnoDB is either not offered or it is a paid upgrade with many other hosting companies, it’s an essential part of the standard set of services that we’re offering with our shared web hosting
packages. If you would like to use an open-source script-powered application that requires InnoDB specifically, in order to be installed and to operate correctly, you will not face any difficulties as the MySQL database storage engine is available on our in-house built cloud website hosting platform. Regardless of whether you create a brand new database and install an app manually or use our one-click app installer software tool, InnoDB will be selected automatically by our system as the default engine if the specific application requires it instead of MyISAM. In addition to the incredible database failure recovery offered by InnoDB, we also perform regular backups of all databases, so that we can swiftly restore any MySQL database in your shared website hosting account.
InnoDB in Semi-dedicated Hosting
All our Linux semi-dedicated hosting
support InnoDB and you’ll be able to make the most of all the features of this database engine with any PHP-driven application that needs it. InnoDB is one of the engines that we have on our cloud platform, so the one that will be selected depends on the prerequisites of the specific application. You will not have to do anything manually to activate InnoDB, since it will be set as the default engine when you install an application – whether manually or using our 1-click app installer. To avoid any risk, we’ll perform daily MySQL database backups, so if anything goes wrong after an update or if you remove some data accidentally, we will be able to restore the database the way it was on any of the previous seven days.
InnoDB in VPS Web Hosting
If you choose a virtual private server
with our Hepsia hosting Control Panel, the InnoDB database storage engine will be part of the standard software bundle that will be pre-installed on your server before we give it to you. You won’t need to activate anything manually and you’ll be able to enable and use any open-source script-powered software app that needs InnoDB as soon as your VPS is up and running, which takes no more than one hour after the order submission procedure itself. Several engines are offered, so anytime you create a MySQL database via the Hepsia hosting Control Panel, a specific engine will be activated once the app activation begins and our system will detect the engine that is required by the app in question. If you need MyISAM, for instance, you will not have to do anything different from installing the chosen application, whether manually or using our app installer tool.
InnoDB in Dedicated Servers Hosting
InnoDB is available as standard with all Linux dedicated servers hosting
that are ordered with the Hepsia hosting Control Panel. It’s included in the standard software bundle that will be installed on all Hepsia-managed dedicated servers, so as soon as your physical machine is assembled, you’ll be able to log in and to activate a various PHP script-driven software app that requires this MySQL storage engine. When you set up a new database via the Control Panel, there won’t be any activated engine till you begin installing an app. As soon as the app setup wizard starts entering information into the database, the engine will be picked automatically on the basis of the requirements of the given app, so you can run both MyISAM and InnoDB without having to select either of them explicitly at any moment. In this way, you can make use of an extensive collection of apps for your sites.