InnoDB is a MySQL storage engine, which has been gaining in popularity lately, as it offers a significantly better overall performance and an improved database failure recovery compared to the default engine used by the MySQL relational database management system – MyISAM. InnoDB is used by a lot of developers that create highly scalable web apps, because it works more effectively with large data volumes, while it keeps the server load at a minimum. In addition, it locks only a single database row in case any information should be updated, whereas many other engines lock the entire table and thus need more time to carry out several successive tasks. Last, but not least, InnoDB complies with the "all-or-nothing" rule – in case the modification of the entire data cannot be completed successfully for whatever reason, the operation is rolled back to prevent scrambling or data loss. Magento and the latest Joomla™ releases are two examples of widespread script-powered web apps which have switched to InnoDB.
InnoDB in Website Hosting
You can use any PHP-powered software app that requires InnoDB in case you’ve got a website hosting
with us, as the database storage engine is present on our cutting-edge cloud website hosting platform by default. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed flawlessly in case this engine is needed. You can activate apps which need the MyISAM engine without the need to deal with any obstacle as well and, again, the engine will be selected automatically, so you won’t need to configure any setting manually at any point. Furthermore, we will also generate daily backups of all the databases that you’ve got in your shared web hosting account, so if you delete or overwrite anything, we can swiftly restore it the way it was on any of the past seven days.
InnoDB in Semi-dedicated Servers
InnoDB is offered with all our semi-dedicated servers
by default, so as soon as you purchase a new semi-dedicated account, you can go on and install any PHP script-powered software app that requires this particular database storage engine. A couple of engines are installed on our cloud website hosting platform, so when you set up a new database and start installing an application manually, or opt to use the Hepsia hosting Control Panel-integrated application installer, the engine for the database will be selected on the basis of the requirements of the particular application. This will permit you to install and manage InnoDB-specific applications without the need to deal with any problem and without the need to modify any settings in your semi-dedicated account. To avoid any risk, we will always keep a 1-week-old backup of all your MySQL databases, so if you erase or edit any content by mistake, we can easily recover it.
InnoDB in VPS Servers
In case our in-house developed Hepsia hosting Control Panel is selected during the registration process for a new VPS servers
, InnoDB will be installed on the VPS server together with other needed software, so you won’t have to do anything if you decide to make use of PHP script-driven software apps that need this MySQL storage engine. The default MySQL engine – MyISAM, will be activated too. You can create a brand-new database and start the app installation procedure manually or using our one-click installer tool. The system will automatically detect which engine the application in question needs and will set it for the specific database, so the installation will proceed impeccably and the application can insert its data into that database. Thus, you can make use of applications with various requirements about the MySQL engine without having to make any changes on your VPS server.
InnoDB in Dedicated Servers
Our Hepsia hosting Control Panel is one of the features which you can pick on the order form when you buy a dedicated server
from us. Since this is the most powerful type of web hosting, it is pretty likely that you’ll manage very popular Internet sites that will attract many visitors, and since InnoDB is one of the best choices for such websites, we’ll activate it along with all the other software apps that come with a Hepsia-managed server. If you create a brand-new MySQL database in your dedicated account, there won’t be any active MySQL storage engine until you start installing a script, whether manually through your browser or using the automatic scripts installation tool that is available in the Control Panel. The necessary engine will be detected and will be assigned to the database in question, so you can run scripts that need InnoDB, as well as ones that require MyISAM – the default MySQL engine, without having to deal with any difficulty.