From the Database Manager integrated into the Web Site Control Panel, it will be easier to make brand–new MySQL and PgSQL databases instantly! At the same time, you will have direct access to the admin area software tools (phpMyAdmin and phpPgAdmin, respectively), so that you can conveniently modify the database you want.
A Convenient–to–use User interface
Handle your databases with only a click
Supervising your databases is easier than before, as a result of Web Site Control Panel user interface for MySQL and PgSQL control! In case you do not have detailed knowledge of managing databases, you will find it effortless to handle the Database Manager.
You can make a new database by only typing the user name and security password or produce a database back–up with just a click of the mouse. Likewise, from the Data Manager you will have direct access to the administrator area for every single database, which enables you to quickly revise it.
Easy Database Back–up
Back up your databases in just a moment
We’ve changed the manual database backup formation into a quite easy activity. To execute this: inside the Database Manager, click on the ’clock’ image on the side of the database that you intend to back up and then wait around for a couple of seconds for the process to take place. With respect to the size of the database, the generation of a backup file will need between a few seconds and a minute.
You may make as many back–ups per database as you desire. We have not specified any confines for the volume of databases you can back up either.
Just about the most secure open source databases
Practically all of the cloud hosting bundles grant PgSQL support. Although dropping behind MySQL when it comes to acceptance and utilization, PgSQL databases are renowned for offering the highest level of safety for your site content. That’s the reason why companies like Skype and Yahoo go with PgSQL databases and not MySQL.
With regards to database management, PgSQL is identically simple and easy as MySQL.
The brand new face of MySQL
With Server Systems, you’ll invariably discover the most recent release of MySQL and also the default MySQL storage engine – InnoDB, installed.
InnoDB is much more reliable than the past storage engine’s version – MyISAM. It is ACID–compliant and, best of all – it gives you 100% transaction support. In addition, it makes use of row–level locking, as an alternative to MyISAM’s table–level locking, that would always cause efficiency issues at high usage times.
Detailed Database Stats
Comprehensive statistics for all of your databases
Keeping track of the load caused by the databases on your busy web site will help you prevent all overload difficulties that could slow it down and chase away site visitors. As a result, we’ve built–in a in depth Database Stats tool in the Web Site Control Panel. There you will find thorough info on the incoming requests to your databases for each hour, day and month.
Using the volume of daily and per hour queries, it will be easier to find out which databases are utilized the most and consider steps to optimize their work.