InnoDB is a popular storage engine for the MySQL database management system. It is an alternative to the default engine – MyISAM, and it has lots of upsides that have made it the preferred engine for a lot of script-driven web apps, such as Magento and Joomla, which have switched to InnoDB for good. For example, adding huge data volumes will be faster with InnoDB, as it locks only one database row to carry out a given task, not the entire database table, which makes the engine ideal for scalable apps. It also supports foreign keys and transactions – these refer to the manner in which the info is handled. To put it simply, appending new or modifying existent data will either be fully completed, or will be aborted and the procedure will be rolled back in case a given issue occurs during the process, which is why the content that remains in the database will not be lost.

InnoDB in Shared Hosting

Any PHP script-based software application that requires InnoDB will function impeccably on our advanced cloud web hosting platform and the database engine is available with all our shared hosting packages. Every time you create a database manually or our app installer tool creates one automatically and an app installation is initiated, the engine that the database in question will make use of will be selected based on the app’s prerequisites without the need to modify any setting in your hosting account. InnoDB will be selected automatically for any app that requires this specific engine and you will be able to make the most of its full capacity. We will create daily content backups, so if you unintentionally remove a database that is important to you or you overwrite some part of it, we will be able to restore your database the way it was just a couple of hours ago.

InnoDB in Semi-dedicated Servers

You can use a script-driven web application that requires InnoDB with any of our semi-dedicated server packages, because all the accounts are created on our cutting-edge cloud web hosting platform where the database storage engine is installed. A new database can be set up in two ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – if you take advantage of our single-click app installer tool. In either case, the required engine will be selected automatically as soon as the app’s activation begins, so you will not need to update anything manually, irrespective of whether the application requires InnoDB or the more commonly used MyISAM. Furthermore, we’ll always be able to restore any of your databases if you unintentionally erase one, as we carry out several MySQL database backups every day, each of which is kept for one whole week.

InnoDB in VPS Servers

In case our custom-developed Hepsia Control Panel is chosen during the signup process for your new VPS servers , InnoDB will be activated on the VPS server together with other necessary pieces of software, so you won’t have to do anything if you choose to use PHP-driven software apps that require this MySQL database engine. The default MySQL engine – MyISAM, will be activated as well. You can create a brand new MySQL database and start installing the app manually or using our one-click installer. The system will automatically recognize the engine that the particular app requires and will assign it to the specific database, so the installation will continue impeccably and the application can insert its content into that database. Therefore, you can activate applications with different prerequisites with regard to the MySQL engine without making any modifications on your VPS server.

InnoDB in Dedicated Servers

All dedicated servers ordered with our custom Hepsia hosting Control Panel include a software package that’s pre-activated and besides everything else, you will get the InnoDB storage engine, so you will not need to add it manually in case you want to run scripts that require it. All it takes to run such a script is to set up a new MySQL database and to begin the installation – once the setup wizard gains access to the database and begins importing data into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one needed by the script. You will also be able to run scripts that need the other widely used MySQL engine – MyISAM, so you won’t have to update any settings on the server. This will permit you to run various scripts on one single physical machine and to use the latter to its full capacity.