InnoDB is a very popular storage engine for the MySQL RDBMS. It’s an alternative to the default engine – MyISAM, and it has got a lot of upsides that have made it the preferred engine for a lot of script-driven web apps, including Joomla™ and Magento, which have shifted over to InnoDB permanently. For example, adding huge data volumes will be faster with InnoDB, due to the fact that it locks only one row to complete a given task, not the entire table, which makes the engine ideal for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the way in which the information is handled. Put simply, importing new or modifying existing data will either be fully completed, or will be annulled and the operation will be rolled back in case any issue occurs in the meantime, which means that the content that remains in the database won’t be damaged.
InnoDB in Website Hosting
InnoDB is offered with all our website hosting plans by default, not as a paid upgrade or upon request, so you will be able to install and run any PHP script-driven web app that needs the MySQL storage engine without having to deal with any difficulty as soon as you activate your shared hosting account. InnoDB will be pre-selected as the default engine for a specific database during the app installation, no matter if you make use of our one-click installation tool or create the database and set up the app manually, provided that the app requires it instead of the more famous MyISAM engine. We’ll generate regular backups of all your databases, so you can rest assured that you will never lose any data if you erase a database accidentally or you overwrite some essential info – you will just have to notify us and we’ll restore your content the way it was.
InnoDB in Semi-dedicated Servers
All our semi-dedicated hosting plans come with InnoDB and you will be able to make the most of all the features of this database storage engine with any script-powered app that requires it. It’s among the engines that we have on our cloud website hosting platform, so the one that will be picked depends on the requirements of the app in question. You will not have to do anything manually to activate InnoDB, because it will be set as the default engine when you install an app – whether manually or using our single-click application installer tool. To be on the safe side, we will store daily backups of all your MySQL databases, so if something goes wrong after an update or if you erase some content unintentionally, we will be able to get the database back to the way it was on any of the past seven days.
InnoDB in VPS Servers
When you obtain a VPS server from us, you will be able to take advantage of our in-house built Hepsia Control Panel to manage your content. A Hepsia-equipped VPS will permit you to use any open-source script-powered application that needs InnoDB, as the MySQL storage engine is an integral part of the standard software bundle that will be pre-installed on the Virtual Private Server during its creation. When you set up a brand new MySQL database using the Control Panel, you just have to begin installing an application – manually or using our app installer. InnoDB will be set as the default engine on the condition that the application in question requires it, so you will not need to do anything else in your account. Correspondingly, if a given app requires MyISAM, it will be automatically set as the default engine for this concrete MySQL database.
InnoDB in Dedicated Servers
All dedicated web hosting plans ordered with our custom-built Hepsia hosting Control Panel come with a software bundle that is pre-activated and among everything else, you will get the InnoDB database engine, so you won’t need to install it manually if you want to run PHP scripts that require it. All it takes to run such a script is to create a new MySQL database and to start the setup – once the installation wizard obtains access to the database in question and starts dumping content in it, InnoDB will be set as the default engine for this database on the condition that it is the one required by the particular script. You will also be able to install scripts that need the other widely used MySQL engine – MyISAM, so you won’t have to configure any settings on the server. This will allow you to use a variety of scripts on a single server and to use it to its fullest capacity.