InnoDB is a MySQL storage engine, which has been gaining popularity in recent years, because it offers a better overall performance and a faster database crash recovery in comparison with the default engine that’s used by MySQL – MyISAM. InnoDB is endorsed by many web developers that write scalable web applications, since it works better with large data volumes, while it keeps the server load low. Moreover, it uses row-level locking in case any info should be updated, whereas many other engines lock the entire table and therefore need much more time to process multiple sequential tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – in case the entire data modification procedure cannot be completed successfully for any reason, the operation is rolled back to avoid scrambling or losing data. Magento and the latest versions of Joomla are two examples of widespread PHP script-powered software platforms that have switched over to InnoDB.
InnoDB in Shared Hosting
Any PHP script-powered web application that requires InnoDB will function flawlessly on our innovative cloud platform and the database storage engine comes with all our shared hosting plans. Whenever you create a MySQL database manually or our app installer creates one automatically and an app installation process is initiated, the engine that the database will make use of will be selected in accordance with the app’s requirements without having to update any setting in your hosting account. InnoDB will be chosen automatically for any app that requires this specific engine and you’ll be able to make the most of its full capacity. We’ll maintain regular backups of your content, so if you unintentionally erase a MySQL database that is important to you or you overwrite a specific part of it, we will be able to restore your data the way it was only a few hours earlier.
InnoDB in Semi-dedicated Hosting
You can run a script-driven web app that requires InnoDB with all of our semi-dedicated server plans, due to the fact that all the accounts are set up on our leading-edge cloud hosting platform where the MySQL database engine is installed. A new database can be set up in two separate ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – if you take advantage of our 1-click app installer tool. Either way, the needed engine will be chosen automatically once the app’s activation starts, so you won’t need to configure anything manually, irrespective of whether the application needs InnoDB or the more commonly used MyISAM. On top of that, we will always be able to restore any of your MySQL databases if you unintentionally delete one, as we perform a few database backups every day, each of which is kept for 1 week.
InnoDB in VPS
All Linux VPS packages that are ordered with the Hepsia Control Panel come with InnoDB pre-activated, so you’ll be able to take advantage of any PHP script-based software app that requires this particular storage engine without the need to activate anything manually. You can select Hepsia on the VPS order form and your new VPS server will be ready within one hour, so you can log in and start setting up your web sites straight away. When you set up a brand-new database and begin the app installation process, our system will set the engine for that database automatically. In this way, you can run various apps at the same time without configuring anything on the server. You can have a WordPress-based personal blog that makes use of the default MySQL engine – MyISAM, and a Magento-driven e-shop that makes use of the InnoDB engine, for example.
InnoDB in Dedicated Hosting
Our Hepsia hosting Control Panel is one of the features that you can select on the order form when you buy a dedicated server from our company. Since this is the most powerful type of hosting, it is quite likely that you’ll run very popular sites that will attract lots of visitors, and since InnoDB is one of the best options for such sites, we’ll activate it along with all the other software applications that are offered with a Hepsia-managed server. When you set up a brand-new database in your dedicated server account, there won’t be any active database storage engine till you start installing an open-source PHP script, whether manually through your web browser or using the automatic script installer tool that is available in the Control Panel. The required engine will be automatically recognized and will be assigned to that database, so you can install scripts that need InnoDB, as well as ones that need MyISAM – the default MySQL engine, without the need to cope with any problem.