Database Manager

Overseeing your databases is easier than ever before, thanks to the Web Control Panel interface for MySQL and PgSQL management! Provided you do not have substantial experience of handling databases, you will find it effortless to work with our Database Manager.

You could make a brand new database by simply entering the username and password or generate a database backup with merely a mouse click. Furthermore, from the Data Manager you will get direct access to the administrative area for each and every database, which enables you to instantly manage it.

We have made the manual database back–up generation into a quite simple activity. To execute that: inside of the Database Manager, click on the ’clock’ symbol next to the database that you intend to back up and after that wait around for a couple of seconds for the process to take place. With respect to the size of the database, the creation of a backup file can take between a couple of seconds and a minute.

You may create as many backup copies per database as you wish. We haven’t determined any limits about the quantity of databases you could back up too.

PgSQL databases are much less popular than the standard MySQL databases. Nevertheless, they are a favored option for designers who are looking for the maximum safety for their websites and web apps. Because of the intuitive Database Manager integrated into the W3 Hosting Control Panel, you can manage all of your PostgreSQL databases with only a mouse click.

Yow will discover PgSQL databases provided by default inside the best Linux website hosting plans packages. If you are using a basic hosting package, it is possible to ask for PgSQL databases to be included in your web hosting account as upgrades.

The MySQL databases on W3 Hosting’s servers make use of the latest build of the InnoDB storage engine. InnoDB has been developed to ensure the optimum performance for sites that operate with sizeable amounts of data. It grants CPU performance that could not be equalled by alternative disk–based relational database engines.

InnoDB is ACID–compliant and gives total transaction support, which means that you’ll be able to update/insert/create/alter/drop a couple of times for one "operation" of your app. In addition, it works by using row–level locking in place of MyISAM’s table–level locking, that increases multi–user concurrency and functionality.

With the detailed database stats tool incorporated into the Web Control Panel, you’re going to be able to keep track of the load created from your active web sites at any hour. Any overload issue with your web sites could slow the loading speeds and have a negative effect on the online experience of your site visitors. Which means that, having details about the database load instantly, you’ll be able to eliminate overload issues as fast as possible.

The database data interface shows information of the quantity of daily, hourly and monthly queries, to help you to examine the way the load is spread over various time frames.