What?s InnoDB? Why has it been used as the standard MySQL storage engine?
InnoDB is a popular storage engine for the MySQL database management system. It is an alternative to the default MyISAM engine and it has numerous strengths that have made it the engine of choice for plenty of PHP script-powered apps, including Joomla™ and Magento, which have shifted over to InnoDB permanently. For instance, adding huge data volumes will be faster with InnoDB, due to the fact that it locks only one row to complete an operation, not the entire table, which makes the engine perfect for scalable applications. It also supports foreign keys and database transactions – these refer to the manner in which the information is treated. To put it simply, appending new or updating existent data will either be fully completed, or will be annulled and the procedure will be rolled back in case some problem appears during the process, which is why the content that remains in the database won’t be damaged.
InnoDB in Web Hosting
Any PHP script-driven app that needs InnoDB will run flawlessly on our leading-edge cloud website hosting platform and the MySQL database engine is offered with all our web hosting
plans. Each time you create a MySQL database manually or our app installer tool creates one automatically and an app installation process is initiated, the engine that the database in question will use will be selected on the basis of the app’s prerequisites without having to edit any setting in your hosting account. InnoDB will be selected automatically for any application that requires this particular engine and you’ll be able to take advantage of its full potential. We will perform regular backups of your content, so if you unintentionally delete a MySQL database that’s important to you or you overwrite a certain part of it, we’ll be able to restore your database the way it was just a few hours earlier.
InnoDB in Semi-dedicated Hosting
If you create a new MySQL database from the hosting Control Panel included with each of our semi-dedicated server
plans and you start installing a PHP-driven software app either manually or using our one-click app installer, the database storage engine will be selected automatically on the basis of the prerequisites of the particular application. As InnoDB is present on the cloud website hosting platform where your new semi-dedicated hosting account will be set up, it will be set as the default engine for each application that needs it without any manual intervention required on your end at any time. To prevent any risk of losing data if you update an application or if you delete a database by mistake, we’ll carry out a backup of all your databases every day, so if something goes wrong, we can recover your data.
InnoDB in Dedicated Web Hosting
InnoDB comes as standard with all Linux dedicated servers hosting packages
ordered with the Hepsia Control Panel. It is an essential part of the default software package that will be installed on all Hepsia-managed servers, so as soon as your machine is up and running, you will be able to sign in and to activate any type of script-driven application that needs this storage engine. If you set up a new database via the hosting Control Panel, there won’t be any active engine till you start installing an application. As soon as the app installation wizard begins inserting content into the database, the engine will be set automatically on the basis of the particular app’s requirements, so you can run both InnoDB and MyISAM without the need to select either one specifically at any moment. Thus, you can make use of a large collection of apps for your Internet sites.