What?s InnoDB? Why has it been picked up as the standard MySQL storage engine?
InnoDB is a very popular storage engine for the MySQL database management system. It’s an alternative to the default engine – MyISAM, and it has got plenty of upsides that make it the engine of choice for a lot of script-based apps, such as Joomla™ and Magento, which have shifted over to InnoDB permanently. For example, adding enormous amounts of data will be faster with InnoDB, since it locks only a single row to perform an operation, not the entire database table, which makes the engine perfect for scalable apps. InnoDB also supports foreign keys and database transactions – these refer to the way in which the info is tackled. In simpler words, importing new or updating existing data will either be thoroughly completed, or will be annulled and the operation will be rolled back if a certain issue shows up during the process, so the content that remains in the database won’t be damaged.
InnoDB in Web Hosting
While InnoDB is either not available or a paid upgrade with other website hosting service providers, it’s an integral part of the standard set of services that we offer with our web hosting
plans. In case you would like to use an open-source script-powered software application that needs InnoDB particularly, in order to be activated and to function properly, you will not face any impediments since the database engine is available on our custom-built cloud web hosting platform. Irrespective of whether you create a brand-new database and install an application manually or take advantage of our one-click application installer software tool, InnoDB will be selected automatically by our system as the default engine if the given application needs InnoDB rather than MyISAM. In addition to the incredible crash recovery offered by InnoDB, we also perform regular backups of all databases, so we can easily recover any database in your shared web hosting account.
InnoDB in Semi-dedicated Servers
InnoDB is available with all our semi-dedicated plans
by default, so the moment you purchase a new semi-dedicated account, you can move on and activate any PHP script-driven software app that requires this particular storage engine. A couple of engines are pre-installed on our cloud website hosting platform, so when you create a new database and begin installing an application manually, or decide to take advantage of the Hepsia Control Panel-integrated application installer, the engine for the database will be set on the basis of the requirements of the particular application. This will allow you to activate and manage InnoDB-specific applications without any obstacle and without the need to change any settings in your account. To take no chances, we’ll always have a one-week-old backup of all your databases, so if you delete or change any content unintentionally, we can easily retrieve it.
InnoDB in VPS Servers
All VPS hosting plans
that are ordered with the Hepsia Control Panel come with InnoDB already activated, so you’ll be able to use any open-source script-based application that requires this particular MySQL database engine without needing to set up anything manually. You can choose Hepsia on the VPS configuration page and your brand-new server will be ready within 60 minutes, so you can log in and start setting up your websites straight away. Once you set up a new MySQL database and start the app activation process, our system will select the engine for this MySQL database automatically. Thus, you can activate various applications simultaneously without configuring anything on the VPS server. You can set up a WordPress-powered personal blog that makes use of MyISAM – the default MySQL engine, and a Magento e-commerce site that makes use of the InnoDB engine, for instance.
InnoDB in Dedicated Servers
Our Hepsia Control Panel is among the features that you can choose on the order page when you buy a dedicated server
from us. As this is the most powerful kind of hosting, it’s quite likely that you’ll manage popular Internet sites that will attract lots of individuals, and since InnoDB is one of the very best options for such Internet sites, we’ll activate it together with all the other software applications that come with a Hepsia-equipped server. When you set up a new database in your account, there won’t be any activated database engine until you start installing a PHP script, whether manually via your web browser or using the automatic scripts installer tool that is available in the Control Panel. The required engine will be recognized and will be set for that database, so you can make use of scripts that need InnoDB, as well as ones that require MyISAM, the default MySQL engine, without having to cope with any problem.