Via the Database Manager incorporated into the Web Site Control Panel, it is possible to make new MySQL and PgSQL databases straight away! Also, you will get immediate access to the administrator area software programs (phpMyAdmin and phpPgAdmin, respectively), so that you can effectively update the database you want.
Neat and Simple User interface
Deal with all of your databases from just one location
The Database Manager within our Web Site Control Panel incorporates a powerful yet user–friendly and uncomplicated interface. You’re able to configure a whole new MySQL or PostgreSQL database simply by typing a username and password. Also, you may create a back–up file or alter the password of your database with a mouse click.
Within the Database Manager you have direct access to the administrator area for each of your databases, in order to make easy changes when you have to.
Fast Database Back up
Back up your databases in a moment
We have made the manual database backup formation into a simple activity. To execute this: inside of the Database Manager, click the ’clock’ icon beside the database that you would like to back up and after that wait around for a few seconds for the backup process to take place. Depending upon the size of your database, the creation of any backup file will need somewhere between a few seconds and a minute.
You can make as many copies of a database as you would like. We haven’t set any limits about the amount of databases you can back up too.
PgSQL Support
Just about the most risk–free open source databases
Most of Astral Hosting’s cloud hosting packages provide PgSQL support. Whilst dropping behind MySQL with regards to acceptance and utilization, PgSQL databases are famous for giving the best level of safety for your web site content. This is the primary reason why companies like Skype and Yahoo employ PgSQL databases as opposed to MySQL.
In terms of database management, PgSQL is as uncomplicated as MySQL.
InnoDB Databases
The brand new face of MySQL
The MySQL databases on our servers work with the most up–to–date version of the InnoDB storage engine. InnoDB has been made to ensure the maximum efficiency for websites that work with massive amounts of data. It delivers CPU performance that could not be matched by any other different disk–based relational database engines.
InnoDB is ACID–compliant and provides total transaction support, which means that you’re able to update/insert/create/alter/drop repeatedly for one "operation" of your web app. Additionally, it makes use of row–level locking as an alternative to MyISAM’s table–level locking, that increases multi–user concurrency and efficiency.
Detailed Database Stats
Detailed statistics for your databases
Checking the load made by the databases on your dynamic site will let you prevent any kind of overload issues that might slow it down and chase away website visitors. For that reason, we have incorporated a in–depth Database Stats tool within the Web Site Control Panel. There you can get all–encompassing info about the arriving requests to your databases for every single hour, day and month.
Based on the amount of daily and per hour queries, it is possible to determine which databases are being used the most and take steps to optimize their load.
