Through the Databases Manager integrated into the Control Panel, it is possible to build completely new MySQL and PgSQL databases instantly! Moreover, you will possess direct access to the administrator area software programs (phpMyAdmin and phpPgAdmin, respectively), allowing you to effectively revise the database you want.
An Easy to use User interface
Be in charge of your databases with just a click
Taking control of your databases now is easier than ever before, thanks to the Control Panel interface for MySQL and PgSQL control! Provided you do not have in depth knowledge of making use of databases, it will be easy to handle our Databases Manager.
You may create a completely new database by merely keying in the username and security password or create a database back–up with merely a click of the mouse. In addition, through the Data Manager you’ll get direct access to the admin area for every database, which means you can quite simply modify it.
Quick Database Back–up
Back up your databases in a moment
We have transformed the manual database back–up generation into a quite easy job. To do so: within the Databases Manager, click the ’clock’ image beside the database that you plan to back up and then wait for a couple of seconds for the process to take place. Depending upon the size of the database, the building of a backup file can take somewhere between a couple of seconds and a minute.
You may make as many backups of a database as you desire. We’ve not determined any restrictions about the amount of databases that you can back up as well.
The most protected open source databases
Practically all of the Linux shared website hosting packages bundles present PgSQL support. While falling behind MySQL with regard to popularity and employment, PgSQL databases are famous for offering up the greatest level of stability for your web site content. This is the primary reason why companies like Skype and Yahoo make use of PgSQL databases as a substitute for MySQL.
When it comes to database management, PgSQL is as easy to understand as MySQL.
The new face of MySQL
We’ve installed InnoDB – the brand new default MySQL database engine on all of our machines. InnoDB is ideal for substantial database web sites which need high levels of effectiveness and scalability. Experiments demonstrate that web sites applying InnoDB based tables attain a 3–fold effectiveness grow for significant joins, in comparison to those working with MyISAM tables.
InnoDB employs row–level locking so as to clear away the efficiency issues discovered at the high usage times of the prior release of the database engine – MyISAM, which employs table–level locking.
Detailed Database Stats
Detailed stats for all your databases
Advance Computer Group offers you a painless option to monitor the database usage for your dynamic websites. Through the thorough database stats interface, which is integrated into the Control Panel, you are able to monitor the load created from your active websites in real time. The supplied info will help you analyze the database load fluctuations on an hourly basis, each day or on a monthly basis.
You’ll be able to monitor the database load for your sites in the Database Stats part of the Control Panel. The table onscreen shows the database queries made in the present month. To look at details for a previous month, all you have to do is click on the back arrows located at the top.