InnoDB is a very popular storage engine for the MySQL database management system. It is an alternative to the default MyISAM engine and it has numerous upsides which make it the preferred engine for many script-driven applications, including Magento and Joomla, which have shifted over to InnoDB permanently. For example, importing huge data volumes will be much faster with InnoDB, since it locks only one row to execute a specific task, not the entire table, which makes the engine ideal for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the way in which the information is handled. Simply put, appending new or modifying existent data will either be fully completed, or will be aborted and the procedure will be rolled back in case a given problem shows up during the process, which is why the content that remains in the database will not be lost.

InnoDB in Website Hosting

Any PHP-powered web application that needs InnoDB will function flawlessly on our avant-garde cloud website hosting platform and the MySQL database storage engine comes with all our website hosting packages. Each time you create a database manually or our app installer tool creates one automatically and an app installation is started, the engine that the database in question will make use of will be selected based on the app’s specifications without the need to change any setting in your shared hosting account. InnoDB will be selected automatically for any application that requires this specific engine and you will be able to take advantage of its full potential. We will keep regular content backups, so if you unintentionally delete a database that you need or you overwrite certain parts of it, we will be able to restore everything the way it was only a few hours ago.

InnoDB in Semi-dedicated Hosting

You can make use of a script-powered web application that needs InnoDB with any of our semi-dedicated server packages, since all the accounts are set up on our avant-garde cloud platform where the MySQL database engine is installed. A new database can be created in two ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – if you use our one-click app installer. In either case, the required engine will be chosen automatically as soon as the application’s installation starts, so you won’t need to edit anything manually, regardless of whether the app requires InnoDB or the more commonly used MyISAM. Furthermore, we’ll always be able to restore any of your MySQL databases if you accidentally remove one, as we make several backups every day, each of which is preserved for seven days.

InnoDB in Dedicated Web Hosting

InnoDB is available as standard with all Linux dedicated web hosting that are ordered with the Hepsia Control Panel. It’s an integral part of the standard software bundle that will be pre-installed on all Hepsia-managed servers, so as soon as your physical machine is ready, you will be able to log in and to install a various PHP script-based web application that needs this MySQL database engine. When you set up a new database through the Control Panel, there won’t be any activated engine till you begin installing an app. Once the app activation wizard begins dumping data in the database, the engine will be picked automatically on the basis of the prerequisites of the particular application, so you can use both MyISAM and InnoDB without selecting either of them explicitly at any time. Therefore, you can use a huge range of apps for your websites.