Learn what a database engine is, what exactly are the benefits of the InnoDB engine and why it is gaining a huge amount of worldwide popularity.
InnoDB is a MySQL storage engine, which has been gaining popularity lately, because it provides a much better overall performance and a faster crash recovery in comparison with the default engine that’s used by MySQL – MyISAM. InnoDB is preferred by plenty of devs that run highly scalable apps, because it works more efficiently with large data volumes, while it keeps the server processing load low. Moreover, it locks only a single row in the database if anything should be edited, whereas many other engines lock the entire database table and hence require much more time to execute several consecutive tasks. Last, but not least, InnoDB obeys a set of "all-or-nothing" rules – in case the entire data modification procedure cannot be completed for any reason, the action is rolled back to prevent scrambling or the loss of data. Magento and the newest Joomla™ versions are two examples of widely used PHP script-driven web applications that have switched to InnoDB.
InnoDB in Shared Website Hosting
InnoDB is offered with all our Linux shared website hosting packages
by default, not as a paid upgrade or upon request, so you’ll be able to install and run any PHP-based application which needs the storage engine without having to deal with any difficulty once you activate your shared website hosting account. InnoDB will be selected automatically as the default engine for a specific database during the app installation, regardless of whether you make use of our 1-click installer or create the MySQL database and install the app manually, as long as the app requires InnoDB instead of the more famous MyISAM engine. We’ll store regular backups of all your MySQL databases, so you can be sure that you won’t ever lose any data in case you delete a database accidentally or you overwrite some important information – you’ll simply have to notify us and we will restore your database the way it was.
InnoDB in Semi-dedicated Hosting
You can run a PHP script-powered app that requires InnoDB with any of our semi-dedicated server
plans, because all the accounts are created on our cutting-edge cloud platform where the database storage engine is installed. A new MySQL database can be created in two ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you take advantage of our one-click app installer tool. Either way, the needed engine will be chosen automatically once the installation of the app begins, so you won’t need to update anything manually, irrespective of whether the app requires InnoDB or the more widely used MyISAM. Also, we will always be able to recover any of your MySQL databases in case you accidentally delete one, as we perform a couple of backups every day, each of which is saved for 1 week.
InnoDB in Dedicated Web Hosting
InnoDB is available as standard with all Linux dedicated servers hosting packages
that are ordered with the Hepsia Control Panel. It’s an essential part of the standard software package that will be pre-installed on all Hepsia-managed dedicated servers, so once your physical machine is set up, you’ll be able to log in and to activate a various script-based web app that needs this particular MySQL database storage engine. When you create a new MySQL database via the hosting Control Panel, there won’t be any active engine till you start installing an app. Once the app activation wizard starts entering data into the newly created database, the engine will be chosen automatically on the basis of the requirements of the respective app, so you can use both MyISAM and InnoDB without the need to select either one of them explicitly at any point. In this way, you can make use of an extensive selection of apps for your sites.