Database Manager

The Database Manager in our Website Control Panel incorporates an effective but still user–friendly interface. You can configure a whole new MySQL or PostgreSQL database simply by typing a username and password. In addition, you can make a backup file or alter the password of your database with a mouse click.

Within the Database Manager you will possess direct access to the administrator area for all of your databases, which means you can make hassle–free modifications if you ever have to.

Within the Database Manager you’ll be able to produce an archived duplicate of your database anytime you wish! Thus, you are going to always have a backup of your active information if your web site gets compromised or if you erroneously get rid of a database. To create a back–up: click on the ’clock’ icon on the side of any database and then simply wait for a couple of seconds for the backup process to be executed.

There won’t be any limitations about the volume of databases you can back up or the quantity of back–ups you can make for any database.

PgSQL databases are much less widespread as opposed to the common MySQL databases. Even so, they’re a preferred selection for programmers who are looking for the best stability for their web sites and apps. Because of the incredibly user–friendly Database Manager built into the CLICKINSTANLYA.COM Control Panel, you can administer your PostgreSQL databases with merely a mouse click.

You’ll find PgSQL databases provided automatically in the top cloud web hosting packages. Provided that you are using a regular hosting package, you can easily ask for PgSQL databases to be added in your web hosting account as upgrades.

With CLICKINSTANLYA.COM, you’ll always discover the latest edition of MySQL along with the default MySQL storage engine – InnoDB, set up.

InnoDB is more stable in comparison to the old storage engine’s edition – MyISAM. It is ACID–compliant and, above all – it has total transaction support. You’ll find, it utilizes row–level locking, in contrast to MyISAM’s table–level locking, that seemed to result in effectiveness troubles at peak usage times.

Monitoring the load made by the databases in your dynamic site makes it possible to prevent any kind of overload problems that could slow it down and ward off visitors. For that reason, we have provided a thorough Database Stats tool directly into the Website Control Panel. There you will find thorough information on the incoming requests to your databases for each hour, day and month.

Using the quantity of day–to–day and hourly queries, it will be straightforward to find out what databases are employed the most as well as take steps to enhance their load.