InnoDB is a MySQL database storage engine, which has been gaining popularity in recent years, as it provides a much better overall performance and a faster crash recovery in comparison with the default engine used by the MySQL database management system – MyISAM. InnoDB is endorsed by many web developers that write highly scalable web apps, since it works more effectively with immense amounts of data, while it keeps the server processing load low. What’s more, it locks only a single row in the database in case anything should be updated, whereas many other engines lock the entire table and hence require much more time to fulfill multiple successive tasks. Last, but not least, InnoDB abides by the "all-or-nothing" rule – if the entire data modification process cannot be completed for any reason, the operation is rolled back to avoid confusion or data loss. Magento and the newest Joomla versions are two instances of famous PHP-based software apps which have moved to InnoDB.

InnoDB in Shared Web Hosting

InnoDB is offered with all our Linux shared web hosting plans by default, not as a paid upgrade or upon request, so you can activate and run any PHP-powered web application that requires the InnoDB storage engine without any problems as soon as you activate your shared website hosting account. InnoDB will be selected automatically as the default engine for a given database during the app activation, no matter if you take advantage of our 1-click installer or create the MySQL database and set up the app manually, on the condition that the application requires it instead of the more famous MyISAM engine. We will maintain regular MySQL database backups, so you can be certain that you won’t ever lose any content if you erase a database by mistake or you overwrite some crucial info – you will simply need to notify us and we will restore your database back to normal.

InnoDB in Semi-dedicated Servers

InnoDB comes with each of our Linux semi-dedicated hosting plans by default, so as soon as you purchase a new semi-dedicated account, you can go on and activate any open-source script-powered app that needs this particular MySQL storage engine. A number of engines are installed on our cloud web hosting platform, so when you set up a new database and begin installing an app manually, or opt to take advantage of the Hepsia hosting Control Panel-integrated app installer tool, the engine for the database will be set based on the requirements of the given application. This will permit you to install and run InnoDB-specific apps without needing to deal with any problem and without the need to edit any settings in your account. To avoid any risk, we’ll always have a 7-day-old backup of all your databases, so if you remove or edit any content by accident, we can quickly restore it.

InnoDB in VPS Servers

If you pick a VPS server with our Hepsia hosting Control Panel, the InnoDB database engine will be an indivisible part of the software pack that will be installed on your server before we hand it over to you. You will not need to set up anything manually and you’ll be able to enable and manage any PHP script-based software application that needs InnoDB as soon as your VPS is set up, which takes no more than 60 minutes after the order submission itself. A number of engines are offered, so whenever you set up a MySQL database via the Hepsia hosting Control Panel, a specific engine will be picked once the app installation commences and our system will automatically recognize the engine that is required by the app in question. If you need to use MyISAM, for example, you won’t need to do anything different from installing the preferred application, whether manually or using our app installer tool.

InnoDB in Dedicated Servers

InnoDB is available as standard with all Linux dedicated servers ordered with the Hepsia Control Panel. It’s an essential part of the software package that we install on all Hepsia-managed dedicated servers, so as soon as your physical machine is ready, you’ll be able to sign in and to install any kind of PHP-driven web app that requires this MySQL database storage engine. If you set up a new MySQL database via the hosting Control Panel, there won’t be any activated engine until you begin installing an application. Once the app installation wizard starts importing data into the newly created database, the engine will be picked automatically in accordance with the particular app’s prerequisites, so you can run both MyISAM and InnoDB without the need to select either one specifically at any time. In this way, you can use a broad variety of apps for your sites.