Find out more about InnoDB and find out why it’s recently been selected as the default MySQL database engine.
InnoDB is a MySQL database storage engine, which has been gaining popularity lately, because it provides a better overall performance and an improved crash recovery compared with the default engine used by the MySQL relational database management system – MyISAM. InnoDB is endorsed by many developers that create scalable software apps, since it works better with enormous amounts of data, while it keeps the server processing load at a minimum. Furthermore, it locks only one database row if any info should be updated, while lots of other engines lock the entire database table and thus require much more time to execute multiple consecutive tasks. Last, but not least, InnoDB observes a set of "all-or-nothing" rules – in case the modification of the entire data cannot be completed successfully for some reason, the action is rolled back to prevent scrambling or the loss of data. Magento and the newest versions of Joomla™ are two examples of widespread PHP script-based software apps that have switched to InnoDB.
InnoDB in Shared Web Hosting
InnoDB is offered with all our Linux shared web hosting packages
by default, not as a paid upgrade or upon request, so you will be able to activate and run any PHP script-driven software app which requires the storage engine without the need to deal with any difficulty as soon as you open your shared hosting account. InnoDB will be selected automatically as the default engine for a given database during the app activation process, irrespective of whether you take advantage of our 1-click installation tool or create the database and install the application manually, provided that the app requires it instead of the more famous MyISAM engine. We will perform daily backups of all your databases, so you can be sure that you’ll never lose any data in case you delete a database accidentally or you overwrite some important info – you simply need to alert us and we’ll restore everything back to normal.
InnoDB in VPS Web Hosting
All Linux VPS web hosting packages
that are ordered with the Hepsia hosting Control Panel come with InnoDB already installed, so you’ll be able to take advantage of any open-source script-based web application that needs this particular storage engine without setting up anything manually. You can select Hepsia on the VPS order page and your brand-new server will be set up within one hour, so you can log in and start setting up your Internet sites right away. Once you create a brand new database and begin the app installation process, our system will pick the engine for that MySQL database automatically. Thus, you can manage various apps simultaneously without the need to modify anything on the server. You can have a WordPress blog that makes use of the default MySQL engine – MyISAM, and a Magento-driven online shop that makes use of InnoDB, for example.
InnoDB in Dedicated Servers Hosting
Our Hepsia Control Panel is one of the features that you can choose on the order page when you purchase a dedicated server
from us. As this is the most powerful kind of web hosting, it’s quite likely that you’ll manage highly popular sites that will attract plenty of individuals, and since InnoDB is among the best options for such websites, we’ll activate it along with all the other software applications that come with a Hepsia-managed dedicated server. When you create a brand new MySQL database in your dedicated account, there won’t be any activated storage engine till you begin installing an open-source script, whether manually through your browser or using the automatic script installer that is included in the hosting Control Panel. The needed engine will be detected automatically and will be assigned to that database, so you can install scripts that need InnoDB, as well as ones that require MyISAM – the default MySQL engine, without the need to deal with any impediment.