Inside of the Apple Hosting Website Control Panel you’re going to find a fully–fledged, user–friendly Database Manager! Utilize it in order to enjoy complete control of all your databases. You’re able to comfortably configure new MySQL and PgSQL databases and manage them through the phpMyAdmin and phpPgAdmin software tools, respectively.
Clean and User–friendly User interface
Be in charge of all your databases from one location
The Database Manager within our Website Control Panel has a powerful nevertheless simplified user interface. It’s possible to set up a whole new MySQL or PostgreSQL database simply by entering a user name and password. Moreover, you could make a back–up file or alter the password of your database with simply a mouse click.
Via the Database Manager you will get direct access to the administration area for all your databases, so you can make uncomplicated alterations if you happen to have to.
Simple Database Back–up
Back up your databases in a minute
We have developed the manual database back–up creation into a very easy activity. To execute this: within the Database Manager, click the ’clock’ icon on the side of the database that you plan to back up and wait around for a couple of seconds for the backup process to take place. With respect to the size of the database, the generation of a backup file will require between a few seconds and a minute.
You can create as many back–ups per database as you want. We have not fixed any limitations for the number of databases you could back up as well.
Support for PgSQL
Guaranteed reliability for your databases
PgSQL databases are less popular when compared to the widespread MySQL databases. Nevertheless, they are a preferred option for developers seeking the greatest safety for their sites and applications. Via the easy–to–use Database Manager integrated into the Apple Hosting Control Panel, you can administer all your PostgreSQL databases with a simple click of the mouse.
Yow will discover PgSQL databases incorporated by default within the top Linux shared hosting packages packages. Provided that you are with a standard hosting package, you are able to ask for PgSQL databases to be included in your website hosting account as upgrades.
The new face of MySQL
We have set up InnoDB – the new default MySQL database engine on all our web servers. InnoDB is good for massive database websites which require high levels of general performance and scalability. Tests show that web sites employing InnoDB based tables reach a 3–fold operation grow for very big joins, as opposed to those making use of MyISAM tables.
InnoDB employs row–level locking in order to take away the general performance problems noticed at the maximum consumption times of the prior release of the database engine – MyISAM, which utilizes table–level locking.
Detailed Database Stats
Thorough statistics for all your databases
Monitoring the load made by the databases for your powerful website makes it possible to prevent all overload issues that could slow it down and ward off site visitors. For this reason, we have provided a comprehensive Database Stats tool into your Website Control Panel. There you can see comprehensive information on the incoming requests to your databases for every single hour, day and month.
Depending on the amount of day–to–day and by the hour queries, it is possible to determine which databases are employed the most and also take measures to enhance their work.