InnoDB is a very popular storage engine for the MySQL database management system. It’s an alternative to the default engine – MyISAM, and it has numerous strong sides that have made it the preferred engine for a lot of script-driven web apps, such as Magento and Joomla, which have switched over to InnoDB permanently. For example, importing huge amounts of data will be much faster with InnoDB, as it locks only a single row to perform a specific operation, not the entire table, which makes the engine excellent for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the way in which the info is tackled. Put simply, adding new or updating existing data will either be thoroughly completed, or will be annulled and the operation will be rolled back if some issue shows up during the process, which is why the content that remains in the database will not be lost.

InnoDB in Website Hosting

InnoDB is offered with all our website hosting by default, not upon request or as a paid upgrade, so you’ll be able to activate and run any PHP-powered software app which needs the InnoDB database engine without any impediments as soon as you order your shared hosting account. InnoDB will be pre-selected as the default engine for a specific MySQL database during the app installation, irrespective of whether you take advantage of our 1-click installation tool or create the database and activate the application manually, as long as the app requires InnoDB instead of the more famous MyISAM engine. We’ll carry out daily backups of all your databases, so you can be certain that you won’t ever lose any data if you erase a database by mistake or you overwrite some essential info – you just have to get in touch with us and we’ll restore your data the way it was.

InnoDB in Semi-dedicated Servers

All our semi-dedicated servers support InnoDB and you’ll be able to take advantage of all the options offered by this database storage engine with any open-source script-powered software application that needs it. It’s one of the engines that we have on our cloud website hosting platform, so the one that will be used depends on the particular app’s requirements. You won’t have to do anything manually to activate InnoDB, because it will be set as the default engine when you install an application – whether manually or using our 1-click application installer. To avoid any risk, we will perform daily MySQL database backups, so if anything goes wrong after some update or if you erase some data by accident, we will be able to restore your database the way it was on any of the previous seven days.

InnoDB in VPS Servers

If our custom Hepsia Control Panel is picked during the registration process for your new VPS servers , InnoDB will be activated on the server along with other essential pieces of software, so you will not need to do anything if you choose to manage script-based applications that need this MySQL storage engine. MyISAM – the default MySQL engine, will be installed as well. You can create a brand-new MySQL database and begin the app installation manually or using our single-click installation tool. The system will automatically recognize the engine that the app in question requires and will assign it to the specific database, so the installation will proceed flawlessly and the app can enter its content into that database. Therefore, you can run applications with various requirements with regard to the MySQL engine without making any changes on your VPS server.

InnoDB in Dedicated Servers

If you purchase a new dedicated server, you’ll be able to select any of the 3 Control Panels offered by us – cPanel, DirectAdmin and Hepsia. Any server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you won’t need to enable this database engine manually so as to be able to use PHP-powered apps that require it. InnoDB is used for scalable applications and since a dedicated server will supply you with all the server resources that you require in order to run large-scale websites, it’s quite possible that you’ll resort to InnoDB. You will be able to use other engines as well, so in case a particular app requires MyISAM instead of InnoDB, you won’t run into any complication while managing it. The engine that will be used will be automatically detected the moment the app installation begins, so you won’t need to update any settings manually at any point.