Database Manager

The Database Manager inside the Web Site Control Panel has a robust but still simple to use user interface. You’re able to set up a brand new MySQL or PostgreSQL database by just typing in a username and security password. Also, you can create a back–up file or alter the security password of an database with a click of the mouse.

With the Database Manager you will possess direct access to the administrative area for each of your databases, meaning you can make hassle–free changes if you ever have to.

With the Database Manager you are able to generate an archived backup of your database whenever you want! Therefore, you’ll always have a back–up of your active content in the event your site gets compromised or if you accidentally eliminate a database. To generate a backup: click on the ’clock’ icon beside any database and afterwards simply wait for a few seconds for the process to be carried out.

There are not any restrictions on the amount of databases you would be able to back up or the volume of back–ups you can create for a database.

PgSQL databases are significantly less famous as compared to the widespread MySQL databases. Then again, they represent a favored option for developers who seek the utmost protection for their websites and web apps. Via the easy–to–use Database Manager included in the -Iclick2- Web Hosting and Cloud Service Control Panel, you can administer all your PostgreSQL databases with merely a click of the mouse.

Yow will discover PgSQL databases included automatically inside of the advanced cloud plans packages. If you are using a regular hosting package, it is possible to ask for PgSQL databases to be added in your website hosting account as upgrades.

With -Iclick2- Web Hosting and Cloud Service, you’ll invariably discover the most up–to–date edition of MySQL and the default MySQL storage engine – InnoDB, set up.

InnoDB is a lot more stable when compared to the past storage engine’s version – MyISAM. It’s ACID–compliant and, most of all – it gives total transaction support. It also takes advantage of row–level locking, in lieu of MyISAM’s table–level locking, that would always cause functionality problems at peak usage periods.

Keeping tabs on the load produced by the databases in your busy site assists you to stop any overload difficulties that can slow it down and ward off visitors. For that reason, we’ve included a in–depth Database Stats tool inside the Web Site Control Panel. There you shall find comprehensive information about the arriving requests to your databases for each and every hour, day and month.

Depending on the number of daily and per hour queries, it will be easy to determine which databases are employed the most as well as take procedures to optimize their work.