InnoDB is a MySQL database engine, which has been gaining in popularity in recent years, because it offers a much better overall performance and an improved database crash recovery in comparison with the default engine that’s used by the MySQL RDBMS – MyISAM. InnoDB is endorsed by numerous developers that write scalable web apps, because it works much more efficiently with huge amounts of data, while it keeps the server processing load at a minimum. Furthermore, it uses row-level locking in case anything should be edited, while lots of other engines lock the entire database table and thus require more time to complete several consecutive tasks. Last, but not least, InnoDB abides by a set of "all-or-nothing" rules – in case the entire data modification process cannot be completed successfully for any reason, the operation is rolled back to prevent confusion or the loss of data. Magento and the newest Joomla releases are two examples of popular script-powered software applications that have switched to InnoDB.
InnoDB in Web Hosting
Any script-driven web app that requires InnoDB will function flawlessly on our innovative cloud platform and the storage engine is offered with all our web hosting packages. 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 use will be selected in accordance with the app’s requirements without having to change any setting in your shared account. InnoDB will be chosen automatically for any app that requires this particular engine and you will be able to make the most of its full capacity. We’ll create regular content backups, so if you accidentally erase a database that you need or you overwrite a certain part of it, we will be able to restore everything the way it was just a few hours ago.
InnoDB in Semi-dedicated Servers
If you create a new MySQL database from the hosting Control Panel coming with each of our semi-dedicated server packages and you start installing a PHP script-driven software application either manually or using our single-click application installer, the storage engine for the MySQL database will be set automatically depending on the given app’s requirements. As InnoDB is present on the cloud hosting platform where your new semi-dedicated hosting account will be created, it will be set as the default engine for any application that requires it without the need for any manual action on your end at any moment. To avoid any risk of losing info if you update an app or if you remove a database accidentally, we’ll generate backups of all your MySQL databases each day, so if something happens, we can retrieve your content.
InnoDB in VPS Servers
All Linux VPS servers that are ordered with the Hepsia Control Panel come with InnoDB pre-installed, so you’ll be able to run any open-source script-driven software application that needs this particular MySQL database storage engine without installing anything manually. You can pick Hepsia on the VPS order page and your brand new server will be set up within the hour, so you can log in and begin building your Internet sites straight away. Once you create a brand new database and begin the app installation process, our system will set the engine for that MySQL database automatically. Thus, you can activate various apps at the same time without the need to update anything on the Virtual Private Server. You can create a WordPress-powered online journal that uses the default MySQL engine – MyISAM, and a Magento e-shop that uses InnoDB, for instance.
InnoDB in Dedicated Servers
Our Hepsia Control Panel is one of the options that you can choose on the server order page when you purchase a dedicated server from us. Since this is the most powerful type of web hosting, it’s rather likely that you will run popular sites that will draw lots of people, and since InnoDB is among the best options for such websites, we will activate it together with all the other software apps that are offered with a Hepsia-equipped server. When you create a brand-new database in your account, there won’t be any activated MySQL storage engine till you begin installing a PHP script, whether manually through your Internet browser or using the automatic scripts installer that is integrated into the Control Panel. The necessary engine will be detected and will be set for that database, so you can run scripts that need InnoDB, as well as ones that need the default MySQL engine – MyISAM, without needing to deal with any obstacle.