Databases Manager

The Databases Manager in our Site Control Panel incorporates a powerful but convenient interface. You can set up a brand new MySQL or PostgreSQL database simply by typing a user name and security password. In addition, you may create a back–up file or change the security password of any database with merely a click of the mouse.

Via the Databases Manager you’ll possess direct access to the administrator area for each of your databases, which means you can make easy changes when you have to.

We’ve transformed the manual database back–up generation into a simple job. To execute this: inside of the Databases Manager, click on the ’clock’ symbol beside the database that you would like to back up and after that wait around for a couple of seconds for the backup process to take place. With respect to the size of the database, the creation of a backup file will take between a couple of seconds and a minute.

You may create as many backups per database as you wish. We’ve not specified any confines on the number of databases that you can back up either.

Practically all of our cloud plans plans present PgSQL support. Although falling behind MySQL when considering acceptance and employment, PgSQL databases are famous for supplying the best level of security for your web site content and articles. That is the key reason why companies such as Skype and Yahoo use PgSQL databases and not MySQL.

With regards to database management, PgSQL is identically uncomplicated as MySQL.

With C.A.A. Hosting, you will inevitably find the most up–to–date edition of MySQL and also the default MySQL storage engine – InnoDB, mounted.

InnoDB is much more dependable as compared to the former storage engine’s edition – MyISAM. It is ACID–compliant and, most importantly – it gives you full transaction support. Additionally, it makes use of row–level locking, instead of MyISAM’s table–level locking, that would always cause effectiveness problems at high usage occasions.

Monitoring the load produced by the databases for your powerful site assists you to stop virtually any overload difficulties that can slow it down and chase away site visitors. Therefore, we have built in a complete Database Stats tool inside the Site Control Panel. There you will find in–depth info on the inbound requests to your databases for each and every hour, day and month.

Using the quantity of daily and hourly queries, it will be straightforward to find out what databases are being used the most and then take procedures to enhance their work.