See what a database engine is, what exactly are the advantages of the InnoDB engine and why it is gaining a huge amount of worldwide popularity.
InnoDB is a very popular database storage engine for the MySQL RDBMS. It’s an alternative to the default MyISAM engine and it has got a number of pluses which make it the engine of choice for many PHP-powered web apps, including Joomla™ and Magento, which have switched over to InnoDB permanently. For example, importing enormous volumes of data will be faster with InnoDB, since it locks only a single database row to perform a 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 data is handled. Simply put, adding new or modifying existent data will either be entirely completed, or will be aborted and the operation will be rolled back in case some problem occurs in the meantime, which is why the content that remains in the database won’t be lost.
InnoDB in Web Hosting
While InnoDB is either a paid upgrade or it is not available at all with many other hosting companies, it’s part of the standard set of services offered with our web hosting
packages. In case you’d like to use a PHP-driven app that requires InnoDB in particular, in order to be activated and to function properly, you will not face any obstacles since the MySQL database engine is available on our custom-built cloud platform. Irrespective of whether you set up a brand new MySQL database and install an app manually or take advantage of our single-click app installer software instrument, InnoDB will be selected automatically by our system as the default engine if the respective application requires InnoDB rather than MyISAM. Besides the incredible crash recovery that InnoDB is offering, we also store regular database backups, so that we can swiftly recover any MySQL database in your shared hosting account.
InnoDB in Semi-dedicated Servers
InnoDB is included with each of our semi-dedicated servers
by default, so once you create a new semi-dedicated account, you can go ahead and install any PHP-driven app that needs this particular MySQL database engine. A number of engines are installed on our cloud hosting platform, so when you set up a brand-new database and begin installing an application manually, or opt to make use of the Hepsia hosting Control Panel-integrated application installer tool, the engine for the database will be picked on the basis of the requirements of the respective application. This will permit you to activate and manage InnoDB-specific apps without having to cope with any impediment and without needing to change any settings in your semi-dedicated account. To avoid any risk, we will always keep a 7-day-old backup of all your databases, so if you erase or alter any content accidentally, we can swiftly rescue it.
InnoDB in Dedicated Servers
All dedicated servers
that are ordered with our in-house built Hepsia hosting Control Panel include a software bundle that is pre-installed and among everything else, you will get the InnoDB storage engine, so you will not need to add it manually in case you would like to run open-source scripts that need it. All it takes to install such a script is to create a new MySQL database and to begin the setup process – once the setup wizard receives access to the database in question and begins inserting data into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one needed by the particular script. You will also be able to run scripts that need MyISAM, the other very popular MySQL engine, so you won’t need to configure any settings on the dedicated server. This will enable you to install various scripts on a single physical machine and to use the latter to its full capabilities.