What?s InnoDB? Why has it been picked up as the standard MySQL storage engine?
InnoDB is a very popular database storage engine for the MySQL RDBMS. It is an alternative to the default MyISAM engine and it has got numerous upsides which have made it the engine of choice for many open-source script-powered applications, among them Joomla™ and Magento, which have moved to InnoDB permanently. For instance, adding large volumes of data will be faster with InnoDB, since it locks only a single row to carry out a specific operation, not the entire database table, which makes the engine perfect for scalable apps. It also supports foreign keys and database transactions – these refer to the way in which the information is treated. Simply put, appending new or modifying existent data will either be entirely completed, or will be aborted and the procedure will be rolled back if any problem occurs during the process, therefore the content that remains in the database won’t be damaged.
InnoDB in Web Hosting
You can run any open-source script-powered software application that needs InnoDB if you’ve got a web hosting
with us, as the database engine is present on our innovative cloud hosting platform by default. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably if this engine is required. You can install applications which require the MyISAM engine without any problem as well and, again, the engine will be selected automatically, so you will not need to configure any setting manually at any moment. Furthermore, we will also generate daily backups of all the databases that you’ve got in your shared account, so if you erase or overwrite something, we can swiftly get it back to the way it was on any of the past seven days.
InnoDB in Semi-dedicated Servers
If you create a new MySQL database through the Control Panel coming with all our semi-dedicated server
accounts and you begin installing a PHP script-driven web app either manually or using our one-click application installer, the MySQL database storage engine will be set automatically on the basis of the requirements of the particular app. As InnoDB is present on the cloud platform where your new semi-dedicated hosting account will be set up, it will be set as the default engine for each app that needs it without any manual action needed on your end at any moment. To prevent any risk of losing information if you update an app or if you delete a database by mistake, we will perform a backup of all your databases each and every day, so if anything happens, we can restore your data.
InnoDB in VPS Servers
If you get a VPS server
with our Hepsia hosting Control Panel, the InnoDB database engine will be included in the default software bundle that will be pre-installed on your server before we give it to you. You will not need to set up anything manually and you’ll be able to install and manage any PHP-based application that needs InnoDB as soon as your VPS is set up, which takes no more than 1 hour after the order process itself. Several engines are offered, so whenever you set up a MySQL database through the Hepsia hosting Control Panel, a specific engine will be activated when the app installation commences and our system will automatically detect which engine is required by the application in question. If you need to use MyISAM, for instance, you will not need to do anything different than installing the desired app, whether manually or using our application installer tool.
InnoDB in Dedicated Servers
Our Hepsia hosting Control Panel is one of the features that you can select on the server configuration page when you buy a dedicated server
from us. Since this is the most powerful kind of web hosting, it is quite likely that you’ll manage popular Internet sites that will attract many individuals, and since InnoDB is among the best options for such Internet sites, we’ll activate it together with all the other software applications that come with a Hepsia-equipped dedicated server. When you create a brand-new database in your dedicated account, there won’t be any activated storage engine until you start installing an open-source script, whether manually via your Internet browser or using the automatic script installer that is available in the hosting Control Panel. The needed engine will be automatically detected and will be assigned to the database in question, so you can install scripts that need InnoDB, as well as ones that require MyISAM, the default MySQL engine, without needing to deal with any problem.