Learn what a database engine is, what are the pros of the InnoDB engine and why it's gaining so much popularity.
InnoDB is a popular database engine for the MySQL DBMS. It is an alternative to the default MyISAM engine and it has got numerous strong sides which make it the engine of choice for a lot of script-driven software applications, such as Joomla™ and Magento, which have shifted over to InnoDB for good. For example, adding huge amounts of data will be much faster with InnoDB, as it locks only one row to execute a given task, not the entire table, which makes the engine perfect for scalable apps. It also supports foreign keys and transactions – these refer to the way in which the information is tackled. In simpler words, appending new or editing existent data will either be fully completed, or will be annulled and the procedure will be rolled back in case a certain problem shows up in the meantime, thus the content that remains in the database won’t be damaged.
InnoDB in Cloud Hosting
You’ll be able to install any open-source script-based application that needs InnoDB if you’ve got a Linux cloud hosting
with us, as the MySQL storage engine is present on our leading-edge cloud web hosting platform by default. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed flawlessly if this engine is needed. You can activate apps which need the MyISAM engine without having any difficulty as well and, again, the engine will be pre-selected, so you will not have to modify any setting manually at any time. Furthermore, we will also generate regular backups of all the MySQL databases that you have in your shared hosting account, so if you erase or overwrite anything, we can quickly restore it the way it was on any of the past seven days.
InnoDB in Semi-dedicated Hosting
You can install a PHP script-powered app that requires InnoDB with any of our semi-dedicated server
plans, as all the accounts are created on our advanced cloud hosting platform where the storage engine is installed. A new MySQL database can be created in two ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – if you use our single-click application installer. Either way, the required engine will be selected automatically as soon as the installation of the application begins, so you won’t need to edit anything manually, regardless of whether the application requires InnoDB or the more widely used MyISAM. On top of that, we will always be able to restore any of your databases if you accidentally erase one, as we generate a few backups every day, each of which is stored for one whole week.
InnoDB in VPS Web Hosting
In case our in-house built Hepsia Control Panel is picked during the signup process for a new Linux virtual private servers
, InnoDB will be installed on the VPS server together with other required software, so you won’t need to do anything if you choose to activate open-source script-driven software applications that need this MySQL storage engine. MyISAM – the default MySQL engine, will be activated as well. You can set up a new database and begin the app installation manually or using our 1-click installer tool. The system will recognize the engine that the particular app requires and will set it for the specific MySQL database, so the installation process will proceed impeccably and the application can insert its content into that database. Thus, you can make use of applications with different requirements with regard to the MySQL engine without the need to make any modifications on your Virtual Private Server.
InnoDB in Dedicated Servers Hosting
When you acquire a new dedicated server
, you’ll be able to select one of the three Control Panels that we’re offering – DirectAdmin, cPanel and Hepsia. Any dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you will not need to enable this database engine manually so as to be able to manage open-source script-powered software apps that require it. InnoDB is used for scalable applications and since a dedicated server will give you all the server resources that you require in order to run large-size websites, it is very possible that you will use InnoDB. You will be able to make use of other engines as well, so if a given app requires MyISAM rather than InnoDB, you will not have to deal with any problem while managing it. The engine that will be used will be recognized automatically when the app installation procedure commences, so you won’t need to alter any setting manually at any moment.