InnoDB is a popular storage engine for the MySQL RDBMS. It is an alternative to the default engine – MyISAM, and it has a number of advantages that have made it the preferred engine for plenty of PHP-powered software applications, such as Magento and Joomla, which have switched to InnoDB permanently. For instance, importing large volumes of data will be faster with InnoDB, due to the fact that it locks only one database row to accomplish a particular task, not the entire database table, which makes the engine perfect for scalable apps. InnoDB also supports foreign keys and database transactions – these refer to the manner in which the info is treated. To put it simply, adding new or editing existing data will either be fully completed, or will be annulled and the operation will be rolled back in case a given problem appears in the meantime, therefore the content that remains in the database will not be damaged.
InnoDB in Shared Hosting
Every PHP script-powered app that requires InnoDB will run impeccably on our leading-edge cloud web hosting platform and the MySQL database engine is offered with all our shared hosting packages. Each time you create a MySQL database manually or our app installer tool creates one automatically and an app installation process is initiated, the engine that the database will use will be selected in accordance with the app’s requirements without the need to update any setting in your shared hosting account. InnoDB will be selected automatically for any application that requires this specific engine and you’ll be able to get the most out of its full potential. We will maintain regular backups of your content, so if you accidentally erase a database that you need or you overwrite certain parts of it, we will be able to restore your content the way it was only a couple of hours earlier.
InnoDB in Dedicated Servers
All Linux dedicated service that are ordered with our custom-built Hepsia Control Panel come with a software bundle that’s pre-activated and among everything else, you’ll get the InnoDB storage engine, so you will not have to install it manually in case you wish to use PHP scripts that need it. All it takes to run such a script is to create a new database and to initiate the setup process – as soon as the script setup wizard receives access to the database and starts importing data into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one required by the particular script. You will also be able to use scripts that require the other very popular MySQL engine, MyISAM, so you won’t need to configure any settings on the server. This will permit you to run various scripts on one single physical machine and to use the latter to its maximum capacity.