InnoDB is a very popular database storage engine for the MySQL DBMS. 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 lots of open-source script-based web apps, including Magento and Joomla™, which have switched to InnoDB permanently. For instance, importing enormous amounts of data will be much faster with InnoDB, as it locks only one database row to execute an operation, not the entire table, which makes the engine ideal for scalable apps. It also supports foreign keys and database transactions – these refer to the way in which the information is treated. In simpler words, appending new or updating existent data will either be fully completed, or will be annulled and the procedure will be rolled back in case a certain problem appears in the meantime, which means that the content that remains in the database won’t be lost.

InnoDB in Shared Hosting

Any PHP-powered application that needs InnoDB will function impeccably on our advanced cloud website hosting platform and the MySQL storage engine is offered with all our shared hosting packages. Each time you create a MySQL database manually or our app installer creates one automatically and an app installation process is started, the engine that the database in question will make use of will be selected on the basis of the app’s specifications without having to edit any setting in your shared account. InnoDB will be picked automatically for any app that requires this particular engine and you will be able to take advantage of its full capacity. We’ll store daily backups of your content, so in case you accidentally erase a MySQL database that you need or you overwrite some part of it, we’ll be able to restore your database the way it was only several hours ago.

InnoDB in Semi-dedicated Hosting

InnoDB is available with all our semi-dedicated hosting by default, so as soon as you order a new account, you can go ahead and activate any PHP-powered web app that needs this particular MySQL storage engine. A couple of engines are pre-installed on our cloud platform, so when you create a new MySQL database and begin installing an application manually, or decide to use the Hepsia Control Panel-integrated application installer, the engine for the database will be chosen based on the requirements of the specific application. This will permit you to install and run InnoDB-specific apps without the need to cope with any impediment and without configuring any settings in your account. To be on the safe side, we will always keep a one-week-old backup of all your MySQL databases, so if you delete or change any content by mistake, we can swiftly retrieve it.

InnoDB in VPS

If our custom Hepsia hosting Control Panel is picked during the signup process for a new Linux virtual private servers , InnoDB will be activated on the VPS server along with other required software, so you will not need to do anything if you decide to use PHP script-driven applications that need this MySQL database storage engine. MyISAM, the default MySQL engine, will be activated as well. You can set up a brand-new database and begin installing the application manually or using our one-click installer tool. The system will recognize which engine the application in question requires and will assign it to the specific MySQL database, so the installation will continue impeccably and the application can dump its data in that database. Therefore, you can activate applications with different requirements concerning the MySQL engine without having to make any changes on your VPS.

InnoDB in Dedicated Hosting

InnoDB is included by default with all Linux dedicated hosting that are ordered with the Hepsia Control Panel. It’s an essential part of the default software bundle that we install on all Hepsia-equipped dedicated servers, so as soon as your physical machine is set up, you will be able to sign in and to activate any script-based web application that requires this MySQL database engine. When you set up a new database through the hosting Control Panel, there won’t be any active engine until you begin installing an app. Once the app setup wizard starts importing content into the newly created database, the engine will be chosen automatically depending on the prerequisites of the respective application, so you can use both InnoDB and MyISAM without the need to select either of them explicitly at any time. Thus, you can make use of a broad range of applications for your Internet sites.