InnoDB is a database storage engine for MySQL databases, which is used by well known PHP script-powered software applications like Joomla™ v3 and Magento. It’s excellent for scalable applications, since it works amazingly well when handling large volumes of data. Rather than locking the whole database table to add new information to a database as many other engines do, InnoDB locks only one database row, so it can perform a lot more tasks for the same period of time. Moreover, InnoDB offers a better database failure recovery and supports database transactions and foreign keys – rules that indicate how data inserts and modifications should be treated. If a certain operation has not been thoroughly completed for any reason, the action will be rolled back. Thus, the information in the database will stay safe and sound and won’t be partially mixed with new content.
InnoDB in Cloud Website Hosting
You will be able to make use of any open-source script-powered software app that requires InnoDB in case you’ve got a cloud website hosting with us, as the MySQL database storage engine is present on our cutting-edge cloud website hosting platform by default. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed impeccably if this engine is needed. You can install apps that need the MyISAM engine without any difficulties as well and, again, the engine will be pre-selected, so you will not have to modify anything manually at any moment. Furthermore, we will also perform daily backups of all the databases that you have in your account, so in case you erase or overwrite something, we can easily restore it the way it was on any of the past seven days.
InnoDB in Semi-dedicated Servers
All our semi-dedicated servers include InnoDB and you can use all the features offered by this database storage engine with any script-based app that needs it. It is among the engines that we have on our cloud web hosting platform, so the one that will be selected depends on the prerequisites of the given application. You will not have to do anything manually to activate InnoDB, as it will be set as the default engine when you install an application – whether manually or using our one-click application installer. To be on the safe side, we’ll perform regular backups of all your MySQL databases, so if something goes wrong following an upgrade or if you delete some data by mistake, we will be able to get your database back to the way it was on any of the past 7 days.
InnoDB in VPS Servers
All Linux VPS hosting plans that are ordered with the Hepsia Control Panel come with InnoDB already installed, so you’ll be able to use any PHP-powered app that needs this storage engine without configuring anything manually. You can choose Hepsia on the VPS order form and your new Virtual Private Server will be ready within one hour, so you can log in and start building your sites right away. When you set up a brand new database and start the app installation process, our system will choose the engine for that database automatically. Thus, you can use different applications at the same time without having to configure anything on the Virtual Private Server. You can create a WordPress-based online blog that uses MyISAM – the default MySQL engine, and a Magento-based e-commerce site that uses the InnoDB engine, for example.
InnoDB in Dedicated Servers
All Linux dedicated servers ordered with our custom-developed Hepsia Control Panel include a software bundle that is pre-installed and among everything else, you will get the InnoDB storage engine, so you will not need to add it manually in case you would like to activate PHP scripts that require it. All it takes to run such a script is to create a new database and to begin the installation – once the installation wizard obtains access to the database in question and starts dumping data in it, InnoDB will be set as the default engine for this database on the condition that it is the one needed by the script. You will also be able to install scripts that require MyISAM – the other widely used MySQL engine, so you won’t have to configure any settings on the server. This will permit you to use a variety of scripts on one single physical server and to use the latter to its maximum capacity.