Learn more about InnoDB and find out why it’s been chosen as the default MySQL database engine.
InnoDB is a MySQL database engine, which has been gaining in popularity lately, because it provides a much better overall performance and an improved crash recovery in comparison with the default engine that’s used by the MySQL RDBMS – MyISAM. InnoDB is endorsed by lots of devs that write highly scalable applications, since it works better with huge data volumes, while it keeps the server load at a minimum. Also, it locks only one database row if any info should be edited, whereas lots of other engines lock the entire database table and thus need much more time to handle several sequential tasks. Last, but not least, InnoDB obeys a set of "all-or-nothing" rules – if the entire data modification cannot be completed for any reason, the action is rolled back to avoid confusion or the loss of data. Magento and the newest Joomla™ versions are two examples of popular open-source script-driven software applications that have switched over to InnoDB.
InnoDB in Cloud Hosting
Every PHP-powered software app that needs InnoDB will run impeccably on our avant-garde cloud website hosting platform and the MySQL database storage engine is available with all our cloud hosting
plans. Whenever you create a database manually or our app installer creates one automatically and an app installation is initiated, the engine that the database will use will be selected on the basis of the app’s specifications without the need to modify any setting in your shared hosting account. InnoDB will be chosen automatically for any app that requires this particular engine and you will be able to make the most of its full capacity. We will generate regular backups of your content, so in case you accidentally delete a MySQL database that you need or you overwrite specific parts of it, we will be able to restore your database the way it was only a few hours earlier.
InnoDB in Semi-dedicated Hosting
If you set up a brand-new MySQL database through the hosting Control Panel coming with all our semi-dedicated server
accounts and you start installing a PHP script-based web application either manually or using our 1-click application installer, the storage engine for the MySQL database will be picked automatically depending on the prerequisites of the app in question. Since InnoDB is present on the cloud hosting platform where your new semi-dedicated account will be set up, it will be set as the default engine for each application that requires it without the need for any manual intervention on your end at any time. To prevent any chance of losing information if you update an app or if you remove a database unintentionally, we’ll carry out a backup of all your databases each and every day, so if something goes wrong, we can retrieve your data.
InnoDB in VPS
If you order a virtual private server
with our Hepsia hosting Control Panel, the InnoDB storage engine will be included in the software package that will be pre-installed on your Virtual Private Server before we hand it over to you. You will not have to set up anything manually and you will be able to enable and run any script-powered software application that needs InnoDB when your VPS is ready, which takes no more than 60 minutes after the order procedure itself. Several engines are available, so whenever you set up a MySQL database using the Hepsia Control Panel, a specific engine will be activated when the app installation process begins and our system will recognize the engine that is required by the application in question. If you have to use MyISAM, for instance, you will not need to do anything different from installing the app of your preference, whether manually or using our app installer.
InnoDB in Dedicated Hosting
InnoDB is available by default with all dedicated hosting services
ordered with the Hepsia Control Panel. It’s an essential part of the standard software bundle that will be pre-installed on all Hepsia-managed servers, so once your machine is up and running, you will be able to log in and to activate any open-source script-driven software application that requires this particular MySQL storage engine. If you set up a new database through the hosting Control Panel, there won’t be any activated engine until you start installing an app. Once the app installation wizard starts importing data into the newly created database, the engine will be set automatically on the basis of the prerequisites of the particular application, so you can run both MyISAM and InnoDB without the need to select either of them explicitly at any point. In this way, you can use a broad selection of apps for your Internet sites.