InnoDB
Find what a database engine is, what are the advantages of the InnoDB engine and why it's gaining a huge amount of worldwide popularity.
InnoDB is a very popular database engine for the MySQL relational database management system. It’s an alternative to the default MyISAM engine and it has got lots of advantages which make it the engine of choice for a lot of PHP-based software apps, such as Magento and Joomla™, which have moved to InnoDB permanently. For instance, adding enormous amounts of data will be faster with InnoDB, because it locks only a single database row to perform a given task, 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 data is tackled. In simpler words, adding new or modifying existent data will either be entirely completed, or will be aborted and the operation will be rolled back if some issue shows up in the meantime, which means that the content that remains in the database will not be damaged.
-
InnoDB in Website Hosting
Every PHP script-powered web application that requires InnoDB will run impeccably on our innovative cloud platform and the storage engine comes with all our
website hosting plans. Every time you create a MySQL database manually or our app installer creates one automatically and an app installation is started, the engine that the database in question will make use of will be selected on the basis of the app’s specifications without having to modify any setting in your shared hosting account. InnoDB will be selected automatically for any app that requires this specific engine and you will be able to take advantage of its full potential. We’ll generate daily backups of your content, so if you unintentionally delete a database that’s important to you or you overwrite some part of it, we will be able to restore your content the way it was only a couple of hours earlier.
-
InnoDB in Semi-dedicated Servers
You can make use of a script-driven software application that needs InnoDB with all of our
semi-dedicated server packages, since all the accounts are set up on our avant-garde cloud platform where the storage engine is installed. A new MySQL database can be created in two different ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you take advantage of our 1-click app installer. In either case, the needed engine will be picked automatically the moment the app’s activation begins, so you won’t have to configure anything manually, irrespective of whether the app needs InnoDB or the more regularly used MyISAM. Also, we will always be able to retrieve any of your databases if you unintentionally remove one, as we create a few database backups every day, each of which is saved for one week.
-
InnoDB in Dedicated Servers
InnoDB is included by default with all
dedicated servers ordered with the Hepsia Control Panel. It is included in the software bundle that we install on all Hepsia-managed servers, so as soon as your physical machine is assembled, you will be able to log in and to activate any kind of open-source script-based web application that needs this particular MySQL database engine. If you create a new MySQL database via the Control Panel, there won’t be any activated engine until you start installing an app. As soon as the app installation wizard begins dumping information in the newly created database, the engine will be picked automatically on the basis of the given app’s requirements, so you can run both InnoDB and MyISAM without the need to select either one specifically at any moment. Therefore, you can use a vast collection of apps for your Internet sites.