InnoDB is a popular database engine for the MySQL relational database management system. It is an alternative to the default MyISAM engine and it has got many upsides that make it the preferred engine for lots of PHP-driven applications, among them Joomla™ and Magento, which have shifted over to InnoDB permanently. For instance, importing immense data volumes will be much faster with InnoDB, due to the fact that it locks only one row to carry out a given task, not the entire table, which makes the engine ideal for scalable apps. InnoDB also supports foreign keys and database transactions – these refer to the manner in which the info is treated. In simpler words, adding new or updating existing data will either be entirely completed, or will be canceled and the procedure will be rolled back in case some issue shows up in the meantime, thus the content that remains in the database will not be lost.

InnoDB in Shared Hosting

Any PHP script-driven web app that needs InnoDB will run flawlessly on our avant-garde cloud hosting platform and the MySQL database engine comes with all our shared hosting plans. Each time you create a MySQL database manually or our app installer creates one automatically and an app installation is initiated, the engine that the database will make use of will be selected in accordance with the app’s prerequisites without the need to update any setting in your shared web hosting account. InnoDB will be chosen automatically for any application that requires this specific engine and you’ll be able to take advantage of its full capacity. We’ll keep regular backups of your content, so if you unintentionally remove a MySQL database that you need or you overwrite a certain part of it, we will be able to restore the database the way it was only a couple of hours earlier.

InnoDB in Semi-dedicated Hosting

You can install a PHP script-powered web app that needs InnoDB with all of our semi-dedicated server packages, as all the accounts are created on our cutting-edge cloud web hosting platform where the storage engine is installed. A new database can be created in two separate ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you make use of our one-click app installer. Either way, the needed engine will be chosen automatically as soon as the app’s installation starts, so you will not have to update anything manually, no matter if the application needs InnoDB or the more commonly used MyISAM. Also, we will always be able to retrieve any of your MySQL databases if you erase one by mistake, as we generate a couple of MySQL database backups every day, each of which is saved for seven days.

InnoDB in VPS

When you acquire a virtual private server from our company, you’ll be able to make use of our custom-developed Hepsia hosting Control Panel to manage your content. A Hepsia-managed Virtual Private Server will allow you to run any script-driven web application which requires InnoDB, as this particular storage engine is an essential part of the software bundle that will be pre-installed on your VPS server during its creation. When you create a brand new database using the Control Panel, you just need to begin installing an app – manually or using our app installer. InnoDB will be set as the default engine on the condition that the app in question requires it, so you will not have to do anything else in your account. Equivalently, if a certain application needs MyISAM, it will be automatically set as the default engine for this particular MySQL database.

InnoDB in Dedicated Hosting

InnoDB is available as standard with all dedicated servers hosting packages that are ordered with the Hepsia Control Panel. It’s part of the default software package that will be installed on all Hepsia-managed servers, so once your physical machine is assembled, you’ll be able to sign in and to install any kind of PHP script-based application that needs this database engine. If you create a new database through the hosting Control Panel, there won’t be any activated engine until you start installing an app. Once the app installation wizard starts dumping information in the database, the engine will be set automatically depending on the prerequisites of the respective app, so you can run both InnoDB and MyISAM without selecting either one of them specifically at any time. Therefore, you can use an extensive collection of apps for your sites.