Databases Manager

The Databases Manager inside the Web Control Panel features a robust yet simple to operate user interface. It is possible to set up a whole new MySQL or PostgreSQL database simply by typing a username and security password. Moreover, you may create a back–up file or customize the password of a database with only a mouse click.

Via the Databases Manager you’ll get immediate access to the administrator area for all your databases, so that you can make convenient adjustments in case you need to.

From the Databases Manager it is easy to make an archived copy of your database whenever you need! For this reason, you are going to always have a data backup of your dynamic content material in case your web site gets broken into or if you incorrectly eliminate a database. To generate a back–up: click on the ’clock’ image beside a given database and after that wait for a couple of seconds for the process to be done.

There aren’t any restrictions on the amount of databases you would be able to back up or the amount of backups you can create for any database.

You’re going to find PgSQL support in every one of our cloud service plans. PgSQL databases are not as famous and frequently used as MySQL, nevertheless they deliver the highest possible level of safety for your web site content. Due to this, a lot of popular businesses like Skype and Yahoo employ PgSQL databases. Controlling PgSQL databases is as easy and simple as MySQL, because of the user–friendly user interface of the Databases Manager.

PgSQL databases are integrated by default inside the most advanced web hosting bundles. For the basic plans, they are presented as upgrades.

The MySQL databases on our machines utilize the most up–to–date build of the InnoDB storage engine. InnoDB has been intended to ensure the top functionality for sites that work with substantial volumes of data. It features CPU effectiveness that can not be equalled by alternative disk–based relational database engines.

InnoDB is ACID–compliant and offers total transaction support, so that you are able to update/insert/create/alter/drop repeatedly for a single "operation" of your application. At the same time, it takes advantage of row–level locking as an alternative for MyISAM’s table–level locking, that increases multi–user concurrency and performance.

Keeping track of the load generated by the databases in your active web site makes it possible to avoid any sort of overload problems that could slow it down and ward off site visitors. Therefore, we’ve incorporated a detailed Database Stats tool inside the Web Control Panel. There you shall find broad info on the inbound requests to your databases for each and every hour, day and month.

In line with the quantity of daily and by the hour queries, you’ll be able to find out which databases are employed the most and consider procedures to enhance their work.