Database Manager

Managing your databases now is easier than in the past, as a result of Control Panel interface for MySQL and PgSQL administration! Even if you do not have substantial expertise in utilizing databases, you will find it easy to manage our Database Manager.

You can create a whole new database by just specifying the username and security password or produce a database back–up with just a click of the mouse. Additionally, from the Data Manager you will get direct access to the administrative area for each and every database, allowing you to quite easily alter it.

We have transformed the manual database backup generation into a very easy activity. To execute that: in the Database Manager, click on the ’clock’ icon next to the database that you would like to back up and then wait around for a few seconds for the process to take place. Depending on the size of your database, the generation of the back–up file will take between a few seconds and a minute.

You may create as many backups of a database as you wish. We have not specified any confines on the quantity of databases that you can back up either.

Practically all of The Hosting Solutions’s shared hosting packages deliver PgSQL support. While falling behind MySQL with regard to global recognition and employment, PgSQL databases are famous for offering the top level of safety for your web site content and articles. That is the key reason why businesses like Skype and Yahoo make use of PgSQL databases as a substitute for MySQL.

When it comes to database administration, PgSQL is as uncomplicated as MySQL.

We have incorporated InnoDB – the brand new default MySQL database engine on each of our machines. InnoDB is great for substantial database web sites that require high performance and scalability. Trials have demonstrated that web sites utilizing InnoDB based tables attain a 3–fold effectiveness grow for massive joins, compared with those utilizing MyISAM tables.

InnoDB takes advantage of row–level locking in order to remove the general performance issues discovered at the maximum usage times of the prior variant of the database engine – MyISAM, which utilizes table–level locking.

Checking the load caused by the databases on your active site will let you prevent any kind of overload problems that could slow it down and chase away website visitors. For this reason, we have built in a detailed Database Stats tool in the Control Panel. There you can get extensive information about the arriving requests to your databases for each hour, day and month.

In line with the volume of day–to–day and hourly queries, it is possible to find out what databases are being used the most and then take procedures to enhance their work.