Find out more about InnoDB and find out why it’s recently been picked out as the default MySQL database engine.
InnoDB is a popular database storage engine for the MySQL RDBMS. It’s an alternative to the default engine – MyISAM, and it has plenty of strong sides that make it the engine of choice for many PHP script-driven applications, such as Magento and Joomla™, which have switched over to InnoDB for good. For instance, adding large volumes of data will be much faster with InnoDB, because it locks only one database row to complete a given task, not the entire database 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 info is tackled. Put simply, importing new or modifying existent data will either be thoroughly completed, or will be aborted and the procedure will be rolled back in case a given issue appears during the process, thus the content that remains in the database will not be lost.
InnoDB in Cloud Hosting
While InnoDB is either not offered or it is a paid upgrade with many hosting service providers, it’s an integral part of the standard set of features offered with our cloud hosting
packages. If you want to make use of an open-source script-based app that needs InnoDB in particular, in order to be activated and to perform properly, you won’t encounter any problems because the MySQL storage engine is available on our in-house built cloud platform. Irrespective of whether you set up a new MySQL database and install an application manually or use our single-click application installer instrument, InnoDB will be selected automatically by our system as the default engine if the application requires it rather than MyISAM. In addition to the outstanding database crash recovery that InnoDB is offering, we also perform daily database backups, so we can quickly recover any MySQL database in your shared website hosting account.
InnoDB in Dedicated Hosting
All Linux dedicated servers hosting packages
ordered with our custom-developed Hepsia Control Panel come with a software bundle that’s pre-activated and besides everything else, you will get the InnoDB database engine, so you won’t need to activate it manually in case you would like to activate scripts that require it. All it takes to use such a script is to set up a new MySQL database and to start the setup process – as soon as the script setup wizard gains access to the database and begins entering content into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one required by the particular script. You will also be able to run scripts that require the other widely used MySQL engine – MyISAM, so you will not have to edit any settings on the server. This will enable you to activate a variety of scripts on one single physical server and to use it to its full capabilities.