From within the Database Manager included in the Control Panel, you’ll be able to build brand–new MySQL and PgSQL databases instantly! Furthermore, you will have immediate access to the administrator area software programs (phpMyAdmin and phpPgAdmin, respectively), allowing you to comfortably alter the database you want.
Tidy and Uncomplicated Interface
Deal with all your databases from a single location
The Database Manager in the Control Panel contains an effective but uncomplicated user interface. You are able to configure a whole new MySQL or PostgreSQL database simply by typing a username and security password. Additionally, you can make a back–up file or change the password of a database with merely a mouse click.
Through the Database Manager you’ll possess immediate access to the administrator area for every one of your databases, allowing you to make easy corrections if you happen to have to.
Quick Database Backup
Back up your databases in just a moment
We have evolved the manual database back–up creation into a very easy job. To execute this: within the Database Manager, click the ’clock’ image near the database that you plan to back up and after that hang on for a couple of seconds for the backup process to take place. Depending upon the size of the database, the generation of the backup file will take somewhere between a couple of seconds and a minute.
You can create as many backup copies per database as you would like. We haven’t determined any confines on the volume of databases you can back up as well.
Just about the most risk–free open source databases
A lot of our Linux web hosting packages provide PgSQL support. Whilst falling behind MySQL when it comes to global recognition and utilization, PgSQL databases are renowned for giving the highest level of safety for your website content and articles. That’s the primary reason why brands like Skype and Yahoo go with PgSQL databases in lieu of MySQL.
With regards to database administration, PgSQL is identically uncomplicated as MySQL.
The fresh new face of MySQL
We have incorporated InnoDB – the brand new standard MySQL database engine on every one of our machines. InnoDB is great for massive database websites which need high performance and scalability. Tests have shown that web sites using InnoDB based tables reach a 3–fold efficiency boost for large joins, in comparison with those working with MyISAM tables.
InnoDB uses row–level locking as a way to clear away the efficiency difficulties witnessed at the peak consumption times of the prior variant of the database engine – MyISAM, which utilizes table–level locking.
Detailed Database Stats
In depth statistics for all of your databases
Monitoring the load made by the databases in your active website assists you to stop any sort of overload issues that might slow it down and ward off website visitors. For this specific purpose, we’ve provided a in–depth Database Stats tool inside the Control Panel. There you can see all–encompassing info about the arriving requests to your databases for each hour, day and month.
Depending on the volume of daily and by the hour queries, it is possible to find out which databases are used the most and then take actions to optimize their load.