InnoDB is a popular storage engine for the MySQL database management system. It is an alternative to the default MyISAM engine and it has a lot of pluses that make it the engine of choice for plenty of open-source script-driven web applications, among them Magento and Joomla™, which have switched to InnoDB permanently. For instance, adding enormous amounts of data will be faster with InnoDB, as it locks only a single row to perform an operation, not the entire database table, which makes the engine perfect for scalable applications. It also supports foreign keys and database transactions – these refer to the way in which the data is handled. In simpler words, adding new or updating existing data will either be entirely completed, or will be aborted and the procedure will be rolled back in case any issue occurs in the meantime, which means that the content that remains in the database won’t be lost.

InnoDB in Shared Web Hosting

You can use any PHP-powered web application that needs InnoDB in case you’ve got a shared web hosting with our company, as the database storage engine is available on our advanced cloud platform as standard. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed impeccably if this engine is required. You can install apps which need the MyISAM engine without having to deal with any problem as well and, again, the engine will be pre-selected, so you won’t need to configure any setting manually at any time. Furthermore, we will also perform daily backups of all the databases that you have in the account, so in case you delete or overwrite anything, we can easily restore it the way it was on any of the previous seven days.

InnoDB in Semi-dedicated Servers

InnoDB is offered with all our semi-dedicated servers by default, so the moment you get a new semi-dedicated account, you can go ahead and activate any PHP script-based software app that needs this particular MySQL database engine. A few engines are pre-installed on our cloud web hosting platform, so when you set up a brand-new database and begin installing an application manually, or opt to make use of the Hepsia hosting Control Panel-integrated application installer, the engine for the database will be selected based on the requirements of the particular application. This will permit you to install and run InnoDB-specific applications without having any complication and without the need to modify any settings in your account. To be on the safe side, we’ll always keep a one-week-old backup of all your databases, so if you remove or alter any content unintentionally, we can swiftly retrieve it.

InnoDB in Dedicated Servers

When you obtain a new dedicated server, you’ll be able to select any of the 3 Control Panels that we’re offering – cPanel, DirectAdmin and Hepsia. Each server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you won’t need to add this MySQL storage engine manually to be able to use PHP-powered apps that need it. InnoDB is used by scalable apps and since a dedicated server will offer you all the resources that you require in order to run large-size websites, it is pretty possible that you’ll use InnoDB. You will be able to make use of other engines too, so if a specific app requires MyISAM instead of InnoDB, you won’t come across any difficulty while running it. The engine that will be used will be recognized automatically when the app installation starts, so you will not need to change any settings manually whatsoever.