Find out more about InnoDB and see why it’s been selected as the default MySQL database engine.
InnoDB is a MySQL database storage engine, which has been gaining in popularity lately, as it offers a better overall performance and an improved database crash recovery compared to the default engine that’s used by MySQL – MyISAM. InnoDB is endorsed by numerous web developers that create scalable web apps, due to the fact that it works better with immense data volumes, while it keeps the server processing load at a minimum. Moreover, it locks only one database row if any information should be modified, whereas lots of other engines lock the entire database table and therefore require more time to fulfill several successive tasks. Last, but not least, InnoDB adheres to a set of "all-or-nothing" rules – if the entire data modification procedure cannot be completed successfully for some reason, the action is rolled back to prevent confusion or losing data. Magento and the latest versions of Joomla™ are two examples of famous PHP script-driven software applications that have moved 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’ll be able to activate and run any open-source script-based app that requires the MySQL storage engine without encountering any obstacle as soon as you open your shared account. InnoDB will be selected automatically as the default engine for a specific MySQL database during the app activation, irrespective of whether you use our one-click installer or create the database and activate the app manually, provided that the app requires it instead of the more famous MyISAM engine. We’ll store regular backups of all your databases, so you can rest assured that you won’t ever lose any data if you erase a database by mistake or you overwrite some essential info – you will simply need to get in touch with us and we will restore everything back to normal.
InnoDB in Semi-dedicated Hosting
If you create a brand-new MySQL database from the hosting Control Panel included with all our semi-dedicated server
plans and you begin installing a PHP script-driven software application either manually or using our one-click application installer tool, the MySQL database storage engine will be selected automatically on the basis of the prerequisites of the app in question. Since InnoDB is available on the cloud hosting platform where your new account will be created, it will be set as the default engine for any application that needs it without any manual intervention needed on your end at any point. To avoid any risk of losing data if you update an application or if you erase a database unintentionally, we will perform a backup of all your databases every day, so if anything happens, we can retrieve your content.
InnoDB in VPS Hosting
If you choose a virtual private server
with our Hepsia hosting Control Panel, the InnoDB storage engine will be an integral part of the software bundle that will be pre-installed on your server before we hand it over to you. You will not have to configure anything manually and you’ll be able to install and run any PHP script-based web application that needs InnoDB when your VPS is ready, which takes no more than sixty minutes after the order process itself. Several engines are offered, so anytime you create a MySQL database via the Hepsia hosting Control Panel, a particular engine will be activated once the app installation process begins and our system will automatically recognize the engine that is required by the application in question. In case you have to use MyISAM, for example, you won’t need to do anything different than installing the desired app, whether manually or using our app installer.
InnoDB in Dedicated Web Hosting
All Linux dedicated servers hosting packages
that are ordered with our custom Hepsia hosting Control Panel come with a software package that is pre-installed and besides everything else, you will get the InnoDB storage engine, so you won’t have to add it manually in case you need to run PHP scripts that need it. All it takes to run such a script is to create a new database and to start the installation – once the script installation wizard obtains access to the database and starts inserting content into it, InnoDB will be set as the default engine for this database provided that it is the one required by the particular script. You’ll also be able to activate scripts that require the other very popular MySQL engine – MyISAM, so you will not need to configure any settings on the server. This will enable you to use a variety of scripts on a single physical machine and to use it to its full capacity.