InnoDB is a popular database engine for the MySQL DBMS. It is an alternative to the default engine – MyISAM, and it has many pluses which make it the engine of choice for lots of PHP script-based software applications, such as Magento and Joomla™, which have shifted over to InnoDB for good. For instance, adding immense amounts of data will be faster with InnoDB, since it locks only one row to carry out a given task, not the entire database table, which makes the engine perfect for scalable applications. It also supports foreign keys and transactions – these refer to the manner in which the info is handled. Put simply, appending new or editing existing data will either be thoroughly completed, or will be aborted and the procedure will be rolled back if some problem occurs during the process, which means that the content that remains in the database will not be damaged.
InnoDB in Shared Website Hosting
InnoDB is offered with all our Linux shared website hosting by default, not as a paid upgrade or upon request, so you’ll be able to activate and manage any PHP-powered web application that needs the database engine without any problem once you order your shared website hosting account. InnoDB will be pre-selected as the default engine for a specific MySQL database during the app activation, irrespective of whether you make use of our one-click installer or create the database and set up the app manually, as long as the application requires it instead of the more popular MyISAM engine. We’ll create regular MySQL database backups, so you can be sure that you’ll never lose any content in case you erase a database by mistake or you overwrite some essential info – you simply have to contact us and we’ll restore everything the way it was.
InnoDB in Dedicated Servers Hosting
All dedicated servers hosting packages ordered with our custom Hepsia Control Panel include a software bundle that is pre-activated and besides everything else, you will get the InnoDB database engine, so you will not need to activate it manually if you wish to activate open-source PHP scripts that require it. All it takes to run such a script is to set up a new MySQL database and to start the setup – as soon as the installation wizard acquires access to the database and starts inserting data into it, InnoDB will be set as the default engine for this database on the condition that it is the one needed by the particular script. You’ll also be able to install scripts that require MyISAM, the other very popular MySQL engine, so you will not need to modify any settings on the server. This will allow you to install different scripts on a single server and to use it to its maximum capacity.