InnoDB is a MySQL storage engine, which has been gaining popularity lately, because it provides a significantly better overall performance and a faster crash recovery compared with the default engine that’s used by the MySQL database management system – MyISAM. InnoDB is used by many developers that build scalable web applications, as it works better with immense amounts of data, while it keeps the server processing load at a minimum. In addition, it locks only a single database row in case any information should be modified, while many other engines lock the entire table and thus need much more time to execute several consecutive tasks. Last, but not least, InnoDB follows a set of "all-or-nothing" rules – if the entire data modification procedure cannot be completed for whatever reason, the operation is rolled back to prevent confusion or data loss. Magento and the newest Joomla releases are two instances of widely used PHP-based software platforms that have switched over to InnoDB.
InnoDB in Cloud Hosting
InnoDB is available with all our cloud plans by default, not upon request or as a paid upgrade, so you will be able to activate and run any PHP-driven web app which needs the MySQL storage engine without any difficulties as soon as you order your shared website hosting account. InnoDB will be selected automatically as the default engine for a given database during the app activation, regardless of whether you make use of our one-click installation tool or create the MySQL database and install the application manually, provided that the app requires InnoDB instead of the more famous MyISAM engine. We’ll generate regular backups of all your MySQL databases, so you can be certain that you will never lose any content in case you delete a database accidentally or you overwrite some key info – you simply need to touch base with us and we’ll restore your database back to normal.
InnoDB in Semi-dedicated Servers
If you create a new MySQL database through the hosting Control Panel coming with all our semi-dedicated server plans and you begin installing a PHP-powered app either manually or using our 1-click app installer tool, the storage engine for the database will be picked automatically based on the given app’s prerequisites. Since 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 requires it without the need for any manual intervention on your end at any time. To avoid any chance of losing info if you update an app or if you remove a database accidentally, we will carry out backups of all your databases each and every day, so if something goes wrong, we can recover your content.
InnoDB in VPS Servers
If you select a VPS server with our Hepsia hosting Control Panel, the InnoDB database engine will be an integral part of the default software bundle that will be pre-installed on your VPS server before we give it to you. You won’t need to activate anything manually and you will be able to enable and manage any PHP script-driven software app that requires InnoDB as soon as your Virtual Private Server is up and running, which takes no more than 60 minutes after the order submission procedure itself. A few engines are offered, so anytime you set up a MySQL database through the Hepsia Control Panel, a particular engine will be selected when the app activation starts and our system will automatically recognize the engine that is required by the application in question. If you need MyISAM, for instance, you won’t need to do anything different than installing the preferred application, whether manually or using our app installer tool.
InnoDB in Dedicated Servers
If you buy a new dedicated server, you will be able to choose one of the three hosting Control Panels that we are offering – DirectAdmin, cPanel and Hepsia. Each server ordered with the Hepsia Control Panel comes with InnoDB pre-installed, so you will not have to install this database storage engine manually in order to be able to run PHP script-driven software apps that need it. InnoDB is used by scalable apps and since a dedicated server will give you all the system resources that you require to run large-scale websites, it’s rather possible that you’ll use InnoDB. You will be able to make use of other engines as well, so in case a specific app requires MyISAM rather than InnoDB, you will not have to deal with any difficulty while running it. The engine that will be used will be recognized automatically once the app installation procedure commences, so you will not have to configure any settings manually at any moment.