InnoDB is a MySQL storage engine, which has been gaining in popularity in recent years, as it provides a much better overall performance and an improved crash recovery compared to the default engine that’s used by MySQL – MyISAM. InnoDB is preferred by many developers that run highly scalable web applications, due to the fact that it works much better with enormous volumes of data, while it keeps the server load low. Moreover, it locks only a single database row in case anything should be edited, whereas many other engines lock the entire table and thus need much more time to accomplish multiple consecutive tasks. Last, but not least, InnoDB abides by a set of "all-or-nothing" rules – if the entire data modification cannot be completed successfully for some reason, the action is rolled back to avoid confusion or data loss. Magento and the newest editions of Joomla are two instances of famous PHP script-powered software platforms that have switched to InnoDB.

InnoDB in Shared Hosting

Every PHP script-powered application that needs InnoDB will run flawlessly on our leading-edge cloud hosting platform and the MySQL database engine is available with all our shared hosting packages. Whenever you create a database manually or our app installer creates one automatically and an app installation process is started, the engine that the database in question will use will be selected on the basis of the app’s requirements without the need to update any setting in your hosting account. InnoDB will be selected automatically for any app that requires this particular engine and you’ll be able to take advantage of its full potential. We will make regular backups of your content, so in case you accidentally remove a MySQL database that you need or you overwrite specific parts of it, we will be able to restore everything the way it was just several hours ago.

InnoDB in Semi-dedicated Hosting

If you set up a brand new MySQL database from the Control Panel coming with all our semi-dedicated server packages and you start installing a PHP script-based web application either manually or using our one-click application installer tool, the MySQL database storage engine will be set automatically depending on the requirements of the specific app. As InnoDB is present on the cloud hosting platform where your new semi-dedicated hosting account will be created, it will be set as the default engine for any application that needs it without the need for any manual intervention on your end at any point. To avoid any risk of losing info if you update an application or if you delete a database by mistake, we’ll make a backup of all your MySQL databases every day, so if something happens, we can rescue your content.

InnoDB in VPS Web Hosting

If our custom Hepsia hosting Control Panel is picked during the signup process for a new Linux VPS web hosting packages , InnoDB will be installed on the Virtual Private Server together with other necessary pieces of software, so you will not have to do anything if you decide to make use of PHP script-based software applications that need this MySQL storage engine. The default MySQL engine, MyISAM, will be installed too. You can create a brand-new database and begin the app installation process manually or using our one-click installer tool. The system will recognize the engine that the app in question requires and will set it for the specific MySQL database, so the installation will continue impeccably and the application can insert its data into that database. Therefore, you can manage applications with various requirements about the MySQL engine without having to make any modifications on your Virtual Private Server.

InnoDB in Dedicated Servers Hosting

When you get a new dedicated server, you’ll be able to pick one of the 3 hosting Control Panels that we’re offering – Hepsia, cPanel and DirectAdmin. Each server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you will not have to enable this storage engine manually to be able to use open-source script-powered applications that need it. InnoDB is used by scalable apps and since a dedicated server will provide you with all the system resources that you require in order to run very large websites, it is pretty possible that you will resort to InnoDB. You’ll be able to use other engines as well, so if a certain app requires MyISAM rather than InnoDB, you will not experience any problem while running it. The engine that will be used will be detected automatically when the app installation process begins, so you will not have to configure any setting manually at any moment.