InnoDB is a MySQL database engine, which has been gaining popularity lately, as it provides a significantly better overall performance and an improved crash recovery in comparison to the default engine used by MySQL – MyISAM. InnoDB is endorsed by lots of developers that create scalable software apps, due to the fact that it works more effectively with immense amounts of data, while it keeps the server load at a minimum. Moreover, it locks only one database row if anything should be modified, while many other engines lock the entire table and thus need much more time to complete several consecutive tasks. Last, but not least, InnoDB observes a set of "all-or-nothing" rules – if the entire data modification procedure cannot be completed successfully for whatever reason, the action is rolled back to prevent confusion or data loss. Magento and the latest editions of Joomla are two instances of popular open-source script-driven software apps that have shifted over to InnoDB.

InnoDB in Hosting

InnoDB is available with all our hosting service by default, not upon request or as a paid upgrade, so you’ll be able to activate and manage any PHP script-based web app that needs the storage engine without the need to deal with any difficulty as soon as you open your shared website hosting account. InnoDB will be selected automatically as the default engine for a particular database during the app installation process, irrespective of whether you make use of our one-click installation tool or create the MySQL database and set up the app manually, as long as the app requires InnoDB instead of the more popular MyISAM engine. We’ll maintain regular backups of all your databases, so you can be certain that you will never lose any content if you delete a database unintentionally or you overwrite some vital information – you simply need to touch base with us and we’ll restore your database the way it was.

InnoDB in Semi-dedicated Servers

InnoDB is offered with all our Linux semi-dedicated hosting service by default, so once you create a new semi-dedicated account, you can move on and install any PHP script-powered application that requires the database storage engine. A number of engines are installed on our cloud platform, so when you create a brand-new database and begin installing an application manually, or decide to take advantage of the Hepsia hosting Control Panel-integrated app installer, the engine for the database will be selected depending on the prerequisites of the application in question. This will permit you to install and run InnoDB-specific applications without the need to deal with any complication and without having to update any settings in your account. To be on the safe side, we will always have a seven-day-old backup of all your MySQL databases, so if you delete or change any content by mistake, we can easily recover it.

InnoDB in VPS Servers

In case our in-house built Hepsia hosting Control Panel is picked during the signup process for a new VPS servers , InnoDB will be installed on the server along with other necessary pieces of software, so you will not have to do anything if you choose to make use of PHP-powered software apps that require this MySQL database storage engine. MyISAM, the default MySQL engine, will be activated as well. You can create a brand-new MySQL database and start installing the app manually or through our 1-click installation tool. The system will recognize the engine that the particular application needs and will assign it to the specific MySQL database, so the installation process will proceed flawlessly and the application can enter its data into that database. Thus, you can install apps with various requirements regarding the MySQL engine without the need to make any changes on your server.

InnoDB in Dedicated Servers

InnoDB is available as standard with all Linux dedicated service ordered with the Hepsia Control Panel. It’s an integral part of the software package that will be installed on all Hepsia-equipped dedicated servers, so as soon as your physical machine is set up, you’ll be able to sign in and to activate any type of PHP-driven app that requires this particular database engine. If you set up a new database through the Control Panel, there won’t be any activated engine until you begin installing an application. Once the app setup wizard starts inserting data into the database, the engine will be set automatically based on the requirements of the respective application, so you can use both InnoDB and MyISAM without the need to select either one specifically at any time. Therefore, you can use a huge range of apps for your websites.