InnoDB is a MySQL storage engine, which has been gaining popularity lately, because it provides a significantly better overall performance and a faster database failure recovery compared with the default engine that’s used by the MySQL relational database management system – MyISAM. InnoDB is endorsed by plenty of developers that run highly scalable web apps, due to the fact that it works better with enormous amounts of data, while it keeps the server load low. Also, it uses row-level locking in case anything should be updated, while many other engines lock the entire table and therefore require much more time to process several sequential tasks. Last, but not least, InnoDB obeys a set of "all-or-nothing" rules – in case the entire data modification procedure cannot be completed for whatever reason, the operation is rolled back to avoid scrambling or data loss. Magento and the newest Joomla editions are two examples of widely used PHP script-powered web applications that have switched to InnoDB.
InnoDB in Shared Hosting
You’ll be able to install any script-based web application that requires InnoDB in case you have a Linux shared hosting with our company, as the storage engine is present on our leading-edge cloud web hosting platform as standard. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue flawlessly in case this engine is required. You can run applications which use the MyISAM engine without any difficulty as well and, again, the engine will be pre-selected, so you won’t need to modify any setting manually at any moment. Furthermore, we will also create regular backups of all the databases that you have in the shared account, so if you erase or overwrite something, we can quickly restore it the way it was on any of the past seven days.
InnoDB in Semi-dedicated Hosting
InnoDB is offered with each of our Linux semi-dedicated hosting by default, so as soon as you obtain a new semi-dedicated account, you can move on and activate any open-source script-based software application that needs this particular MySQL storage engine. A couple of engines are installed on our cloud website hosting platform, so when you create a brand new MySQL database and start installing an app manually, or decide to take advantage of the Hepsia hosting Control Panel-integrated app installer, the engine for the database will be chosen in accordance with the respective app’s requirements. This will allow you to activate and run InnoDB-specific apps without any difficulty and without having to edit any settings in your account. To take no chances, we will always keep a seven-day-old backup of all your databases, so if you remove or edit any content by mistake, we can quickly recover it.
InnoDB in Dedicated Web Hosting
Our Hepsia Control Panel is among the options which you can choose on the order page when you buy a dedicated server from us. Since this is the most powerful kind of website hosting, it’s quite likely that you’ll manage highly popular Internet sites that will attract a lot of individuals, and since InnoDB is one of the very best options for such sites, we’ll activate it together with all the other software applications that are available with a Hepsia-managed server. If you set up a brand new MySQL database in your dedicated server account, there won’t be any active storage engine till you start installing an open-source script, whether manually via your web browser or using the automatic scripts installer tool that is included in the Control Panel. The necessary engine will be recognized and will be assigned to the database in question, so you can use scripts that require InnoDB, as well as ones that need MyISAM – the default MySQL engine, without any difficulties.