InnoDB is a MySQL database engine, which has been gaining in popularity in recent years, because it offers a better overall performance and a faster database failure recovery compared with the default engine that is used by the MySQL DBMS – MyISAM. InnoDB is used by numerous devs that write scalable web applications, since it works more effectively with immense volumes of data, while it keeps the server load at a minimum. What’s more, it uses row-level locking if any information should be modified, while many other engines lock the entire database table and thus need more time to carry out several successive tasks. Last, but not least, InnoDB abides by the "all-or-nothing" rule – if the entire data modification cannot be completed successfully for some reason, the action is rolled back to avoid scrambling or data loss. Magento and the newest Joomla releases are two examples of widespread PHP-powered web apps which have moved to InnoDB.
InnoDB in Hosting
While InnoDB is either a paid upgrade or it is not available at all with other hosting providers, it’s part of the default set of features offered with our hosting plans. In case you wish to use a script-driven app that requires InnoDB specifically, in order to be activated and to function correctly, you will not experience any obstacles as the database storage engine is available on our custom-developed cloud web hosting platform. Regardless of whether you create a brand new MySQL database and install an application manually or make use of our one-click application installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the respective app requires InnoDB instead of MyISAM. In addition to the remarkable database crash recovery that InnoDB is offering, we also keep daily database backups, so we can quickly recover any MySQL database in your shared web hosting account.
InnoDB in Semi-dedicated Servers
InnoDB is included with all our Linux semi-dedicated hosting plans by default, so the moment you create a new semi-dedicated account, you can go on and install any PHP script-based web application that needs this particular MySQL storage engine. A few engines are pre-installed on our cloud website hosting platform, so when you set up a new MySQL database and begin installing an app manually, or opt to take advantage of the Hepsia Control Panel-integrated app installer, the engine for the database will be chosen on the basis of the requirements of the app in question. This will permit you to install and run InnoDB-specific apps without running into any impediment and without the need to modify any settings in your semi-dedicated account. To avoid any risk, we will always have a one-week-old backup of all your MySQL databases, so if you remove or change any content unintentionally, we can swiftly restore it.
InnoDB in VPS Servers
If our custom-developed Hepsia hosting Control Panel is selected during the registration process for a new VPS plans , InnoDB will be installed on the server together with other necessary pieces of software, so you won’t have to do anything if you choose to activate PHP script-driven web apps that need this MySQL database engine. MyISAM – the default MySQL engine, will be installed too. You can create a brand-new MySQL database and start installing the application manually or through our 1-click installation tool. The system will recognize the engine that the application in question needs and will set it for the specific database, so the installation process will proceed impeccably and the application can dump its data in that database. Therefore, you can use apps with different prerequisites with regard to the MySQL engine without the need to make any modifications on your VPS.
InnoDB in Dedicated Servers
Our Hepsia Control Panel is one of the features which you can select on the server order page when you buy a dedicated server from our company. Since this is the most powerful type of hosting, it is rather likely that you’ll run popular sites that will attract plenty of people, and since InnoDB is among the very best choices for such Internet sites, we will install it along with all the other software apps that are available with a Hepsia-equipped dedicated server. If you set up a brand new database in your dedicated account, there won’t be any active database storage engine till you start installing a script, whether manually via your web browser or using the automatic script installer that is included in the Control Panel. The required engine will be detected automatically and will be set for that database, so you can make use of scripts that require InnoDB, as well as ones that require MyISAM – the default MySQL engine, without encountering any obstacle.