InnoDB is a MySQL database engine, which has been gaining popularity in recent years, because it provides a significantly better overall performance and a faster database failure recovery in comparison to the default engine that is used by the MySQL database management system – MyISAM. InnoDB is preferred by many programmers that build highly scalable apps, due to the fact that it works more efficiently with huge data volumes, while it keeps the server load low. Also, it it locks only one row in the database if any information should be edited, whereas many other engines lock the entire table and hence require more time to carry out multiple consecutive tasks. Last, but not least, InnoDB adheres to a set of "all-or-nothing" rules – in case the entire data modification process cannot be completed successfully for whatever reason, the action is rolled back to avoid scrambling or data loss. Magento and the newest versions of Joomla are two instances of popular open-source script-based web applications which have switched over to InnoDB.

InnoDB in Shared Hosting

You’ll be able to use any PHP script-driven web app that needs InnoDB in case you have a Linux shared hosting plan with us, as the storage engine is available on our innovative cloud website hosting platform as standard. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue flawlessly if this engine is required. You can activate applications which use the MyISAM engine without any problem as well and, again, the engine will be pre-selected, so you won’t have to change anything manually at any time. On top of that, we will also carry out daily backups of all the MySQL databases that you’ve got in your shared web hosting account, so in case you erase or overwrite anything, we can swiftly restore it the way it was on any of the previous 7 days.

InnoDB in Semi-dedicated Servers

InnoDB is available with all our Linux semi-dedicated plans by default, so the moment you order a new account, you can move on and install any PHP-powered web app that requires the database engine. A few engines are installed on our cloud platform, so when you create a brand-new MySQL database and start installing an app manually, or opt to take advantage of the Hepsia Control Panel-integrated application installer, the engine for the database will be chosen on the basis of the concrete app’s requirements. This will allow you to activate and run InnoDB-specific apps without having to deal with any obstacle and without changing any settings in your semi-dedicated account. To take no chances, we will always keep a one-week-old backup of all your MySQL databases, so if you delete or alter any content unintentionally, we can easily recover it.

InnoDB in VPS Servers

In case our in-house built Hepsia Control Panel is selected during the registration process for a new VPS web hosting plans , InnoDB will be installed on the Virtual Private Server along with other required software, so you will not have to do anything if you decide to use PHP script-based apps that need this MySQL storage engine. The default MySQL engine, MyISAM, will be activated too. You can create a brand new MySQL database and begin the app installation procedure manually or using our 1-click installation tool. The system will recognize the engine that the particular application needs and will set it for the specific MySQL database, so the installation process will continue flawlessly and the application can import its content into that database. In this way, you can activate apps with various prerequisites in regard to the MySQL engine without making any changes on your server.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is one of the features that you can select on the order form when you buy a dedicated server from our company. Since this is the most powerful type of web hosting, it is pretty likely that you’ll manage very popular websites that will draw lots of visitors, and since InnoDB is among the very best options for such websites, we will activate it together with all the other software applications that come with a Hepsia-managed dedicated server. If you set up a brand-new database in your account, there won’t be any activated database engine until you start installing a script, whether manually through your web browser or using the automatic scripts installer tool that is integrated into the hosting Control Panel. The needed engine will be detected automatically and will be assigned to that database, so you can run scripts that require InnoDB, as well as ones that need the default MySQL engine, MyISAM, without coming across any impediment.