Database Manager

Taking control of your databases is easier than before, due to the Web Hosting Control Panel user interface for MySQL and PgSQL control! Provided you do not have extensive expertise in working with databases, you will find it simple to work with our Database Manager.

You can make a new database by only keying in the username and security password or produce a database back–up with a simple click of the mouse. Furthermore, within the Data Manager you will get direct access to the administration area for each and every database, so you can immediately manage it.

We’ve made the manual database back–up creation into a simple task. To execute this: inside the Database Manager, click on the ’clock’ symbol on the side of the database that you plan to back up and after that wait around for a few seconds for the backup process to take place. Depending upon the size of the database, the creation of a backup file can take between a couple of seconds and a minute.

You can create as many back–ups of a database as you desire. We haven’t determined any confines for the number of databases that you could back up either.

Practically all of Howard ITech Hosting’s shared website hosting plans packages provide PgSQL support. Although dropping behind MySQL when it comes to popularity and application, PgSQL databases are famous for giving the highest level of security for your site content. That is the key reason why brands like Skype and Yahoo employ PgSQL databases instead of MySQL.

In terms of database administration, PgSQL is as effortless to use as MySQL.

We’ve installed InnoDB – the brand new standard MySQL database engine on all our servers. InnoDB is good for huge database sites which require high efficiency and scalability. Experiments have indicated that sites utilizing InnoDB based tables attain a 3–fold overall performance boost for big joins, as opposed to those working with MyISAM tables.

InnoDB makes use of row–level locking as a way to eliminate the efficiency difficulties witnessed at the high usage times of the prior variant of the database engine – MyISAM, which uses table–level locking.

Via the thorough database stats tool incorporated into the Web Hosting Control Panel, it’s possible to keep track of the stress created by your active sites around the clock. Virtually any overload problem with your web sites can lower the loading speeds and have a damaging effect on the overall impression of your respective website visitors. Hence, by having info about the database work immediately, it’s possible to fix overload troubles as fast as possible.

The database stats interface reveals details of the quantity of daily, hourly and monthly lookups, allowing you to analyze how the load is distributed over several periods of time.