InnoDB is a database engine for MySQL databases, which is used by well known open-source script-driven applications like Magento and Joomla v3. It’s excellent for scalable applications, because it works amazingly well when managing enormous data volumes. Rather than locking the entire table to add new information to a database like many other engines do, InnoDB locks only one row, so it can carry out a lot more tasks for the same length of time. Additionally, InnoDB offers an improved database crash recovery and supports database transactions and foreign keys – a set of rules that prescribe how data inserts and modifications should be handled. If a particular task hasn’t been thoroughly completed for whatever reason, the action will be rolled back. Thus, the content in the database will be kept undamaged and won’t be partially mixed with newly added content.
InnoDB in Cloud Hosting
InnoDB is available with all our Linux cloud hosting packages by default, not as a paid upgrade or upon request, so you can install and manage any PHP script-based software app which needs the InnoDB database storage engine without having to deal with any difficulty once you order your shared web hosting account. InnoDB will be pre-selected as the default engine for a particular database during the app activation, no matter if you use our one-click installer or create the MySQL database and activate the application manually, as long as the application requires InnoDB instead of the more popular MyISAM engine. We will perform daily backups of all your MySQL databases, so you can rest assured that you’ll never lose any content in case you erase a database by mistake or you overwrite some vital information – you simply need to get in touch with us and we’ll restore everything the way it was.
InnoDB in Semi-dedicated Hosting
All our semi-dedicated packages include InnoDB and you will be able to use all the options offered by this MySQL database engine with any PHP script-driven web application that needs it. InnoDB is one of the engines that we have on our cloud web hosting platform, so the one that will be picked depends on the prerequisites of the respective app. You will not need to do anything manually to activate InnoDB, as it will be set as the default engine whenever you install an application – whether manually or using our 1-click application installer tool. To avoid any risk, we will create regular backups of all your MySQL databases, so if anything goes wrong after some update or if you remove some content unintentionally, we’ll be able to restore your database the way it was on any of the past seven days.
InnoDB in VPS
In case our in-house built Hepsia Control Panel is selected during the registration process for a new Linux VPS packages , InnoDB will be installed on the server together with other required pieces of software, so you won’t have to do anything if you choose to use PHP-powered web applications that require this MySQL database engine. MyISAM, the default MySQL engine, will be activated too. You can set up a brand new MySQL database and begin the app installation procedure manually or using our single-click installer. The system will recognize the engine that the app in question needs and will set it for the specific MySQL database, so the installation will proceed impeccably and the application can insert its data into that database. Therefore, you can activate apps with various requirements with regard to the MySQL engine without making any modifications on your VPS server.
InnoDB in Dedicated Hosting
InnoDB is included as standard with all dedicated hosting that are ordered with the Hepsia Control Panel. It is part of the standard software bundle that we install on all Hepsia-equipped dedicated servers, so once your machine is set up, you’ll be able to log in and to install a various PHP-driven software app that requires this database engine. If you create a new MySQL database through the Control Panel, there won’t be any active engine until you start installing an application. As soon as the app setup wizard starts importing information into the database, the engine will be set automatically in accordance with the requirements of the respective application, so you can use both MyISAM and InnoDB without selecting either one explicitly at any point. In this way, you can make use of a huge variety of applications for your Internet sites.