Databases Manager

The Databases Manager inside the Control Panel incorporates a powerful but convenient interface. It is possible to set up a brand new MySQL or PostgreSQL database simply by entering a username and security password. Moreover, you can create a back–up file or modify the security password of a database with only a click of the mouse.

Through the Databases Manager you’ll get immediate access to the admin area for each of your databases, in order to make effortless changes in the event you need to.

Through the Databases Manager it’s easy to make an archived copy of your database when you wish! Thus, you are going to always have a data backup of your operating content material if your website gets hacked or if you accidentally remove a database. To produce a back–up: click on the ’clock’ image beside a given database and afterwards just wait for a couple of seconds for the process to be done.

There aren’t any restrictions about the volume of databases you would be able to back up or the number of backup copies you can make for a database.

Almost all of our cloud hosting bundles deliver PgSQL support. Whilst falling behind MySQL when considering global recognition and application, PgSQL databases are famous for offering the best level of security for your web site content and articles. It is the primary reason why companies such as Skype and Yahoo go with PgSQL databases as opposed to MySQL.

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

The MySQL databases on our machines use the newest build of the InnoDB storage engine. InnoDB has been designed to guarantee the highest performance for websites that process massive volumes of data. It grants CPU effectiveness that could not be equalled by any other disk–based relational database engines.

InnoDB is ACID–compliant and grants complete transaction support, so that you’ll be able to update/insert/create/alter/drop a couple of times for a single "operation" of your web app. Also, it makes use of row–level locking instead of MyISAM’s table–level locking, that increases multi–user concurrency and performance.

Keeping track of the load accumulated by the databases in your active site will let you prevent all sorts of overload issues that can slow it down and ward off website visitors. As a result, we’ve integrated a descriptive Database Stats tool into your Control Panel. There you can get in depth information about the incoming requests to your databases for every hour, day and month.

Depending on the volume of daily and per hour queries, you will be able to determine which databases are being used the most and then consider actions to enhance their work.