InnoDB is a MySQL database storage engine, which has been gaining popularity lately, because it offers a much better overall performance and an improved database failure recovery compared with the default engine that is used by the MySQL database management system – MyISAM. InnoDB is preferred by a lot of programmers that build highly scalable software applications, since it works much better with large amounts of data, while it keeps the server processing load low. What’s more, it uses row-level locking in case any information should be edited, while many other engines lock the entire table and hence require much more time to execute multiple consecutive tasks. Last, but not least, InnoDB abides by 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 data loss. Magento and the newest Joomla™ releases are two examples of famous PHP-driven web apps which have switched over to InnoDB.
InnoDB in Shared Website Hosting
InnoDB is offered with all our shared website hosting by default, not upon request or as a paid upgrade, so you can install and run any open-source script-driven app that requires the database storage engine without having to deal with any difficulty as soon as you activate your shared website hosting account. InnoDB will be pre-selected as the default engine for a certain MySQL database during the app installation process, irrespective of whether you make use of our 1-click installation tool or create the database and install the app manually, as long as the application requires InnoDB instead of the more popular MyISAM engine. We will carry out regular backups of all your databases, so you can be certain that you will never lose any content if you delete a database accidentally or you overwrite some key info – you’ll simply have to get in touch with us and we’ll restore the database the way it was.
InnoDB in Semi-dedicated Servers
InnoDB is offered with all our Linux semi-dedicated servers by default, so the moment you purchase a new semi-dedicated account, you can go on and install any PHP-powered software application that requires the storage engine. A few engines are installed on our cloud hosting platform, so when you create a brand-new MySQL database and start installing an app manually, or decide to take advantage of the Hepsia hosting Control Panel-integrated app installer, the engine for the database will be chosen on the basis of the given app’s requirements. This will allow you to install and run InnoDB-specific applications without having to deal with any complication and without configuring any settings in your semi-dedicated account. To take no chances, we will always keep a 1-week-old backup of all your MySQL databases, so if you erase or alter any content by accident, we can swiftly retrieve it.
InnoDB in VPS Servers
If our custom-built Hepsia Control Panel is chosen during the signup process for a new VPS plans , InnoDB will be activated on the VPS server together with other necessary software, so you will not have to do anything if you decide to use PHP script-powered applications that need this MySQL database storage engine. MyISAM – the default MySQL engine, will be activated as well. You can set up a new database and begin the app installation procedure manually or using our 1-click installation tool. The system will automatically detect the engine that the particular application needs and will set it for the specific MySQL database, so the installation process will continue flawlessly and the application can enter its data into that database. Therefore, you can activate apps with various requirements about the MySQL engine without making any changes on your VPS server.
InnoDB in Dedicated Servers
InnoDB comes as standard with all Linux dedicated web hosting plans ordered with the Hepsia Control Panel. It is included in the standard software package that will be pre-installed on all Hepsia-equipped servers, so as soon as your physical machine is up and running, you will be able to log in and to activate any type of open-source script-based software application that needs this database engine. If you create a new MySQL database through the Control Panel, there won’t be any activated engine until you begin installing an app. As soon as the app configuration wizard begins dumping data in the database, the engine will be set automatically in accordance with the specific app’s requirements, so you can run both MyISAM and InnoDB without the need to select either one of them specifically at any point. In this way, you can make use of a wide range of apps for your websites.