InnoDB is a very popular storage engine for the MySQL DBMS. It’s an alternative to the default MyISAM engine and it has numerous strong sides which have made it the preferred engine for a lot of open-source script-driven applications, including Joomla and Magento, which have switched over to InnoDB for good. For example, importing immense volumes of data will be faster with InnoDB, because it locks only one row to carry out a task, not the entire database table, which makes the engine perfect for scalable apps. It also supports foreign keys and database transactions – these refer to the way in which the data is treated. Simply put, importing new or updating existent data will either be entirely completed, or will be aborted and the operation will be rolled back if a given issue shows up in the meantime, so the content that remains in the database will not be damaged.
InnoDB in Cloud Web Hosting
InnoDB is offered with all our Linux cloud web hosting services by default, not upon request or as a paid upgrade, so you will be able to install and run any PHP-driven software application which requires the InnoDB database storage engine without the need to deal with any difficulty once you open your shared website hosting account. InnoDB will be selected automatically as the default engine for a specific database during the app installation process, regardless of whether you use our one-click installation tool or create the MySQL database and install the application manually, provided that the application requires InnoDB instead of the more famous MyISAM engine. We’ll make regular backups of all your MySQL databases, so you can be sure that you will never lose any content in case you erase a database unintentionally or you overwrite some vital information – you’ll just have to touch base with us and we’ll restore everything back to normal.
InnoDB in Semi-dedicated Hosting
InnoDB is available with all our Linux semi-dedicated hosting by default, so as soon as you get a new account, you can go on and activate any PHP script-driven web app that needs this particular database storage engine. A number of engines are installed on our cloud web hosting platform, so when you create a brand new MySQL database and begin installing an app manually, or decide to take advantage of the Hepsia hosting Control Panel-integrated app installer tool, the engine for the database will be selected in accordance with the prerequisites of the particular application. This will allow you to activate and run InnoDB-specific apps without needing to cope with any obstacle and without the need to change any settings in your semi-dedicated account. To take no chances, we’ll always keep a 1-week-old backup of all your databases, so if you remove or alter any content by mistake, we can swiftly recover it.
InnoDB in VPS Web Hosting
In case our in-house built Hepsia hosting Control Panel is chosen during the signup process for a new Linux virtual private servers , InnoDB will be activated on the Virtual Private Server together with other essential software, so you will not need to do anything if you decide to install open-source script-powered web applications that require this MySQL database engine. MyISAM – the default MySQL engine, will be activated as well. You can set up a new MySQL database and start the app installation procedure manually or through our one-click installer tool. The system will detect the engine that the particular application requires and will set it for the specific database, so the installation will continue impeccably and the application can import its content into that database. Thus, you can activate apps with different requirements regarding the MySQL engine without the need to make any changes on your VPS.
InnoDB in Dedicated Servers Hosting
All Linux dedicated hosting services that are ordered with our custom-developed Hepsia Control Panel come with a software package that’s pre-activated and among everything else, you’ll get the InnoDB database storage engine, so you won’t have to activate it manually in case you need to activate open-source scripts that require it. All it takes to activate such a script is to set up a new database and to begin the installation – as soon as the script configuration wizard acquires access to the database in question and begins importing content into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one required by the script. You’ll also be able to install scripts that require MyISAM, the other very popular MySQL engine, so you won’t have to edit any settings on the dedicated server. This will permit you to install different scripts on one single machine and to use the latter to its full capacity.