What?s InnoDB? Why has it been selected as the default MySQL storage engine?
InnoDB is a popular storage engine for the MySQL DBMS. It’s an alternative to the default engine – MyISAM, and it has numerous strengths that have made it the engine of choice for a lot of PHP-powered software applications, such as Joomla™ and Magento, which have shifted over to InnoDB permanently. For example, adding large amounts of data will be much faster with InnoDB, as it locks only a single database row to carry out a specific task, not the entire database table, which makes the engine ideal for scalable apps. It also supports foreign keys and database transactions – these refer to the way in which the information is treated. To put it simply, adding new or updating existing data will either be entirely completed, or will be annulled and the procedure will be rolled back in case any problem appears during the process, which is why the content that remains in the database won’t be lost.
InnoDB in Shared Hosting
You can make use of any script-powered web app that needs InnoDB if you’ve got a Linux shared hosting
with us, as the database engine is available on our cutting-edge cloud platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed flawlessly in case this engine is required. You can activate applications that require the MyISAM engine without any difficulty as well and, again, the engine will be pre-selected, so you will not have to update any setting manually at any time. Furthermore, we’ll also carry out regular backups of all the databases that you have in the shared web hosting account, so if you delete or overwrite something, we can swiftly get it back to the way it was on any of the past 7 days.
InnoDB in Semi-dedicated Hosting
You can install a script-driven web application that needs InnoDB with all of our semi-dedicated server
packages, since all the accounts are created on our innovative cloud hosting platform where the storage engine is installed. A new MySQL database can be set up in two ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – when you take advantage of our 1-click app installer. Either way, the required engine will be chosen automatically once the activation of the app starts, so you will not need to edit anything manually, no matter if the application needs InnoDB or the more widely used MyISAM. On top of that, we’ll always be able to recover any of your databases if you erase 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 Web Hosting
InnoDB is available by default with all Linux dedicated web hosting
that are ordered with the Hepsia Control Panel. It is part of the standard software bundle that will be installed on all Hepsia-managed servers, so once your physical machine is up and running, you will be able to log in and to install any script-based software application that needs this particular MySQL storage engine. If you create a new MySQL database via the hosting Control Panel, there won’t be any activated engine till you begin installing an application. As soon as the app configuration wizard begins importing information into the newly created database, the engine will be set automatically depending on the specific app’s prerequisites, so you can use both MyISAM and InnoDB without having to select either of them specifically at any moment. In this way, you can make use of a vast selection of apps for your Internet sites.