From within the Databases Manager built–into the Website Control Panel, you will be able to build completely new MySQL and PgSQL databases in an instant! At the same time, you’ll have direct access to the administrator area software programs (phpMyAdmin and phpPgAdmin, respectively), to help you to effortlessly modify the database you want.
Tidy and Straightforward Interface
Maintain all your databases from just one location
The Databases Manager inside the Website Control Panel contains a robust yet simple to use user interface. You are able to configure a whole new MySQL or PostgreSQL database simply by specifying a user name and password. Furthermore, you can create a back–up file or modify the security password of the database with just a mouse click.
From the Databases Manager you will have direct access to the management area for each of your databases, in order to make effortless alterations should you need to.
Simple Database Data backup
Back up your databases in a minute
We have transformed the manual database backup generation into a very simple job. To execute this: within the Databases Manager, click on the ’clock’ image next to the database that you plan to back up and afterwards wait around for a few seconds for the backup process to take place. Depending upon the size of your database, the generation of a backup file will require somewhere between a couple of seconds and a minute.
You may create as many back–ups per database as you wish. We haven’t specified any boundaries about the amount of databases that you could back up too.
Support for PgSQL
Guaranteed stability for one’s databases
PgSQL databases are significantly less widespread as compared to the standard MySQL databases. However, they represent a favored alternative for web developers seeking the ultimate security for their sites and web apps. Thanks to the incredibly user–friendly Databases Manager built into the Roy Hosting Control Panel, you can control all of your PostgreSQL databases with simply a click of the mouse.
You’re going to find PgSQL databases bundled by default in the best Linux shared web hosting packages. Assuming that you are with a basic hosting package, it’s possible to ask for PgSQL databases to be added in your account as upgrades.
The fresh new face of MySQL
We have integrated InnoDB – the new default MySQL database engine on each of our web servers. InnoDB is perfect for huge database web sites that require high efficiency and scalability. Tests have indicated that web sites using InnoDB based tables reach a 3–fold efficiency grow for very big joins, compared to those applying MyISAM tables.
InnoDB works by using row–level locking in order to be able to take away the efficiency problems found at the peak consumption times of the prior release of the database engine – MyISAM, which utilizes table–level locking.
Detailed Database Stats
Thorough stats for all of your databases
From your in depth database stats tool included in the Website Control Panel, it is possible to keep a record of the load accumulated through your dynamic web sites twenty–four hours a day. Any overload problem with your websites could slow the loading rates and have a negative influence over the overall experience of your site visitors. Therefore, having info about the database load in real time, you will be able to solve overload problems quickly.
The database data user interface shows details of the volume of daily, hourly and monthly lookups, allowing you to review the way the load is distributed over different time frames.