InnoDB is a MySQL database storage engine, which has been gaining in popularity in recent years, because it provides a much better overall performance and a faster database crash recovery compared to the default engine that is used by the MySQL database management system – MyISAM. InnoDB is preferred by plenty of devs that write scalable web applications, due to the fact that it works better with immense data volumes, while it keeps the server load at a minimum. What’s more, it locks only a single database row if any information should be edited, whereas many other engines lock the entire table and thus need much more time to handle several consecutive tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – in case the modification of the entire data cannot be completed successfully for some reason, the operation is rolled back to prevent scrambling or the loss of data. Magento and the newest editions of Joomla are two examples of widely used open-source script-powered software apps that have switched to InnoDB.
InnoDB in Shared Hosting
You can run any open-source script-powered app that requires InnoDB if you have a Linux shared hosting with us, as the database storage engine is available on our leading-edge cloud hosting platform by default. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed impeccably in case this engine is needed. You can install applications that need the MyISAM engine without encountering any difficulty as well and, again, the engine will be selected automatically, so you will not have to change anything manually at any point. Furthermore, we’ll also make daily backups of all the databases that you’ve got in your shared hosting account, so if you delete or overwrite something, we can easily restore it the way it was on any of the past seven days.
InnoDB in Semi-dedicated Servers
InnoDB comes with each of our semi-dedicated service by default, so the moment you buy a new account, you can move on and install any script-powered software app that requires this MySQL storage engine. A few engines are pre-installed on our cloud hosting platform, so when you create a brand-new MySQL database and begin installing an app manually, or opt to use the Hepsia Control Panel-integrated application installer tool, the engine for the database will be selected on the basis of the concrete app’s requirements. This will allow you to activate and run InnoDB-specific applications without having to cope with any impediment and without editing any settings in your account. To avoid any risk, we will always have a 7-day-old backup of all your databases, so if you delete or change any content by accident, we can quickly retrieve it.
InnoDB in Dedicated Servers
InnoDB is available by default with all Linux dedicated service ordered with the Hepsia hosting Control Panel. It’s included in the software package that will be installed on all Hepsia-managed servers, so as soon as your machine is set up, you’ll be able to log in and to install any type of script-based software application that needs this particular storage engine. If you create a new MySQL database through the hosting Control Panel, there won’t be any activated engine until you start installing an application. Once the app configuration wizard begins inserting content into the database, the engine will be set automatically on the basis of the requirements of the application in question, so you can run both InnoDB and MyISAM without having to select either one of them explicitly at any moment. Thus, you can use a wide range of applications for your websites.