What?s InnoDB? Why has it been picked up as the standard MySQL storage engine?
InnoDB is a very popular database engine for the MySQL database management system. It is an alternative to the default engine – MyISAM, and it has numerous strong sides which have made it the engine of choice for many PHP-driven web applications, such as Magento and Joomla™, which have switched to InnoDB for good. For example, adding enormous amounts of data will be faster with InnoDB, due to the fact that it locks only a single row to complete a given operation, not the entire database table, which makes the engine excellent for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the manner in which the information is handled. Simply put, importing new or modifying existing data will either be entirely completed, or will be annulled and the operation will be rolled back in case a certain issue shows up in the meantime, therefore the content that remains in the database will not be lost.
InnoDB in Cloud Web Hosting
While InnoDB is either a paid upgrade or it is not available at all with many hosting companies, it is included in the default set of features offered with our cloud web hosting
plans. If you want to make use of a PHP-powered web app that needs InnoDB specifically, in order to be installed and to function properly, you will not have to deal with any problems since the InnoDB storage engine is available on our custom-built cloud Internet hosting platform. Irrespective of whether you set up a new database and install an application manually or use our one-click application installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the particular application requires it instead of MyISAM. Besides the remarkable database crash recovery that InnoDB is offering, we also keep regular backups of all databases, so we can swiftly recover any database in your shared account.
InnoDB in Semi-dedicated Servers
All our semi-dedicated servers
include InnoDB and you’ll be able to take full advantage of all the features offered by this MySQL database engine with any PHP-based software application that needs it. It’s one of the engines that are available on our cloud platform, so the one that will be selected depends on the requirements of the application in question. You will not have to do anything manually in order to enable InnoDB, since it will be set as the default engine when you install an application – whether manually or using our one-click app installer. To avoid any risk, we will generate regular backups of all your MySQL databases, so if something goes wrong following an update or if you delete some data accidentally, we will be able to get the database back to the way it was on any of the past 7 days.
InnoDB in VPS Servers
If our in-house developed Hepsia Control Panel is picked during the registration process for your new VPS plans
, InnoDB will be activated on the server along with other essential software, so you will not need to do anything if you decide to activate PHP-driven applications that need this MySQL storage engine. MyISAM, the default MySQL engine, will be activated as well. You can create a brand new MySQL database and start the app installation process manually or using our 1-click installation tool. The system will recognize the engine that the particular application needs and will assign it to the specific MySQL database, so the installation will continue flawlessly and the application can enter its data into that database. Thus, you can activate apps with various prerequisites about the MySQL engine without the need to make any modifications on your Virtual Private Server.
InnoDB in Dedicated Servers
If you purchase a new dedicated server
, you’ll be able to pick any of the three Control Panels offered by us – cPanel, Hepsia and DirectAdmin. Each server ordered with Hepsia comes with InnoDB pre-activated, so you will not need to enable this database storage engine manually so as to be able to manage open-source script-driven apps that need it. InnoDB is used by scalable apps and since a dedicated server will offer you all the system resources that you require to manage large-size websites, it’s quite possible that you’ll use InnoDB. You’ll be able to use other engines as well, so if a particular app requires MyISAM rather than InnoDB, you won’t have to deal with any difficulty while using it. The engine that will be used will be recognized automatically as soon as the app installation process commences, so you won’t need to edit any settings manually at any point.