InnoDB is a very popular storage engine for the MySQL DBMS. It is an alternative to the default MyISAM engine and it has many strengths that make it the preferred engine for plenty of PHP-powered web apps, such as Magento and Joomla, which have switched to InnoDB permanently. For instance, adding enormous amounts of data will be much faster with InnoDB, because it locks only a single database row to perform a certain operation, not the entire database table, which makes the engine perfect for scalable apps. InnoDB also supports foreign keys and database transactions – these refer to the way in which the information is handled. Simply put, importing new or editing existing data will either be fully completed, or will be aborted and the procedure will be rolled back if some problem shows up during the process, which is why the content that remains in the database won’t be lost.
InnoDB in Website Hosting
InnoDB is available with all our Linux website hosting by default, not as a paid upgrade or upon request, so you will be able to activate and manage any PHP-powered app that needs the database engine without any impediments once you open your shared hosting account. InnoDB will be selected automatically as the default engine for a specific MySQL database during the app activation, irrespective of whether you take advantage of our single-click installer or create the database and set up the application manually, as long as the app requires InnoDB instead of the more famous MyISAM engine. We’ll store daily backups of all your MySQL databases, so you can rest assured that you won’t ever lose any content in case you delete a database by accident or you overwrite some crucial information – you’ll simply need to notify us and we will restore the database back to normal.
InnoDB in Semi-dedicated Servers
All our Linux semi-dedicated servers support InnoDB and you’ll be able to use all the features of this database storage engine with any PHP-driven web application 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 will not have to do anything manually in order to enable InnoDB, because it will be set as the default engine whenever you install an application – whether manually or using our one-click application installer tool. To be on the safe side, we’ll perform regular backups of all your MySQL databases, so if anything goes wrong following an update or if you delete some content unintentionally, we’ll be able to get the database back to the way it was on any of the past seven days.
InnoDB in VPS Servers
If our custom-developed Hepsia hosting Control Panel is picked during the signup process for your new VPS servers , InnoDB will be activated on the Virtual Private Server along with other required pieces of software, so you won’t need to do anything if you decide to make use of script-powered web apps that need this MySQL database engine. The default MySQL engine, MyISAM, will be installed as well. You can set up a brand-new database and start the app installation procedure manually or through our 1-click installer. The system will recognize which engine the particular app requires and will set it for the specific database, so the installation process will continue impeccably and the application can dump its data in that database. Thus, you can use applications with various requirements concerning the MySQL engine without the need to make any modifications on your server.
InnoDB in Dedicated Servers
All dedicated service ordered with our custom Hepsia Control Panel include a software bundle that is pre-activated and besides everything else, you’ll get the InnoDB database engine, so you won’t need to activate it manually in case you wish to activate open-source PHP scripts that need it. All it takes to run such a script is to set up a new database and to initiate the setup process – as soon as the script configuration wizard gains access to the database in question and starts entering content into it, InnoDB will be set as the default engine for this database on the condition that it is the one required by the particular script. You will also be able to use scripts that require MyISAM, the other popular MySQL engine, so you won’t have to edit any settings on the server. This will permit you to install a variety of scripts on a single server and to use it to its full potential.