Find out more on InnoDB and see why it’s recently been chosen as the default MySQL database engine.
InnoDB is a MySQL storage engine, which has been gaining in popularity in recent years, because it offers a much better overall performance and an improved database crash recovery compared to the default engine used by the MySQL database management system – MyISAM. InnoDB is used by plenty of web developers that write highly scalable web apps, as it works much better with enormous data volumes, while it keeps the server load low. In addition, it locks only one database row in case anything should be edited, while lots of other engines lock the entire database table and thus require more time to perform multiple consecutive tasks. Last, but not least, InnoDB obeys the "all-or-nothing" rule – in case the entire data modification cannot be completed for some reason, the operation is rolled back to avoid confusion or data loss. Magento and the latest Joomla™ editions are two instances of popular PHP script-powered software platforms that have shifted over to InnoDB.
InnoDB in Web Hosting
InnoDB is available with all our Linux web hosting packages
by default, not as a paid upgrade or upon request, so you’ll be able to activate and manage any PHP script-powered software application which needs the MySQL storage engine without having to deal with any impediment as soon as you activate your account. InnoDB will be pre-selected as the default engine for a given MySQL database during the app installation, irrespective of whether you use our one-click installer or create the MySQL database and activate the app manually, as long as the app requires it instead of the more famous MyISAM engine. We will perform daily database backups, so you can be sure that you won’t ever lose any content if you erase a database accidentally or you overwrite some essential info – you’ll simply have to contact us and we’ll restore the database back to normal.
InnoDB in Semi-dedicated Hosting
You can install a PHP script-based web app that needs InnoDB with all of our semi-dedicated server
packages, because all the accounts are set up on our avant-garde cloud hosting platform where the database engine is installed. A new database can be set up in two separate ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – if you use our 1-click application installer. Either way, the needed engine will be chosen automatically the moment the installation of the app begins, so you won’t need to edit anything manually, regardless of whether the app needs InnoDB or the more frequently used MyISAM. Furthermore, we’ll always be able to restore any of your MySQL databases if you remove one by mistake, as we carry out a couple of MySQL database backups every day, each of which is preserved for 7 days.
InnoDB in Dedicated Hosting
Our Hepsia hosting Control Panel is among the features that you can select on the order form when you buy a dedicated server
from us. As this is the most powerful type of website hosting, it’s quite likely that you will run very popular websites that will attract plenty of people, and since InnoDB is one of the very best choices for such sites, we’ll install it along with all the other software applications that are offered with a Hepsia-managed dedicated server. When you set up a new database in your dedicated server account, there won’t be any activated database storage engine until you begin installing an open-source script, whether manually via your browser or using the automatic script installation tool that is available in the Control Panel. The necessary engine will be recognized and will be assigned to the database in question, so you can use scripts that need InnoDB, as well as ones that need MyISAM, the default MySQL engine, without the need to deal with any problem.