InnoDB is a storage engine for MySQL databases, which is used by well known PHP-powered software applications such as Magento and Joomla 3.x. It is excellent for scalable apps, because it works very well when managing huge data volumes. Instead of locking the whole database table to insert new information in a database as many other engines do, InnoDB locks only one row, so it can execute a lot more operations for the same period of time. In addition, InnoDB offers a much better database failure recovery and supports database transactions and foreign key constraints – a set of rules that prescribe how data inserts and modifications should be handled. If a certain operation has not been thoroughly completed for any reason, the action will be rolled back. Thus, the database content will stay safe and sound and will not be partially mixed with newly imported content.
InnoDB in Shared Web Hosting
Any PHP-powered web app that requires InnoDB will function flawlessly on our innovative cloud web hosting platform and the database storage engine is available with all our shared web hosting packages. Every time you create a MySQL database manually or our app installer creates one automatically and an app installation process is started, the engine that the database will use will be selected in accordance with the app’s specifications without the need to modify any setting in your shared account. InnoDB will be chosen automatically for any application that requires this particular engine and you will be able to take advantage of its full potential. We’ll store daily backups of your content, so in case you accidentally erase a MySQL database that’s important to you or you overwrite a certain part of it, we will be able to restore your data the way it was just a few hours ago.
InnoDB in Semi-dedicated Hosting
All our Linux semi-dedicated hosting packages include InnoDB and you can get the most out of all the features of this database engine with any PHP-powered application that requires it. It is among the engines that are available on our cloud hosting platform, so the one that will be picked depends on the requirements of the given application. You will not have to do anything manually in order to activate InnoDB, as it will be set as the default engine when you install an app – whether manually or using our one-click application installer tool. To avoid any risk, we’ll perform regular MySQL database backups, so if something goes wrong after some update or if you erase some content accidentally, we will be able to restore the database the way it was on any of the previous seven days.
InnoDB in Dedicated Servers Hosting
All Linux dedicated servers hosting packages ordered with our custom-built Hepsia Control Panel come with a software bundle that is pre-activated and among everything else, you’ll get the InnoDB storage engine, so you won’t need to add it manually in case you want to activate scripts that need it. All it takes to install such a script is to create a new MySQL database and to start the setup process – as soon as the script installation wizard acquires access to the database in question and starts dumping content in it, InnoDB will be set as the default engine for this database as long as it is the one needed by the particular script. You’ll also be able to activate scripts that need MyISAM, the other widely used MySQL engine, so you won’t have to edit any settings on the dedicated server. This will enable you to use different scripts on a single machine and to use it to its full potential.