InnoDB is a very popular storage engine for MySQL. It is an alternative to the default MyISAM engine and it has got a number of pluses which make it the engine of choice for plenty of open-source script-based web apps, including Magento and Joomla, which have shifted over to InnoDB permanently. For instance, adding large amounts of data will be much faster with InnoDB, due to the fact that it locks only a single row to accomplish a given task, not the entire table, which makes the engine perfect for scalable applications. It also supports foreign keys and database transactions – these refer to the way in which the info is handled. Simply put, appending new or editing existing data will either be thoroughly completed, or will be annulled and the operation will be rolled back if a given problem shows up during the process, thus the content that remains in the database will not be lost.
InnoDB in VPS Servers
When you buy a VPS server from our company, you will be able to take advantage of our in-house developed Hepsia Control Panel to manage your web content. A Hepsia-managed VPS will permit you to use any PHP-powered web app that needs InnoDB, as this MySQL database storage engine is part of the standard software bundle that will be installed on the VPS server during its setup. When you create a brand-new MySQL database using the Control Panel, you’ll simply need to start installing an application – manually or using our app installer tool. InnoDB will be set as the default engine if the application in question needs it, so you will not need to do anything else in your VPS account. In the same manner, if an app needs MyISAM, it will be automatically set as the default engine for this specific MySQL database.
InnoDB in Dedicated Servers
If you purchase a new dedicated server, you will be able to pick any of the three Control Panels that we offer – DirectAdmin, cPanel and Hepsia. Each dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-installed, so you won’t have to activate this MySQL database storage engine manually to be able to run script-driven applications that require it. InnoDB is used by scalable apps and since a dedicated server will provide you with all the server resources that you require to run large-scale websites, it is rather likely that you’ll resort to InnoDB. You’ll be able to make use of other engines as well, so in case a particular application requires MyISAM rather than InnoDB, you won’t have any obstacle while managing it. The engine that will be used will be detected automatically the moment the app installation begins, so you won’t need to alter any setting manually whatsoever.