Databases Manager

The Databases Manager in our Control Panel provides an effective yet uncomplicated user interface. You’ll be able to configure a new MySQL or PostgreSQL database simply by entering a username and password. In addition, you could make a back–up file or alter the password of an database with simply a click of the mouse.

Via the Databases Manager you’ll get immediate access to the admin area for all of your databases, so that you can make simple and easy changes when you need to.

Via the Databases Manager you’re able to create an archived backup of your database whenever you wish! This way, you will always have a backup of your dynamic information if your site gets hacked or you accidentally delete a database. To make a backup: click the ’clock’ symbol alongside a given database and afterwards just wait for a few seconds for the process to be concluded.

There are no confines about the amount of databases you can back up or the number of backup copies you may make for a database.

Most of our Linux cloud web hosting packages packages feature PgSQL support. While dropping behind MySQL in terms of reputation and utilization, PgSQL databases are famous for supplying the best level of protection for your site content material. That is the primary reason why companies like Skype and Yahoo go with PgSQL databases as an alternative to MySQL.

When it comes to database administration, PgSQL is just as simple and easy as MySQL.

We’ve added InnoDB – the brand new default MySQL database engine on all our web servers. InnoDB is made for substantial database web sites which need high levels of functionality and scalability. Trials have indicated that sites utilizing InnoDB based tables achieve a 3–fold overall performance grow for very big joins, in contrast to those making use of MyISAM tables.

InnoDB uses row–level locking in an effort to eliminate the general performance difficulties detected at the maximum consumption times of the prior variant of the database engine – MyISAM, which employs table–level locking.

Monitoring the load made by the databases for your powerful website will let you prevent any overload issues that can slow it down and ward off site visitors. For this reason, we’ve provided a descriptive Database Stats tool into your Control Panel. There you can see complete information on the incoming requests to your databases for each and every hour, day and month.

Using the quantity of day–to–day and per hour queries, you are able to find out what databases are utilized the most as well as take procedures to enhance their work.