InnoDB is a very popular storage engine for the MySQL database management system. It is an alternative to the default engine – MyISAM, and it has a lot of strong sides which have made it the preferred engine for lots of PHP script-based apps, among them Magento and Joomla, which have switched to InnoDB permanently. For instance, importing huge amounts of data will be faster with InnoDB, because it locks only one row to accomplish a given task, not the entire table, which makes the engine ideal for scalable apps. InnoDB also supports foreign keys and database transactions – these refer to the manner in which the data is treated. To put it simply, adding new or modifying existent data will either be thoroughly completed, or will be canceled and the operation will be rolled back if a given problem occurs in the meantime, thus the content that remains in the database will not be damaged.

InnoDB in Cloud Web Hosting

InnoDB is offered with all our cloud web hosting by default, not as a paid upgrade or upon request, so you can install and run any script-based application which needs the MySQL storage engine without having to deal with any problem once you activate your shared web hosting account. InnoDB will be selected automatically as the default engine for a certain MySQL database during the app activation, irrespective of whether you make use of our 1-click installer or create the database and set up the application manually, on the condition that the application requires it instead of the more famous MyISAM engine. We will store daily backups of all your MySQL databases, so you can be certain that you won’t ever lose any data if you delete a database by accident or you overwrite some crucial info – you simply have to get in touch with us and we will restore your database the way it was.

InnoDB in Semi-dedicated Hosting

You can use a script-powered web app that requires InnoDB with all of our semi-dedicated server packages, due to the fact that all the accounts are set up on our leading-edge cloud hosting platform where the MySQL database engine is installed. A new MySQL database can be created in two separate ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – if you use our one-click app installer tool. Either way, the needed engine will be chosen automatically once the installation of the application begins, so you will not have to change anything manually, no matter if the app requires InnoDB or the more widely used MyISAM. Furthermore, we will always be able to retrieve any of your MySQL databases in case you unintentionally remove one, as we carry out a couple of MySQL database backups every day, each of which is preserved for 7 days.

InnoDB in VPS Web Hosting

If our in-house built Hepsia hosting Control Panel is selected during the registration process for a new Linux VPS web hosting packages , InnoDB will be installed on the VPS server along with other required pieces of software, so you will not need to do anything if you choose to manage PHP-based software apps that require this MySQL database storage engine. The default MySQL engine – MyISAM, will be activated too. You can create a brand new MySQL database and start the app installation manually or using our 1-click installation tool. The system will detect the engine that the app in question needs and will set it for the specific MySQL database, so the installation process will proceed impeccably and the application can insert its content into that database. In this way, you can activate apps with different prerequisites regarding the MySQL engine without making any changes on your server.

InnoDB in Dedicated Servers Hosting

If you purchase a new dedicated server, you will be able to select one of the three Control Panels offered by us – DirectAdmin, cPanel and Hepsia. Any dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you won’t need to enable this MySQL database storage engine manually so as to be able to run open-source script-driven web applications that require it. InnoDB is used for scalable applications and since a dedicated server will provide you with all the resources that you need to run large-size websites, it is quite possible that you will use InnoDB. You’ll be able to use other engines too, so if a specific app needs MyISAM instead of InnoDB, you won’t have to deal with any impediment while running it. The engine that will be used will be automatically detected when the app installation begins, so you will not need to update any setting manually at any moment.