InnoDB is a MySQL storage engine, which has been gaining popularity in recent years, as it provides a much better overall performance and an improved database failure recovery compared to the default engine that is used by MySQL – MyISAM. InnoDB is preferred by a lot of web developers that write highly scalable web applications, because it works more effectively with enormous amounts of data, while it keeps the server processing load low. What’s more, it locks only a single database row if any info should be modified, whereas lots of other engines lock the entire table and thus need much more time to complete several successive tasks. Last, but not least, InnoDB adheres to the "all-or-nothing" rule – if the entire data modification process cannot be completed successfully for any reason, the action is rolled back to avoid confusion or losing data. Magento and the latest versions of Joomla are two examples of widely used script-powered apps that have switched over to InnoDB.

InnoDB in Cloud Website Hosting

While InnoDB is either not available or a paid upgrade with many web hosts, it’s an integral part of the default set of services offered with our cloud website hosting plans. If you want to make use of a script-based software app that requires InnoDB specifically, in order to be installed and to perform correctly, you will not face any obstacles since the InnoDB database engine is available on our custom-built cloud Internet hosting platform. Irrespective of whether you set up a brand-new database and install an application manually or take advantage of our one-click application installer instrument, InnoDB will be selected automatically by our platform as the default engine if the particular app needs it rather than MyISAM. Besides the amazing database failure recovery that InnoDB offers, we also generate daily database backups, so we can easily recover any MySQL database in your shared hosting account.

InnoDB in Semi-dedicated Servers

You can activate a PHP-driven app that needs InnoDB with any of our semi-dedicated server packages, as all the accounts are created on our leading-edge cloud platform where the database storage engine is installed. A new database can be created in two ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – if you make use of our one-click app installer. In either case, the required engine will be selected automatically as soon as the application’s activation starts, so you won’t need to configure anything manually, no matter if the application needs InnoDB or the more commonly used MyISAM. Also, we’ll always be able to recover any of your databases in case you accidentally delete one, as we generate a couple of backups every day, each of which is saved for seven days.

InnoDB in VPS Servers

In case our in-house built Hepsia Control Panel is selected during the registration process for your new VPS plans , InnoDB will be installed on the server together with other necessary software, so you won’t have to do anything if you choose to use PHP script-powered apps that need this MySQL storage engine. MyISAM, the default MySQL engine, will be activated too. You can set up a brand new MySQL database and start the app installation manually or through our single-click installer. The system will recognize which engine the particular app requires and will assign it to the specific database, so the installation will proceed flawlessly and the app can dump its data in that database. Thus, you can run apps with different requirements in regard to the MySQL engine without making any changes on your server.

InnoDB in Dedicated Servers

When you buy a new dedicated server, you will be able to pick any of the 3 hosting Control Panels that we’re offering – Hepsia, DirectAdmin and cPanel. Each server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you won’t have to add this database storage engine manually in order to be able to manage PHP script-powered applications that need it. InnoDB is used for scalable applications and since a dedicated server will offer you all the system resources that you require in order to run large-size Internet sites, it is very likely that you’ll use InnoDB. You’ll be able to use other engines as well, so in case a given app needs MyISAM instead of InnoDB, you will not run into any problem while running it. The engine that will be used will be automatically recognized once the app installation process begins, so you won’t need to alter any setting manually at any time.