Read more about InnoDB and see why it’s been picked out as the default MySQL database engine.
InnoDB is a MySQL database engine, which has been gaining popularity in recent years, because it provides a better overall performance and a faster database failure recovery compared with the default engine used by MySQL – MyISAM. InnoDB is used by numerous programmers that build scalable applications, since it works much more effectively with huge volumes of data, while it keeps the server load low. Moreover, it locks only a single database row in case any info should be edited, whereas lots of other engines lock the entire database table and hence require more time to complete several sequential tasks. Last, but not least, InnoDB observes a set of "all-or-nothing" rules – in case the entire data modification procedure cannot be completed successfully for some reason, the operation is rolled back to avoid confusion or losing data. Magento and the newest versions of Joomla™ are two instances of widely used open-source script-driven software platforms that have moved to InnoDB.
InnoDB in Shared Hosting
InnoDB is available with all our shared plans
by default, not as a paid upgrade or upon request, so you will be able to activate and manage any PHP script-based software app that requires the InnoDB database engine without having any difficulty as soon as you open your shared web hosting account. InnoDB will be selected automatically as the default engine for a certain MySQL database during the app installation, regardless of whether you use our 1-click installer or create the MySQL database and activate the app manually, provided that the application requires it instead of the more popular MyISAM engine. We will make daily MySQL database backups, so you can rest assured that you won’t ever lose any content if you erase a database unintentionally or you overwrite some key info – you’ll simply have to notify us and we will restore everything back to normal.
InnoDB in Semi-dedicated Servers
If you set up a brand new MySQL database from the Control Panel offered with all our semi-dedicated server
plans and you begin installing an open-source script-powered app either manually or using our single-click application installer tool, the database storage engine will be set automatically based on the requirements of the given application. As InnoDB is present on the cloud web hosting platform where your new semi-dedicated account will be created, it will be set as the default engine for any application that requires it without any manual intervention required on your end at any time. To avoid any chance of losing data if you update an app or if you erase a database accidentally, we’ll perform a backup of all your databases each day, so if something happens, we can retrieve your content.
InnoDB in Dedicated Servers
InnoDB is available as standard with all dedicated web hosting plans
ordered with the Hepsia Control Panel. It’s an integral part of the software package that will be pre-installed on all Hepsia-equipped dedicated servers, so once your machine is ready, you will be able to sign in and to install a various PHP script-driven app that needs this storage engine. If you set up a new MySQL database via the Control Panel, there won’t be any activated engine till you begin installing an app. As soon as the app installation wizard starts entering content into the newly created database, the engine will be selected automatically in accordance with the specific app’s prerequisites, so you can use both InnoDB and MyISAM without having to select either of them explicitly at any point. Therefore, you can make use of a broad selection of applications for your Internet sites.