InnoDB is a popular database storage engine for the MySQL database management system. It’s an alternative to the default MyISAM engine and it has lots of strengths which make it the preferred engine for numerous PHP script-powered applications, including Magento and Joomla™, which have shifted over to InnoDB for good. For example, importing large amounts of data will be much faster with InnoDB, as it locks only one database row to carry out a certain task, not the entire table, which makes the engine perfect for scalable apps. It also supports foreign keys and database transactions – these refer to the way in which the information is handled. In simpler words, importing new or modifying existing data will either be entirely completed, or will be aborted and the procedure will be rolled back if a given problem shows up in the meantime, thus the content that remains in the database will not be lost.

InnoDB in Shared Website Hosting

While InnoDB is either not available or a paid upgrade with many other website hosting service providers, it is an essential part of the default set of services offered with our shared website hosting plans. If you wish to make use of a PHP script-driven web application that needs InnoDB specifically, in order to be activated and to work properly, you won’t have any difficulties since the MySQL storage engine is available on our in-house developed cloud website hosting platform. Irrespective of whether you create a new database and install an app manually or make use of our one-click application installer tool, InnoDB will be selected automatically by our system as the default engine if the specific application needs InnoDB instead of MyISAM. In addition to the incredible crash recovery that InnoDB offers, we also generate daily database backups, so we can swiftly restore any database in your shared hosting account.

InnoDB in Semi-dedicated Hosting

If you create a new MySQL database from the Control Panel provided with all our semi-dedicated server accounts and you begin installing a script-powered web app either manually or using our 1-click app installer, the database storage engine will be selected automatically based on the prerequisites of the given app. Since InnoDB is available on the cloud website hosting platform where your new account will be set up, it will be set as the default engine for any app that requires it without any manual intervention required on your end at any moment. To avoid any chance of losing info if you update an application or if you erase a database by accident, we will generate a backup of all your databases every day, so if something happens, we can rescue your data.

InnoDB in VPS Web Hosting

If our custom Hepsia Control Panel is picked during the registration process for a new Linux VPS web hosting packages , InnoDB will be activated on the Virtual Private Server together with other essential software, so you will not have to do anything if you decide to manage PHP script-driven software applications that need this MySQL storage engine. MyISAM – the default MySQL engine, will be installed as well. You can set up a brand new database and begin the app installation process manually or using our one-click installation tool. The system will automatically detect which engine the particular app needs and will assign it to the specific MySQL database, so the installation process will proceed impeccably and the application can dump its content in that database. In this way, you can use applications with different requirements about the MySQL engine without the need to make any changes on your VPS.

InnoDB in Dedicated Servers Hosting

Our Hepsia hosting Control Panel is among the features which you can choose on the server configuration page when you purchase a dedicated server from us. Since this is the most powerful kind of web hosting, it’s pretty likely that you will run popular Internet sites that will attract many individuals, and since InnoDB is among the best choices for such sites, we will install it along with all the other software applications that are available with a Hepsia-managed dedicated server. When you create a brand new MySQL database in your dedicated server account, there won’t be any active MySQL database engine until you start installing an open-source script, whether manually via your browser or using the automatic scripts installation tool that is integrated into the Control Panel. The needed engine will be detected automatically and will be set for that database, so you can activate scripts that require InnoDB, as well as ones that need the default MySQL engine, MyISAM, without having to cope with any obstacle.