InnoDB is a popular database engine for the MySQL DBMS. It is an alternative to the default MyISAM engine and it has a number of pluses which have made it the preferred engine for lots of script-based apps, including Magento and Joomla™, which have shifted over to InnoDB for good. For example, adding huge data volumes will be much faster with InnoDB, as it locks only a single database row to execute a specific task, not the entire database table, which makes the engine excellent for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the manner in which the data is treated. To put it simply, appending new or editing existing data will either be entirely completed, or will be annulled and the operation will be rolled back if some issue appears during the process, therefore the content that remains in the database won’t be lost.

InnoDB in Hosting

Any PHP script-powered software application that requires InnoDB will run flawlessly on our innovative cloud web hosting platform and the MySQL database storage engine is offered with all our hosting packages. Each time you create a MySQL database manually or our app installer creates one automatically and an app installation is started, the engine that the database in question will use will be selected in accordance with the app’s specifications without the need to configure any setting in your hosting account. InnoDB will be selected automatically for any app that requires this particular engine and you will be able to take advantage of its full capacity. We’ll keep regular backups of your content, so in case you unintentionally remove a MySQL database that’s important to you or you overwrite some part of it, we will be able to restore the database the way it was only a few hours earlier.

InnoDB in Semi-dedicated Servers

You can make use of a script-powered software app that needs InnoDB with any of our semi-dedicated server plans, since all the accounts are created on our cutting-edge cloud hosting platform where the MySQL storage engine is installed. A new database can be set up in two different ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – in case you make use of our one-click application installer. Either way, the needed engine will be selected automatically once the application’s activation starts, so you will not have to change anything manually, irrespective of whether the application requires InnoDB or the more widely used MyISAM. Also, we will always be able to recover any of your MySQL databases if you erase one by mistake, as we generate a few MySQL database backups every day, each of which is preserved for 7 days.

InnoDB in VPS Servers

All Linux VPS web hosting service that are ordered with the Hepsia Control Panel come with InnoDB already activated, so you’ll be able to run any open-source script-driven application that needs this particular database storage engine without needing to install anything manually. You can select Hepsia on the VPS configuration page and your brand-new VPS server will be set up within 1 hour, so you can sign in and start setting up your sites straight away. Once you create a new MySQL database and start the app installation process, our system will set the engine for that MySQL database automatically. Thus, you can use different apps at the same time without the need to modify anything on the VPS server. You can have a WordPress personal blog that makes use of MyISAM – the default MySQL engine, and a Magento shopping portal that uses InnoDB, for example.

InnoDB in Dedicated Servers

When you acquire a new dedicated server, you’ll be able to choose any of the 3 hosting Control Panels that we are offering – cPanel, Hepsia and DirectAdmin. Any server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you won’t have to add this database storage engine manually in order to be able to manage PHP script-based software apps that need it. InnoDB is used by scalable apps and since a dedicated server will offer you all the server resources that you require to manage large-scale Internet sites, it is rather likely that you will use InnoDB. You will be able to use other engines as well, so if a given app needs MyISAM instead of InnoDB, you will not run into any difficulty while running it. The engine that will be used will be automatically recognized the moment the app installation process commences, so you won’t need to configure any setting manually at any time.