Database Manager

Taking control of your databases is much simpler than in the past, due to the Web Control Panel user interface for MySQL and PgSQL administration! Even though you may not have considerable experience of utilizing databases, you will find it an easy task to use WebHost4.us’s Database Manager.

You can make a completely new database simply by typing the user name and security password or create a database backup with a click of the mouse. Additionally, with the Data Manager you’ll get direct access to the admin area for every database, so you’re able to instantly modify it.

With the Database Manager you can generate an archived backup of your database whenever you want! Thus, you will always have a data backup of your dynamic content in case your website gets hacked or if you incorrectly delete a database. To generate a backup: click on the ’clock’ image on the side of a given database and then simply wait for a few seconds for the process to be completed.

There aren’t any limits on the volume of databases you would be able to back up or the volume of backups you can create for a database.

The majority of our Linux web hosting packages plans feature PgSQL support. While falling behind MySQL when considering popularity and utilization, PgSQL databases are famous for supplying the top level of stability for your website content material. That’s the main reason why companies like Skype and Yahoo rely on PgSQL databases in lieu of MySQL.

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

We’ve installed InnoDB – the brand new standard MySQL database engine on all our web servers. InnoDB is ideal for big database sites which need high efficiency and scalability. Trials have revealed that websites working with InnoDB based tables achieve a 3–fold operation increase for very big joins, compared to those using MyISAM tables.

InnoDB utilizes row–level locking in an effort to take away the operation problems witnessed at the peak usage times of the earlier version of the database engine – MyISAM, which employs table–level locking.

We supply you a simple and easy method to monitor the database utilization for your dynamic sites. Via the thorough database stats user interface, that’s included in the Web Control Panel, you can keep track of the load created from your active sites in real time. The provided data will help you analyze the database load fluctuations per hour, per day or monthly.

It is easy to monitor the database load for your websites within the Database Stats area of the Web Control Panel. The table on–screen features the database lookups created within the present month. To look at data for a previous month, just click on the back arrows situated at the top.