What?s InnoDB? Why has it been picked up as the default MySQL storage engine?
InnoDB is a database storage engine for MySQL databases, which is used by well known script-based apps such as Joomla™ 3.x and Magento. It is ideal for scalable apps, as it works exceptionally well when managing immense data volumes. Instead of locking the entire table to enter new information into a database like many other engines do, InnoDB locks only one database row, so it can carry out much more tasks for the same length of time. Besides, InnoDB offers a much better crash recovery and supports database transactions and foreign keys – a set of rules that prescribe how data inserts and modifications should be handled. In case a given task hasn’t been entirely completed for whatever reason, the action will be rolled back. In this way, the content in the database will stay safe and sound and won’t be partially mixed with newly imported content.
InnoDB in Cloud Hosting
While InnoDB is either not offered or it is a paid upgrade with many other hosting providers, it is an integral part of the standard set of features that we are offering with our cloud hosting
plans. If you wish to use a PHP-based application that requires InnoDB specifically, in order to be activated and to operate properly, you won’t have any problems since the MySQL database storage engine is available on our in-house developed cloud web hosting platform. Regardless of whether you create a brand new database and install an app manually or use our single-click application installer instrument, InnoDB will be selected automatically by our system as the default engine if the particular application requires it instead of MyISAM. In addition to the remarkable database crash recovery that InnoDB offers, we also make daily database backups, so that we can easily restore any database in your shared hosting account.
InnoDB in Semi-dedicated Servers
If you create a brand-new MySQL database through the hosting Control Panel coming with each of our semi-dedicated server
accounts and you start installing an open-source script-based application either manually or using our 1-click app installer, the database storage engine will be selected automatically based on the prerequisites of the specific application. Since InnoDB is present on the cloud hosting platform where your new semi-dedicated hosting account will be set up, it will be set as the default engine for each application that needs it without any manual action required on your end at any time. To prevent any risk of losing info if you update an application or if you erase a database accidentally, we will carry out backups of all your databases every day, so if something goes wrong, we can retrieve your content.
InnoDB in VPS Servers
In case our in-house developed Hepsia hosting Control Panel is selected during the signup process for your new VPS plans
, InnoDB will be installed on the VPS server along with other required pieces of software, so you will not need to do anything if you choose to manage script-driven apps that need this MySQL storage engine. MyISAM, the default MySQL engine, will be installed too. You can create a new MySQL database and begin the app installation procedure manually or using our one-click installer tool. The system will detect which engine the application in question needs and will assign it to the specific database, so the installation will continue impeccably and the app can insert its content into that database. In this way, you can run applications with different prerequisites with regard to the MySQL engine without having to make any changes on your server.
InnoDB in Dedicated Servers
InnoDB is included by default with all Linux dedicated servers
ordered with the Hepsia hosting Control Panel. It is an essential part of the software bundle that we install on all Hepsia-managed servers, so once your physical machine is assembled, you will be able to sign in and to activate a various script-based web application that requires this particular storage engine. When you set up a new MySQL database through the Control Panel, there won’t be any activated engine until you begin installing an application. Once the app installation wizard begins importing content into the newly created database, the engine will be set automatically based on the given app’s prerequisites, so you can run both InnoDB and MyISAM without having to select either one explicitly at any point. Therefore, you can make use of a wide variety of apps for your Internet sites.