Inside of the CMS HelpDesk Web Site Control Panel you can find a feature–rich, convenient Databases Manager! Utilize it to experience full command over your databases. You are able to simply create new MySQL and PgSQL databases and manage them through the phpMyAdmin and phpPgAdmin software programs, respectively.
Tidy and Hassle–free User interface
Deal with all your databases from one place
The Databases Manager within our Web Site Control Panel incorporates a powerful yet convenient–to–use interface. You can easily configure a new MySQL or PostgreSQL database by just entering a username and password. Additionally, you may create a backup file or alter the password of the database with simply a click of the mouse.
Through the Databases Manager you’ll get immediate access to the administrative area for all your databases, meaning you can make simple modifications should you have to.
Simple Database Back–up
Back up your databases in just a moment
We have designed the manual database backup creation into a simple activity. To execute this: inside of the Databases Manager, click the ’clock’ icon near the database that you intend to back up and after that wait for a couple of seconds for the backup process to take place. Depending upon the size of your database, the generation of a back–up file will take between a couple of seconds and a minute.
You may create as many backups of a database as you would like. We have not set any boundaries about the volume of databases that you can back up as well.
Support for PgSQL
Guaranteed security for one’s databases
PgSQL databases are less famous when compared to the well–known MySQL databases. Having said that, they are a preferred choice for designers who are looking for the best safety for their websites and web apps. Thanks to the incredibly user–friendly Databases Manager integrated into the CMS HelpDesk Control Panel, you can administer your PostgreSQL databases with merely a mouse click.
You can discover PgSQL databases bundled automatically inside of the top cloud website hosting services packages. If you are using a regular hosting package, it is easy to request PgSQL databases to be included in your web hosting account as upgrades.
The new face of MySQL
We’ve integrated InnoDB – the new default MySQL database engine on every one of our servers. InnoDB is perfect for substantial database websites that demand high effectiveness and scalability. Experiments demonstrate that sites applying InnoDB based tables reach a 3–fold efficiency boost for large joins, in comparison to those employing MyISAM tables.
InnoDB uses row–level locking in an effort to take away the performance problems noticed at the high usage times of the earlier release of the database engine – MyISAM, which utilizes table–level locking.
Detailed Database Stats
Comprehensive statistics for all your databases
Tracking the load accumulated by the databases in your active site assists you to prevent all sorts of overload issues that can slow it down and chase away site visitors. As a result, we have integrated a comprehensive Database Stats tool inside the Web Site Control Panel. There you shall find comprehensive info about the incoming requests to your databases for each and every hour, day and month.
In line with the volume of day–to–day and per hour queries, it will be straightforward to find out what databases are being used the most and also take procedures to optimize their load.