InnoDB is a database engine for MySQL relational databases, which is used by widely used script-based software apps like Magento and Joomla™ 3.x. It’s perfect for scalable apps, as it works amazingly well when processing immense data volumes. Instead of locking the whole database table to insert new information in a database like many other engines do, InnoDB locks only one row, so it can carry out a lot more tasks for the same length of time. Besides, InnoDB offers a better database failure recovery and supports transactions and foreign keys – a set of rules that define how data imports and modifications should be handled. In case a particular operation hasn’t been entirely completed for whatever reason, the action will be rolled back. Thus, the information in the database will remain safe and sound and won’t be partially mixed with newly entered content.

InnoDB in Cloud Web Hosting

Every PHP script-based app that needs InnoDB will function impeccably on our avant-garde cloud hosting platform and the database storage engine comes with all our cloud web hosting packages. Whenever you create a database manually or our app installer tool creates one automatically and an app installation process is started, the engine that the database in question will use will be selected in accordance with the app’s prerequisites without having to change any setting in your account. InnoDB will be chosen automatically for any app that requires this particular engine and you’ll be able to get the most out of its full potential. We’ll store regular content backups, so in case you unintentionally remove a database that is important to you or you overwrite a certain 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 run a PHP script-powered app that needs InnoDB with all of our semi-dedicated server packages, due to the fact that all the accounts are created on our advanced cloud hosting platform where the MySQL database engine is installed. A new database can be set up in two separate ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you make use of our one-click application installer. In either case, the needed engine will be picked automatically as soon as the application’s installation begins, so you won’t have to edit anything manually, no matter if the app needs InnoDB or the more frequently used MyISAM. Furthermore, we will always be able to restore any of your MySQL databases if you remove one by accident, as we carry out a couple of backups every day, each of which is preserved for 1 whole week.

InnoDB in VPS Servers

In case our in-house developed Hepsia Control Panel is selected during the registration process for a new VPS servers , InnoDB will be activated on the server along with other necessary software, so you won’t need to do anything if you decide to activate PHP script-based software applications that require this MySQL database storage engine. MyISAM – the default MySQL engine, will be activated as well. You can set up a brand new MySQL database and begin the app installation manually or using our one-click installation tool. The system will automatically recognize the engine that the application in question requires and will assign it to the specific MySQL database, so the installation process will proceed impeccably and the app can dump its data in that database. Thus, you can activate applications with different prerequisites about the MySQL engine without having to make any modifications on your VPS.

InnoDB in Dedicated Servers

All Linux dedicated servers ordered with our custom-built Hepsia hosting Control Panel come with a software package that’s pre-activated and besides everything else, you’ll get the InnoDB database storage engine, so you won’t have to add it manually if you’d like to run PHP scripts that require it. All it takes to use such a script is to create a new database and to begin the installation – as soon as the script setup 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 on the condition that it is the one needed by the particular script. You’ll also be able to activate scripts that require the other widely used MySQL engine – MyISAM, so you will not have to change any settings on the dedicated server. This will enable you to run various scripts on a single machine and to use the latter to its maximum capacity.