InnoDB is a very popular database engine for the MySQL RDBMS. It’s an alternative to the default MyISAM engine and it has a number of upsides that make it the engine of choice for a lot of script-based web apps, among them Joomla™ and Magento, which have moved to InnoDB for good. For example, importing enormous volumes of data will be much faster with InnoDB, as it locks only one row to execute a given operation, not the entire database table, which makes the engine ideal for scalable apps. It also supports foreign keys and database transactions – these refer to the manner in which the information is treated. Simply put, importing new or modifying existing data will either be entirely completed, or will be canceled and the operation will be rolled back in case any issue shows up in the meantime, which means that the content that remains in the database won’t be lost.
InnoDB in Shared Hosting
While InnoDB is either a paid upgrade or it is not available at all with many other website hosting service providers, it’s an essential part of the standard set of features offered with our shared hosting
packages. In case you would like to use an open-source script-driven web app that requires InnoDB in particular, in order to be installed and to perform properly, you will not encounter any difficulties since the InnoDB storage engine is available on our in-house built cloud web hosting platform. Irrespective of whether you create a brand-new MySQL database and install an app manually or take advantage of our one-click application installer tool, InnoDB will be selected automatically by our platform as the default engine if the app requires InnoDB instead of MyISAM. Besides the excellent database crash recovery that InnoDB is offering, we also keep daily backups of all databases, so we can quickly restore any MySQL database in your shared hosting account.
InnoDB in Semi-dedicated Hosting
If you create a brand new MySQL database from the Control Panel offered with all our semi-dedicated server
packages and you start installing an open-source script-driven app either manually or using our 1-click app installer tool, the storage engine for the database will be picked automatically on the basis of the requirements of the app in question. Since InnoDB is available on the cloud platform where your new semi-dedicated server account will be created, it will be set as the default engine for any application that requires it without any manual action needed on your end at any moment. To avoid any chance of losing info if you update an app or if you remove a database accidentally, we will perform a backup of all your MySQL databases every day, so if anything goes wrong, we can retrieve your content.
InnoDB in VPS Web Hosting
If our custom Hepsia Control Panel is selected during the registration process for a new Linux VPS web hosting packages
, InnoDB will be installed on the server together with other necessary software, so you won’t have to do anything if you decide to activate PHP-powered software apps that need this MySQL database storage engine. The default MySQL engine, MyISAM, will be installed as well. You can set up a brand-new database and begin installing the application manually or through our 1-click installer. The system will detect the engine that the particular app needs and will assign it to the specific MySQL database, so the installation will continue flawlessly and the app can import its content into that database. In this way, you can activate apps with different requirements in regard to the MySQL engine without the need to make any changes on your VPS.
InnoDB in Dedicated Servers Hosting
If you buy a new dedicated server
, you will be able to pick one of the three hosting Control Panels that we are offering – Hepsia, DirectAdmin and cPanel. Each server ordered with the Hepsia Control Panel comes with InnoDB pre-installed, so you won’t have to activate this database storage engine manually in order to be able to run PHP script-driven software apps that need it. InnoDB is used for scalable applications and since a dedicated server will provide you with all the system resources that you require in order to run large-scale sites, it’s quite possible that you’ll resort to InnoDB. You’ll be able to use other engines too, so in case a certain app requires MyISAM instead of InnoDB, you won’t have to deal with any difficulty while using it. The engine that will be used will be detected automatically the moment the app installation process begins, so you won’t need to alter any setting manually at any point.