InnoDB is a MySQL database engine, which has been gaining popularity lately, as it provides a much better overall performance and an improved database failure recovery compared with the default engine that’s used by the MySQL relational database management system – MyISAM. InnoDB is preferred by plenty of devs that run scalable apps, due to the fact that it works better with huge data volumes, while it keeps the server load low. Additionally, it locks only a single database row in case any information should be updated, while many other engines lock the entire table and hence require more time to execute multiple successive tasks. Last, but not least, InnoDB obeys the "all-or-nothing" rule – in case the modification of the entire data cannot be completed for whatever reason, the operation is rolled back to prevent confusion or losing data. Magento and the newest editions of Joomla are two instances of widely used PHP-driven software platforms that have switched over to InnoDB.
InnoDB in Shared Hosting
While InnoDB is either a paid upgrade or it is not available at all with many other web hosting companies, it is included in the standard set of services that we’re offering with our shared hosting packages. If you’d like to use a PHP-based application that requires InnoDB specifically, in order to be activated and to function correctly, you will not face any impediments as the storage engine is available on our custom-developed cloud hosting platform. No matter if you create a brand new database and install an app manually or make use of our 1-click application installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the application needs InnoDB rather than MyISAM. In addition to the remarkable database crash recovery offered by InnoDB, we also carry out regular backups of all databases, so that we can swiftly recover any MySQL database in your shared web hosting account.
InnoDB in Semi-dedicated Hosting
You can use a PHP script-driven web app that needs InnoDB with any of our semi-dedicated server packages, since all the accounts are created on our cutting-edge cloud hosting platform where the MySQL storage engine is installed. A new MySQL database can be created in two separate ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – in case you use our 1-click application installer. In either case, the needed engine will be chosen automatically as soon as the app’s activation starts, so you won’t need to change anything manually, irrespective of whether the application needs InnoDB or the more regularly used MyISAM. In addition, we’ll always be able to recover any of your MySQL databases in case you accidentally delete one, as we generate a few database backups every day, each of which is preserved for seven days.
InnoDB in VPS
If our in-house built Hepsia hosting Control Panel is selected during the signup process for your new Linux virtual private servers , InnoDB will be activated on the server together with other essential pieces of software, so you won’t need to do anything if you decide to install script-powered web apps that need this MySQL database engine. MyISAM, the default MySQL engine, will be activated as well. You can create a brand-new database and begin the app installation manually or through our single-click installer tool. The system will recognize the engine that the app in question needs and will assign it to the specific database, so the installation will continue impeccably and the app can enter its content into that database. Therefore, you can install applications with different requirements with regard to the MySQL engine without the need to make any modifications on your VPS.
InnoDB in Dedicated Hosting
Our Hepsia Control Panel is among the options which you can pick on the order page when you buy a dedicated server from our company. As this is the most powerful kind of hosting, it is quite likely that you’ll run very popular sites that will draw many individuals, and since InnoDB is among the best choices for such sites, we will install it along with all the other software apps that are offered with a Hepsia-managed dedicated server. If you create a new database in your dedicated account, there won’t be any activated database storage engine until you start installing a PHP script, whether manually through your Internet browser or using the automatic scripts installer tool that is available in the Control Panel. The needed engine will be recognized and will be set for that database, so you can make use of scripts that need InnoDB, as well as ones that need the default MySQL engine – MyISAM, without experiencing any obstacle.
    • Our ID: 53825