Database Manager

Taking control of your databases is much simpler than before, as a result of Control Panel user interface for MySQL and PgSQL administration! Even though you may not have extensive experience of dealing with databases, you will find it very easy to use the Database Manager.

You could make a whole new database by merely specifying the username and password or generate a database backup with just a click of the mouse. Moreover, with the Data Manager you will get direct access to the admin area for each database, so that you can quite simply update it.

Assuming you have worked with databases, you already know that making a manual database back–up is simply not a basic task. In order to change this, we’ve created a simple tool that will back up the entire database with only one click of the mouse. The back–up file will be ready for you in less than a minute, with regards to the size of the selected database.

There won’t be any limitations on how many back–ups you can create for any selected database.

A lot of the Linux web hosting service plans provide PgSQL support. Although dropping behind MySQL with regards to level of popularity and utilization, PgSQL databases are famous for giving the top level of security for your web site content. That’s the key reason why companies like Skype and Yahoo rely upon PgSQL databases rather than MySQL.

In terms of database administration, PgSQL is identically straightforward as MySQL.

With WebPad, you’ll invariably find the most recent edition of MySQL and the default MySQL storage engine – InnoDB, set up.

InnoDB is a lot more stable as compared to the earlier storage engine’s edition – MyISAM. It’s ACID–compliant and, most significantly – it gives you 100% transaction support. In addition, it employs row–level locking, as a substitute for MyISAM’s table–level locking, that used to result in effectiveness problems at high usage times.

From your detailed database stats tool included in the Control Panel, you will be able to keep track of the stress generated from your busy web sites 24 hour a day. Every single overload trouble with your sites could slow the loading speeds and have a bad influence over the overall impression of your site visitors. Thus, by having data for the database load right away, it will be straightforward to fix overload problems right away.

The database statistics user interface reveals data of the volume of daily, hourly and monthly lookups, which means you can assess the way the load is allocated over several time frames.