InnoDB is a MySQL database storage engine, which has been gaining popularity in recent years, as it provides a much better overall performance and an improved crash recovery compared to the default engine that is used by the MySQL database management system – MyISAM. InnoDB is endorsed by a lot of devs that run scalable software apps, since it works much more efficiently with huge amounts of data, while it keeps the server processing load at a minimum. Additionally, it locks only a single row in the database if anything should be modified, while lots of other engines lock the entire database table and thus need more time to process multiple successive tasks. Last, but not least, InnoDB adheres to a set of "all-or-nothing" rules – in case the modification of the entire data cannot be completed for any reason, the operation is rolled back to avoid confusion or data loss. Magento and the newest Joomla editions are two instances of famous open-source script-based applications that have switched to InnoDB.

InnoDB in Shared Website Hosting

You’ll be able to use any script-based app that requires InnoDB if you have a Linux shared website hosting with our company, as the database engine is available on our leading-edge cloud hosting platform as standard. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue impeccably in case this engine is required. You can activate apps that use the MyISAM engine without the need to deal with any obstacle as well and, again, the engine will be selected automatically, so you won’t need to update any setting manually at any moment. Furthermore, we will also carry out regular backups of all the databases that you’ve got in your shared web hosting account, so if you erase or overwrite something, we can swiftly restore it the way it was on any of the past 7 days.

InnoDB in Semi-dedicated Hosting

If you create a new MySQL database from the Control Panel coming with all our semi-dedicated server packages and you begin installing a script-powered software app either manually or using our single-click app installer tool, the MySQL database storage engine will be picked automatically depending on the given app’s prerequisites. Since InnoDB is present on the cloud web hosting platform where your new semi-dedicated server account will be set up, it will be set as the default engine for any application that needs it without any manual intervention needed on your end at any moment. To prevent any chance of losing info if you update an app or if you remove a database accidentally, we’ll perform a backup of all your databases each day, so if something goes wrong, we can restore your data.

InnoDB in VPS

If you select a virtual private server with our Hepsia Control Panel, the InnoDB storage engine will be part of the software package that will be pre-installed on your server before we give it to you. You will not need to activate anything manually and you’ll be able to enable and run any PHP script-powered app that needs InnoDB once your Virtual Private Server is ready, which takes no more than sixty minutes after the order submission procedure itself. Several engines are offered, so every time you set up a database via the Hepsia Control Panel, a particular engine will be picked when the app activation starts and our system will automatically recognize the engine that is required by the app in question. In case you need to use MyISAM, for instance, you won’t have to do anything different from installing the desired application, whether manually or using our application installer tool.

InnoDB in Dedicated Hosting

InnoDB comes by default with all dedicated hosting ordered with the Hepsia hosting Control Panel. It’s an integral part of the software bundle that will be pre-installed on all Hepsia-managed dedicated servers, so once your physical machine is assembled, you will be able to log in and to activate a various script-driven web application that needs this particular MySQL database engine. If you set up a new MySQL database via the hosting Control Panel, there won’t be any activated engine till you begin installing an app. As soon as the app configuration wizard starts entering data into the newly created database, the engine will be selected automatically depending on the requirements of the app in question, so you can run both MyISAM and InnoDB without selecting either one of them explicitly at any point. In this way, you can make use of a wide variety of apps for your websites.