InnoDB is a MySQL database storage engine, which has been gaining popularity lately, as it provides a better overall performance and an improved database crash recovery compared to the default engine that’s used by the MySQL database management system – MyISAM. InnoDB is endorsed by numerous devs that run scalable software apps, as it works more efficiently with large amounts of data, while it keeps the server processing load at a minimum. Additionally, it locks only a single database row in case any information should be updated, while lots of other engines lock the entire database table and thus require much more time to process multiple successive tasks. Last, but not least, InnoDB follows a set of "all-or-nothing" rules – in case the entire data modification cannot be completed for whatever reason, the operation is rolled back to prevent confusion or losing data. Magento and the newest Joomla™ editions are two instances of widely used PHP-powered software applications which have switched over to InnoDB.
InnoDB in Website Hosting
InnoDB is available with all our Linux website hosting by default, not as a paid upgrade or upon request, so you will be able to activate and manage any PHP-based software application which requires the InnoDB database engine without any obstacles once you open your shared website hosting account. InnoDB will be pre-selected as the default engine for a certain MySQL database during the app activation process, regardless of whether you use our one-click installation tool or create the MySQL database and set up the application manually, as long as the app requires it instead of the more famous MyISAM engine. We’ll create daily MySQL database backups, so you can be certain that you won’t ever lose any data if you delete a database unintentionally or you overwrite some crucial information – you will just need to inform us and we’ll restore your data the way it was.
InnoDB in Semi-dedicated Servers
All our semi-dedicated hosting service support InnoDB and you can get the most out of all the features of this MySQL storage engine with any script-driven software app that requires it. It is one of the engines that are available on our cloud website hosting platform, so the one that will be selected depends on the requirements of the given application. You won’t need to do anything manually in order to activate InnoDB, because it will be set as the default engine when you install an application – whether manually or using our 1-click app installer tool. To avoid any risk, we’ll keep daily MySQL database backups, so if anything goes wrong following an update or if you erase some content by mistake, we will be able to restore the database the way it was on any of the past seven days.
InnoDB in VPS Servers
In case our custom-developed Hepsia hosting Control Panel is chosen during the signup process for a new VPS servers , InnoDB will be activated on the VPS server together with other required pieces of software, so you will not have to do anything if you choose to make use of PHP script-powered applications that need this MySQL database storage engine. MyISAM, the default MySQL engine, will be installed as well. You can set up a brand new MySQL database and start the app installation procedure manually or using our 1-click installation tool. The system will detect which engine the app in question needs and will assign it to the specific MySQL database, so the installation process will proceed impeccably and the application can import its content into that database. In this way, you can use applications with different requirements in regard to the MySQL engine without the need to make any changes on your Virtual Private Server.
InnoDB in Dedicated Servers
InnoDB is available as standard with all Linux dedicated service that are ordered with the Hepsia Control Panel. It’s an integral part of the default software bundle that we install on all Hepsia-equipped dedicated servers, so as soon as your machine is ready, you’ll be able to log in and to activate any type of script-driven software application that requires this MySQL database engine. If you set up a new database via the hosting Control Panel, there won’t be any activated engine until you start installing an application. Once the app activation wizard starts inserting data into the newly created database, the engine will be set automatically in accordance with the prerequisites of the particular app, so you can use both MyISAM and InnoDB without the need to select either one explicitly at any time. In this way, you can use a vast range of apps for your Internet sites.