InnoDB is a database engine for MySQL databases, which is used by widespread script-driven applications like Magento and Joomla 3. It’s perfect for scalable applications, because it excels in managing immense volumes of data. Instead of locking the entire table to add new information to a database like many other engines do, InnoDB locks only one row, so it can carry out a lot more tasks for the same period of time. Additionally, InnoDB offers a much better database crash recovery and supports database transactions and foreign key constraints – rules that specify how data imports and updates should be handled. If a given task hasn’t been fully completed for any reason, the action will be rolled back. Thus, the information in the database will stay safe and sound and will not be partially mixed with newly appended content.
InnoDB in Shared Hosting
InnoDB is available with all our shared plans by default, not upon request or as a paid upgrade, so you will be able to activate and run any script-powered web application that needs the MySQL storage engine without any difficulties as soon as you order your shared website hosting account. InnoDB will be pre-selected as the default engine for a certain database during the app activation process, irrespective of whether you take advantage of our single-click installer or create the MySQL database and install the app manually, on the condition that the application requires InnoDB instead of the more popular MyISAM engine. We’ll maintain daily MySQL database backups, so you can be certain that you won’t ever lose any content in case you delete a database by mistake or you overwrite some vital info – you’ll just need to get in touch with us and we’ll restore your data back to normal.
InnoDB in Semi-dedicated Servers
If you set up a brand-new MySQL database from the Control Panel offered with all our semi-dedicated server plans and you start installing a script-powered software application either manually or using our 1-click app installer, the database storage engine will be selected automatically on the basis of the requirements of the specific application. As InnoDB is available on the cloud hosting platform where your new semi-dedicated server account will be created, it will be set as the default engine for each application that needs it without any manual intervention required on your end at any moment. To avoid any chance of losing data if you update an app or if you delete a database by accident, we will carry out a backup of all your databases each day, so if something happens, we can restore your data.
InnoDB in VPS Servers
If you purchase a VPS server from our company, you’ll be able to take advantage of our custom Hepsia Control Panel to manage your web content. A Hepsia-managed Virtual Private Server will permit you to activate any open-source script-powered web application which needs InnoDB, as this storage engine is included in the software bundle that will be pre-installed on your server during its creation. When you create a brand-new database using the hosting Control Panel, you will just have to start installing an application – manually or using our app installer tool. InnoDB will be set as the default engine given that the app in question needs it, so you will not need to do anything else in your VPS account. Correspondingly, if a given app needs MyISAM, it will be automatically set as the default engine for this concrete database.
InnoDB in Dedicated Servers
Our Hepsia hosting Control Panel is among the options that you can choose on the server order page when you buy a dedicated server from us. Since this is the most powerful kind of website hosting, it is very likely that you’ll run popular sites that will draw plenty 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 come with a Hepsia-equipped server. When you set up a new database in your dedicated server account, there won’t be any active MySQL database engine until you start installing a script, whether manually through your browser or using the automatic script installer that is available in the hosting Control Panel. The needed engine will be automatically recognized 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 encountering any complication.