InnoDB is a storage engine for MySQL relational databases, which is used by famous open-source script-driven apps like Joomla 3 and Magento. It is perfect for scalable applications, as it works astonishingly well when handling immense amounts of data. Instead of locking the whole database table to add new information to a database like many other engines do, InnoDB locks only one row, so it can handle a lot more operations for the same length of time. Besides, InnoDB offers a better database failure recovery and supports database transactions and foreign key constraints – rules that prescribe how data imports and modifications should be treated. In case a given operation hasn’t been thoroughly completed for any reason, the action will be rolled back. In this way, the database content will be preserved safe and sound and won’t be partially merged with newly imported content.

InnoDB in Cloud Web Hosting

While InnoDB is either a paid upgrade or it is not available at all with many hosting companies, it is an integral part of the standard set of services that we offer with our cloud web hosting plans. If you’d like to use a script-driven web application that requires InnoDB particularly, in order to be installed and to function properly, you won’t need to deal with any problems since the InnoDB storage engine is available on our custom-built cloud hosting platform. Regardless of whether you set up a new MySQL database and activate an app manually or make use of our 1-click application installer instrument, InnoDB will be selected automatically by our system as the default engine if the given app needs it rather than MyISAM. Besides the exceptional database crash recovery offered by InnoDB, we also generate daily database backups, so we can swiftly recover any database in your shared hosting account.

InnoDB in Semi-dedicated Hosting

You can activate an open-source script-based web app that needs InnoDB with all of our semi-dedicated server packages, due to the fact that all the accounts are set up on our avant-garde cloud web hosting platform where the storage engine is installed. A new database can be created in two separate ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you take advantage of our 1-click app installer. In either case, the required engine will be picked automatically as soon as the installation of the app starts, so you won’t need to update anything manually, no matter if the app needs InnoDB or the more commonly used MyISAM. Also, we will always be able to retrieve any of your databases in case you delete one by mistake, as we perform several database backups every day, each of which is preserved for seven days.

InnoDB in Dedicated Hosting

Our Hepsia Control Panel is one of the features that you can choose on the order page when you purchase a dedicated server from our company. As this is the most powerful kind of hosting, it is quite likely that you’ll run very popular websites that will attract a lot of people, and since InnoDB is among the best choices for such Internet sites, we will install it together with all the other software apps that come with a Hepsia-managed server. When you create a brand-new MySQL database in your dedicated account, there won’t be any activated MySQL database storage engine till you start installing an open-source script, whether manually via your browser or using the automatic script installer that is available in the hosting Control Panel. The necessary engine will be automatically recognized and will be assigned to that database, so you can run scripts that require InnoDB, as well as ones that need MyISAM – the default MySQL engine, without encountering any impediment.