InnoDB is a popular database engine for MySQL. It is an alternative to the default engine – MyISAM, and it has got numerous strong sides that have made it the engine of choice for a lot of script-based web applications, such as Joomla™ and Magento, which have shifted over to InnoDB permanently. For example, adding huge volumes of data will be faster with InnoDB, because it locks only one row to accomplish a certain operation, not the entire table, which makes the engine excellent for scalable applications. InnoDB also supports foreign keys and database transactions – these refer to the way in which the information is tackled. In simpler words, adding new or modifying existing data will either be fully completed, or will be annulled and the operation will be rolled back in case a certain problem shows up in the meantime, so the content that remains in the database will not be lost.
InnoDB in Cloud Hosting
InnoDB is available with all our cloud hosting service
by default, not as a paid upgrade or upon request, so you will be able to activate and manage any PHP-driven app that requires the InnoDB database engine without encountering any impediment as soon as you open your shared web hosting account. InnoDB will be pre-selected as the default engine for a certain database during the app installation process, irrespective of whether you make use of our 1-click installer or create the database and activate the app manually, on the condition that the app requires it instead of the more famous MyISAM engine. We will create regular database backups, so you can be sure that you won’t ever lose any content if you erase a database by accident or you overwrite some essential info – you will simply have to touch base with us and we will restore your data back to normal.
InnoDB in Semi-dedicated Servers
All our Linux semi-dedicated service
include InnoDB and you’ll be able to take advantage of all the options offered by this database engine with any PHP-based application that requires it. InnoDB is one of the engines that we have on our cloud web hosting platform, so the one that will be selected depends on the prerequisites of the specific application. You won’t need to do anything manually to enable InnoDB, since it will be set as the default engine when you install an app – whether manually or using our one-click application installer. To avoid any risk, we’ll create daily database backups, so if anything goes wrong following some update or if you delete some data unintentionally, we will be able to get your database back to the way it was on any of the past 7 days.
InnoDB in VPS Servers
If you select a VPS server
with our Hepsia hosting Control Panel, the InnoDB database storage engine will be an essential part of the standard software pack that will be installed on your server before we hand it over to you. You will not have to activate anything manually and you will be able to install and manage any open-source script-driven app that needs InnoDB when your VPS is up and running, which takes no more than sixty minutes after the order process itself. A couple of engines are available, so every time you set up a database via the Hepsia Control Panel, a particular engine will be activated when the app installation begins and our system will automatically detect the engine that is required by the app in question. If you need to use MyISAM, for example, you will not need to do anything different from installing the desired app, whether manually or using our app installer tool.
InnoDB in Dedicated Servers
If you order a new dedicated server
, you will be able to choose one of the three Control Panels that we are offering – cPanel, Hepsia and DirectAdmin. Any dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you will not have to enable this MySQL database storage engine manually so as to be able to manage open-source script-based web apps that require it. InnoDB is used by scalable apps and since a dedicated server will supply you with all the resources that you need in order to run large-scale Internet sites, it’s very possible that you will resort to InnoDB. You will be able to use other engines as well, so if a certain app needs MyISAM rather than InnoDB, you won’t have to deal with any impediment while managing it. The engine that will be used will be recognized automatically the moment the app installation process commences, so you will not need to alter any settings manually at any moment.