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 a lot of advantages which make it the engine of choice for numerous script-based web applications, such as Joomla™ and Magento, which have moved to InnoDB for good. For instance, importing large volumes of data will be faster with InnoDB, as it locks only one row to perform a particular operation, not the entire database table, which makes the engine perfect for scalable applications. InnoDB also supports foreign keys and database transactions – these refer to the manner in which the info is handled. Put simply, appending new or modifying existing data will either be entirely completed, or will be aborted and the procedure will be rolled back if a given problem appears during the process, so the content that remains in the database won’t be lost.

InnoDB in Web Hosting

While InnoDB is either a paid upgrade or it is not available at all with many other hosting service providers, it is part of the default set of services offered with our web hosting packages. In case you would like to make use of an open-source script-driven software application that needs InnoDB particularly, in order to be activated and to perform correctly, you will not come across any problems because the storage engine is available on our in-house built cloud web hosting platform. No matter if you create a brand-new MySQL database and activate an app manually or use our single-click app installer software instrument, InnoDB will be selected automatically by our system as the default engine if the specific application needs InnoDB instead of MyISAM. Besides the incredible crash recovery offered by InnoDB, we also keep regular database backups, so we can swiftly restore any database in your shared website hosting account.

InnoDB in Semi-dedicated Servers

InnoDB comes with each of our semi-dedicated servers by default, so once you create a new account, you can go ahead and install any script-powered web app that requires the storage engine. A couple of engines are installed on our cloud web hosting platform, so when you set up a brand new MySQL database and start installing an application manually, or opt to use the Hepsia Control Panel-integrated app installer tool, the engine for the database will be chosen in accordance with the specific app’s requirements. This will permit you to activate and run InnoDB-specific applications without having to deal with any difficulty and without editing any settings in your semi-dedicated account. To take no chances, we will always have a 1-week-old backup of all your databases, so if you delete or change any content by accident, we can quickly restore it.

InnoDB in VPS Servers

When you obtain a VPS server from us, you’ll be able to take full advantage of our custom Hepsia hosting Control Panel to manage your web content. A Hepsia-equipped VPS will permit you to install any open-source script-powered web app that requires InnoDB, as the database storage engine is an integral part of the default software bundle that will be installed on your server during its creation. When you create a brand-new database via the Control Panel, you simply have to start installing an app – manually or using our application installer. InnoDB will be set as the default engine in case the application in question needs it, so you won’t have to do anything else in your account. In the same manner, if a given app needs MyISAM, it will be automatically set as the default engine for this specific MySQL database.

InnoDB in Dedicated Servers

All Linux dedicated servers ordered with our in-house built Hepsia Control Panel include a software package that’s pre-installed and besides everything else, you’ll get the InnoDB database storage engine, so you won’t need to add it manually if you’d like to activate open-source scripts that require it. All it takes to use such a script is to create a new MySQL database and to initiate the installation process – once the setup wizard acquires access to the database and starts entering content into it, InnoDB will be set as the default MySQL engine for this database as long as it is the one needed by the script. You will also be able to activate scripts that require MyISAM, the other popular MySQL engine, so you will not have to configure any settings on the server. This will allow you to activate a variety of scripts on one single machine and to use it to its full potential.