InnoDB is a database storage engine for MySQL relational databases, which is used by famous PHP script-powered web apps such as Magento and Joomla 3. It is ideal for scalable applications, since it works incredibly well when managing large volumes of data. Rather than locking the entire table to add new information to a database as many other engines do, InnoDB locks only one database row, so it can handle much more operations for the same length of time. What’s more, InnoDB offers an improved database failure recovery and supports transactions and foreign key constraints – rules that prescribe how data imports and modifications should be handled. If a certain task hasn’t been fully completed for some reason, the action will be rolled back. Thus, the information in the database will remain undamaged and won’t be partially mixed with newly entered content.
InnoDB in Cloud Website Hosting
InnoDB is available with all our Linux cloud website hosting by default, not upon request or as a paid upgrade, so you will be able to install and manage any PHP script-powered web app that needs the storage engine without the need to deal with any difficulty once you activate your shared hosting account. InnoDB will be selected automatically as the default engine for a given database during the app installation process, regardless of whether you use our 1-click installation tool or create the database and install the application manually, as long as the application requires InnoDB instead of the more famous MyISAM engine. We will keep daily backups of all your databases, so you can be certain that you won’t ever lose any content in case you erase a database by mistake or you overwrite some crucial information – you will just have to alert us and we’ll restore your content back to normal.
InnoDB in Semi-dedicated Hosting
InnoDB is offered with each of our semi-dedicated hosting packages by default, so once you purchase a new semi-dedicated account, you can go on and install any PHP script-powered application that needs the MySQL database engine. Several engines are pre-installed on our cloud hosting platform, so when you set up a brand new database and start installing an app manually, or opt to use the Hepsia hosting Control Panel-integrated app installer, the engine for the database will be chosen in accordance with the requirements of the respective application. This will permit you to activate and manage InnoDB-specific apps without any complications and without updating any settings in your semi-dedicated account. To take no chances, we will always keep a one-week-old backup of all your databases, so if you erase or change any content unintentionally, we can easily restore it.
InnoDB in VPS
If our in-house built Hepsia Control Panel is selected during the signup process for your new Linux VPS packages , 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 manage open-source script-driven software applications that require this MySQL database storage engine. MyISAM, the default MySQL engine, will be activated as well. You can set up a brand new database and begin the app installation manually or through our 1-click installation tool. The system will automatically detect the engine that the particular application needs and will assign it to the specific database, so the installation process will proceed impeccably and the application can import its content into that database. Therefore, you can run applications with different prerequisites concerning the MySQL engine without making any modifications on your Virtual Private Server.
InnoDB in Dedicated Hosting
InnoDB comes as standard with all dedicated hosting ordered with the Hepsia hosting Control Panel. It is an essential part of the standard software bundle that will be installed on all Hepsia-managed servers, so as soon as your machine is up and running, you’ll be able to sign in and to install any PHP script-driven web application that requires this particular MySQL database engine. If you set up a new MySQL database through the hosting Control Panel, there won’t be any activated engine until you start installing an application. As soon as the app setup wizard starts inserting content into the database, the engine will be picked automatically on the basis of the requirements of the specific app, so you can use both InnoDB and MyISAM without having to select either one specifically at any moment. Thus, you can use a wide variety of apps for your websites.