InnoDB is a popular database engine for the MySQL relational database management system. It’s an alternative to the default engine – MyISAM, and it has numerous strong sides which have made it the engine of choice for lots of open-source script-driven software applications, such as Joomla and Magento, which have switched to InnoDB permanently. For instance, adding huge volumes of data will be much faster with InnoDB, as it locks only a single database row to execute a certain task, not the entire table, which makes the engine ideal for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the way in which the data is handled. Simply put, appending new or updating existent data will either be entirely completed, or will be annulled and the operation will be rolled back if any problem occurs in the meantime, hence the content that remains in the database won’t be lost.

InnoDB in Hosting

InnoDB is offered with all our Linux hosting by default, not upon request or as a paid upgrade, so you will be able to install and run any PHP script-based application that requires the MySQL storage engine without the need to deal with any problem once you order your shared account. InnoDB will be pre-selected as the default engine for a given MySQL database during the app activation, no matter if you make use of our single-click installer or create the database and activate the application manually, on the condition that the application requires it instead of the more famous MyISAM engine. We’ll create regular MySQL database backups, so you can rest assured that you’ll never lose any content if you delete a database by accident or you overwrite some vital information – you simply have to notify us and we’ll restore your database the way it was.

InnoDB in Semi-dedicated Hosting

InnoDB comes with all our Linux semi-dedicated hosting by default, so as soon as you create a new semi-dedicated account, you can go on and install any script-driven app that requires this MySQL database storage engine. Several engines are pre-installed on our cloud website hosting platform, so when you set up a brand new MySQL database and start installing an application manually, or decide to make use of the Hepsia hosting Control Panel-integrated application installer, the engine for the database will be chosen in accordance with the requirements of the given application. This will allow you to install and run InnoDB-specific apps without needing to deal with any problem and without having to modify any settings in your semi-dedicated account. To take no chances, we’ll always have a one-week-old backup of all your databases, so if you delete or alter any content accidentally, we can easily retrieve it.

InnoDB in VPS Hosting

In case our in-house developed Hepsia Control Panel is selected during the registration process for a new Linux virtual private servers , InnoDB will be activated on the server together with other needed software, so you will not need to do anything if you choose to manage open-source script-driven software apps that require this MySQL database engine. MyISAM – the default MySQL engine, will be activated too. You can set up a new MySQL database and begin installing the app manually or through our single-click installation tool. The system will automatically detect which engine the application in question requires and will set it for the specific database, so the installation will proceed impeccably and the app can enter its content into that database. Therefore, you can install applications with various prerequisites with regard to the MySQL engine without the need to make any modifications on your server.

InnoDB in Dedicated Web Hosting

All Linux dedicated web hosting that are ordered with our in-house developed Hepsia Control Panel come with a software package that is pre-activated and besides everything else, you’ll get the InnoDB database engine, so you won’t need to activate it manually if you need to run scripts that need it. All it takes to run such a script is to set up a new MySQL database and to start the installation process – once the setup wizard gets access to the database in question and starts entering content into it, InnoDB will be set as the default MySQL engine for this database as long as it is the one needed by the script. You’ll also be able to run scripts that need the other widely used MySQL engine – MyISAM, so you won’t need to modify any settings on the dedicated server. This will permit you to activate different scripts on one single physical server and to use it to its maximum capacity.