See what a database engine is, what are the pros of the InnoDB engine and why it's gaining a huge amount of worldwide popularity.
InnoDB is a MySQL database engine, which has been gaining in popularity lately, as it provides a better overall performance and an improved database failure recovery compared with the default engine that is used by the MySQL DBMS – MyISAM. InnoDB is preferred by many web developers that create scalable software applications, as it works more effectively with enormous volumes of data, while it keeps the server load low. In addition, it locks only a single database row if any information should be edited, whereas many other engines lock the entire database table and hence need much more time to carry out multiple sequential tasks. Last, but not least, InnoDB obeys the "all-or-nothing" rule – in case the modification of the entire data cannot be completed successfully for some reason, the operation is rolled back to prevent confusion or the loss of data. Magento and the latest Joomla™ releases are two examples of widespread PHP script-based apps that have switched to InnoDB.
InnoDB in Shared Web Hosting
InnoDB is offered with all our Linux shared web hosting
by default, not as a paid upgrade or upon request, so you will be able to install and manage any script-based software app which needs the database storage engine without having to deal with any impediment as soon as you open your shared web hosting account. InnoDB will be selected automatically as the default engine for a given database during the app activation process, no matter if you make use of our one-click installer or create the database and install the app manually, on the condition that the app requires InnoDB instead of the more famous MyISAM engine. We’ll store regular database backups, so you can rest assured that you won’t ever lose any content in case you delete a database by accident or you overwrite some vital information – you simply need to inform us and we will restore your content the way it was.
InnoDB in Semi-dedicated Hosting
If you set up a brand new MySQL database through the Control Panel included with each of our semi-dedicated server
packages and you begin installing a PHP script-driven software app either manually or using our single-click app installer, the storage engine for the MySQL database will be selected automatically based on the specific app’s requirements. As InnoDB is available on the cloud platform where your new semi-dedicated server account will be created, it will be set as the default engine for each application that requires it without any manual intervention needed on your end at any moment. To avoid any risk of losing info if you update an application or if you remove a database by accident, we’ll make a backup of all your MySQL databases each day, so if something happens, we can recover your content.
InnoDB in Dedicated Web Hosting
Our Hepsia hosting Control Panel is one of the options that you can pick on the server configuration page when you buy a dedicated server
from us. As this is the most powerful kind of hosting, it’s pretty likely that you’ll run very popular sites that will attract a lot of people, and since InnoDB is one of the very best choices for such sites, we will install it together with all the other software apps that are offered with a Hepsia-equipped server. If you create a brand new database in your dedicated server account, there won’t be any activated MySQL database engine until you start installing an open-source PHP script, whether manually via your web browser or using the automatic script installation tool that is available in the Control Panel. The required engine will be recognized and will be assigned to the database in question, so you can make use of scripts that need InnoDB, as well as ones that need the default MySQL engine, MyISAM, without experiencing any obstacle.