InnoDB is a storage engine for MySQL databases, which is used by famous script-powered software apps such as Joomla™ 3 and Magento. It’s perfect for scalable apps, as it works amazingly well when handling immense volumes of data. Instead of locking the entire table to import new information into a database like many other engines do, InnoDB locks only one row, so it can perform a lot more operations for the same period of time. Plus, InnoDB offers a faster database crash recovery and supports transactions and foreign keys – a set of rules that specify how data imports and modifications should be treated. In case a given operation has not been entirely completed for whatever reason, the action will be rolled back. Thus, the information in the database will remain undamaged and won’t be partially merged with newly added content.
InnoDB in Cloud Hosting
InnoDB is available with all our cloud plans by default, not as a paid upgrade or upon request, so you can activate and run any script-powered software app which needs the storage engine without the need to deal with any obstacle once you activate your account. InnoDB will be selected automatically as the default engine for a particular database during the app activation process, regardless of whether you take advantage of our single-click installation tool or create the database and activate the application manually, as long as the application requires InnoDB instead of the more popular MyISAM engine. We will carry out daily backups of all your MySQL databases, so you can rest assured that you will never lose any data in case you erase a database by mistake or you overwrite some essential information – you will simply have to notify us and we’ll restore the database back to normal.
InnoDB in Semi-dedicated Servers
InnoDB is offered with all our semi-dedicated hosting plans by default, so as soon as you create a new semi-dedicated account, you can go on and activate any script-driven web application that requires the MySQL database engine. Several engines are installed on our cloud platform, so when you set up a brand new database and start installing an app manually, or opt to take advantage of the Hepsia Control Panel-integrated application installer, the engine for the database will be set in accordance with the given app’s requirements. This will permit you to activate and manage InnoDB-specific apps without experiencing any obstacle and without having to configure any settings in your semi-dedicated account. To take no chances, we will always have a seven-day-old backup of all your MySQL databases, so if you remove or edit any content unintentionally, we can quickly rescue it.
InnoDB in VPS Servers
If you buy a VPS server from our company, you’ll be able to take advantage of our custom-built Hepsia Control Panel to manage your web content. A Hepsia-managed VPS will allow you to activate any PHP script-powered software app that requires InnoDB, as the MySQL storage engine is an essential part of the default software bundle that will be pre-installed on the VPS server during its creation. When you set up a brand new MySQL database via the hosting Control Panel, you just need to begin installing an app – manually or using our application installer tool. InnoDB will be set as the default engine given that the application in question requires it, so you will not need to do anything else in your account. Identically, if an app requires MyISAM, it will be automatically set as the default engine for this concrete database.
InnoDB in Dedicated Servers
Our Hepsia hosting Control Panel is one of the features which you can select on the server configuration page when you buy a dedicated server from our company. Since this is the most powerful kind of website hosting, it is very likely that you’ll manage highly popular websites that will draw lots of visitors, and since InnoDB is one of the very best choices for such sites, we’ll activate it along with all the other software apps that are offered with a Hepsia-equipped server. If you create a brand-new database in your dedicated server account, there won’t be any activated MySQL database storage engine until you start installing an open-source PHP script, whether manually through your browser or using the automatic script installer tool that is included in the Control Panel. The required engine will be detected and will be assigned to the database in question, so you can run scripts that require InnoDB, as well as ones that need MyISAM, the default MySQL engine, without having to cope with any complication.