InnoDB is a storage engine for MySQL relational databases, which is used by well known PHP script-powered apps such as Magento and Joomla v3. It is excellent for scalable apps, since it works unbelievably well when managing immense volumes of data. Instead of locking the whole table to enter new information into a database like many other engines do, InnoDB locks only one row, so it can carry out much more tasks for the same length of time. Furthermore, InnoDB offers a better crash recovery and supports database transactions and foreign keys – a set of rules that specify how data imports and modifications should be treated. If a particular operation hasn’t been thoroughly completed for some reason, the action will be rolled back. Thus, the database content will be preserved undamaged and will not be partially mixed with new content.
InnoDB in Shared Hosting
While InnoDB is either not available or a paid upgrade with many hosting service providers, it is part of the standard set of features that we offer with our shared hosting packages. In case you wish to use an open-source script-powered web app that needs InnoDB particularly, in order to be installed and to work correctly, you will not encounter any impediments because the InnoDB storage engine is available on our in-house built cloud Internet hosting platform. Irrespective of whether you create a new database and activate an app manually or use our single-click app installer software tool, InnoDB will be selected automatically by our system as the default engine if the particular application needs InnoDB rather than MyISAM. Besides the amazing database crash recovery that InnoDB is offering, we also make daily database backups, so that we can easily recover any MySQL database in your shared hosting account.
InnoDB in Semi-dedicated Hosting
You can run a PHP script-powered software app that requires InnoDB with any of our semi-dedicated server packages, because all the accounts are set up on our innovative cloud hosting platform where the MySQL database engine is installed. A new MySQL database can be created in two different ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – in case you take advantage of our 1-click application installer tool. Either way, the needed engine will be picked automatically as soon as the app’s activation starts, so you won’t have to edit anything manually, no matter if the app requires InnoDB or the more widely used MyISAM. Also, we will always be able to recover any of your MySQL databases in case you accidentally erase one, as we carry out a few database backups every day, each of which is stored for 1 whole week.
InnoDB in VPS Web Hosting
When you purchase a virtual private server from us, you’ll be able to take advantage of our in-house developed Hepsia Control Panel to manage your content. A Hepsia-managed Virtual Private Server will allow you to run any PHP script-powered web app that needs InnoDB, as the MySQL database engine is part of the standard software package that will be pre-installed on the Virtual Private Server during its configuration. When you set up a brand new MySQL database using the hosting Control Panel, you’ll just need to begin installing an application – manually or using our application installer. InnoDB will be set as the default engine on the condition that the application in question needs it, so you will not have to do anything else in your VPS account. Correspondingly, if a given application needs MyISAM, it will be automatically set as the default engine for this specific database.
InnoDB in Dedicated Servers Hosting
When you acquire a new dedicated server, you’ll be able to choose any of the 3 Control Panels that we offer – Hepsia, cPanel and DirectAdmin. Any dedicated server ordered with Hepsia comes with InnoDB pre-installed, so you will not need to enable this MySQL storage engine manually so as to be able to run PHP-driven applications that require it. InnoDB is used by scalable applications and since a dedicated server will supply you with all the server resources that you require to manage large-size Internet sites, it’s quite likely that you will resort to InnoDB. You’ll be able to make use of other engines too, so if a certain app requires MyISAM instead of InnoDB, you will not come across any impediment while managing it. The engine that will be used will be detected automatically when the app installation process commences, so you will not have to edit any setting manually at any time.