InnoDB is a MySQL database storage engine, which has been gaining in popularity lately, as it offers a much better overall performance and a faster crash recovery in comparison to the default engine that is used by MySQL – MyISAM. InnoDB is used by numerous developers that write highly scalable software apps, because it works better with immense amounts of data, while it keeps the server processing load at a minimum. Moreover, it uses row-level locking in case any info should be modified, while lots of other engines lock the entire table and hence need much more time to perform multiple consecutive tasks. Last, but not least, InnoDB obeys the "all-or-nothing" rule – in case the entire data modification process cannot be completed for whatever reason, the operation is rolled back to prevent scrambling or losing data. Magento and the newest Joomla versions are two examples of famous script-powered software platforms that have switched to InnoDB.
InnoDB in Shared Website Hosting
While InnoDB is either not offered or it is a paid upgrade with many website hosting service providers, it is an essential part of the standard set of services that we are offering with our shared website hosting packages. In case you’d like to make use of a PHP-powered application that needs InnoDB specifically, in order to be activated and to operate correctly, you will not face any impediments because the MySQL database engine is available on our in-house built cloud platform. No matter if you create a new MySQL database and activate an app manually or use our one-click app installer software instrument, 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 make regular database backups, so we can quickly restore any MySQL database in your shared web hosting account.
InnoDB in Semi-dedicated Hosting
You can make use of a PHP script-based application that requires InnoDB with all of our semi-dedicated server plans, since all the accounts are set up on our cutting-edge cloud platform where the MySQL storage engine is installed. A new MySQL database can be set up in two separate ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you take advantage of our 1-click application installer. Either way, the required engine will be picked automatically once the activation of the app begins, so you won’t need to configure anything manually, regardless of whether the application requires InnoDB or the more widely used MyISAM. In addition, we’ll always be able to recover any of your MySQL databases in case you remove one by mistake, as we make several MySQL database backups every day, each of which is stored for one week.
InnoDB in Dedicated Hosting
All Linux dedicated servers hosting packages that are ordered with our custom-developed Hepsia hosting Control Panel come with a software package that is pre-installed and among everything else, you’ll get the InnoDB database storage engine, so you won’t have to activate it manually in case you need to use PHP scripts that require it. All it takes to activate such a script is to create a new database and to begin the installation process – once the setup wizard gains access to the database and starts dumping data in it, InnoDB will be set as the default MySQL engine for this database as long as it is the one needed by the script. You will also be able to activate scripts that require the other popular MySQL engine – MyISAM, so you will not need to modify any settings on the dedicated server. This will allow you to activate various scripts on a single machine and to use the latter to its fullest capabilities.