Read more about InnoDB and find out why it’s recently been picked out as the default MySQL database engine.
InnoDB is a MySQL database engine, which has been gaining popularity in recent years, as it provides a much better overall performance and a faster database crash recovery compared to the default engine used by the MySQL database management system – MyISAM. InnoDB is endorsed by many developers that create scalable applications, as it works much better with huge volumes of data, while it keeps the server processing load low. Additionally, it it locks only one row in the database if any info should be updated, whereas many other engines lock the entire table and thus require much more time to perform multiple consecutive tasks. Last, but not least, InnoDB complies with a set of "all-or-nothing" rules – in case the entire data modification cannot be completed successfully for any reason, the operation is rolled back to avoid scrambling or data loss. Magento and the latest editions of Joomla™ are two instances of widely used PHP script-driven web apps which have moved to InnoDB.
InnoDB in Web Hosting
While InnoDB is either not available or a paid upgrade with other website hosting service providers, it is an integral part of the standard set of services that we’re offering with our web hosting
packages. In case you want to use an open-source script-driven app that requires InnoDB in particular, in order to be activated and to function correctly, you won’t come across any difficulties since the MySQL database engine is available on our custom cloud platform. No matter if you create a brand new database and install an app manually or make use of our one-click app installer software tool, InnoDB will be selected automatically by our platform as the default engine if the specific app needs it instead of MyISAM. Besides the outstanding crash recovery that InnoDB is offering, we also store regular database backups, so that we can easily restore any MySQL database in your shared website hosting account.
InnoDB in Semi-dedicated Servers
All our semi-dedicated servers
support InnoDB and you will be able to take advantage of all the options offered by this MySQL storage engine with any script-based software application that needs it. It’s one of the engines that are available on our cloud web hosting platform, so the one that will be used depends on the prerequisites of the given app. You will not need to do anything manually to activate InnoDB, since it will be set as the default engine whenever you install an application – whether manually or using our one-click application installer tool. To be on the safe side, we’ll make daily backups of all your MySQL databases, so if something goes wrong following some update or if you erase some content by accident, we will be able to get your database back to the way it was on any of the past seven days.
InnoDB in VPS Servers
If our in-house built Hepsia hosting Control Panel is picked during the registration process for a new VPS servers
, InnoDB will be installed on the Virtual Private Server along with other required software, so you won’t have to do anything if you choose to use PHP script-based applications that require this MySQL database storage engine. The default MySQL engine – MyISAM, will be activated too. You can set up a brand new database and begin the app installation manually or through our single-click installer tool. The system will automatically detect the engine that the particular application requires and will assign it to the specific database, so the installation will proceed impeccably and the app can enter its content into that database. In this way, you can use applications with different prerequisites about the MySQL engine without the need to make any changes on your VPS server.
InnoDB in Dedicated Servers
All dedicated servers
that are ordered with our in-house developed Hepsia Control Panel include a software package that’s pre-installed and besides everything else, you will get the InnoDB storage engine, so you won’t have to add it manually in case you would like to run open-source PHP scripts that need it. All it takes to use such a script is to create a new database and to start the setup – once the installation wizard receives access to the database in question and begins importing data into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one needed by the script. You will also be able to run scripts that need the other very popular MySQL engine – MyISAM, so you won’t need to configure any settings on the dedicated server. This will allow you to install different scripts on a single server and to use it to its full capacity.