InnoDB is a very popular storage engine for the MySQL RDBMS. It’s an alternative to the default MyISAM engine and it has many advantages that make it the engine of choice for lots of PHP-powered applications, among them Magento and Joomla, which have moved to InnoDB for good. For instance, adding immense data volumes will be much faster with InnoDB, since it locks only a single row to complete a specific operation, not the entire database table, which makes the engine perfect for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the way in which the data is tackled. Simply put, adding new or modifying existent data will either be thoroughly completed, or will be aborted and the operation will be rolled back if a certain problem occurs during the process, thus the content that remains in the database will not be damaged.
InnoDB in Shared Website Hosting
While InnoDB is either not available or a paid upgrade with many web hosts, it’s an integral part of the default set of services offered with our shared website hosting packages. If you wish to use a script-powered web app that needs InnoDB in particular, in order to be installed and to operate correctly, you won’t have any difficulties as the MySQL database engine is available on our custom-developed cloud platform. No matter if you create a brand-new database and install an app manually or take advantage of our single-click app installer instrument, InnoDB will be selected automatically by our system as the default engine if the application needs it rather than MyISAM. Besides the excellent database failure recovery offered by InnoDB, we also generate regular backups of all databases, so we can quickly recover any MySQL database in your shared web hosting account.
InnoDB in Semi-dedicated Servers
You can run a PHP-powered software application that needs InnoDB with any of our semi-dedicated server packages, because all the accounts are created on our avant-garde cloud web hosting platform where the database engine is installed. A new MySQL database can be set up in two separate ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – in case you make use of our 1-click application installer. Either way, the required engine will be picked automatically the moment the application’s activation begins, so you will not need to configure anything manually, regardless of whether the application requires InnoDB or the more regularly used MyISAM. In addition, we will always be able to recover any of your MySQL databases in case you unintentionally erase one, as we generate several database backups every day, each of which is stored for 7 days.