InnoDB is a very popular database storage engine for the MySQL RDBMS. It’s an alternative to the default engine – MyISAM, and it has a lot of strong sides which make it the preferred engine for numerous script-based web apps, among them Magento and Joomla™, which have switched over to InnoDB permanently. For instance, importing immense amounts of data will be much faster with InnoDB, due to the fact that it locks only one database row to complete a certain task, not the entire database table, which makes the engine perfect for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the way in which the information is treated. Simply put, adding new or updating existent data will either be thoroughly completed, or will be canceled and the operation will be rolled back in case a certain issue appears in the meantime, thus the content that remains in the database will not be lost.
InnoDB in Cloud Web Hosting
While InnoDB is either not offered or it is a paid upgrade with many other web hosting providers, it is part of the default set of features offered with our cloud web hosting
plans. If you would like to use a script-driven web app that needs InnoDB specifically, in order to be activated and to perform properly, you won’t encounter any difficulties as the database engine is available on our in-house developed cloud Internet hosting platform. No matter if you set up a brand-new MySQL database and activate an application manually or take advantage of our one-click application installer instrument, InnoDB will be selected automatically by our platform as the default engine if the respective app needs it rather than MyISAM. In addition to the exceptional crash recovery that InnoDB offers, we also keep daily database backups, so we can easily recover any database in your shared web hosting account.
InnoDB in Semi-dedicated Hosting
InnoDB comes with all our Linux semi-dedicated packages
by default, so the moment you obtain a new account, you can go ahead and activate any PHP script-powered application that needs this database storage engine. A few engines are pre-installed on our cloud platform, so when you set up a brand new database and begin installing an app manually, or opt to take advantage of the Hepsia hosting Control Panel-integrated app installer, the engine for the database will be selected on the basis of the requirements of the given app. This will allow you to install and manage InnoDB-specific apps without having any problem and without needing to change any settings in your account. To be on the safe side, we will always have a seven-day-old backup of all your databases, so if you erase or change any content by accident, we can quickly recover it.
InnoDB in VPS Hosting
If our in-house built Hepsia hosting Control Panel is chosen during the signup process for a new Linux VPS hosting packages
, InnoDB will be installed on the VPS server along with other necessary software, so you won’t need to do anything if you choose to manage PHP script-based software applications that need this MySQL database storage engine. MyISAM, the default MySQL engine, will be installed as well. You can create a brand new MySQL database and begin the app installation process manually or using our single-click installation tool. The system will recognize the engine that the particular app requires and will set it for the specific MySQL database, so the installation process will proceed flawlessly and the application can dump its data in that database. Thus, you can make use of applications with various prerequisites with regard to the MySQL engine without having to make any modifications on your server.
InnoDB in Dedicated Web Hosting
InnoDB is available by default with all Linux dedicated servers hosting packages
ordered with the Hepsia Control Panel. It is an integral part of the default software bundle that we install on all Hepsia-equipped servers, so as soon as your physical machine is up and running, you’ll be able to log in and to install any kind of script-driven app that requires this database engine. If you create a new MySQL database through the hosting Control Panel, there won’t be any active engine till you start installing an app. As soon as the app installation wizard begins inserting content into the database, the engine will be picked automatically depending on the respective app’s prerequisites, so you can use both InnoDB and MyISAM without having to select either one of them explicitly at any time. In this way, you can make use of a broad collection of apps for your Internet sites.