InnoDB is a popular database storage engine for the MySQL relational database management system. It is an alternative to the default MyISAM engine and it has a lot of pluses that make it the preferred engine for many PHP script-based web apps, among them Magento and Joomla™, which have switched over to InnoDB permanently. For example, importing large amounts of data will be faster with InnoDB, as it locks only a single database row to perform a specific task, 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 info is tackled. In simpler words, importing new or editing existent data will either be fully completed, or will be annulled and the procedure will be rolled back in case a given issue appears in the meantime, which is why the content that remains in the database won’t be lost.

InnoDB in Hosting

While InnoDB is either a paid upgrade or it is not available at all with many hosting companies, it’s included in the default set of features that we’re offering with our hosting plans. If you wish to make use of a script-driven application that needs InnoDB particularly, in order to be activated and to function correctly, you won’t encounter any difficulties because the storage engine is available on our in-house built cloud website hosting platform. No matter if you set up a brand new MySQL database and install an application manually or use our one-click app installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the particular application requires it rather than MyISAM. Besides the amazing crash recovery that InnoDB offers, we also perform daily backups of all databases, so that we can easily restore any MySQL database in your shared web hosting account.

InnoDB in Semi-dedicated Servers

You can run an open-source script-powered application that requires InnoDB with any of our semi-dedicated server plans, due to the fact that all the accounts are created on our avant-garde cloud hosting platform where the MySQL database storage engine is installed. A new MySQL database can be created in two different ways – manually from the Database Manager section of the Hepsia web hosting Control Panel, or automatically – if you use our single-click app installer tool. In either case, the required engine will be picked automatically once the application’s activation starts, so you won’t need to change anything manually, no matter if the application needs InnoDB or the more commonly used MyISAM. On top of that, we’ll always be able to restore any of your databases if you delete one by accident, as we create a couple of database backups every day, each of which is saved for 1 week.

InnoDB in Dedicated Servers

InnoDB comes by default with all dedicated servers that are ordered with the Hepsia hosting Control Panel. It’s included in the software bundle that we install on all Hepsia-managed servers, so once your physical machine is up and running, you’ll be able to log in and to activate any PHP-powered software application that needs this MySQL database engine. If you create a new MySQL database via the Control Panel, there won’t be any activated engine until you begin installing an application. Once the app activation wizard begins dumping information in the database, the engine will be picked automatically depending on the specific app’s prerequisites, so you can use both InnoDB and MyISAM without having to select either one of them explicitly at any point. Therefore, you can use a broad range of applications for your Internet sites.