InnoDB is a popular database engine for the MySQL database management system. It is an alternative to the default engine – MyISAM, and it has got numerous strong sides which have made it the preferred engine for plenty of PHP-powered web apps, including Joomla and Magento, which have switched to InnoDB for good. For instance, importing large volumes of data will be faster with InnoDB, as it locks only one row to accomplish a given operation, not the entire database table, which makes the engine ideal for scalable applications. It also supports foreign keys and database transactions – these refer to the way in which the data is treated. To put it simply, adding new or modifying existing data will either be entirely completed, or will be annulled and the procedure will be rolled back in case some issue shows up during the process, which is why the content that remains in the database won’t be lost.

InnoDB in Cloud Web Hosting

While InnoDB is either not offered or it is a paid upgrade with other hosting companies, it’s an integral part of the standard set of services that we offer with our cloud web hosting plans. In case you would like to make use of a script-driven app that requires InnoDB in particular, in order to be activated and to function properly, you won’t experience any impediments as the InnoDB storage engine is available on our custom cloud web hosting platform. Regardless of whether you create a brand new database and install an app manually or take advantage of our 1-click app installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the specific application needs InnoDB rather than MyISAM. In addition to the exceptional database crash recovery offered by InnoDB, we also make daily database backups, so we can quickly restore any database in your shared website hosting account.

InnoDB in Semi-dedicated Hosting

InnoDB is included with all our Linux semi-dedicated packages by default, so as soon as you order a new account, you can go ahead and install any open-source script-driven app that needs the MySQL database storage engine. A few engines are pre-installed on our cloud web hosting platform, so when you set up a brand new database and start installing an application manually, or decide to make use of the Hepsia hosting Control Panel-integrated app installer tool, the engine for the database will be set based on the specific app’s prerequisites. This will allow you to activate and manage InnoDB-specific applications without having any impediment and without editing any settings in your account. To be on the safe side, we’ll always have a 7-day-old backup of all your databases, so if you delete or change any content accidentally, we can swiftly recover it.

InnoDB in VPS Hosting

In case our custom-built Hepsia hosting Control Panel is selected during the signup process for a new Linux VPS hosting packages , InnoDB will be installed on the VPS server along with other necessary pieces of software, so you will not need to do anything if you decide to run open-source script-driven web applications that require this MySQL database engine. MyISAM, the default MySQL engine, will be activated as well. You can create a new database and begin installing the app manually or through our single-click installer tool. The system will automatically recognize the engine that the application in question needs and will set it for the specific MySQL database, so the installation process will continue impeccably and the app can dump its data in that database. Therefore, you can manage apps with various prerequisites concerning the MySQL engine without the need to make any modifications on your VPS server.

InnoDB in Dedicated Web Hosting

All Linux dedicated servers hosting packages ordered with our custom Hepsia hosting Control Panel come with a software bundle that’s pre-activated and besides everything else, you will get the InnoDB database storage engine, so you won’t need to install it manually if you wish to run open-source PHP scripts that need it. All it takes to run such a script is to create a new database and to start the installation process – once the installer wizard obtains access to the database in question and begins importing data into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one needed by the particular script. You’ll also be able to activate scripts that require the other popular MySQL engine, MyISAM, so you will not have to configure any settings on the dedicated server. This will permit you to run different scripts on one single physical server and to use it to its maximum potential.