Databases Manager

The Databases Manager inside the Hosting Control Panel contains a robust nevertheless simplified interface. You’ll be able to configure a whole new MySQL or PostgreSQL database by just entering a username and security password. Additionally, you may create a back–up file or change the security password of your database with merely a mouse click.

From the Databases Manager you will get immediate access to the administrative area for every one of your databases, so that you can make uncomplicated modifications should you have to.

If you have dealt with databases, you know that creating a manual database back–up isn’t a simple job. In order to change this, we’ve made very simple tool that can back up your entire database with simply one click of the mouse. The back–up file shall be completely ready for you in under a minute, depending on the size of the selected database.

There are not any limits on just how many backup copies you may make for any particular database.

A majority of our Linux cloud services bundles offer PgSQL support. Although falling behind MySQL with respect to global recognition and employment, PgSQL databases are famous for presenting the greatest level of protection for your web site content material. That’s the main reason why brands like Skype and Yahoo employ PgSQL databases and not MySQL.

When it comes to database management, PgSQL is just as easy to use as MySQL.

The MySQL databases on our servers employ the most up–to–date build of the InnoDB storage engine. InnoDB was developed to guarantee the maximum performance for websites that deal with sizeable amounts of data. It supplies CPU efficiency that can not be equalled by any other disk–based relational database engines.

InnoDB is ACID–compliant and grants full transaction support, so that you’ll be able to update/insert/create/alter/drop many times for a single "operation" of your app. Furthermore, it makes use of row–level locking as an alternative to MyISAM’s table–level locking, that improves multi–user concurrency and functionality.

Monitoring the load accumulated by the databases in your active web site assists you to avoid any sort of overload troubles that could slow it down and ward off website visitors. For this specific purpose, we’ve provided a complete Database Stats tool in the Hosting Control Panel. There you can find in depth information on the arriving requests to your databases for every hour, day and month.

Based on the volume of daily and hourly queries, it’s possible to find out what databases are utilized the most and consider steps to optimize their load.