InnoDB
Read more about InnoDB and find out why it’s recently been chosen as the default MySQL database engine.
InnoDB is a popular database engine for MySQL. It is an alternative to the default engine – MyISAM, and it has got plenty of strong sides that make it the engine of choice for a lot of open-source script-based apps, such as Joomla™ and Magento, which have switched over to InnoDB permanently. For example, importing large amounts of data will be much faster with InnoDB, due to the fact that it locks only one row to carry out a given operation, not the entire table, which makes the engine perfect for scalable apps. It also supports foreign keys and database transactions – these refer to the manner in which the info is handled. Simply put, appending new or updating existent data will either be thoroughly completed, or will be annulled and the procedure will be rolled back if a certain problem appears in the meantime, hence the content that remains in the database won’t be damaged.
-
InnoDB in Cloud Hosting
While InnoDB is either a paid upgrade or it is not available at all with other web hosting companies, it is part of the default set of features offered with our
cloud hosting plans. In case you want to make use of a PHP-based application that requires InnoDB specifically, in order to be activated and to operate properly, you will not experience any impediments as the InnoDB storage engine is available on our custom-developed cloud web hosting platform. Irrespective of whether you create a brand-new MySQL database and activate an application manually or make use of our one-click application installer instrument, InnoDB will be selected automatically by our system as the default engine if the application needs InnoDB instead of MyISAM. In addition to the incredible crash recovery that InnoDB offers, we also store regular backups of all databases, so we can swiftly recover any MySQL database in your shared hosting account.
-
InnoDB in Semi-dedicated Hosting
All our
semi-dedicated services include InnoDB and you will be able to get the most out of all the features of this MySQL database engine with any PHP-driven app that requires it. It’s among the engines that are available on our cloud web hosting platform, so the one that will be picked depends on the given app’s requirements. You won’t need to do anything manually to activate InnoDB, since it will be set as the default engine whenever you install an application – whether manually or using our 1-click application installer tool. To avoid any risk, we will keep regular database backups, so if something goes wrong after some update or if you delete some data unintentionally, we’ll be able to restore the database the way it was on any of the previous 7 days.
-
InnoDB in VPS Hosting
All
VPS hosting that are ordered with the Hepsia hosting Control Panel come with InnoDB already installed, so you’ll be able to use any PHP-driven app that needs this MySQL database storage engine without the need to set up anything manually. You can choose Hepsia on the VPS order form and your brand new Virtual Private Server will be ready within 60 minutes, so you can log in and begin building your web sites straight away. When you create a new database and start the app installation process, our system will choose the engine for that MySQL database automatically. Thus, you can manage various applications simultaneously without the need to change anything on the VPS server. You can have a WordPress-powered weblog that uses the default MySQL engine – MyISAM, and a Magento-powered online shop that uses InnoDB, for example.
-
InnoDB in Dedicated Web Hosting
When you buy a new
dedicated server, you’ll be able to select one of the three Control Panels that we’re offering – cPanel, DirectAdmin and Hepsia. Each dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you will not need to add this MySQL database engine manually so as to be able to run open-source script-driven web apps that require it. InnoDB is used for scalable applications and since a dedicated server will supply you with all the system resources that you need to run very large websites, it’s very likely that you’ll resort to InnoDB. You’ll be able to make use of other engines as well, so in case a given application requires MyISAM rather than InnoDB, you will not experience any problem while using it. The engine that will be used will be automatically detected once the app installation procedure begins, so you won’t have to configure any settings manually at any moment.