InnoDB
Discover what a database engine is, what are the merits of the InnoDB engine and why it is gaining a huge amount of popularity.
InnoDB is a MySQL database storage engine, which has been gaining popularity in recent years, as it provides a better overall performance and an improved database failure recovery in comparison to the default engine that is used by the MySQL database management system – MyISAM. InnoDB is endorsed by numerous programmers that run scalable applications, since it works much more effectively with enormous amounts of data, while it keeps the server processing load at a minimum. Also, it it locks only one row in the database if any info should be edited, whereas many other engines lock the entire database table and hence require much more time to fulfill several sequential tasks. Last, but not least, InnoDB complies with the "all-or-nothing" rule – in case the entire data modification cannot be completed successfully for some reason, the operation is rolled back to avoid confusion or data loss. Magento and the newest Joomla™ releases are two instances of widespread PHP script-powered web apps which have shifted over to InnoDB.
-
InnoDB in Shared Hosting
InnoDB is available with all our
Linux shared hosting packages by default, not upon request or as a paid upgrade, so you will be able to install and manage any PHP-based application that requires the MySQL database engine without encountering any problem once you open your shared web hosting account. InnoDB will be selected automatically as the default engine for a given database during the app installation process, no matter if you make use of our 1-click installer or create the database and install the application manually, as long as the app requires it instead of the more famous MyISAM engine. We will perform regular database backups, so you can rest assured that you will never lose any content if you delete a database by accident or you overwrite some essential info – you’ll just need to alert us and we’ll restore your content back to normal.
-
InnoDB in Semi-dedicated Hosting
All our
Linux semi-dedicated packages come with InnoDB and you’ll be able to take full advantage of all the features offered by this storage engine with any PHP-driven web application that requires it. It’s one of the engines that we have on our cloud platform, so the one that will be selected depends on the given app’s prerequisites. You will not have to do anything manually in order to activate InnoDB, as it will be set as the default engine when you install an application – whether manually or using our one-click app installer. To avoid any risk, we’ll carry out daily database backups, so if anything goes wrong following some update or if you erase some data by mistake, we’ll be able to get your database back to the way it was on any of the past 7 days.
-
InnoDB in VPS
If you get a
virtual private server from us, you’ll be able to make use of our in-house built Hepsia hosting Control Panel to manage your content. A Hepsia-managed VPS will permit you to use any open-source script-based software application that requires InnoDB, as the database engine is included in the default software package that will be pre-installed on the Virtual Private Server during its configuration. When you create a brand-new MySQL database through the Control Panel, you simply need to start installing an application – manually or using our app installer. InnoDB will be set as the default engine in case the app in question needs it, so you won’t have to do anything else in your account. Equivalently, if a certain application requires MyISAM, it will be automatically set as the default engine for this particular MySQL database.
-
InnoDB in Dedicated Hosting
InnoDB is included by default with all
Linux dedicated servers hosting packages that are ordered with the Hepsia Control Panel. It is part of the software package that we install on all Hepsia-equipped servers, so as soon as your machine is assembled, you’ll be able to log in and to install any type of script-powered web application that needs this MySQL database storage engine. When you create a new MySQL database through the hosting Control Panel, there won’t be any activated engine until you begin installing an app. Once the app activation wizard begins inserting information into the newly created database, the engine will be picked automatically in accordance with the requirements of the app in question, so you can run both MyISAM and InnoDB without selecting either of them explicitly at any point. Therefore, you can use a huge selection of apps for your Internet sites.