InnoDB is a MySQL storage engine, which has been gaining in popularity lately, as it offers a better overall performance and a faster database crash recovery compared to the default engine used by the MySQL database management system – MyISAM. InnoDB is used by numerous developers that run scalable web apps, since it works more efficiently with enormous data volumes, while it keeps the server processing load low. What’s more, it it locks only one row in the database in case any info should be edited, while lots of other engines lock the entire database table and hence need much more time to accomplish several sequential tasks. Last, but not least, InnoDB adheres to the "all-or-nothing" rule – in case the entire data modification procedure cannot be completed successfully for any reason, the action is rolled back to avoid confusion or data loss. Magento and the latest editions of Joomla™ are two instances of widely used PHP script-driven applications that have shifted over to InnoDB.
InnoDB in Shared Hosting
Any PHP script-driven web application that requires InnoDB will run impeccably on our innovative cloud platform and the MySQL storage engine is offered with all our shared hosting plans. Whenever you create a MySQL database manually or our app installer creates one automatically and an app installation process is started, the engine that the database will use will be selected in accordance with the app’s prerequisites without the need to change any setting in your account. InnoDB will be chosen automatically for any application that requires this particular engine and you’ll be able to make the most of its full capacity. We’ll perform regular content backups, so in case you accidentally remove a database that you need or you overwrite some part of it, we will be able to restore your content the way it was only a few hours ago.
InnoDB in Semi-dedicated Servers
InnoDB is available with all our Linux semi-dedicated hosting service by default, so the moment you obtain a new semi-dedicated account, you can go on and install any PHP script-based application that needs this storage engine. A few engines are pre-installed on our cloud hosting platform, so when you set up a brand-new database and begin installing an application manually, or opt to use the Hepsia hosting Control Panel-integrated application installer tool, the engine for the database will be picked on the basis of the requirements of the respective app. This will allow you to install and manage InnoDB-specific apps without any problem and without having to edit any settings in your semi-dedicated account. To take no chances, we will always keep a 1-week-old backup of all your databases, so if you delete or alter any content unintentionally, we can easily rescue it.
InnoDB in VPS Servers
If our custom-developed Hepsia Control Panel is chosen during the signup process for a new VPS servers , InnoDB will be activated on the Virtual Private Server together with other required software, so you won’t have to do anything if you choose to activate script-powered apps that need this MySQL database engine. MyISAM – the default MySQL engine, will be installed too. You can create a brand new database and start the app installation process manually or through our one-click installer tool. The system will recognize which engine the particular application needs and will assign it to the specific database, so the installation will continue impeccably and the application can enter its content into that database. Therefore, you can install apps with various requirements concerning the MySQL engine without making any changes on your Virtual Private Server.
InnoDB in Dedicated Servers
InnoDB is available as standard with all dedicated service that are ordered with the Hepsia Control Panel. It’s an essential part of the default software package that we install on all Hepsia-managed servers, so as soon as your physical machine is ready, you will be able to log in and to install any kind of PHP-driven web application that requires this particular database storage engine. When you create a new MySQL database via the hosting Control Panel, there won’t be any activated engine till you begin installing an app. As soon as the app setup wizard starts entering content into the database, the engine will be set automatically in accordance with the requirements of the respective application, so you can run both InnoDB and MyISAM without the need to select either one of them explicitly at any point. Therefore, you can use an extensive variety of applications for your websites.