Read more about InnoDB and find out why it’s already been chosen as the default MySQL database engine.
InnoDB is a popular database engine for the MySQL DBMS. It is an alternative to the default engine – MyISAM, and it has got a number of advantages which have made it the preferred engine for numerous PHP-powered applications, such as Joomla™ and Magento, which have switched over to InnoDB permanently. For example, adding huge amounts of data will be faster with InnoDB, because it locks only a single row to perform a given operation, not the entire table, which makes the engine excellent for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the way in which the info is tackled. To put it simply, adding new or updating existent data will either be thoroughly completed, or will be aborted and the procedure will be rolled back in case a certain issue appears in the meantime, so the content that remains in the database won’t be lost.
InnoDB in Shared Web Hosting
You can activate any open-source script-based web app that requires InnoDB in case you have a shared web hosting plan
with our company, as the MySQL database engine is present on our avant-garde cloud platform as standard. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably in case this engine is required. You can install apps that need the MyISAM engine without the need to deal with any obstacle as well and, again, the engine will be pre-selected, so you won’t have to edit any setting manually at any point. Furthermore, we will also make regular backups of all the databases that you’ve got in your account, so in case you delete or overwrite something, we can easily restore it the way it was on any of the previous 7 days.
InnoDB in Dedicated Servers
InnoDB is included by default with all dedicated web hosting plans
ordered with the Hepsia hosting Control Panel. It’s an essential part of the default software bundle that we install on all Hepsia-equipped servers, so as soon as your machine is up and running, you will be able to log in and to install any kind of script-driven web application that requires this MySQL storage engine. If you create a new database via the hosting Control Panel, there won’t be any active engine until you start installing an application. Once the app activation wizard begins inserting content into the database, the engine will be selected automatically based on the respective app’s requirements, so you can run both InnoDB and MyISAM without selecting either one of them explicitly at any moment. In this way, you can use a large variety of apps for your sites.