InnoDB is a MySQL database engine, which has been gaining popularity in recent years, because it provides a significantly better overall performance and a faster crash recovery in comparison with the default engine that’s used by the MySQL database management system – MyISAM. InnoDB is used by many programmers that create scalable web apps, because it works better with enormous volumes of data, while it keeps the server load low. What’s more, it locks only one database row in case any info should be updated, while lots of other engines lock the entire database table and hence need more time to process multiple sequential tasks. Last, but not least, InnoDB observes a set of "all-or-nothing" rules – if the entire data modification procedure cannot be completed for whatever reason, the operation is rolled back to prevent scrambling or losing data. Magento and the newest Joomla editions are two instances of famous script-powered web apps that have moved to InnoDB.
InnoDB in Shared Hosting
While InnoDB is either a paid upgrade or it is not available at all with other hosting companies, it’s part of the default set of services offered with our shared hosting plans. In case you wish to use an open-source script-driven software application that needs InnoDB in particular, in order to be installed and to operate correctly, you won’t have any difficulties as the database storage engine is available on our in-house developed cloud platform. Regardless of whether you set up a brand new MySQL database and install an application manually or take advantage of our 1-click app installer tool, InnoDB will be selected automatically by our platform as the default engine if the application requires InnoDB instead of MyISAM. Besides the exceptional database failure recovery offered by InnoDB, we also generate regular database backups, so we can easily restore any MySQL database in your shared account.
InnoDB in Semi-dedicated Servers
You can install a script-driven app that needs InnoDB with any of our semi-dedicated server packages, due to the fact that all the accounts are created on our innovative cloud platform where the MySQL storage engine is installed. A new database can be set up in two separate ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – if you make use of our one-click application installer. In either case, the needed engine will be selected automatically as soon as the application’s activation starts, so you will not need to modify anything manually, no matter if the application needs InnoDB or the more frequently used MyISAM. On top of that, we’ll always be able to retrieve any of your databases in case you accidentally remove one, as we generate a couple of MySQL database backups every day, each of which is saved for one week.
InnoDB in VPS Servers
In case our custom Hepsia Control Panel is chosen during the signup process for a new VPS servers , InnoDB will be activated on the server along with other essential software, so you won’t need to do anything if you choose to install script-powered apps that require this MySQL database engine. MyISAM – the default MySQL engine, will be activated as well. You can create a brand-new database and start the app installation process manually or through our single-click installation tool. The system will automatically recognize which engine the app in question requires and will set it for the specific database, so the installation will proceed impeccably and the app can import its data into that database. Thus, you can activate applications with different prerequisites about the MySQL engine without making any modifications on your server.
InnoDB in Dedicated Servers
If you purchase a new dedicated server, you’ll be able to select any of the 3 Control Panels that we’re offering – DirectAdmin, cPanel and Hepsia. Any dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you will not need to add this MySQL database engine manually in order to be able to run PHP script-powered web apps that need it. InnoDB is used for scalable apps and since a dedicated server will supply you with all the system resources that you need in order to manage large-scale websites, it’s pretty possible that you will resort to InnoDB. You’ll be able to make use of other engines too, so if a particular application needs MyISAM instead of InnoDB, you will not have any problem while managing it. The engine that will be used will be automatically recognized the moment the app installation procedure begins, so you won’t need to tweak any settings manually at any point.