Discover what a database engine is, what are the advantages of the InnoDB engine and why it's gaining so much global popularity.
InnoDB is a very popular storage engine for the MySQL database management system. It is an alternative to the default MyISAM engine and it has a number of advantages that have made it the preferred engine for plenty of script-driven web apps, including Magento and Joomla™, which have moved to InnoDB permanently. For instance, adding large amounts of data will be much faster with InnoDB, since it locks only a single row to accomplish a certain task, not the entire database table, which makes the engine ideal for scalable applications. InnoDB also supports foreign keys and database transactions – these refer to the way in which the data is treated. To put it simply, adding new or modifying existent data will either be thoroughly completed, or will be aborted and the procedure will be rolled back if some problem shows up during the process, which means that the content that remains in the database will not be damaged.
InnoDB in Cloud Web Hosting
You’ll be able to install any PHP script-based web application that requires InnoDB if you have a Linux cloud web hosting package
with our company, as the database storage engine is available on our advanced cloud hosting platform by default. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue flawlessly if this engine is required. You can activate applications which use the MyISAM engine without any difficulties as well and, again, the engine will be selected automatically, so you will not need to configure anything manually at any moment. In addition, we’ll also create regular backups of all the databases that you have in your shared account, so if you erase or overwrite anything, we can quickly get it back to the way it was on any of the previous 7 days.
InnoDB in Semi-dedicated Hosting
InnoDB is available with each of our Linux semi-dedicated packages
by default, so the moment you order a new semi-dedicated account, you can go ahead and activate any open-source script-based web app that needs this MySQL database engine. Several engines are installed on our cloud platform, so when you set up a brand-new database and start installing an application manually, or decide to take advantage of the Hepsia hosting Control Panel-integrated app installer tool, the engine for the database will be picked in accordance with the specific app’s prerequisites. This will permit you to activate and manage InnoDB-specific applications without having to cope with any impediment and without modifying any settings in your semi-dedicated account. To take no chances, we’ll always keep a seven-day-old backup of all your MySQL databases, so if you delete or edit any content by accident, we can easily retrieve it.
InnoDB in VPS
If you obtain a virtual private server
from us, you will be able to make use of our custom-developed Hepsia hosting Control Panel to manage your web content. A Hepsia-equipped VPS will permit you to manage any PHP script-based web app that needs InnoDB, as this MySQL database storage engine is part of the software package that will be installed on your VPS server during its setup. When you create a brand new database via the hosting Control Panel, you just have to start installing an application – manually or using our app installer tool. InnoDB will be set as the default engine as long as the app in question requires it, so you won’t have to do anything else in your VPS account. Likewise, if a given application needs MyISAM, it will be automatically set as the default engine for this concrete MySQL database.
InnoDB in Dedicated Hosting
If you obtain a new dedicated server
, you will be able to select one of the 3 Control Panels offered by us – DirectAdmin, Hepsia and cPanel. Each server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you will not need to install this database storage engine manually so as to be able to manage open-source script-based applications that require it. InnoDB is used for scalable applications and since a dedicated server will offer you all the resources that you need in order to manage large-size Internet sites, it’s pretty possible that you will use InnoDB. You will be able to use other engines as well, so if a particular app requires MyISAM rather than InnoDB, you won’t come across any impediment while running it. The engine that will be used will be automatically recognized when the app installation starts, so you will not need to change any settings manually whatsoever.