Databases Manager

The Databases Manager inside the Control Panel provides a refined but intuitive interface. You can configure a completely new MySQL or PostgreSQL database by simply entering a user name and security password. Moreover, you can make a backup file or modify the security password of any database with merely a click of the mouse.

From the Databases Manager you will get direct access to the administrator area for each of your databases, which enables you to make quick adjustments in the event you need to.

We’ve developed the manual database back–up generation into a simple activity. To execute this: inside of the Databases Manager, click on the ’clock’ icon on the side of the database that you want to back up and afterwards hang on for a few seconds for the backup process to take place. With respect to the size of the database, the generation of a back–up file will need between a couple of seconds and a minute.

You may create as many backup copies per database as you wish. We’ve not set any limits for the number of databases that you could back up too.

You’ll find PgSQL support in every one of our Linux cloud hosting bundles. PgSQL databases might not be as sought after and widespread as MySQL, nonetheless they deliver the best level of security for your web site content and articles. For this reason, a number of widely known companies like Skype and Yahoo use PgSQL databases. Controlling PgSQL databases is as simple and easy as MySQL, thanks to the easy–to–use interface of the Databases Manager.

PgSQL databases are incorporated automatically within the most innovative web hosting bundles. For the normal plans, they’re suggested as upgrades.

We have integrated InnoDB – the brand new standard MySQL database engine on each of our web servers. InnoDB is good for massive database sites which need high levels of effectiveness and scalability. Experiments show that websites utilizing InnoDB based tables reach a 3–fold performance grow for big joins, when compared with those utilizing MyISAM tables.

InnoDB utilizes row–level locking in order to be able to remove the effectiveness issues noticed at the top usage times of the prior variant of the database engine – MyISAM, which employs table–level locking.

From your in–depth database statistics tool integrated into the Control Panel, you will be able to keep track of the load produced from your dynamic sites 24 hour a day. Virtually any overload issue with your sites could slow the loading speeds and have a damaging effect on the overall impression of your website visitors. Therefore, having information for the database work instantly, it will be easier to fix overload problems in a timely manner.

The database stats user interface shows data of the amount of daily, hourly and monthly queries, so its possible to review the way the load is spread over various time periods.