InnoDB is a popular storage engine for the MySQL RDBMS. It’s an alternative to the default MyISAM engine and it has got plenty of upsides which make it the preferred engine for many open-source script-driven apps, among them Magento and Joomla, which have switched to InnoDB permanently. For instance, adding enormous data volumes will be much faster with InnoDB, since it locks only a single database row to accomplish an operation, not the entire database table, which makes the engine ideal for scalable apps. It also supports foreign keys and database transactions – these refer to the way in which the information is tackled. Simply put, appending new or editing existing data will either be fully completed, or will be canceled and the procedure will be rolled back if any issue occurs in the meantime, thus the content that remains in the database won’t be damaged.

InnoDB in Shared Website Hosting

While InnoDB is either not offered or it is a paid upgrade with many web hosting providers, it is included in the default set of services offered with our shared website hosting packages. In case you wish to make use of a PHP-powered software application that needs InnoDB in particular, in order to be installed and to operate properly, you will not come across any impediments as the MySQL database engine is available on our custom-built cloud platform. Regardless of whether you create a brand new database and install an application manually or take advantage of our one-click app installer tool, InnoDB will be selected automatically by our system as the default engine if the app requires it rather than MyISAM. Besides the outstanding database crash recovery offered by InnoDB, we also keep regular database backups, so that we can easily recover any database in your shared website hosting account.

InnoDB in Semi-dedicated Hosting

You can make use of a script-based web app that needs InnoDB with any of our semi-dedicated server packages, because all the accounts are set up on our innovative cloud hosting platform where the database engine is installed. A new database can be set up in two ways – manually from the Database Manager section of the Hepsia web hosting Control Panel, or automatically – when you take advantage of our single-click application installer. Either way, the required engine will be picked automatically as soon as the installation of the application begins, so you will not have to modify anything manually, no matter if the app requires InnoDB or the more widely used MyISAM. Furthermore, we’ll always be able to restore any of your databases if you remove one by mistake, as we make a couple of database backups every day, each of which is stored for 1 week.

InnoDB in Dedicated Hosting

Our Hepsia hosting Control Panel is one of the features that you can select on the server order page when you purchase a dedicated server from us. Since this is the most powerful type of hosting, it’s rather likely that you will manage popular Internet sites that will attract lots of visitors, and since InnoDB is one of the best options for such websites, we’ll activate it together with all the other software apps that are offered with a Hepsia-managed server. When you set up a brand new MySQL database in your account, there won’t be any activated MySQL database engine until you begin installing an open-source script, whether manually through your web browser or using the automatic scripts installer that is included in the Control Panel. The necessary engine will be recognized automatically and will be assigned to that database, so you can use scripts that need InnoDB, as well as ones that require MyISAM – the default MySQL engine, without any difficulties.