Become aware of what a database engine is, what are the pros of the InnoDB engine and why it's gaining that much global popularity.
InnoDB is a very popular database storage engine for the MySQL database management system. It is an alternative to the default MyISAM engine and it has got a lot of upsides which have made it the preferred engine for a lot of PHP script-powered applications, among them Joomla™ and Magento, which have moved to InnoDB for good. For example, adding immense amounts of data will be much faster with InnoDB, due to the fact that it locks only a single database row to execute a certain operation, not the entire database table, which makes the engine perfect for scalable apps. It also supports foreign keys and transactions – these refer to the way in which the information is handled. To put it simply, adding new or updating existent data will either be thoroughly completed, or will be canceled and the operation will be rolled back in case some issue appears in the meantime, which is why the content that remains in the database will not be damaged.
InnoDB in Shared Website Hosting
InnoDB is available with all our Linux shared website hosting packages
by default, not upon request or as a paid upgrade, so you will be able to install and manage any PHP-powered application that requires the database engine without encountering any difficulty once you activate your account. InnoDB will be pre-selected as the default engine for a particular database during the app installation process, no matter if you take advantage of our single-click installation tool or create the MySQL database and activate the application manually, on the condition that the app requires it instead of the more famous MyISAM engine. We’ll maintain daily backups of all your MySQL databases, so you can be sure that you won’t ever lose any content if you erase a database unintentionally or you overwrite some important information – you’ll just have to notify us and we will restore your content back to normal.
InnoDB in Semi-dedicated Hosting
InnoDB is included with each of our Linux semi-dedicated hosting packages
by default, so the moment you get a new semi-dedicated account, you can move on and activate any PHP script-based application that requires this particular MySQL database engine. A couple of engines are installed on our cloud website hosting platform, so when you create a brand new MySQL database and start installing an application manually, or opt to make use of the Hepsia hosting Control Panel-integrated application installer, the engine for the database will be picked in accordance with the prerequisites of the specific application. This will allow you to activate and run InnoDB-specific apps without coming across any complication and without changing any settings in your semi-dedicated account. To take no chances, we’ll always have a 7-day-old backup of all your MySQL databases, so if you delete or edit any content by accident, we can quickly rescue it.
InnoDB in Dedicated Servers Hosting
When you obtain a new dedicated server
, you’ll be able to pick any of the three Control Panels that we are offering – cPanel, Hepsia and DirectAdmin. Each server ordered with Hepsia comes with InnoDB pre-installed, so you will not have to install this MySQL database engine manually so as to be able to manage script-powered web apps that need it. InnoDB is used by scalable applications and since a dedicated server will supply you with all the resources that you require in order to manage large-scale sites, it’s very possible that you’ll use InnoDB. You’ll be able to use other engines as well, so in case a specific app needs MyISAM rather than InnoDB, you will not need to deal with any complication while managing it. The engine that will be used will be automatically recognized the moment the app installation procedure starts, so you won’t need to modify any setting manually at any point.