Find out more about InnoDB and find out why it’s already been picked out as the default MySQL database engine.
InnoDB is a popular storage engine for the MySQL database management system. It is an alternative to the default engine – MyISAM, and it has numerous strengths that make it the engine of choice for plenty of open-source script-powered software apps, among them Joomla™ and Magento, which have shifted over to InnoDB for good. For instance, importing immense amounts of data will be much faster with InnoDB, as it locks only one row to perform a certain task, not the entire database table, which makes the engine ideal for scalable applications. It also supports foreign keys and database transactions – these refer to the manner in which the info is treated. Put simply, adding new or updating existent data will either be fully completed, or will be annulled and the procedure will be rolled back in case some problem occurs during the process, thus the content that remains in the database will not be damaged.
InnoDB in Cloud Web Hosting
Any PHP script-powered web app that requires InnoDB will run impeccably on our leading-edge cloud platform and the MySQL database storage engine is offered with all our cloud web hosting
plans. Whenever you create a database manually or our app installer creates one automatically and an app installation is started, the engine that the database in question will use will be selected in accordance with the app’s prerequisites without having to configure any setting in your shared web hosting account. InnoDB will be selected automatically for any application that requires this specific engine and you’ll be able to get the most out of its full potential. We will create daily backups of your content, so in case you accidentally delete a MySQL database that is important to you or you overwrite specific parts of it, we will be able to restore your data the way it was just a couple of hours ago.
InnoDB in Semi-dedicated Hosting
InnoDB is available with each of our semi-dedicated hosting
by default, so as soon as you purchase a new account, you can move on and activate any PHP-powered software app that requires this particular storage engine. A number of engines are pre-installed on our cloud web hosting 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 picked on the basis of the particular app’s requirements. This will allow you to install and manage InnoDB-specific apps without any impediment and without having to edit any settings in your semi-dedicated account. To take no chances, we’ll always have a one-week-old backup of all your MySQL databases, so if you delete or alter any content by accident, we can easily retrieve it.
InnoDB in VPS Hosting
If you choose a virtual private server
with our Hepsia Control Panel, the InnoDB database storage engine will be included in the standard software package that will be pre-installed on your server before we give it to you. You will not have to configure anything manually and you will be able to enable and manage any open-source script-driven web application that requires InnoDB once your VPS server is up and running, which takes no more than one hour after the order process itself. Several engines are offered, so every time you create a database via the Hepsia hosting Control Panel, a particular engine will be picked when the app activation begins and our system will automatically recognize which engine is required by the application in question. In case you need MyISAM, for example, you will not need to do anything different than installing the chosen app, whether manually or using our app installer.
InnoDB in Dedicated Web Hosting
All Linux dedicated web hosting
that are ordered with our custom Hepsia hosting Control Panel include a software bundle that is pre-activated and among everything else, you will get the InnoDB storage engine, so you won’t have to add it manually if you want to run PHP scripts that require it. All it takes to install such a script is to create a new database and to initiate the installation process – once the setup wizard acquires access to the database and begins inserting data into it, InnoDB will be set as the default engine for this database as long as it is the one needed by the script. You will also be able to use scripts that need MyISAM – the other widely used MySQL engine, so you will not have to configure any settings on the dedicated server. This will enable you to use different scripts on one single physical server and to use it to its fullest capabilities.