InnoDB is a MySQL database engine, which has been gaining in popularity in recent years, because it offers a better overall performance and a faster database crash recovery in comparison to the default engine that’s used by the MySQL relational database management system – MyISAM. InnoDB is preferred by many developers that run scalable software applications, as it works better with large volumes of data, while it keeps the server load at a minimum. Also, it locks only one database row if any information should be edited, while lots of other engines lock the entire table and thus need much more time to carry out multiple consecutive tasks. Last, but not least, InnoDB abides by the "all-or-nothing" rule – in case the modification of the entire data cannot be completed successfully for some reason, the operation is rolled back to prevent scrambling or the loss of data. Magento and the newest editions of Joomla are two examples of widespread PHP script-powered web applications that have switched over to InnoDB.

InnoDB in Hosting

You’ll be able to activate any script-powered web app that requires InnoDB if you have a Linux hosting package with us, as the database engine is available on our cutting-edge cloud platform as standard. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed impeccably if this engine is required. You can install applications which use the MyISAM engine without encountering any problem as well and, again, the engine will be pre-selected, so you will not have to update any setting manually at any time. On top of that, we’ll also carry out daily backups of all the databases that you’ve got in the shared hosting account, so if you delete or overwrite anything, we can quickly restore it the way it was on any of the past 7 days.

InnoDB in Semi-dedicated Hosting

You can make use of a PHP script-driven software app that needs InnoDB with any of our semi-dedicated server packages, because all the accounts are created on our leading-edge cloud platform where the database storage engine is installed. A new database can be created in two different ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you take advantage of our 1-click app installer tool. Either way, the required engine will be selected automatically once the app’s activation begins, so you won’t need to modify anything manually, irrespective of whether the app needs InnoDB or the more frequently used MyISAM. Also, we will always be able to retrieve any of your databases in case you unintentionally remove one, as we carry out several database backups every day, each of which is preserved for 1 week.

InnoDB in VPS

All Linux VPS packages that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-activated, so you will be able to make use of any script-driven application that needs this storage engine without needing to install anything manually. You can pick Hepsia on the VPS order page and your brand new server will be set up within 1 hour, so you can log in and begin building your web sites right away. When you set up a brand-new database and start the app activation process, our system will set the engine for this database automatically. In this way, you can make use of different apps at the same time without modifying anything on the server. You can create a WordPress-based online journal that makes use of the default MySQL engine – MyISAM, and a Magento-based shopping portal that uses the InnoDB engine, for example.

InnoDB in Dedicated Hosting

Our Hepsia Control Panel is one of the features which you can pick on the server configuration page when you buy a dedicated server from our company. As this is the most powerful kind of website hosting, it’s very likely that you will run very popular websites that will draw many individuals, and since InnoDB is one of the very best options for such websites, we’ll install it along with all the other software apps that are offered with a Hepsia-managed dedicated server. When you set up a brand new MySQL database in your dedicated account, there won’t be any activated storage engine until you start installing a script, whether manually via your Internet browser or using the automatic scripts installer tool that is integrated into the Control Panel. The required engine will be detected and will be assigned to that database, so you can activate scripts that need InnoDB, as well as ones that need the default MySQL engine – MyISAM, without the need to cope with any problem.