Learn more about InnoDB and find out why it’s been chosen as the default MySQL database engine.
InnoDB is a MySQL storage engine, which has been gaining popularity in recent years, because it provides a much better overall performance and a faster database crash recovery in comparison with the default engine that’s used by the MySQL database management system – MyISAM. InnoDB is endorsed by a lot of developers that build highly scalable applications, as it works more efficiently with large data volumes, while it keeps the server load at a minimum. Furthermore, it locks only one database row if anything should be updated, while many other engines lock the entire table and therefore require much more time to carry out several consecutive tasks. Last, but not least, InnoDB adheres to a set of "all-or-nothing" rules – if the entire data modification procedure cannot be completed for any reason, the operation is rolled back to prevent scrambling or data loss. Magento and the latest Joomla™ versions are two examples of popular PHP-driven web applications that have shifted over to InnoDB.
InnoDB in Cloud Website Hosting
While InnoDB is either a paid upgrade or it is not available at all with many web hosts, it is included in the standard set of services that we offer with our cloud website hosting
plans. In case you would like to make use of an open-source script-powered software app that requires InnoDB particularly, in order to be activated and to operate correctly, you will not come across any difficulties as the InnoDB storage engine is available on our in-house built cloud hosting platform. Regardless of whether you create a new MySQL database and install an app manually or make use of our 1-click application installer instrument, InnoDB will be selected automatically by our system as the default engine if the particular app needs it instead of MyISAM. In addition to the incredible database failure recovery offered by InnoDB, we also perform daily database backups, so that we can quickly restore any database in your shared account.
InnoDB in Semi-dedicated Hosting
InnoDB comes with all our Linux semi-dedicated hosting
by default, so once you buy a new semi-dedicated account, you can go on and activate any PHP-powered software app that needs the MySQL database engine. A couple of engines are pre-installed on our cloud hosting platform, so when you create a brand-new database and start installing an application manually, or decide to make use of the Hepsia hosting Control Panel-integrated application installer tool, the engine for the database will be set depending on the prerequisites of the respective application. This will allow you to install and run InnoDB-specific apps without the need to deal with any obstacle and without needing to configure any settings in your semi-dedicated account. To take no chances, we will always keep a one-week-old backup of all your databases, so if you erase or change any content by mistake, we can swiftly recover it.
InnoDB in VPS Hosting
All Linux VPS hosting
that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-installed, so you will be able to run any PHP script-driven software application that requires this particular MySQL storage engine without having to install anything manually. You can select Hepsia on the VPS configuration page and your new server will be up and running within 1 hour, so you can log in and begin setting up your Internet sites right away. When you create a brand new MySQL database and start the app activation process, our system will set the engine for that MySQL database automatically. In this way, you can use different apps at the same time without modifying anything on the VPS server. You can create a WordPress-powered weblog that makes use of the default MySQL engine – MyISAM, and a Magento-based web store that uses the InnoDB engine, for example.
InnoDB in Dedicated Web Hosting
Our Hepsia hosting Control Panel is among the features that you can choose on the server configuration page when you purchase a dedicated server
from our company. As this is the most powerful type of web hosting, it’s quite likely that you’ll run highly popular sites that will attract many visitors, and since InnoDB is among the best options for such websites, we will install it along with all the other software applications that come with a Hepsia-managed dedicated server. If you set up a brand new database in your account, there won’t be any activated MySQL storage engine till you begin installing an open-source script, whether manually through your Internet browser or using the automatic script installation tool that is included in the hosting Control Panel. The required engine will be automatically recognized and will be set for the database in question, so you can run scripts that require InnoDB, as well as ones that require MyISAM, the default MySQL engine, without coming across any complication.