InnoDB is a very popular database storage engine for MySQL. It is an alternative to the default engine – MyISAM, and it has got a lot of advantages that have made it the preferred engine for many open-source script-based web applications, such as Joomla™ and Magento, which have moved to InnoDB for good. For instance, importing large amounts of data will be faster with InnoDB, because it locks only a single database row to complete an operation, not the entire table, which makes the engine excellent for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the manner in which the data is tackled. Simply put, adding new or editing existent data will either be fully completed, or will be canceled and the procedure will be rolled back in case any problem appears during the process, which means that the content that remains in the database won’t be damaged.
InnoDB in Shared Website Hosting
While InnoDB is either not available or a paid upgrade with other website hosting service providers, it is included in the standard set of features that we’re offering with our shared website hosting packages. If you would like to make use of a PHP script-based software app that requires InnoDB specifically, in order to be activated and to operate correctly, you won’t have to deal with any impediments because the MySQL storage engine is available on our in-house developed cloud website hosting platform. Irrespective of whether you create a brand new database and activate an app manually or take advantage of our single-click app installer software tool, InnoDB will be selected automatically by our platform as the default engine if the specific app requires InnoDB instead of MyISAM. In addition to the outstanding database crash recovery that InnoDB offers, we also perform daily backups of all databases, so we can quickly recover any database in your shared account.
InnoDB in Semi-dedicated Servers
If you create a brand new MySQL database from the hosting Control Panel offered with all our semi-dedicated server plans and you begin installing a PHP script-driven software application either manually or using our single-click application installer, the storage engine for the MySQL database will be picked automatically based on the specific app’s requirements. Since InnoDB is present on the cloud website hosting platform where your new account will be set up, it will be set as the default engine for each app that requires it without the need for any manual intervention on your end at any point. To prevent any risk of losing info if you update an application or if you remove a database by mistake, we’ll generate backups of all your MySQL databases every day, so if something happens, we can restore your data.
InnoDB in VPS Servers
In case our in-house built Hepsia hosting Control Panel is picked during the signup process for your new VPS servers , InnoDB will be installed on the Virtual Private Server along with other necessary pieces of software, so you will not have to do anything if you choose to run script-based software apps that require this MySQL database storage engine. MyISAM – the default MySQL engine, will be activated too. You can create a brand new MySQL database and start installing the app manually or through our 1-click installer. The system will recognize the engine that the app in question requires and will set it for the specific database, so the installation process will continue impeccably and the app can dump its data in that database. Thus, you can manage applications with various requirements concerning the MySQL engine without the need to make any changes on your server.
InnoDB in Dedicated Servers
InnoDB is available as standard with all Linux dedicated service that are ordered with the Hepsia hosting Control Panel. It is part of the software package that will be pre-installed on all Hepsia-equipped servers, so once your physical machine is ready, you will be able to sign in and to activate any PHP-powered software application that requires this MySQL storage engine. If you set up a new database through the hosting Control Panel, there won’t be any activated engine until you start installing an application. Once the app configuration wizard begins importing data into the database, the engine will be chosen automatically depending on the requirements of the specific application, so you can run both InnoDB and MyISAM without the need to select either one of them specifically at any time. Therefore, you can make use of an immense collection of applications for your Internet sites.