InnoDB is a popular database engine for the MySQL DBMS. It is an alternative to the default MyISAM engine and it has numerous advantages that have made it the preferred engine for lots of PHP-driven web applications, among them Joomla™ and Magento, which have moved to InnoDB for good. For example, adding enormous volumes of data will be much faster with InnoDB, since it locks only a single database row to carry out a particular task, not the entire table, which makes the engine perfect for scalable applications. InnoDB also supports foreign keys and database transactions – these refer to the manner in which the info is treated. Put simply, appending new or updating existent data will either be thoroughly completed, or will be aborted and the procedure will be rolled back if some issue appears in the meantime, thus the content that remains in the database will not be lost.
InnoDB in Cloud Hosting
InnoDB is available with all our Linux cloud hosting by default, not as a paid upgrade or upon request, so you’ll be able to install and run any open-source script-powered web app which requires the storage engine without any problem once you activate your shared account. InnoDB will be selected automatically as the default engine for a certain MySQL database during the app installation process, no matter if you take advantage of our one-click installer or create the database and set up the application manually, as long as the application requires InnoDB instead of the more popular MyISAM engine. We’ll maintain daily backups of all your databases, so you can be certain that you won’t ever lose any data in case you erase a database by mistake or you overwrite some crucial information – you will simply need to get in touch with us and we will restore your database back to normal.
InnoDB in Semi-dedicated Hosting
All our semi-dedicated hosting packages include InnoDB and you’ll be able to take advantage of all the features of this storage engine with any open-source script-driven application that requires it. It’s among the engines that we have on our cloud hosting platform, so the one that will be selected depends on the particular app’s requirements. You won’t have to do anything manually to enable InnoDB, since it will be set as the default engine when you install an application – whether manually or using our one-click application installer. To avoid any risk, we will generate daily backups of all your databases, so if something goes wrong after some update or if you remove some content accidentally, we will be able to restore your database the way it was on any of the past seven days.
InnoDB in VPS Hosting
If you select a virtual private server with our Hepsia hosting Control Panel, the InnoDB storage engine will be included in the standard software bundle that will be installed on your VPS server before we give it to you. You won’t need to set up anything manually and you’ll be able to enable and use any PHP script-driven web application that needs InnoDB when your VPS is up and running, which takes no more than sixty minutes after the order submission process itself. A couple of engines are offered, so anytime you set up a MySQL database through the Hepsia Control Panel, a specific engine will be picked once the app installation begins and our system will recognize which engine is required by the application in question. In case you need to use MyISAM, for instance, you will not need to do anything different than installing the app of your preference, whether manually or using our app installer.
InnoDB in Dedicated Web Hosting
All Linux dedicated web hosting ordered with our custom Hepsia Control Panel include a software bundle that’s pre-activated and besides everything else, you’ll get the InnoDB database storage engine, so you will not have to add it manually in case you would like to use open-source scripts that require it. All it takes to install such a script is to set up a new MySQL database and to start the installation process – once the script installation wizard obtains access to the database and begins inserting data into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one required by the script. You will also be able to install scripts that need the other popular MySQL engine – MyISAM, so you will not have to modify any settings on the server. This will enable you to run different scripts on a single machine and to use the latter to its maximum capabilities.