InnoDB is a MySQL storage engine, which has been gaining in popularity in recent years, because it offers a much better overall performance and an improved database crash recovery in comparison with the default engine that’s used by the MySQL relational database management system – MyISAM. InnoDB is endorsed by many programmers that build scalable software applications, since it works more effectively with large volumes of data, while it keeps the server processing load low. In addition, it it locks only one row in the database if any information should be modified, whereas lots of other engines lock the entire database table and therefore need much more time to perform multiple consecutive tasks. Last, but not least, InnoDB follows a set of "all-or-nothing" rules – in case the entire data modification procedure cannot be completed for any reason, the operation is rolled back to prevent scrambling or losing data. Magento and the latest releases of Joomla™ are two examples of famous script-driven software apps which have switched over to InnoDB.
InnoDB in Cloud Hosting
InnoDB is available with all our cloud plans by default, not as a paid upgrade or upon request, so you can activate and run any PHP script-driven web application that requires the storage engine without any difficulty once you order your shared account. InnoDB will be pre-selected as the default engine for a particular database during the app activation, irrespective of whether you use our single-click installation tool or create the database and set up the application manually, provided that the app requires it instead of the more popular MyISAM engine. We will perform daily backups of all your MySQL databases, so you can be sure that you’ll never lose any data in case you erase a database accidentally or you overwrite some key information – you will just have to touch base with us and we will restore your data the way it was.
InnoDB in Semi-dedicated Servers
You can activate a PHP script-based software app that requires InnoDB with any of our semi-dedicated server plans, due to the fact that all the accounts are created on our leading-edge cloud web hosting platform where the MySQL database storage engine is installed. A new MySQL database can be set up in two separate ways – manually from the Database Manager section of the Hepsia web hosting Control Panel, or automatically – when you make use of our single-click application installer. In either case, the required engine will be selected automatically as soon as the application’s installation starts, so you will not need to modify anything manually, regardless of whether the app requires InnoDB or the more regularly used MyISAM. Also, we’ll always be able to retrieve any of your MySQL databases if you accidentally remove one, as we generate a few backups every day, each of which is stored for 7 days.
InnoDB in VPS Servers
In case our custom Hepsia hosting Control Panel is picked during the registration process for your new VPS plans , InnoDB will be installed on the server along with other required pieces of software, so you won’t need to do anything if you choose to make use of PHP script-based web apps that need this MySQL database engine. MyISAM – the default MySQL engine, will be installed as well. You can set up a brand new database and begin installing the application manually or using our single-click installer. The system will automatically detect the engine that the app in question needs and will assign it to the specific MySQL database, so the installation will continue flawlessly and the app can enter its content into that database. Therefore, you can make use of apps with different prerequisites concerning the MySQL engine without making any changes on your VPS server.
InnoDB in Dedicated Servers
If you purchase a new dedicated server, you’ll be able to pick any of the three hosting Control Panels that we offer – DirectAdmin, cPanel and Hepsia. Each dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you will not need to enable this database engine manually to be able to run open-source script-based software applications that require it. InnoDB is used by scalable applications and since a dedicated server will provide you with all the resources that you need in order to manage very large websites, it is quite likely that you’ll use InnoDB. You’ll be able to use other engines too, so if a particular application requires MyISAM rather than InnoDB, you won’t encounter any impediment while running it. The engine that will be used will be detected automatically once the app installation commences, so you will not have to update any settings manually whatsoever.