Databases Manager

The Databases Manager in our Control Panel boasts a refined but easy to navigate interface. You are able to configure a whole new MySQL or PostgreSQL database by just typing a user name and password. In addition, you can create a back–up file or modify the password of the database with simply a click of the mouse.

With the Databases Manager you’ll get immediate access to the administrator area for all of your databases, so its possible to make convenient modifications when you have to.

Through the Databases Manager you can easily generate an archived backup of your database whenever you wish! Thus, you are going to always have a data backup of your operating content if your web site gets compromised or you accidentally erase a database. To create a backup: click the ’clock’ symbol alongside a certain database and then simply wait for a couple of seconds for the process to be concluded.

There are no limitations about the amount of databases you are able to back up or the amount of backups you can create for a database.

Just about all of our Linux shared hosting bundles present PgSQL support. Whilst dropping behind MySQL when considering global recognition and application, PgSQL databases are renowned for giving the greatest level of stability for your site content and articles. It is the main reason why companies like Skype and Yahoo rely upon PgSQL databases as an alternative to MySQL.

In terms of database administration, PgSQL is as effortless to use as MySQL.

We’ve integrated InnoDB – the brand new standard MySQL database engine on all of our web servers. InnoDB is designed for huge database web sites which require high efficiency and scalability. Tests have established that web sites using InnoDB based tables reach a 3–fold effectiveness grow for massive joins, as opposed to those making use of MyISAM tables.

InnoDB works by using row–level locking in an effort to get rid of the efficiency problems noticed at the top usage times of the earlier release of the database engine – MyISAM, which utilizes table–level locking.

Tracking the load accumulated by the databases within your active website will let you reduce all sorts of overload troubles that could slow it down and ward off visitors. As a result, we’ve incorporated a complete Database Stats tool into the Control Panel. There you can see thorough info on the incoming requests to your databases for every single hour, day and month.

Based on the quantity of daily and per hour queries, it will be straightforward to find out which databases are employed the most and consider actions to enhance their work.