InnoDB is a MySQL storage engine, which has been gaining in popularity lately, as it provides a better overall performance and an improved database crash recovery in comparison to the default engine that’s used by MySQL – MyISAM. InnoDB is used by a lot of web developers that write scalable software applications, due to the fact that it works more efficiently with immense data volumes, while it keeps the server processing load low. What’s more, it uses row-level locking in case anything should be modified, whereas lots of other engines lock the entire database table and thus need much more time to accomplish multiple consecutive tasks. Last, but not least, InnoDB follows a set of "all-or-nothing" rules – if the entire data modification process cannot be completed successfully for some reason, the operation is rolled back to avoid scrambling or data loss. Magento and the newest editions of Joomla™ are two instances of popular script-driven web apps which have moved to InnoDB.
InnoDB in Website Hosting
InnoDB is offered with all our website hosting packages by default, not as a paid upgrade or upon request, so you can install and manage any open-source script-powered app that requires the database engine without having any difficulty once you activate your shared web hosting account. InnoDB will be selected automatically as the default engine for a certain database during the app installation process, irrespective of whether you take advantage of our single-click installation tool or create the database and activate the application manually, provided that the app requires it instead of the more popular MyISAM engine. We will maintain regular MySQL database backups, so you can be sure that you won’t ever lose any data if you erase a database by mistake or you overwrite some crucial information – you’ll just have to contact us and we will restore everything the way it was.
InnoDB in Semi-dedicated Hosting
InnoDB is available with each of our Linux semi-dedicated hosting packages by default, so the moment you create a new account, you can go on and activate any script-powered web application that needs this particular database engine. Several engines are installed on our cloud hosting platform, so when you set up a brand-new database and begin installing an application manually, or opt to use the Hepsia Control Panel-integrated application installer, the engine for the database will be picked on the basis of the respective app’s prerequisites. This will allow you to install and manage InnoDB-specific applications without having to deal with any difficulty and without needing to modify any settings in your semi-dedicated account. To avoid any risk, we will always keep a seven-day-old backup of all your databases, so if you erase or change any content unintentionally, we can easily retrieve it.
InnoDB in VPS Hosting
If you select a virtual private server with our Hepsia hosting Control Panel, the InnoDB storage engine will be included in the software package 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 install and use any open-source script-driven web application that requires InnoDB once your Virtual Private Server is set up, which takes no more than one hour after the order submission itself. Several engines are offered, so whenever you create a MySQL database via the Hepsia hosting Control Panel, a specific engine will be selected once the app installation process starts and our system will detect which engine is required by the app in question. If you need MyISAM, for example, you will not need to do anything different from installing the application of your preference, whether manually or using our app installer tool.
InnoDB in Dedicated Web Hosting
All Linux dedicated servers hosting packages ordered with our in-house built Hepsia hosting Control Panel come with a software bundle that’s pre-activated and among everything else, you’ll get the InnoDB storage engine, so you will not have to add it manually if you need to activate open-source scripts that need it. All it takes to run such a script is to create a new database and to begin the installation process – as soon as the script setup wizard obtains access to the database in question and starts importing content into 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 will also be able to install 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 enable you to activate various scripts on a single physical server and to use it to its maximum capabilities.