Databases Manager

Supervising your databases is simpler than before, on account of the Control Panel interface for MySQL and PgSQL administration! Even if you do not have thorough knowledge of dealing with databases, you will find it easy to manage our Databases Manager.

You could make a brand new database simply by entering the username and security password or produce a database back–up with a simple click of the mouse. Likewise, through the Data Manager you will have direct access to the management area for each individual database, meaning you can instantly alter it.

Through the Databases Manager it is simple to produce an archived duplicate of your database when you wish! Therefore, you’ll always have a back–up of your dynamic information in case your website gets hacked or you mistakenly erase a database. To generate a backup: click the ’clock’ symbol alongside any database and then wait for a couple of seconds for the backup process to be concluded.

There won’t be any restricts for the volume of databases you are able to back up or the volume of backups you can make for a database.

Practically all of our cloud plans bundles offer PgSQL support. Whilst falling behind MySQL in terms of popularity and application, PgSQL databases are famous for giving the greatest level of security for your website content material. That is the main reason why businesses like Skype and Yahoo employ PgSQL databases as opposed to MySQL.

With regards to database administration, PgSQL is just as easy to use as MySQL.

We have integrated InnoDB – the new standard MySQL database engine on every one of our machines. InnoDB is perfect for huge database web sites that demand high overall performance and scalability. Tests have demonstrated that sites making use of InnoDB based tables reach a 3–fold performance increase for massive joins, compared to those working with MyISAM tables.

InnoDB uses row–level locking in order to be able to eliminate operation issues observed at the maximum consumption times of the earlier release of the database engine – MyISAM, which employs table–level locking.

Monitoring the load caused by the databases within your dynamic web site will help you stop virtually any overload troubles that might slow it down and ward off website visitors. For this reason, we’ve integrated a complete Database Stats tool directly into the Control Panel. There you can find thorough info about the inbound requests to your databases for every single hour, day and month.

In line with the volume of daily and by the hour queries, it will be easy to find out which databases are utilized the most as well as consider actions to enhance their load.