With the Databases Manager integrated into the Web Control Panel, it is possible to make brand–new MySQL and PgSQL databases instantly! Also, you will have direct access to the management area software tools (phpMyAdmin and phpPgAdmin, respectively), so that you can quickly revise the database you want.
Neat and Uncomplicated User interface
Maintain all of your databases from one place
The Databases Manager inside our Web Control Panel incorporates a robust but still user–friendly user interface. You’re able to configure a completely new MySQL or PostgreSQL database by simply typing a user name and security password. What’s more, you can make a back–up file or modify the security password of your database with just a click of the mouse.
With the Databases Manager you’ve got direct access to the administrative area for each of your databases, allowing you to make convenient modifications in case you have to.
Quick and Simple Database Backup
Database backup copies can be a click away
From the Databases Manager you are able to produce an archived backup of your database whenever you want! This way, you’ll always have a backup of your active information in case your website gets hacked or you erroneously get rid of a database. To create a back–up: click on the ’clock’ icon next to a given database and afterwards simply wait for a few seconds for the process to be carried out.
There aren’t any boundaries for the quantity of databases you are able to back up or the quantity of backup copies you can create for any database.
PgSQL Support
Just about the most protected open source databases
A lot of the Linux cloud web hosting packages packages present PgSQL support. While falling behind MySQL regarding reputation and application, PgSQL databases are famous for giving the highest level of protection for your site content and articles. That is the reason why businesses like Skype and Yahoo go with PgSQL databases in lieu of MySQL.
With regard to database management, PgSQL is just as uncomplicated as MySQL.
InnoDB Databases
The fresh new face of MySQL
We have installed InnoDB – the brand new standard MySQL database engine on all our machines. InnoDB is perfect for substantial database web sites which need high functionality and scalability. Trials demonstrate that websites making use of InnoDB based tables achieve a 3–fold performance boost for very big joins, as opposed to those utilizing MyISAM tables.
InnoDB works by using row–level locking so as to take away the overall performance problems found at the top consumption times of the prior variant of the database engine – MyISAM, which utilizes table–level locking.
Detailed Database Stats
Thorough stats for all your databases
Checking the load generated by the databases within your busy web site assists you to reduce any overload issues that could slow it down and chase away site visitors. For this reason, we have bundled a thorough Database Stats tool in the Web Control Panel. There you can find in depth information about the incoming requests to your databases for each hour, day and month.
Depending on the quantity of daily and by the hour queries, it will be easy to determine which databases are being used the most and then take measures to enhance their work.
