InnoDB is a very popular database storage engine for the MySQL RDBMS. It’s an alternative to the default MyISAM engine and it has many strengths which have made it the preferred engine for numerous open-source script-based software applications, such as Magento and Joomla, which have switched to InnoDB permanently. For instance, adding large amounts of data will be faster with InnoDB, because it locks only one row to execute a particular task, not the entire 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. Put simply, adding new or modifying existing data will either be thoroughly completed, or will be canceled and the procedure will be rolled back in case any issue occurs during the process, therefore the content that remains in the database will not be lost.

InnoDB in Shared Hosting

InnoDB is available with all our shared hosting plans by default, not as a paid upgrade or upon request, so you’ll be able to install and manage any PHP script-based web app which needs the storage engine without the need to deal with any complication as soon as you activate your shared account. InnoDB will be selected automatically as the default engine for a particular database during the app activation, irrespective of whether you make use of our single-click installer or create the MySQL database and activate the app manually, on the condition that the app requires InnoDB instead of the more popular MyISAM engine. We will store daily database backups, so you can be certain that you won’t ever lose any content if you delete a database accidentally or you overwrite some vital info – you’ll just need to alert us and we will restore the database back to normal.

InnoDB in Semi-dedicated Servers

You can make use of an open-source script-based software app that needs InnoDB with all of our semi-dedicated server plans, since all the accounts are created on our advanced cloud platform where the MySQL storage engine is installed. A new database can be set up in two separate ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you take advantage of our one-click app installer. Either way, the needed engine will be selected automatically the moment the installation of the application starts, so you will not have to configure anything manually, no matter if the application needs InnoDB or the more widely used MyISAM. On top of that, we’ll always be able to retrieve any of your MySQL databases if you remove one by mistake, as we create a couple of MySQL database backups every day, each of which is preserved for seven days.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is among the features which you can choose on the server order page when you buy a dedicated server from us. Since this is the most powerful kind of hosting, it is quite likely that you will run highly popular websites that will draw plenty of visitors, and since InnoDB is one of the very best choices for such Internet sites, we will install it together with all the other software apps that are available with a Hepsia-managed dedicated server. When you set up a brand new database in your dedicated account, there won’t be any active MySQL storage engine until you start installing an open-source script, whether manually via your web browser or using the automatic scripts installation tool that is included in the hosting Control Panel. The needed engine will be detected and will be set for that database, so you can install scripts that need InnoDB, as well as ones that need the default MySQL engine – MyISAM, without the need to cope with any difficulty.