InnoDB is a MySQL storage engine, which has been gaining popularity lately, as it offers a better overall performance and a faster database crash recovery in comparison with the default engine that is used by the MySQL relational database management system – MyISAM. InnoDB is used by lots of web developers that create scalable applications, due to the fact that it works much better with large volumes of data, while it keeps the server load at a minimum. Moreover, it locks only one database row in case any information should be updated, whereas many other engines lock the entire database table and thus require more time to execute multiple consecutive tasks. Last, but not least, InnoDB adheres to the "all-or-nothing" rule – in case the entire data modification cannot be completed successfully for any reason, the operation is rolled back to prevent confusion or data loss. Magento and the latest Joomla editions are two instances of widely used PHP-based web applications which have switched over to InnoDB.
InnoDB in Cloud Website Hosting
Every open-source script-driven application that requires InnoDB will function flawlessly on our advanced cloud platform and the database engine comes with all our cloud website hosting packages. Whenever you create a database manually or our app installer creates one automatically and an app installation process is started, the engine that the database in question will use will be selected based on the app’s specifications without the need to update any setting in your web hosting account. InnoDB will be selected automatically for any application that requires this specific engine and you will be able to make the most of its full capacity. We will generate daily content backups, so in case you accidentally remove a MySQL database that is important to you or you overwrite certain parts of it, we’ll be able to restore everything the way it was only several hours ago.
InnoDB in Semi-dedicated Hosting
If you create a brand new MySQL database through the Control Panel coming with all our semi-dedicated server accounts and you begin installing an open-source script-powered web app either manually or using our 1-click app installer tool, the storage engine for the MySQL database will be set automatically on the basis of the particular app’s requirements. As InnoDB is available on the cloud website hosting platform where your new semi-dedicated account will be created, it will be set as the default engine for each application that requires it without any manual action required on your end at any time. To avoid any risk of losing information if you update an application or if you erase a database accidentally, we will make a backup of all your MySQL databases every day, so if something happens, we can retrieve your data.
InnoDB in VPS Hosting
When you buy a virtual private server from our company, you will be able to use our in-house built Hepsia Control Panel to manage your web content. A Hepsia-equipped Virtual Private Server will permit you to manage any PHP script-based web app that needs InnoDB, as this particular MySQL database engine is part of the default software bundle that will be pre-installed on your server during its creation. When you create a brand-new database via the hosting Control Panel, you will just need to begin installing an app – manually or using our app installer. InnoDB will be set as the default engine in case the app in question requires it, so you will not have to do anything else in your account. In the same manner, if a given app needs MyISAM, it will be automatically set as the default engine for this particular MySQL database.
InnoDB in Dedicated Web Hosting
All Linux dedicated servers hosting packages ordered with our custom Hepsia hosting Control Panel include a software package that is pre-activated and besides everything else, you’ll get the InnoDB database storage engine, so you won’t need to add it manually in case you wish to use open-source PHP scripts that require it. All it takes to run such a script is to create a new MySQL database and to begin the installation – once the script installation wizard gets access to the database and begins inserting data into it, InnoDB will be set as the default engine for this database as long as it is the one required by the script. You will also be able to use scripts that need the other widely used MySQL engine – MyISAM, so you will not have to edit any settings on the server. This will enable you to activate various scripts on one single server and to use the latter to its maximum potential.