InnoDB is a MySQL database engine, which has been gaining popularity in recent years, as it provides a better overall performance and an improved crash recovery compared to the default engine that is used by MySQL – MyISAM. InnoDB is preferred by a lot of web developers that build scalable apps, because it works more efficiently with immense amounts of data, while it keeps the server processing load low. Furthermore, it locks only a single row in the database if any info should be modified, while many other engines lock the entire table and thus require much more time to complete multiple consecutive tasks. Last, but not least, InnoDB adheres to a set of "all-or-nothing" rules – in case the entire data modification procedure cannot be completed successfully for some reason, the operation is rolled back to avoid scrambling or data loss. Magento and the newest Joomla™ versions are two examples of famous open-source script-driven web applications that have switched over to InnoDB.

InnoDB in Shared Hosting

While InnoDB is either not available or a paid upgrade with many web hosting companies, it’s part of the default set of services that we are offering with our shared hosting packages. In case you would like to make use of an open-source script-powered app that requires InnoDB specifically, in order to be activated and to function correctly, you will not come across any obstacles because the InnoDB database engine is available on our custom-built cloud hosting platform. No matter if you set up a brand new database and install an app manually or use our 1-click app installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the given app requires InnoDB rather than MyISAM. In addition to the excellent database crash recovery offered by InnoDB, we also maintain regular database backups, so we can quickly restore any MySQL database in your shared hosting account.

InnoDB in Semi-dedicated Hosting

All our semi-dedicated hosting services include InnoDB and you will be able to make the most of all the features offered by this database storage engine with any PHP-powered app that needs it. It’s one of the engines that are available on our cloud web hosting platform, so the one that will be selected depends on the prerequisites of the application in question. You will not have to do anything manually in order to activate InnoDB, because it will be set as the default engine when you install an app – whether manually or using our single-click app installer tool. To avoid any risk, we will carry out daily backups of all your MySQL databases, so if anything goes wrong after some update or if you erase some content unintentionally, we’ll be able to restore the database the way it was on any of the previous seven days.

InnoDB in VPS

In case our custom-developed Hepsia Control Panel is chosen during the registration process for a new Linux virtual private servers , InnoDB will be activated on the server along with other needed pieces of software, so you will not have to do anything if you decide to install script-driven applications that need this MySQL database engine. The default MySQL engine, MyISAM, will be activated as well. You can create a brand-new database and start the app installation process manually or through our single-click installer. The system will detect which engine the app in question needs and will set it for the specific database, so the installation process will continue flawlessly and the app can import its content into that database. Thus, you can install applications with different requirements about the MySQL engine without the need to make any modifications on your Virtual Private Server.

InnoDB in Dedicated Hosting

If you order a new dedicated server, you will be able to choose any of the 3 hosting Control Panels that we’re offering – cPanel, DirectAdmin and Hepsia. Each dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you will not need to install this database storage engine manually so as to be able to use script-driven web apps that require it. InnoDB is used for scalable applications and since a dedicated server will provide you with all the system resources that you need in order to manage large-scale websites, it’s very likely that you’ll resort to InnoDB. You will be able to use other engines as well, so in case a specific app requires MyISAM instead of InnoDB, you will not need to deal with any complication while managing it. The engine that will be used will be detected automatically when the app installation begins, so you won’t have to tweak any settings manually whatsoever.