Via the Databases Manager incorporated into the Online Control Panel, it will be easier to build brand–new MySQL and PgSQL databases right away! Furthermore, you’ll get immediate access to the administration area software programs (phpMyAdmin and phpPgAdmin, respectively), allowing you to quickly alter the database you want.
Neat and Simple User interface
Manage all your databases from a single location
The Databases Manager in our Online Control Panel has an effective but still easy to navigate interface. It is easy to configure a new MySQL or PostgreSQL database by just specifying a username and password. In addition, you could make a back–up file or modify the password of a database with merely a click of the mouse.
Through the Databases Manager you’ve got direct access to the management area for all your databases, which means you can make simple and easy modifications in the event you have to.
Easy and fast Database Backup
Database backups are a click away
Within the Databases Manager it’s easy to create an archived backup of your database anytime you want! This way, you’ll always have a data backup of your operating information in case your site gets compromised or if you mistakenly eliminate a database. To produce a backup: click on the ’clock’ symbol next to a particular database and then wait for a few seconds for the backup process to be completed.
There are not any confines on the number of databases you are able to back up or the volume of back–ups you can make for any database.
Support for PgSQL
Assured reliability for one’s databases
PgSQL databases are much less widespread in comparison to the well–known MySQL databases. Then again, they represent a favorite option for programmers who are looking for the uttermost security for their web sites and web applications. Thanks to the intuitive Databases Manager built into the XtreemHost Control Panel, you can control your PostgreSQL databases with only a mouse click.
You’re going to find PgSQL databases bundled automatically inside the advanced Linux cloud hosting packages. In case you are with a standard hosting package, you’ll be able to request PgSQL databases to be added to your web hosting account as upgrades.
The new face of MySQL
With XtreemHost, you shall regularly find the newest build of MySQL and also the default MySQL storage engine – InnoDB, installed.
InnoDB is a lot more dependable as compared to the past storage engine’s edition – MyISAM. It’s ACID–compliant and, best of all – it provides complete transaction support. Additionally, it takes advantage of row–level locking, as a substitute for MyISAM’s table–level locking, that seemed to result in effectiveness troubles at peak usage occasions.
Detailed Database Stats
In depth statistics for your databases
Checking the load caused by the databases on your active site makes it possible to stop virtually any overload problems that could slow it down and ward off visitors. For that reason, we have included a thorough Database Stats tool into your Online Control Panel. There you will find in–depth information about the inbound requests to your databases for every single hour, day and month.
Depending on the quantity of day–to–day and hourly queries, it will be easier to find out which databases are being used the most and take procedures to optimize their load.