Find out more about InnoDB and find out why it’s already been chosen as the default MySQL database engine.
InnoDB is a popular storage engine for the MySQL RDBMS. It is an alternative to the default engine – MyISAM, and it has numerous advantages that have made it the engine of choice for a lot of open-source script-powered apps, such as Magento and Joomla™, which have moved to InnoDB for good. For instance, importing enormous amounts of data will be faster with InnoDB, as it locks only one row to complete a particular operation, not the entire table, which makes the engine excellent for scalable applications. It also supports foreign keys and transactions – these refer to the way in which the info is tackled. To put it simply, appending new or modifying existent data will either be entirely completed, or will be canceled and the operation will be rolled back if some problem occurs in the meantime, which is why the content that remains in the database won’t be damaged.
InnoDB in Website Hosting
Any PHP script-powered software application that needs InnoDB will run impeccably on our innovative cloud platform and the database engine is available with all our website hosting
plans. Each time you create a MySQL database manually or our app installer tool creates one automatically and an app installation process is started, the engine that the database will use will be selected on the basis of the app’s prerequisites without having to configure any setting in your shared web hosting account. InnoDB will be picked automatically for any application that requires this specific engine and you’ll be able to take advantage of its full capacity. We’ll create regular backups of your content, so if you accidentally remove a database that you need or you overwrite a specific part of it, we will be able to restore the database the way it was only a couple of hours earlier.
InnoDB in Semi-dedicated Servers
If you create a brand-new MySQL database through the Control Panel coming with each of our semi-dedicated server
accounts and you start installing a script-powered app either manually or using our one-click application installer, the storage engine for the database will be picked automatically based on the requirements of the app in question. As InnoDB is present on the cloud website hosting platform where your new account will be created, it will be set as the default engine for each app that requires it without any manual intervention needed on your end at any time. To avoid any chance of losing data if you update an app or if you delete a database by accident, we will carry out backups of all your databases every day, so if anything goes wrong, we can recover your data.
InnoDB in Dedicated Servers
All dedicated web hosting plans
that are ordered with our custom-built Hepsia Control Panel include a software bundle that is pre-installed and besides everything else, you will get the InnoDB database storage engine, so you will not need to install it manually in case you would like to use open-source scripts that need it. All it takes to activate such a script is to set up a new MySQL database and to start the installation – as soon as the installation wizard obtains access to the database and starts entering content into it, InnoDB will be set as the default engine for this database provided that it is the one required by the script. You’ll also be able to activate scripts that require the other popular MySQL engine – MyISAM, so you will not need to edit any settings on the server. This will permit you to activate different scripts on one single physical machine and to use it to its fullest capacity.