InnoDB is a MySQL database storage engine, which has been gaining popularity lately, as it provides a much better overall performance and a faster database crash recovery compared to the default engine that’s used by the MySQL relational database management system – MyISAM. InnoDB is used by lots of web developers that run scalable web applications, since it works much better with large data volumes, while it keeps the server load low. Furthermore, it locks only one database row if any information should be edited, whereas lots of other engines lock the entire table and thus require much more time to perform multiple consecutive tasks. Last, but not least, InnoDB complies with the "all-or-nothing" rule – if the entire data modification cannot be completed for some reason, the action is rolled back to prevent confusion or losing data. Magento and the latest editions of Joomla are two examples of popular PHP-powered web apps that have switched over to InnoDB.

InnoDB in Hosting

InnoDB is available with all our hosting plans by default, not as a paid upgrade or upon request, so you will be able to activate and manage any script-based web app that requires the InnoDB database engine without any impediments once you order your shared account. InnoDB will be selected automatically as the default engine for a particular MySQL database during the app installation, irrespective of whether you use our 1-click installer or create the database and activate the app manually, on the condition that the app requires InnoDB instead of the more popular MyISAM engine. We will perform regular backups of all your databases, so you can be certain that you will never lose any content if you erase a database accidentally or you overwrite some vital info – you’ll simply have to touch base with us and we will restore your content the way it was.

InnoDB in Semi-dedicated Servers

InnoDB comes with each of our semi-dedicated hosting plans by default, so once you buy a new account, you can go on and install any PHP script-driven app that requires the MySQL database engine. A few engines are pre-installed on our cloud platform, so when you create a new MySQL database and begin installing an app manually, or decide to use the Hepsia hosting Control Panel-integrated application installer tool, the engine for the database will be set depending on the requirements of the specific app. This will allow you to activate and manage InnoDB-specific applications without experiencing any complication and without changing any settings in your account. To take no chances, we will always have a seven-day-old backup of all your databases, so if you delete or change any content by accident, we can swiftly restore it.

InnoDB in VPS Servers

If our custom-built Hepsia hosting Control Panel is picked during the signup process for a new VPS plans , InnoDB will be installed on the Virtual Private Server together with other necessary software, so you will not have to do anything if you choose to use open-source script-based apps that need this MySQL storage engine. The default MySQL engine – MyISAM, will be installed too. You can set up a brand-new database and begin the app installation manually or using our one-click installer. The system will automatically detect the engine that the application in question requires and will set it for the specific database, so the installation process will continue flawlessly and the application can dump its data in that database. Thus, you can activate applications with various prerequisites concerning the MySQL engine without making any changes on your VPS server.

InnoDB in Dedicated Servers

Our Hepsia Control Panel is among the options which you can pick on the server order page when you buy a dedicated server from our company. Since this is the most powerful type of hosting, it’s quite likely that you’ll manage highly popular Internet sites that will draw a lot of individuals, and since InnoDB is one of the best choices for such Internet sites, we will enable it together with all the other software apps that are available with a Hepsia-managed dedicated server. When you create a brand-new MySQL database in your dedicated server account, there won’t be any active MySQL database storage engine until you start installing a script, whether manually via your browser or using the automatic script installation tool that is available in the hosting Control Panel. The needed engine will be recognized automatically and will be assigned to the database in question, so you can run scripts that need InnoDB, as well as ones that require the default MySQL engine, MyISAM, without the need to deal with any obstacle.