InnoDB is a database storage engine for MySQL relational databases, which is used by famous open-source script-driven web applications such as Joomla™ v3 and Magento. It is ideal for scalable applications, because it works stunningly well when processing enormous volumes of data. Instead of locking the whole database table to enter new information into a database like many other engines do, InnoDB locks only one database row, so it can complete much more tasks for the same period of time. Plus, InnoDB offers a better crash recovery and supports database transactions and foreign key constraints – a set of rules that specify how data imports and updates should be treated. In case a given task has not been thoroughly completed for whatever reason, the action will be rolled back. In this way, the content in the database will remain safe and sound and will not be partially mixed with newly entered content.
InnoDB in Hosting
Every PHP-driven software app that needs InnoDB will run impeccably on our avant-garde cloud platform and the storage engine is available with all our hosting plans. Each time you create a MySQL database manually or our app installer tool creates one automatically and an app installation is initiated, the engine that the database will make use of will be selected based on the app’s specifications without having to configure any setting in your shared web hosting account. InnoDB will be picked automatically for any application that requires this particular engine and you will be able to get the most out of its full potential. We will carry out regular content backups, so in case you unintentionally erase a MySQL database that you need or you overwrite a certain part of it, we’ll be able to restore your database the way it was only several hours earlier.
InnoDB in Semi-dedicated Servers
All our semi-dedicated servers include InnoDB and you can use all the features offered by this MySQL storage engine with any PHP script-driven software application that needs it. It is one of the engines that are available on our cloud website hosting platform, so the one that will be used depends on the given app’s prerequisites. You won’t need to do anything manually in order to enable InnoDB, because it will be set as the default engine when you install an application – whether manually or using our single-click app installer tool. To be on the safe side, we’ll make daily database backups, so if anything goes wrong following some update or if you remove some content by mistake, we’ll be able to restore the database the way it was on any of the past seven days.
InnoDB in VPS Servers
In case our in-house built Hepsia hosting Control Panel is selected during the signup process for a new VPS servers , InnoDB will be installed on the VPS server together with other required software, so you will not have to do anything if you decide to install PHP script-based apps that need this MySQL database engine. MyISAM, the default MySQL engine, will be installed as well. You can set up a brand new MySQL database and begin installing the app manually or through our one-click installation tool. The system will recognize the engine that the app in question needs and will set it for the specific database, so the installation will proceed flawlessly and the application can insert its content into that database. Therefore, you can install applications with different requirements about the MySQL engine without making any modifications on your VPS server.
InnoDB in Dedicated Servers
Our Hepsia Control Panel is one of the features which you can choose on the server order page when you buy a dedicated server from our company. Since this is the most powerful type of web hosting, it is pretty likely that you will run popular sites that will draw many people, and since InnoDB is one of the best options for such websites, we will enable it along with all the other software applications that are offered with a Hepsia-managed server. When you set up a brand new MySQL database in your dedicated server account, there won’t be any active MySQL database engine till you start installing an open-source PHP script, whether manually through your web browser or using the automatic script installer tool that is integrated into the Control Panel. The needed engine will be recognized automatically and will be set for the database in question, so you can install scripts that need InnoDB, as well as ones that need MyISAM, the default MySQL engine, without any impediments.