InnoDB is a popular database engine for the MySQL database management system. It is an alternative to the default engine – MyISAM, and it has a lot of advantages which make it the engine of choice for numerous PHP-powered apps, such as Joomla and Magento, which have switched over to InnoDB for good. For instance, importing huge data volumes will be faster with InnoDB, as it locks only one database row to accomplish a certain operation, not the entire table, which makes the engine ideal for scalable apps. It also supports foreign keys and transactions – these refer to the manner in which the info is handled. Simply put, appending new or updating existent data will either be entirely completed, or will be aborted and the procedure will be rolled back if any problem appears in the meantime, so the content that remains in the database will not be damaged.

InnoDB in Hosting

You can install any script-based app that requires InnoDB if you have a hosting service with our company, as the MySQL storage engine is present on our leading-edge cloud platform as standard. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably if this engine is needed. You can activate apps which use the MyISAM engine without encountering any difficulty as well and, again, the engine will be selected automatically, so you won’t need to modify any setting manually at any time. In addition, we’ll also carry out daily backups of all the MySQL databases that you have in your shared account, so if you erase or overwrite something, we can quickly get it back to the way it was on any of the past 7 days.

InnoDB in Semi-dedicated Hosting

All our semi-dedicated services include InnoDB and you can make the most of all the options offered by this storage engine with any open-source script-powered software application that requires it. InnoDB is one of the engines that are available on our cloud website hosting platform, so the one that will be picked depends on the prerequisites of the specific application. You will not need to do anything manually in order to enable InnoDB, as it will be set as the default engine whenever you install an app – whether manually or using our 1-click app installer. To be on the safe side, we’ll generate daily MySQL database backups, so if something goes wrong following an upgrade or if you delete some content by mistake, we will be able to get the database back to the way it was on any of the previous seven days.

InnoDB in VPS

If you get a virtual private server with our Hepsia Control Panel, the InnoDB storage engine will be part of the default software pack that will be installed on your Virtual Private Server before we give it to you. You will not have to set up anything manually and you’ll be able to enable and use any script-powered software application that requires InnoDB once your VPS server is up and running, which takes no more than sixty minutes after the order procedure itself. A few engines are offered, so anytime you create a MySQL database through the Hepsia Control Panel, a particular engine will be selected once the app activation commences and our system will detect which engine is required by the application in question. If you need MyISAM, for instance, you will not have to do anything different from installing the desired app, whether manually or using our app installer.

InnoDB in Dedicated Hosting

All dedicated hosting services ordered with our custom-built Hepsia hosting Control Panel come with a software package that’s pre-activated and among everything else, you will get the InnoDB storage engine, so you won’t have to install it manually if you’d like to use PHP scripts that need it. All it takes to run such a script is to set up a new MySQL database and to initiate the setup process – as soon as the script setup wizard receives access to the database in question and starts inserting content 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 use scripts that need MyISAM, the other popular MySQL engine, so you won’t need to update any settings on the dedicated server. This will permit you to use a variety of scripts on one single physical machine and to use it to its fullest capacity.