InnoDB is a popular database engine for the MySQL DBMS. It is an alternative to the default MyISAM engine and it has got a lot of pluses that make it the engine of choice for a lot of script-powered apps, including Magento and Joomla, which have switched to InnoDB permanently. For instance, importing huge amounts of data will be faster with InnoDB, due to the fact that it locks only one database row to perform a specific operation, not the entire table, which makes the engine ideal for scalable applications. InnoDB also supports foreign keys and database transactions – these refer to the way in which the information is treated. To put it simply, importing new or editing existent data will either be fully completed, or will be canceled and the procedure will be rolled back in case a given problem appears in the meantime, therefore the content that remains in the database won’t be damaged.

InnoDB in Hosting

You can install any PHP-based web app that requires InnoDB if you have a hosting service with us, as the MySQL database storage engine is present on our innovative cloud hosting platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed flawlessly if this engine is needed. You can install applications which need the MyISAM engine without any problems as well and, once again, the engine will be selected automatically, so you will not need to update any setting manually at any time. What’s more, we’ll also carry out daily backups of all the databases that you have in the account, so in case you delete or overwrite anything, we can swiftly get it back to the way it was on any of the previous seven days.

InnoDB in Semi-dedicated Servers

All our Linux semi-dedicated service support InnoDB and you will be able to get the most out of all the features of this database engine with any script-powered web application that requires it. It is among the engines that we have on our cloud platform, so the one that will be picked depends on the prerequisites of the given application. You won’t have to do anything manually to enable InnoDB, because it will be set as the default engine when you install an app – whether manually or using our single-click application installer tool. To avoid any risk, we will carry out daily backups of all your MySQL databases, so if anything goes wrong after an upgrade or if you delete some data by mistake, we’ll be able to restore your database the way it was on any of the previous seven days.

InnoDB in VPS Servers

In case our in-house developed Hepsia hosting Control Panel is selected during the signup process for a new VPS servers , InnoDB will be activated on the server along with other necessary software, so you will not need to do anything if you choose to manage script-driven apps that need this MySQL database storage engine. MyISAM – the default MySQL engine, will be activated too. You can set up a new database and start installing the application manually or using our one-click installation tool. The system will recognize the engine that the application in question needs and will set it for the specific MySQL database, so the installation process will proceed impeccably and the application can enter its content into that database. Thus, you can make use of apps with various requirements concerning the MySQL engine without the need to make any changes on your VPS.

InnoDB in Dedicated Servers

All dedicated service ordered with our in-house built Hepsia hosting Control Panel come with a software package that is pre-installed and besides everything else, you’ll get the InnoDB storage engine, so you won’t need to add it manually in case you wish to activate open-source scripts that require it. All it takes to install such a script is to set up a new database and to start the installation – as soon as the setup wizard accesses the database and begins importing data into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one needed by the script. You’ll also be able to activate scripts that require the other very popular MySQL engine, MyISAM, so you will not have to modify any settings on the dedicated server. This will permit you to use a variety of scripts on a single physical machine and to use the latter to its fullest potential.