InnoDB is a database storage engine for MySQL relational databases, which is used by popular open-source script-driven applications such as Magento and Joomla™ 3.x. It is excellent for scalable apps, because it works exceptionally well when handling immense data volumes. Instead of locking the whole database table to insert new information in a database as many other engines do, InnoDB locks only one database row, so it can carry out a lot more tasks for the same length of time. Plus, InnoDB offers a faster crash recovery and supports database transactions and foreign keys – rules that specify how data inserts and modifications should be treated. In case a given task hasn’t been entirely completed for some reason, the action will be rolled back. Thus, the database content will remain safe and sound and won’t be partially mixed with newly added content.

InnoDB in Hosting

Every PHP script-powered software application that requires InnoDB will run impeccably on our innovative cloud hosting platform and the MySQL database engine is offered with all our hosting packages. Every 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 based on the app’s requirements without having to update any setting in your hosting account. InnoDB will be chosen automatically for any app that requires this particular engine and you will be able to take advantage of its full potential. We will carry out daily content backups, so in case you accidentally remove a MySQL database that is important to you or you overwrite specific parts of it, we will be able to restore your database the way it was just a couple of hours earlier.

InnoDB in Semi-dedicated Hosting

All our semi-dedicated hosting support InnoDB and you can take full advantage of all the features of this MySQL storage engine with any PHP-driven web application that needs it. InnoDB is one of the engines that are available on our cloud hosting platform, so the one that will be used depends on the requirements of the given application. You will not need to do anything manually to activate InnoDB, since it will be set as the default engine whenever you install an application – whether manually or using our one-click app installer tool. To avoid any risk, we’ll generate daily database backups, so if something goes wrong after an upgrade or if you remove some content unintentionally, we will be able to restore your database the way it was on any of the previous 7 days.

InnoDB in VPS Web Hosting

When you acquire a virtual private server from our company, you’ll be able to use our in-house developed Hepsia hosting Control Panel to manage your web content. A Hepsia-managed VPS will allow you to run any PHP script-driven web application which needs InnoDB, as this database storage engine is included in the standard software bundle that will be pre-installed on the VPS server during its creation. When you create a brand new MySQL database using the hosting Control Panel, you will simply have to begin installing an application – manually or using our application installer tool. InnoDB will be set as the default engine as long as the application in question requires it, so you won’t need to do anything else in your account. Analogously, if a certain application needs MyISAM, it will be automatically set as the default engine for this specific database.

InnoDB in Dedicated Servers Hosting

All Linux dedicated servers hosting that are ordered with our in-house developed Hepsia Control Panel come with a software bundle that’s pre-installed and besides everything else, you’ll get the InnoDB database engine, so you will not have to activate it manually if you want to use open-source scripts that need it. All it takes to use such a script is to create a new database and to begin the setup – as soon as the installer wizard acquires access to the database in question and starts dumping data in it, InnoDB will be set as the default MySQL engine for this database provided that it is the one required by the particular script. You will also be able to activate scripts that need MyISAM – the other very popular MySQL engine, so you won’t need to edit any settings on the server. This will enable you to run different scripts on one single physical machine and to use the latter to its fullest capabilities.