InnoDB is a popular storage engine for the MySQL RDBMS. It is an alternative to the default MyISAM engine and it has a lot of strengths that make it the preferred engine for plenty of PHP script-driven software apps, among them Magento and Joomla, which have switched to InnoDB permanently. For instance, adding large volumes of data will be much faster with InnoDB, as it locks only a single database row to carry out a certain task, not the entire database table, which makes the engine ideal for scalable apps. It also supports foreign keys and transactions – these refer to the way in which the data is treated. Simply put, appending new or modifying existing data will either be fully completed, or will be annulled and the operation will be rolled back if any problem shows up during the process, which means that the content that remains in the database won’t be damaged.

InnoDB in Shared Hosting

Every open-source script-powered application that needs InnoDB will run impeccably on our avant-garde cloud hosting platform and the MySQL database engine comes with all our shared hosting packages. Whenever you create a database manually or our app installer tool creates one automatically and an app installation process is initiated, the engine that the database will use will be selected in accordance with the app’s prerequisites without the need to update any setting in your hosting account. InnoDB will be chosen automatically for any app that requires this specific engine and you’ll be able to get the most out of its full potential. We will keep daily backups of your content, so if you accidentally remove a MySQL database that you need or you overwrite a certain part of it, we’ll be able to restore your database the way it was only a couple of hours earlier.

InnoDB in Semi-dedicated Servers

You can make use of a PHP-driven software app that needs InnoDB with any of our semi-dedicated server packages, since all the accounts are set up on our avant-garde cloud hosting platform where the storage engine is installed. A new MySQL database can be set up in two ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – in case you use our one-click app installer tool. Either way, the required engine will be picked automatically the moment the installation of the application starts, so you will not need to edit anything manually, irrespective of whether the app requires InnoDB or the more commonly used MyISAM. Also, we’ll always be able to retrieve any of your databases in case you accidentally erase one, as we create a couple of database backups every day, each of which is saved for seven days.

InnoDB in VPS Servers

If our custom-built Hepsia Control Panel is picked during the registration process for your new VPS servers , InnoDB will be activated on the server together with other essential software, so you will not need to do anything if you decide to manage PHP-powered web applications that require this MySQL database engine. MyISAM – the default MySQL engine, will be installed too. You can create a brand-new database and begin installing the application manually or through our one-click installer tool. The system will automatically recognize the engine that the application in question needs and will assign it to the specific MySQL database, so the installation will proceed flawlessly and the app can insert its data into that database. Thus, you can make use of applications with different requirements concerning the MySQL engine without making any modifications on your server.

InnoDB in Dedicated Servers

InnoDB is available by default with all dedicated servers that are ordered with the Hepsia hosting Control Panel. It is part of the software bundle that will be installed on all Hepsia-managed dedicated servers, so as soon as your machine is up and running, you will be able to log in and to install any kind of PHP-driven software app that requires this MySQL database storage engine. If you set up a new MySQL database via the hosting Control Panel, there won’t be any active engine until you start installing an app. Once the app setup wizard begins importing information into the database, the engine will be chosen automatically based on the requirements of the respective application, so you can use both MyISAM and InnoDB without the need to select either of them explicitly at any time. In this way, you can make use of a large variety of apps for your Internet sites.