InnoDB is a MySQL storage engine, which has been gaining popularity lately, as it provides a much better overall performance and a faster crash recovery compared with the default engine that’s used by MySQL – MyISAM. InnoDB is preferred by a lot of devs that create scalable web apps, as it works more effectively with large data volumes, while it keeps the server processing load at a minimum. Furthermore, it locks only a single row in the database if anything should be modified, while many other engines lock the entire table and thus need more time to accomplish multiple successive tasks. Last, but not least, InnoDB adheres to the "all-or-nothing" rule – in case the entire data modification process cannot be completed successfully for any reason, the operation is rolled back to avoid scrambling or losing data. Magento and the latest Joomla™ releases are two examples of widely used script-driven software applications which have shifted over to InnoDB.
InnoDB in Cloud Web Hosting
While InnoDB is either not available or a paid upgrade with other hosting providers, it is an essential part of the default set of features that we offer with our cloud web hosting plans. If you want to use a script-based software application that requires InnoDB in particular, in order to be activated and to work correctly, you won’t face any obstacles as the MySQL database storage engine is available on our custom-built cloud platform. Regardless of whether you set up a new MySQL database and activate an application manually or take advantage of our single-click app installer software tool, InnoDB will be selected automatically by our system as the default engine if the respective application needs InnoDB instead of MyISAM. In addition to the exceptional crash recovery offered by InnoDB, we also generate daily backups of all databases, so that we can swiftly recover any MySQL database in your shared website hosting account.
InnoDB in Semi-dedicated Servers
If you set up a brand-new MySQL database through the hosting Control Panel included with all our semi-dedicated server packages and you begin installing a script-based web app either manually or using our single-click application installer, the database storage engine will be set automatically on the basis of the particular app’s requirements. As InnoDB is present 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 app that requires it without any manual intervention required on your end at any time. To prevent any chance of losing info if you update an application or if you delete a database by mistake, we’ll make backups of all your MySQL databases each and every day, so if something happens, we can recover your content.
InnoDB in VPS Servers
In case our custom-built Hepsia hosting Control Panel is selected during the signup process for your new VPS web hosting plans , InnoDB will be installed on the server along with other essential pieces of software, so you won’t need to do anything if you decide to make use of PHP script-driven web apps that need this MySQL database engine. MyISAM – the default MySQL engine, will be installed as well. You can set up a brand new database and start the app installation manually or using our one-click installer. The system will automatically recognize the engine that the particular app needs and will assign it to the specific MySQL database, so the installation process will continue flawlessly and the application can import its content into that database. In this way, you can install applications with different prerequisites with regard to the MySQL engine without the need to make any changes on your server.
InnoDB in Dedicated Servers
All dedicated servers ordered with our custom-built Hepsia Control Panel include a software bundle that is pre-installed and besides everything else, you will get the InnoDB database engine, so you won’t have to activate it manually if you want to run open-source scripts that require it. All it takes to use such a script is to create a new MySQL database and to initiate the installation process – as soon as the installation wizard gets access to the database in question and begins inserting content into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one needed by the script. You will also be able to install scripts that require the other widely used MySQL engine – MyISAM, so you will not need to edit any settings on the server. This will enable you to install different scripts on a single physical machine and to use the latter to its maximum potential.