InnoDB is a database engine for MySQL databases, which is used by famous PHP script-powered software applications such as Magento and Joomla v3. It’s excellent for scalable apps, as it performs amazingly well when handling immense amounts of data. Instead of locking the entire database table to import new information into a database like many other engines do, InnoDB locks only one row, so it can complete much more tasks for the same period of time. Besides, InnoDB offers a faster database failure recovery and supports database transactions and foreign keys – rules that determine how data imports and updates should be treated. In case a given operation has not been thoroughly completed for some reason, the action will be rolled back. Thus, the content in the database will be retained undamaged and will not be partially mixed with newly entered content.
InnoDB in Shared Website Hosting
InnoDB is available with all our Linux shared website hosting plans by default, not upon request or as a paid upgrade, so you can install and manage any script-driven app that requires the InnoDB database engine without encountering any impediment as soon as you activate your account. InnoDB will be pre-selected as the default engine for a certain MySQL database during the app activation process, no matter if you make use of our 1-click installer or create the database and activate the application manually, as long as the application requires it instead of the more popular MyISAM engine. We will store daily MySQL database backups, so you can be certain that you won’t ever lose any content in case you erase a database unintentionally or you overwrite some vital information – you simply need to get in touch with us and we’ll restore your database the way it was.
InnoDB in Semi-dedicated Servers
All our Linux semi-dedicated hosting plans support InnoDB and you’ll be able to use all the features offered by this MySQL database engine with any PHP-based software app that requires it. InnoDB is among the engines that are available on our cloud platform, so the one that will be selected depends on the particular app’s prerequisites. You will not have to do anything manually to enable InnoDB, as it will be set as the default engine when you install an app – whether manually or using our 1-click app installer tool. To avoid any risk, we will maintain regular backups of all your MySQL databases, so if something goes wrong following an upgrade or if you erase some data by accident, we will be able to restore your database the way it was on any of the previous seven days.
InnoDB in VPS Servers
All VPS hosting plans that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-activated, so you’ll be able to take advantage of any PHP-driven web app that needs this database storage engine without the need to install anything manually. You can select Hepsia on the VPS configuration page and your brand new Virtual Private Server will be up and running within 60 minutes, so you can log in and start creating your sites straight away. Once you create a brand new database and begin the app installation process, our system will choose the engine for that MySQL database automatically. In this way, you can activate various applications at the same time without having to update anything on the Virtual Private Server. You can have a WordPress online journal that uses the default MySQL engine – MyISAM, and a Magento Internet shop that makes use of InnoDB, for instance.
InnoDB in Dedicated Servers
All dedicated web hosting plans ordered with our custom-developed Hepsia Control Panel include a software package that’s pre-installed and among everything else, you’ll get the InnoDB storage engine, so you won’t need to activate it manually if you would like to use scripts that need it. All it takes to activate such a script is to create a new MySQL database and to initiate the setup process – once the script installation wizard obtains access to the database in question and begins entering data into it, InnoDB will be set as the default engine for this database as long as it is the one needed by the script. You’ll also be able to use scripts that require MyISAM – the other very popular MySQL engine, so you won’t have to edit any settings on the server. This will enable you to use a variety of scripts on a single physical server and to use it to its maximum capabilities.