Database Manager

The Database Manager inside the Web Site Control Panel includes a robust but simple to operate user interface. You’ll be able to set up a whole new MySQL or PostgreSQL database by just typing a username and security password. Additionally, you may create a backup file or change the password of an database with a click of the mouse.

Through the Database Manager you will get direct access to the administration area for every one of your databases, so its possible to make convenient corrections in case you have to.

With the Database Manager it is easy to generate an archived backup of your database when you need! For this reason, you are going to always have a back–up of your dynamic content if your site gets hacked or you erroneously delete a database. To create a backup: click on the ’clock’ image next to a certain database and afterwards simply wait for a few seconds for the process to be completed.

There won’t be any restrictions on the number of databases you are able to back up or the volume of backup copies you can create for a database.

PgSQL databases are less common as compared to the widespread MySQL databases. Then again, they are a preferred option for designers who are looking for the finest safety for their websites and web apps. Through the intuitive Database Manager integrated into the NRGHost Hosting Control Panel, you can administer all your PostgreSQL databases with simply a click of the mouse.

You’ll find PgSQL databases integrated automatically in the top Linux shared website hosting plans packages. Provided that you are with a standard hosting package, it is easy to ask for PgSQL databases to be added in your hosting account as upgrades.

With NRGHost Hosting, you’ll inevitably find the most current variant of MySQL along with the default MySQL storage engine – InnoDB, installed.

InnoDB is far more reliable in comparison to the previous storage engine’s version – MyISAM. It is ACID–compliant and, above all – it has complete transaction support. Furthermore, it utilizes row–level locking, as an alternative to MyISAM’s table–level locking, that seemed to result in functionality troubles at peak usage times.

Tracking the load caused by the databases on your busy site makes it possible to avoid any overload difficulties that could slow it down and chase away site visitors. For that reason, we’ve built–in a in–depth Database Stats tool directly into the Web Site Control Panel. There you shall find complete information about the incoming requests to your databases for every hour, day and month.

Based on the number of daily and per hour queries, it is possible to find out which databases are being used the most and then take actions to optimize their load.