InnoDB is a popular database storage engine for the MySQL database management system. It is an alternative to the default engine – MyISAM, and it has got numerous advantages that make it the engine of choice for lots of open-source script-based software applications, among them Magento and Joomla™, which have switched over to InnoDB permanently. For instance, adding enormous data volumes will be faster with InnoDB, because it locks only a single row to complete an operation, not the entire database table, which makes the engine ideal for scalable apps. It also supports foreign keys and database transactions – these refer to the manner in which the information is handled. In simpler words, appending new or modifying existent data will either be thoroughly completed, or will be aborted and the procedure will be rolled back in case a certain issue occurs during the process, which means that the content that remains in the database will not be lost.

InnoDB in Web Hosting

You will be able to make use of any script-powered web app that requires InnoDB if you have a web hosting plan with us, as the database engine is present on our leading-edge cloud web hosting platform as standard. During 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 run applications which require the MyISAM engine without any impediments as well and, again, the engine will be selected automatically, so you won’t need to configure any setting manually at any point. What’s more, we will also carry out daily backups of all the MySQL databases that you have in the shared web hosting account, so in case you erase or overwrite something, we can quickly restore it the way it was on any of the previous 7 days.

InnoDB in Semi-dedicated Servers

If you create a brand-new MySQL database from the hosting Control Panel provided with each of our semi-dedicated server accounts and you begin installing an open-source script-based application either manually or using our single-click application installer, the storage engine for the MySQL database will be picked automatically depending on the requirements of the particular application. As InnoDB is available on the cloud platform where your new semi-dedicated account will be created, it will be set as the default engine for each app that requires it without the need for any manual intervention on your end at any time. To prevent any chance of losing information if you update an app or if you erase a database by mistake, we will perform a backup of all your databases every day, so if anything goes wrong, we can retrieve your data.

InnoDB in Dedicated Servers

If you acquire a new dedicated server, you’ll be able to choose one of the three hosting Control Panels that we are offering – Hepsia, DirectAdmin and cPanel. Each dedicated server ordered with Hepsia comes with InnoDB pre-activated, so you won’t need to add this MySQL storage engine manually to be able to run PHP script-powered apps that require it. InnoDB is used for scalable applications and since a dedicated server will provide you with all the server resources that you need to manage large-size Internet sites, it is very likely that you’ll use InnoDB. You will be able to use other engines as well, so in case a specific app needs MyISAM instead of InnoDB, you won’t need to deal with any difficulty while using it. The engine that will be used will be detected automatically the moment the app installation begins, so you will not have to configure any settings manually at any moment.