InnoDB is a database storage engine for MySQL relational databases, which is used by famous PHP script-based applications like Joomla™ 3.x and Magento. It’s ideal for scalable apps, as it excels in managing immense amounts of data. Rather than locking the entire table to insert new information in a database as many other engines do, InnoDB locks only one row, so it can process much more tasks for the same period of time. Additionally, InnoDB offers a much better crash recovery and supports database transactions and foreign keys – a set of rules that indicate how data imports and modifications should be treated. In case a certain task has not been fully completed for any reason, the action will be rolled back. In this way, the content in the database will stay safe and sound and will not be partially mixed with newly imported content.
InnoDB in Shared Hosting
InnoDB is available with all our Linux shared hosting by default, not upon request or as a paid upgrade, so you can activate and run any PHP-based web app that needs the InnoDB database storage engine without any impediments as soon as you order your shared hosting account. InnoDB will be pre-selected as the default engine for a particular MySQL database during the app installation, irrespective of whether you use our one-click installation tool or create the MySQL database and activate the application manually, as long as the application requires it instead of the more popular MyISAM engine. We’ll carry out regular backups of all your MySQL databases, so you can be certain that you will never lose any data if you delete a database by mistake or you overwrite some essential information – you just have to contact us and we will restore your content back to normal.
InnoDB in Semi-dedicated Servers
All our semi-dedicated servers support InnoDB and you’ll be able to take full advantage of all the features of this MySQL storage engine with any PHP-based app that needs it. It is among the engines that we have on our cloud website hosting platform, so the one that will be used depends on the prerequisites of the application in question. You won’t have to do anything manually in order to enable InnoDB, because it will be set as the default engine when you install an app – whether manually or using our 1-click application installer. To avoid any risk, we’ll create regular MySQL database backups, so if something goes wrong following some update or if you erase some data by mistake, we will be able to restore your database the way it was on any of the past 7 days.
InnoDB in VPS Servers
If you get a VPS server with our Hepsia Control Panel, the InnoDB database storage engine will be an essential part of the software bundle that will be installed on your Virtual Private Server before we give it to you. You won’t have to activate anything manually and you will be able to enable and run any PHP script-based software app that requires InnoDB as soon as your Virtual Private Server is up and running, which takes no more than sixty minutes after the order submission procedure itself. A couple of engines are offered, so anytime you set up a database using the Hepsia Control Panel, a specific engine will be picked once the app installation process starts and our system will detect the engine that is required by the app in question. In case you need MyISAM, for instance, you will not have to do anything different than installing the application of your preference, whether manually or using our application installer.
InnoDB in Dedicated Servers
Our Hepsia Control Panel is among the features which you can pick on the server order page when you purchase a dedicated server from us. Since this is the most powerful type of hosting, it’s very likely that you’ll run popular sites that will attract lots of individuals, and since InnoDB is among the best options for such sites, we’ll install it along with all the other software applications that are offered with a Hepsia-equipped dedicated server. When you set up a new database in your dedicated account, there won’t be any activated storage engine till you start installing an open-source PHP script, whether manually via your browser or using the automatic script installer that is integrated into the hosting Control Panel. The needed engine will be recognized automatically and will be set for the database in question, so you can run scripts that need InnoDB, as well as ones that need the default MySQL engine – MyISAM, without having to cope with any obstacle.