What?s InnoDB? Why has it been picked up as the default MySQL storage engine?
InnoDB is a very popular database storage engine for the MySQL relational database management system. It is an alternative to the default engine – MyISAM, and it has got numerous strong sides that have made it the engine of choice for many script-powered applications, including Magento and Joomla™, which have switched to InnoDB for good. For instance, importing huge volumes of data will be faster with InnoDB, as it locks only a single database row to carry out a certain task, not the entire database table, which makes the engine ideal for scalable apps. InnoDB also supports foreign keys and database transactions – these refer to the way in which the data is tackled. To put it simply, importing new or modifying existing data will either be thoroughly completed, or will be canceled and the operation will be rolled back in case a given problem shows up in the meantime, which is why the content that remains in the database will not be lost.
InnoDB in Web Hosting
InnoDB is available with all our web hosting plans
by default, not upon request or as a paid upgrade, so you’ll be able to activate and manage any PHP script-powered web app that requires the database engine without encountering any obstacle once you activate your shared web hosting account. InnoDB will be selected automatically as the default engine for a certain database during the app activation, no matter if you take advantage of our 1-click installer or create the MySQL database and activate the application manually, on the condition that the app requires InnoDB instead of the more famous MyISAM engine. We will store regular MySQL database backups, so you can be sure that you will never lose any content if you erase a database by mistake or you overwrite some crucial info – you’ll simply need to get in touch with us and we will restore your content back to normal.
InnoDB in Semi-dedicated Servers
If you set up a brand-new MySQL database through the hosting Control Panel included with all our semi-dedicated server
plans and you begin installing an open-source script-powered software app either manually or using our 1-click application installer, the storage engine for the MySQL database will be picked automatically depending on the specific app’s prerequisites. Since InnoDB is present on the cloud hosting platform where your new account will be set up, it will be set as the default engine for any application that requires it without any manual intervention required on your end at any moment. To avoid any risk of losing information if you update an application or if you delete a database accidentally, we will perform backups of all your MySQL databases each day, so if something happens, we can recover your data.
InnoDB in Dedicated Servers
InnoDB comes as standard with all dedicated web hosting plans
that are ordered with the Hepsia hosting Control Panel. It is an integral part of the standard software bundle that we install on all Hepsia-equipped dedicated servers, so once your machine is ready, you’ll be able to sign in and to activate any PHP script-driven web app that needs this particular MySQL database engine. If you set up a new database through the Control Panel, there won’t be any activated engine until you start installing an app. As soon as the app activation wizard starts dumping data in the database, the engine will be chosen automatically depending on the requirements of the particular app, so you can use both InnoDB and MyISAM without having to select either of them explicitly at any moment. Therefore, you can use an extensive variety of apps for your sites.