Find out about InnoDB and find out why it’s been selected as the default MySQL database engine.
InnoDB is a very popular database engine for the MySQL RDBMS. It is an alternative to the default engine – MyISAM, and it has got a lot of advantages that make it the engine of choice for lots of script-driven applications, such as Joomla™ and Magento, which have shifted over to InnoDB permanently. For instance, adding enormous data volumes will be faster with InnoDB, since it locks only one database row to execute a particular task, not the entire database table, which makes the engine excellent for scalable applications. It also supports foreign keys and database transactions – these refer to the way in which the data is treated. To put it simply, adding new or updating existent data will either be fully completed, or will be annulled and the operation will be rolled back in case some issue appears during the process, thus the content that remains in the database won’t be damaged.
InnoDB in Shared Hosting
While InnoDB is either not available or a paid upgrade with other hosting companies, it’s an integral part of the default set of features offered with our shared hosting
plans. In case you want to use a script-driven web application that needs InnoDB specifically, in order to be installed and to function properly, you will not need to deal with any problems because the MySQL database engine is available on our custom cloud web hosting platform. No matter if you set up a new database and activate an application manually or take advantage of our single-click application installer tool, InnoDB will be selected automatically by our platform as the default engine if the application requires it instead of MyISAM. Besides the remarkable crash recovery offered by InnoDB, we also generate daily backups of all databases, so we can easily recover any MySQL database in your shared account.
InnoDB in Semi-dedicated Hosting
All our semi-dedicated hosting
support InnoDB and you can use all the features of this MySQL database storage engine with any open-source script-driven application that requires it. It’s among the engines that are available on our cloud platform, so the one that will be picked depends on the prerequisites of the particular app. You will not have to do anything manually to enable InnoDB, because it will be set as the default engine when you install an app – whether manually or using our single-click app installer tool. To be on the safe side, we’ll keep regular MySQL database backups, so if anything goes wrong after an update or if you remove some content accidentally, we will be able to restore the database the way it was on any of the past seven days.
InnoDB in VPS Hosting
All VPS hosting
that are ordered with the Hepsia Control Panel come with InnoDB pre-activated, so you will be able to take advantage of any PHP-based app that requires this particular MySQL database engine without needing to set up anything manually. You can select Hepsia on the VPS configuration page and your brand new server will be ready within one hour, so you can log in and begin setting up your web sites right away. Once you create a brand new database and start the app installation process, our system will choose the engine for that database automatically. In this way, you can manage different applications simultaneously without having to change anything on the VPS server. You can set up a WordPress-powered weblog that uses MyISAM – the default MySQL engine, and a Magento-driven e-store that makes use of the InnoDB engine, for example.
InnoDB in Dedicated Web Hosting
All dedicated web hosting
that are ordered with our custom Hepsia Control Panel include a software package that is pre-installed and besides everything else, you will get the InnoDB storage engine, so you will not have to add it manually in case you want to use open-source PHP scripts that require it. All it takes to activate such a script is to create a new MySQL database and to begin the setup – once the setup wizard gains access to the database and starts entering data into it, InnoDB will be set as the default engine for this database as long as it is the one needed by the script. You’ll also be able to activate scripts that need MyISAM – the other widely used MySQL engine, so you won’t need to modify any settings on the server. This will enable you to run various scripts on a single physical machine and to use the latter to its full capabilities.