Databases Manager

Supervising your databases now is easier than in the past, thanks to the Web Site Control Panel user interface for MySQL and PgSQL management! Assuming you do not have thorough knowledge of managing databases, it will be very easy to use the Databases Manager.

You could make a completely new database by simply keying in the username and password or make a database back–up with just a click of the mouse. Likewise, through the Data Manager you’ll get direct access to the admin area for each and every database, which enables you to conveniently alter it.

Assuming you have worked with databases, you know that generating a manual database backup is not a simple task. As a way to change this, we’ve created an easy to understand tool that can back up your complete database with only a single click of the mouse. The back–up file is going to be available for you in less than a minute, with regards to the size of the chosen database.

You won’t notice any limits on exactly how many back–ups you may make for any particular database.

Nearly all of YASPE’s Linux web hosting packages grant PgSQL support. Although falling behind MySQL in terms of level of popularity and application, PgSQL databases are famous for delivering the highest level of security for your website content and articles. That is the key reason why brands like Skype and Yahoo rely upon PgSQL databases as an alternative to MySQL.

With regard to database administration, PgSQL is equally easy to understand as MySQL.

With YASPE, you’ll regularly find the newest variant of MySQL and also the default MySQL storage engine – InnoDB, mounted.

InnoDB is far more stable compared to the old storage engine’s version – MyISAM. It’s ACID–compliant and, most significantly – it has 100% transaction support. Furthermore, it takes advantage of row–level locking, as opposed to MyISAM’s table–level locking, that used to lead to performance troubles at peak usage periods.

We supply you an effortless option to keep tabs on the database consumption for your active web sites. From your thorough database stats interface, that is built–into the Web Site Control Panel, you can easily keep track of the load accumulated by your busy websites in real time. The delivered details will help you assess the database load changes on an hourly basis, every day or on a monthly basis.

You can track the database load for all of your web sites from the Database Stats part of the Web Site Control Panel. The table on–screen shows the database lookups made in the present month. To inspect data for a past month, just click on the back arrows placed at the top.