InnoDB is a very popular database engine for the MySQL RDBMS. It is an alternative to the default engine – MyISAM, and it has got numerous advantages which make it the preferred engine for numerous PHP script-powered software apps, among them Magento and Joomla, which have switched over to InnoDB for good. For instance, importing enormous amounts of data will be much faster with InnoDB, since it locks only a single database row to carry out a given task, not the entire database table, which makes the engine ideal for scalable applications. It also supports foreign keys and transactions – these refer to the way in which the data is handled. To put it simply, adding new or updating existing data will either be fully completed, or will be annulled and the procedure will be rolled back in case a given issue shows up during the process, hence the content that remains in the database won’t be damaged.

InnoDB in Hosting

You’ll be able to make use of any script-driven web application that requires InnoDB if you’ve got a hosting plan with us, as the MySQL database engine is present on our avant-garde cloud hosting platform as standard. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue flawlessly if this engine is needed. You can run apps which require the MyISAM engine without having any difficulty as well and, once again, the engine will be pre-selected, so you won’t need to update anything manually at any moment. Furthermore, we’ll also make daily backups of all the databases that you have in the shared web hosting account, so in case you delete or overwrite something, we can quickly restore it the way it was on any of the previous 7 days.

InnoDB in Semi-dedicated Servers

InnoDB is available with all our semi-dedicated hosting plans by default, so the moment you obtain a new semi-dedicated account, you can move on and install any PHP-based software app that requires the storage engine. A few engines are installed on our cloud platform, so when you set up a brand new MySQL database and start installing an application manually, or decide to make use of the Hepsia hosting Control Panel-integrated application installer, the engine for the database will be set depending on the requirements of the app in question. This will allow you to activate and run InnoDB-specific applications without coming across any difficulty and without modifying any settings in your account. To avoid any risk, we will always have a 7-day-old backup of all your MySQL databases, so if you remove or change any content accidentally, we can easily restore it.

InnoDB in VPS Servers

All VPS plans that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-installed, so you’ll be able to take advantage of any open-source script-powered web application that requires the database engine without the need to set up anything manually. You can select Hepsia on the VPS order page and your brand new server will be up and running within 60 minutes, so you can sign in and begin building your websites right away. Once you create a brand new MySQL database and start the app installation process, our system will pick the engine for that database automatically. In this way, you can run different apps simultaneously without updating anything on the server. You can have a WordPress-based personal journal that uses the default MySQL engine – MyISAM, and a Magento Internet shop that uses InnoDB, for instance.

InnoDB in Dedicated Servers

When you buy a new dedicated server, you will be able to select any of the three hosting 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 enable this MySQL storage engine manually to be able to manage open-source script-based web applications that require it. InnoDB is used by scalable apps and since a dedicated server will provide you with all the resources that you require to run large-size websites, it’s very possible that you will resort to InnoDB. You will be able to use other engines too, so if a certain app needs MyISAM rather than InnoDB, you won’t experience any difficulty while using it. The engine that will be used will be recognized automatically when the app installation process starts, so you won’t have to alter any setting manually whatsoever.