InnoDB
What?s InnoDB? Why has it been picked up as the default MySQL storage engine?
InnoDB is a MySQL database engine, which has been gaining popularity in recent years, as it offers a much better overall performance and a faster crash recovery in comparison with the default engine used by MySQL – MyISAM. InnoDB is endorsed by plenty of programmers that write highly scalable web applications, due to the fact that it works more efficiently with immense data volumes, while it keeps the server load low. Moreover, it it locks only one row in the database if any info should be edited, whereas many other engines lock the entire table and thus require more time to fulfill 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 action is rolled back to prevent scrambling or data loss. Magento and the latest Joomla™ editions are two examples of popular PHP-driven web apps that have switched to InnoDB.
-
InnoDB in Cloud Web Hosting
InnoDB is offered with all our
cloud web hosting by default, not as a paid upgrade or upon request, so you can activate and run any script-driven application that needs the MySQL database storage engine without any difficulty as soon as you activate your shared hosting account. InnoDB will be pre-selected as the default engine for a certain database during the app activation, irrespective of whether you use our 1-click installer or create the MySQL database and activate the application manually, provided that the application requires InnoDB instead of the more popular MyISAM engine. We will perform daily backups of all your MySQL databases, so you can be certain that you won’t ever lose any content in case you erase a database by accident or you overwrite some important info – you will just have to get in touch with us and we will restore everything the way it was.
-
InnoDB in Semi-dedicated Servers
InnoDB comes with all our
Linux semi-dedicated hosting plans by default, so the moment you obtain a new semi-dedicated account, you can go on and install any open-source script-based app that needs this particular storage engine. Several engines are pre-installed on our cloud website hosting platform, so when you set up a new database and start installing an app manually, or opt to take advantage of the Hepsia Control Panel-integrated application installer tool, the engine for the database will be selected in accordance with the prerequisites of the specific app. This will permit you to install and manage InnoDB-specific applications without the need to deal with any problem and without needing to configure any settings in your semi-dedicated account. To avoid any risk, we will always keep a 7-day-old backup of all your databases, so if you delete or alter any content by accident, we can quickly retrieve it.
-
InnoDB in VPS Servers
If you choose a
VPS server with our Hepsia hosting Control Panel, the InnoDB database engine will be included in the software bundle that will be installed on your Virtual Private Server before we give it to you. You won’t have to set up anything manually and you will be able to install and run any PHP script-driven software app that needs InnoDB when your VPS server is set up, which takes no more than 60 minutes after the order submission itself. A number of engines are available, so whenever you set up a database using the Hepsia Control Panel, a particular engine will be activated once the app activation starts and our system will recognize which engine is required by the app in question. In case you need MyISAM, for example, you won’t have to do anything different from installing the desired app, whether manually or using our application installer tool.
-
InnoDB in Dedicated Servers
Our Hepsia Control Panel is among the options which you can select on the server configuration page when you buy a
dedicated server from us. Since this is the most powerful kind of website hosting, it’s pretty likely that you will manage very popular sites that will draw lots of visitors, and since InnoDB is among the very best choices for such websites, we’ll install it together with all the other software apps that are available with a Hepsia-managed server. If you create a brand-new database in your account, there won’t be any activated MySQL database storage engine till you start installing an open-source PHP script, whether manually through your web browser or using the automatic script installer tool that is included in the Control Panel. The needed engine will be automatically detected and will be assigned to the database in question, so you can activate scripts that require InnoDB, as well as ones that need the default MySQL engine, MyISAM, without having to deal with any impediment.