Databases Manager

The Databases Manager inside our Web Control Panel features a robust but convenient to use interface. It is easy to set up a whole new MySQL or PostgreSQL database simply by typing a username and security password. What’s more, you could make a back–up file or change the security password of a database with merely a mouse click.

Within the Databases Manager you will possess direct access to the administration area for each of your databases, allowing you to make simple and easy adjustments when you have to.

Provided you have worked with databases, you know that making a manual database backup just isn’t a simple job. In order to change this, we have developed an effortless to use tool that will back up your complete database with simply one click. The backup file will be completely ready for you in less than a minute, based on the size of the chosen database.

There are not any limits on just how many back–ups you could make for a chosen database.

A majority of our shared web hosting plans plans deliver PgSQL support. Although falling behind MySQL regarding acceptance and employment, PgSQL databases are famous for offering the highest level of protection for your web site content and articles. That is the reason why businesses like Skype and Yahoo go with PgSQL databases in lieu of MySQL.

In relation to database management, PgSQL is identically uncomplicated as MySQL.

The MySQL databases on our servers work with the most up–to–date release of the InnoDB storage engine. InnoDB is created to ensure the max effectiveness for web sites that work with big volumes of data. It offers CPU effectiveness that can not be equalled by any other disk–based relational database engines.

InnoDB is ACID–compliant and offers total transaction support, which means that you can easily update/insert/create/alter/drop repeatedly for one "operation" of your app. At the same time, it employs row–level locking as an alternative to MyISAM’s table–level locking, that increases multi–user concurrency and performance.

Monitoring the load accumulated by the databases in your active web site makes it possible to prevent any overload issues that might slow it down and chase away website visitors. As a result, we have built in a complete Database Stats tool within the Web Control Panel. There you can find thorough information regarding the incoming requests to your databases for each hour, day and month.

Using the number of day–to–day and hourly queries, you are going to be able to find out what databases are used the most and also take measures to optimize their work.