Databases Manager

Administering your databases is simpler than in the past, on account of the Web Hosting Control Panel user interface for MySQL and PgSQL administration! Even though you may not have extensive experience of making use of databases, you will find it simple to use the Databases Manager.

You can make a completely new database merely by entering the user name and password or produce a database backup with a click of the mouse. Furthermore, through the Data Manager you have direct access to the administrator area for every single database, so you can instantly modify it.

Provided you have worked with databases, you already know that making a manual database back–up is simply not a basic task. So as to change this, we have created an effortless to use tool that can back up your whole database with just a single mouse click. The back–up file shall be completely ready for you in under a minute, with regards to the size of the selected database.

There aren’t any confines on how many back–ups you could make for a specific database.

A majority of the Linux shared web hosting packages packages feature PgSQL support. While falling behind MySQL when it comes to level of popularity and application, PgSQL databases are famous for supplying the greatest level of safety for your site content material. It is the key reason why companies such as Skype and Yahoo employ PgSQL databases as a substitute for MySQL.

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

We’ve set up InnoDB – the new standard MySQL database engine on all of our machines. InnoDB is great for huge database sites which need high performance and scalability. Tests have demonstrated that web sites making use of InnoDB based tables achieve a 3–fold performance boost for substantial joins, in comparison to those using MyISAM tables.

InnoDB works by using row–level locking in an effort to take away the efficiency issues witnessed at the high usage times of the previous release of the database engine – MyISAM, which utilizes table–level locking.

Checking the load caused by the databases within your dynamic web site makes it possible to prevent virtually any overload difficulties that could slow it down and chase away site visitors. As a result, we have included a in depth Database Stats tool into your Web Hosting Control Panel. There you will find detailed information on the arriving requests to your databases for each and every hour, day and month.

Depending on the volume of daily and hourly queries, it is possible to determine which databases are used the most as well as consider steps to enhance their load.