InnoDB
Find out about InnoDB and find out why it’s already been picked out as the default MySQL database engine.
InnoDB is a very popular database engine for the MySQL RDBMS. It is an alternative to the default MyISAM engine and it has got lots of strengths which have made it the preferred engine for lots of PHP script-based web apps, among them Magento and Joomla™, which have switched over to InnoDB for good. For instance, importing huge volumes of data will be faster with InnoDB, because it locks only one database row to execute a particular task, not the entire table, which makes the engine ideal for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the manner in which the info is tackled. Put simply, adding new or updating existent data will either be entirely completed, or will be canceled and the procedure will be rolled back if any issue shows up in the meantime, therefore the content that remains in the database won’t be lost.
-
InnoDB in Cloud Hosting
Every open-source script-powered app that requires InnoDB will function impeccably on our advanced cloud website hosting platform and the MySQL database engine comes with all our
cloud hosting packages. Every time you create a MySQL database manually or our app installer creates one automatically and an app installation process is started, the engine that the database in question will use will be selected in accordance with the app’s requirements without having to update any setting in your hosting account. InnoDB will be selected automatically for any app that requires this particular engine and you’ll be able to make the most of its full potential. We’ll create regular content backups, so if you accidentally delete a database that is important to you or you overwrite a specific part of it, we will be able to restore everything the way it was only several hours ago.
-
InnoDB in Semi-dedicated Hosting
All our
semi-dedicated hosting packages come with InnoDB and you can use all the options offered by this MySQL database storage engine with any PHP-driven software app that requires it. InnoDB is among the engines that we have on our cloud website hosting platform, so the one that will be selected depends on the particular app’s prerequisites. You won’t have to do anything manually to activate InnoDB, since it will be set as the default engine whenever you install an application – whether manually or using our one-click app installer tool. To be on the safe side, we’ll create regular database backups, so if something goes wrong after an upgrade or if you remove some content by accident, we will be able to restore your database the way it was on any of the past 7 days.
-
InnoDB in Dedicated Hosting
If you purchase a new
dedicated server, you will be able to choose one of the three Control Panels offered by our company – Hepsia, DirectAdmin and cPanel. Each server ordered with Hepsia comes with InnoDB pre-installed, so you will not need to install this storage engine manually in order to be able to run script-powered web applications that require it. InnoDB is used for scalable apps and since a dedicated server will supply you with all the resources that you need to run very large sites, it’s quite possible that you’ll resort to InnoDB. You will be able to use other engines too, so in case a specific app requires MyISAM rather than InnoDB, you will not have to deal with any complication while managing it. The engine that will be used will be recognized automatically once the app installation procedure begins, so you won’t have to configure any settings manually at any point.