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 upsides that have made it the preferred engine for many open-source script-based web applications, including Magento and Joomla™, which have shifted over to InnoDB for good. For example, adding immense volumes of data will be faster with InnoDB, because it locks only a single row to perform an operation, not the entire database table, which makes the engine excellent for scalable apps. It also supports foreign keys and transactions – these refer to the manner in which the info is handled. Put simply, importing new or updating existent data will either be thoroughly completed, or will be canceled and the operation will be rolled back in case a certain problem occurs in the meantime, so the content that remains in the database will not be damaged.
InnoDB in Hosting
While InnoDB is either a paid upgrade or it is not available at all with many web hosts, it is an essential part of the default set of services that we’re offering with our hosting packages. In case you’d like to make use of a script-based application that requires InnoDB specifically, in order to be installed and to work correctly, you will not come across any obstacles because the MySQL database engine is available on our in-house developed cloud Internet hosting platform. Irrespective of whether you set up a brand new MySQL database and install an application manually or use our one-click application installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the respective application requires it rather than MyISAM. In addition to the incredible crash recovery offered by InnoDB, we also perform daily backups of all databases, so that we can swiftly recover any database in your shared web hosting account.
InnoDB in Semi-dedicated Hosting
If you set up a new MySQL database from the Control Panel offered with each of our semi-dedicated server accounts and you begin installing a PHP script-based web app either manually or using our one-click app installer, the storage engine for the MySQL database will be selected automatically on the basis of the requirements of the given app. Since InnoDB is present on the cloud website hosting platform where your new account will be set up, it will be set as the default engine for any application that requires it without any manual intervention needed on your end at any point. To prevent any chance of losing information if you update an app or if you erase a database unintentionally, we will generate backups of all your databases each and every day, so if something happens, we can retrieve your content.
InnoDB in Dedicated Hosting
All Linux dedicated hosting that are ordered with our custom-built Hepsia hosting Control Panel include a software package that is pre-installed and among everything else, you’ll get the InnoDB storage engine, so you will not need to install it manually if you’d like to activate PHP scripts that need it. All it takes to install such a script is to create a new MySQL database and to begin the installation process – as soon as the setup wizard accesses the database in question and begins dumping content in 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 run scripts that require the other popular MySQL engine, MyISAM, so you will not have to change any settings on the dedicated server. This will permit you to activate various scripts on a single physical machine and to use the latter to its full capabilities.