Database Manager

Taking control of your databases is less complicated than ever before, thanks to the Web Hosting Control Panel interface for MySQL and PgSQL control! Even though you may not have thorough expertise in making use of databases, it will be an easy task to manage the Database Manager.

You can create a completely new database by merely typing the user name and security password or produce a database back–up with merely a click of the mouse. Additionally, through the Data Manager you will possess direct access to the management area for every single database, so you’re able to efficiently manage it.

Within the Database Manager you’ll be able to generate an archived backup of your database whenever you need! That way, you’ll always have a data backup of your operating information if your web site gets hacked or you incorrectly delete a database. To produce a back–up: click on the ’clock’ icon alongside a particular database and then just wait for a couple of seconds for the backup process to be carried out.

There aren’t any limitations on the quantity of databases you would be able to back up or the volume of backups you may make for any database.

A lot of our shared website hosting plans packages grant PgSQL support. While dropping behind MySQL in terms of level of popularity and employment, PgSQL databases are renowned for delivering the greatest level of stability for your site content. It is the basic reason why companies such as Skype and Yahoo rely on PgSQL databases rather than MySQL.

When it comes to database administration, PgSQL is as quick as MySQL.

With N-MAN, you shall inevitably find the latest build of MySQL and also the default MySQL storage engine – InnoDB, installed.

InnoDB is much more stable as compared to the old storage engine’s version – MyISAM. It’s ACID–compliant and, most significantly – it has full transaction support. In addition, it employs row–level locking, as an alternative to MyISAM’s table–level locking, that seemed to lead to functionality problems at high usage times.

Tracking the load made by the databases for your powerful web site will let you stop any overload problems that can slow it down and ward off visitors. As a result, we have bundled a in depth Database Stats tool into the Web Hosting Control Panel. There you can get comprehensive info on the inbound requests to your databases for every single hour, day and month.

Using the quantity of day–to–day and per hour queries, you are going to be able to find out what databases are utilized the most and consider procedures to enhance their load.