InnoDB is a database storage engine for MySQL databases, which is used by popular open-source script-based software apps such as Magento and Joomla™ 3.x. It’s excellent for scalable applications, as it works stunningly well when handling immense amounts of data. Rather than locking the entire table to insert new information in a database as many other engines do, InnoDB locks only one database row, so it can execute a lot more operations for the same length of time. What’s more, InnoDB offers a better crash recovery and supports database transactions and foreign key constraints – a set of rules that determine how data imports and updates should be treated. If a given operation has not been thoroughly completed for any reason, the action will be rolled back. Thus, the content in the database will remain intact and will not be partially mixed with newly inserted content.
InnoDB in Shared Hosting
While InnoDB is either a paid upgrade or it is not available at all with other web hosts, it is an integral part of the standard set of services that we offer with our shared hosting plans. In case you’d like to make use of an open-source script-powered web app that requires InnoDB particularly, in order to be installed and to operate correctly, you will not come across any impediments since the InnoDB storage engine is available on our custom cloud platform. No matter if you create a brand-new database and install an application manually or make use of our 1-click application installer software tool, InnoDB will be selected automatically by our platform as the default engine if the specific application needs InnoDB rather than MyISAM. Besides the amazing crash recovery that InnoDB offers, we also store daily database backups, so that we can swiftly restore any database in your shared hosting account.
InnoDB in Dedicated Hosting
If you purchase a new dedicated server, you’ll be able to pick one of the three Control Panels that we offer – Hepsia and cPanel. Each dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you will not need to add this MySQL storage engine manually so as to be able to use PHP-driven web apps that need it. InnoDB is used by scalable apps and since a dedicated server will supply you with all the resources that you need in order to run very large websites, it’s rather likely that you’ll use InnoDB. You’ll be able to use other engines too, so in case a particular app requires MyISAM rather than InnoDB, you won’t have any complication while managing it. The engine that will be used will be automatically recognized the moment the app installation process begins, so you will not have to update any settings manually at any moment.