Database Manager

The Database Manager within our Control Panel includes a powerful but straightforward interface. It’s possible to configure a completely new MySQL or PostgreSQL database by simply typing in a user name and password. What’s more, you may create a backup file or customize the security password of your database with only a mouse click.

With the Database Manager you’ve got immediate access to the administration area for all your databases, so that you can make hassle–free adjustments in case you have to.

Within the Database Manager it is simple to generate an archived backup of your database when you wish! This way, you’ll always have a data backup of your active information in the event your web site gets broken into or you erroneously delete a database. To produce a backup: click the ’clock’ icon beside any database and afterwards just wait for a couple of seconds for the backup process to be done.

There are no limitations for the quantity of databases you would be able to back up or the amount of backups you can make for any database.

Nearly all of the Linux cloud packages packages offer PgSQL support. While falling behind MySQL when considering popularity and utilization, PgSQL databases are famous for offering up the greatest level of safety for your web site content material. This is the key reason why brands like Skype and Yahoo rely on PgSQL databases as a substitute for MySQL.

With regard to database administration, PgSQL is equally easy to use as MySQL.

The MySQL databases on our web servers employ the most recent build of the InnoDB storage engine. InnoDB was created to ensure the highest performance for sites that work with massive amounts of data. It offers CPU efficiency that could not be matched by other disk–based relational database engines.

InnoDB is ACID–compliant and provides total transaction support, so that you’re able to update/insert/create/alter/drop a couple of times for a single "operation" of your application. Moreover, it utilizes row–level locking as an alternative for MyISAM’s table–level locking, that boosts multi–user concurrency and performance.

Tracking the load accumulated by the databases for your powerful web site assists you to stop all sorts of overload problems that could slow it down and ward off visitors. For that reason, we’ve incorporated a complete Database Stats tool inside the Control Panel. There you can get comprehensive information on the arriving requests to your databases for each and every hour, day and month.

Depending on the volume of daily and per hour queries, it will be straightforward to determine which databases are employed the most and also consider actions to optimize their load.