InnoDB is a popular database storage engine for the MySQL RDBMS. It is an alternative to the default engine – MyISAM, and it has got numerous pluses which have made it the engine of choice for lots of PHP-based software apps, such as Magento and Joomla, which have shifted over to InnoDB permanently. For example, adding large volumes of data will be much faster with InnoDB, as it locks only one database row to execute a given operation, not the entire table, which makes the engine perfect for scalable applications. It also supports foreign keys and transactions – these refer to the way in which the information is treated. Simply put, appending new or editing existent data will either be fully completed, or will be canceled and the procedure will be rolled back in case a certain issue appears in the meantime, thus the content that remains in the database won’t be damaged.

InnoDB in Cloud Hosting

You can install any PHP script-driven app that needs InnoDB in case you have a Linux cloud hosting with us, as the storage engine is available on our leading-edge cloud platform as standard. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed impeccably in case this engine is needed. You can install apps that require the MyISAM engine without any problem as well and, again, the engine will be selected automatically, so you won’t need to update any setting manually at any point. What’s more, we will also make daily backups of all the MySQL databases that you’ve got in the account, so in case you delete or overwrite something, we can quickly restore it the way it was on any of the previous seven days.

InnoDB in Semi-dedicated Hosting

If you set up a new MySQL database from the hosting Control Panel offered with each of our semi-dedicated server accounts and you begin installing a PHP script-based application either manually or using our one-click app installer tool, the storage engine for the MySQL database will be set automatically depending on the requirements of the specific application. Since InnoDB is available on the cloud web hosting platform where your new semi-dedicated account will be set up, it will be set as the default engine for any app that requires it without any manual intervention needed on your end at any moment. To avoid any risk of losing information if you update an application or if you delete a database unintentionally, we’ll generate backups of all your MySQL databases every day, so if something goes wrong, we can recover your data.

InnoDB in VPS

All Linux VPS that are ordered with the Hepsia hosting Control Panel come with InnoDB already activated, so you’ll be able to use any script-driven application that needs this MySQL database storage engine without setting up anything manually. You can select Hepsia on the VPS order form and your new VPS server will be ready within one hour, so you can log in and begin setting up your websites right away. When you create a brand new database and begin the app installation process, our system will select the engine for that database automatically. Thus, you can make use of different apps simultaneously without having to configure anything on the Virtual Private Server. You can have a WordPress-based personal journal that makes use of the default MySQL engine – MyISAM, and a Magento e-commerce portal that makes use of the InnoDB engine, for example.

InnoDB in Dedicated Hosting

If you obtain a new dedicated server, you’ll be able to select any of the 3 hosting Control Panels offered by our company – Hepsia, cPanel and DirectAdmin. Each dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you won’t have to enable this MySQL database engine manually in order to be able to run open-source script-powered apps that require it. InnoDB is used for scalable apps and since a dedicated server will supply you with all the resources that you need in order to run large-scale Internet sites, it’s very likely that you’ll resort to InnoDB. You’ll be able to make use of other engines too, so in case a given app needs MyISAM instead of InnoDB, you won’t experience any problem while running it. The engine that will be used will be detected automatically the moment the app installation process commences, so you will not have to alter any settings manually at any point.