Databases Manager

Administering your databases is less complicated than ever, due to the Web Hosting Control Panel user interface for MySQL and PgSQL management! Provided you do not have thorough knowledge in dealing with databases, it will be easy to use the Databases Manager.

You can make a completely new database by just keying in the user name and security password or produce a database back–up with merely a mouse click. Furthermore, from the Data Manager you’ll get direct access to the administrator area for each individual database, which enables you to effortlessly edit it.

Via the Databases Manager you’re able to make an archived copy of your database whenever you would like! This way, you will always have a back–up of your active information in the event your site gets compromised or you accidentally delete a database. To produce a backup: click the ’clock’ image beside a certain database and afterwards just wait for a few seconds for the backup process to be carried out.

There are no restrictions on the number of databases you can back up or the amount of backup copies you can make for a database.

Most of our Linux hosting packages plans grant PgSQL support. While falling behind MySQL when it comes to reputation and employment, PgSQL databases are famous for offering up the top level of protection for your website content material. That is the reason why brands like Skype and Yahoo employ PgSQL databases and not MySQL.

In relation to database management, PgSQL is just as simple as MySQL.

We’ve installed InnoDB – the new standard MySQL database engine on each of our servers. InnoDB is good for massive database web sites which need high overall performance and scalability. Tests have shown that websites utilizing InnoDB based tables reach a 3–fold overall performance grow for big joins, in comparison to those employing MyISAM tables.

InnoDB takes advantage of row–level locking so as to clear away the operation difficulties found at the high consumption times of the earlier release of the database engine – MyISAM, which uses table–level locking.

We provide you a simple approach to keep tabs on the database use of your active web sites. Through the thorough database statistics interface, that’s built into the Web Hosting Control Panel, you can keep track of the load created through your busy websites in real time. The delivered information will assist you to analyze the database load fluctuations by the hour, per day or per month.

You’re able to keep an eye on the database load for all your web sites from the Database Stats section of the Web Hosting Control Panel. The table on–screen reveals the database lookups generated in the present month. To inspect details for a past month, just click on the back arrows located at the top.