InnoDB is a popular database engine for the MySQL database management system. It’s an alternative to the default MyISAM engine and it has got lots of upsides that have made it the engine of choice for many PHP-based web applications, including Joomla and Magento, which have shifted over to InnoDB for good. For instance, importing immense data volumes will be faster with InnoDB, as it locks only a single row to execute a given task, not the entire database table, which makes the engine ideal for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the manner in which the data is treated. Put simply, appending new or editing existent data will either be entirely completed, or will be canceled and the procedure will be rolled back in case a given problem appears in the meantime, so the content that remains in the database will not be damaged.

InnoDB in Hosting

You’ll be able to run any script-driven web application that requires InnoDB in case you have a Linux hosting package with us, as the MySQL database storage engine is present on our leading-edge cloud hosting platform by default. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed flawlessly if this engine is needed. You can install apps which need the MyISAM engine without encountering any obstacle as well and, again, the engine will be selected automatically, so you won’t have to modify any setting manually at any point. On top of that, we’ll also generate daily backups of all the MySQL databases that you have in the shared account, so in case you delete or overwrite anything, we can swiftly get it back to the way it was on any of the past seven days.

InnoDB in Semi-dedicated Hosting

If you set up a brand-new MySQL database through the Control Panel provided with each of our semi-dedicated server packages and you start installing a PHP-driven app either manually or using our one-click app installer tool, the storage engine for the database will be picked automatically depending on the requirements of the specific application. As InnoDB is available on the cloud website hosting platform where your new account will be created, it will be set as the default engine for any application that requires it without the need for any manual action on your end at any moment. To avoid any risk of losing information if you update an application or if you erase a database by accident, we’ll carry out a backup of all your MySQL databases each day, so if anything happens, we can rescue your content.

InnoDB in VPS Web Hosting

In case our custom-developed Hepsia Control Panel is picked during the signup process for your new Linux VPS web hosting packages , InnoDB will be activated on the VPS server together with other needed pieces of software, so you won’t need to do anything if you decide to make use of script-powered applications that need this MySQL database storage engine. The default MySQL engine, MyISAM, will be activated too. You can create a new MySQL database and start installing the app manually or using our 1-click installer. The system will automatically detect the engine that the particular app requires and will set it for the specific database, so the installation will proceed impeccably and the app can dump its data in that database. Thus, you can install applications with various prerequisites with regard to the MySQL engine without having to make any changes on your VPS.

InnoDB in Dedicated Servers Hosting

InnoDB comes as standard with all Linux dedicated servers hosting that are ordered with the Hepsia hosting Control Panel. It is an essential part of the default software package that we install on all Hepsia-managed servers, so as soon as your physical machine is assembled, you’ll be able to log in and to install any kind of open-source script-powered web app that needs this particular database engine. If you create a new database via the hosting Control Panel, there won’t be any activated engine till you begin installing an app. Once the app installation wizard starts inserting information into the database, the engine will be chosen automatically in accordance with the prerequisites of the given app, so you can run both MyISAM and InnoDB without having to select either of them specifically at any point. In this way, you can make use of a wide selection of apps for your sites.