InnoDB is a very popular database engine for the MySQL relational database management system. It is an alternative to the default engine – MyISAM, and it has got lots of upsides that have made it the engine of choice for numerous PHP script-powered software applications, such as Joomla and Magento, which have moved to InnoDB for good. For example, adding huge data volumes will be faster with InnoDB, due to the fact that it locks only a single database row to accomplish a particular task, not the entire database table, which makes the engine excellent for scalable applications. It also supports foreign keys and transactions – these refer to the way in which the information is tackled. To put it simply, appending new or modifying existing data will either be thoroughly completed, or will be annulled and the operation will be rolled back if a certain issue shows up during the process, which means that the content that remains in the database won’t be lost.

InnoDB in Cloud Hosting

InnoDB is offered with all our Linux cloud hosting by default, not upon request or as a paid upgrade, so you’ll be able to activate and run any open-source script-based software application which requires the storage engine without the need to deal with any obstacle once you open your shared hosting account. InnoDB will be selected automatically as the default engine for a specific MySQL database during the app installation process, no matter if you take advantage of our single-click installation tool or create the MySQL database and install the app manually, provided that the app requires InnoDB instead of the more popular MyISAM engine. We’ll perform daily backups of all your MySQL databases, so you can be certain that you will never lose any content if you erase a database unintentionally or you overwrite some vital information – you simply have to notify us and we’ll restore your content back to normal.

InnoDB in Semi-dedicated Servers

You can make use of a script-powered software application that needs InnoDB with any of our semi-dedicated server packages, because all the accounts are created on our advanced cloud web hosting platform where the database storage engine is installed. A new database can be created in two different ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – if you make use of our 1-click application installer. Either way, the required engine will be chosen automatically once the app’s activation starts, so you won’t need to change anything manually, regardless of whether the app needs InnoDB or the more widely used MyISAM. On top of that, we will always be able to retrieve any of your MySQL databases if you delete one by accident, as we make a few MySQL database backups every day, each of which is saved for one whole week.

InnoDB in VPS Servers

All VPS service that are ordered with the Hepsia Control Panel come with InnoDB pre-activated, so you will be able to make use of any open-source script-based software application that needs the database engine without having to configure anything manually. You can pick Hepsia on the VPS configuration page and your brand new server will be up and running within 60 minutes, so you can sign in and begin setting up your websites straight away. When you set up a brand-new database and start the app installation process, our system will select the engine for that MySQL database automatically. In this way, you can run different apps simultaneously without updating anything on the server. You can have a WordPress-based blog that makes use of the default MySQL engine – MyISAM, and a Magento-powered online shop that makes use of InnoDB, for instance.

InnoDB in Dedicated Servers

All Linux dedicated service ordered with our in-house built Hepsia Control Panel come with a software package that is pre-activated and besides everything else, you will get the InnoDB storage engine, so you will not need to install it manually if you wish to activate PHP scripts that need it. All it takes to install such a script is to create a new database and to begin the setup process – once the installer wizard obtains access to the database in question and begins importing data into it, InnoDB will be set as the default MySQL engine for this database as long as it is the one required by the particular script. You will also be able to activate scripts that require the other widely used MySQL engine, MyISAM, so you won’t need to modify any settings on the server. This will enable you to install various scripts on a single machine and to use the latter to its fullest capabilities.