Read more about InnoDB and see why it’s recently been chosen as the default MySQL database engine.
InnoDB is a very popular storage engine for the MySQL relational database management system. It is an alternative to the default engine – MyISAM, and it has got numerous advantages that have made it the preferred engine for numerous open-source script-based applications, such as Joomla™ and Magento, which have switched over to InnoDB permanently. For instance, importing large amounts of data will be much faster with InnoDB, due to the fact that it locks only a single database row to execute a specific task, not the entire table, which makes the engine perfect for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the manner in which the data is handled. To put it simply, adding new or editing existent data will either be fully completed, or will be annulled and the procedure will be rolled back in case some problem shows up during the process, which is why the content that remains in the database will not be damaged.
InnoDB in Hosting
InnoDB is offered with all our Linux hosting
by default, not upon request or as a paid upgrade, so you can install and run any open-source script-driven software application which requires the InnoDB database storage engine without having to deal with any obstacle once you order your shared web hosting account. InnoDB will be selected automatically as the default engine for a given MySQL database during the app activation, no matter if you make use of our one-click installation tool or create the MySQL database and activate the app manually, on the condition that the app requires InnoDB instead of the more popular MyISAM engine. We will perform regular database backups, so you can rest assured that you will never lose any content in case you delete a database by mistake or you overwrite some key information – you will just have to contact us and we will restore your data the way it was.
InnoDB in Semi-dedicated Hosting
InnoDB is offered with all our Linux semi-dedicated hosting
by default, so as soon as you get a new account, you can move on and install any script-driven application that needs this MySQL database storage engine. Several engines are pre-installed on our cloud hosting platform, so when you create a brand-new MySQL database and begin installing an app manually, or opt to use the Hepsia Control Panel-integrated app installer tool, the engine for the database will be set in accordance with the prerequisites of the app in question. This will permit you to install and run InnoDB-specific applications without needing to cope with any problem and without updating any settings in your account. To avoid any risk, we will always have a 1-week-old backup of all your databases, so if you remove or edit any content by mistake, we can easily restore it.
InnoDB in VPS
All Linux VPS
that are ordered with the Hepsia Control Panel come with InnoDB pre-activated, so you will be able to make use of any open-source script-driven software application that requires the database storage engine without activating anything manually. You can pick Hepsia on the VPS order page and your brand new Virtual Private Server will be ready within sixty minutes, so you can log in and start building your websites right away. When you create a brand new MySQL database and begin the app installation process, our system will set the engine for that database automatically. In this way, you can run different applications at the same time without configuring anything on the Virtual Private Server. You can set up a WordPress-powered blog that makes use of MyISAM – the default MySQL engine, and a Magento Internet shop that makes use of InnoDB, for instance.
InnoDB in Dedicated Hosting
Our Hepsia Control Panel is among the options which you can select on the order page when you buy a dedicated server
from our company. Since this is the most powerful kind of web hosting, it is rather likely that you will run popular Internet sites that will draw plenty of individuals, and since InnoDB is among the best options for such websites, we’ll enable it together with all the other software applications that are offered with a Hepsia-managed server. When you create a brand-new MySQL database in your dedicated account, there won’t be any active MySQL database storage engine until you start installing a script, whether manually through your browser or using the automatic scripts installer tool that is integrated into the hosting Control Panel. The necessary engine will be automatically detected and will be assigned to that database, so you can install scripts that require InnoDB, as well as ones that require the default MySQL engine – MyISAM, without needing to deal with any obstacle.