InnoDB is a popular database storage engine for the MySQL DBMS. It’s an alternative to the default engine – MyISAM, and it has a number of strong sides which make it the engine of choice for lots of PHP-driven applications, among them Magento and Joomla™, which have switched to InnoDB permanently. For example, adding enormous volumes of data will be faster with InnoDB, due to the fact that it locks only a single row to accomplish a specific operation, not the entire database table, which makes the engine ideal for scalable apps. It also supports foreign keys and transactions – these refer to the manner in which the information is tackled. In simpler words, importing new or updating existent data will either be fully completed, or will be annulled and the procedure will be rolled back if a given problem shows up in the meantime, which is why the content that remains in the database will not be lost.
InnoDB in Web Hosting
Any open-source script-powered web app that needs InnoDB will function impeccably on our innovative cloud website hosting platform and the database engine comes with all our web hosting plans. Each time you create a database manually or our app installer creates one automatically and an app installation process is initiated, the engine that the database in question will make use of will be selected based on the app’s specifications without the need to change any setting in your account. InnoDB will be chosen automatically for any app that requires this particular engine and you’ll be able to get the most out of its full capacity. We’ll create regular backups of your content, so if you accidentally erase a MySQL database that is important to you or you overwrite specific parts of it, we’ll be able to restore everything the way it was only several hours ago.
InnoDB in Semi-dedicated Servers
If you create a brand-new MySQL database from the Control Panel provided with all our semi-dedicated server accounts and you start installing a PHP script-powered web app either manually or using our single-click app installer tool, the storage engine for the database will be selected automatically depending on the particular app’s prerequisites. As InnoDB is present on the cloud web hosting platform where your new semi-dedicated hosting account will be set up, it will be set as the default engine for any app that requires it without the need for any manual intervention on your end at any moment. To prevent any risk of losing information if you update an application or if you erase a database by mistake, we will carry out backups of all your databases every day, so if anything happens, we can rescue your data.
InnoDB in VPS Servers
If you order a VPS server with our Hepsia hosting Control Panel, the InnoDB storage engine will be an integral part of the default software package that will be pre-installed on your VPS server before we give it to you. You will not need to set up anything manually and you will be able to install and manage any open-source script-powered software app that requires InnoDB once your VPS is ready, which takes no more than 1 hour after the order submission process itself. A number of engines are available, so every time you create a MySQL database via the Hepsia Control Panel, a particular engine will be activated once the app activation commences and our system will automatically recognize the engine that is required by the application in question. If you have to use MyISAM, for example, you will not need to do anything different from installing the app of your preference, whether manually or using our application installer tool.
InnoDB in Dedicated Servers
InnoDB is included as standard with all dedicated web hosting plans ordered with the Hepsia Control Panel. It is part of the software package that we install on all Hepsia-managed servers, so as soon as your machine is assembled, you’ll be able to log in and to install any PHP script-driven software app that requires this MySQL storage engine. When you create a new database through the Control Panel, there won’t be any activated engine until you start installing an application. As soon as the app configuration wizard begins importing information into the newly created database, the engine will be set automatically depending on the specific app’s prerequisites, so you can run both MyISAM and InnoDB without having to select either one of them specifically at any point. Therefore, you can make use of a wide selection of applications for your sites.