InnoDB is a MySQL database storage engine, which has been gaining in popularity lately, as it provides a better overall performance and a faster database failure recovery in comparison with the default engine that is used by the MySQL database management system – MyISAM. InnoDB is preferred by numerous developers that build scalable software apps, since it works more effectively with immense amounts of data, while it keeps the server load at a minimum. What’s more, it locks only one database row if any info should be edited, whereas many other engines lock the entire table and therefore need much more time to complete several consecutive tasks. Last, but not least, InnoDB adheres to a set of "all-or-nothing" rules – if the entire data modification process cannot be completed for whatever reason, the action is rolled back to prevent confusion or losing data. Magento and the newest Joomla editions are two examples of widely used script-based web applications which have switched to InnoDB.

InnoDB in Hosting

While InnoDB is either not available or a paid upgrade with many other web hosting companies, it is an integral part of the default set of services that we are offering with our hosting plans. In case you want to use a PHP script-driven web app that needs InnoDB specifically, in order to be installed and to perform correctly, you won’t have any difficulties as the MySQL storage engine is available on our custom cloud Internet hosting platform. Irrespective of whether you set up a brand-new database and install 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 given app needs it rather than MyISAM. Besides the exceptional crash recovery offered by InnoDB, we also store daily database backups, so we can swiftly recover any MySQL database in your shared website hosting account.

InnoDB in Semi-dedicated Servers

InnoDB is included with each of our semi-dedicated plans by default, so the moment you get a new account, you can go on and activate any PHP-powered web app that requires the MySQL database engine. A few engines are installed on our cloud website hosting platform, so when you create a brand new database and start installing an application manually, or opt to take advantage of the Hepsia Control Panel-integrated application installer tool, the engine for the database will be chosen on the basis of the given app’s requirements. This will allow you to activate and run InnoDB-specific apps without encountering any difficulty and without needing to change any settings in your semi-dedicated account. To take no chances, we’ll always have a 7-day-old backup of all your MySQL databases, so if you delete or change any content by mistake, we can swiftly recover it.

InnoDB in Dedicated Servers

All dedicated web hosting plans that are ordered with our custom-developed Hepsia Control Panel include a software package that is pre-installed and among everything else, you will get the InnoDB database storage engine, so you will not have to install it manually if you’d like to activate scripts that require it. All it takes to run such a script is to create a new database and to begin the installation – once the script setup wizard gets access to the database in question and begins dumping content in it, InnoDB will be set as the default MySQL engine for this database provided that it is the one needed by the particular script. You will also be able to use scripts that need MyISAM – the other widely used MySQL engine, so you will not need to modify any settings on the dedicated server. This will permit you to run a variety of scripts on one single machine and to use it to its fullest capabilities.