Databases Manager

The Databases Manager in our Site Control Panel includes an effective but still easy to navigate user interface. It is possible to configure a brand new MySQL or PostgreSQL database by simply specifying a user name and password. Also, you may create a back–up file or customize the password of any database with a click of the mouse.

Within the Databases Manager you have immediate access to the administrator area for all your databases, in order to make easy modifications if you ever need to.

If you have worked with databases, you are aware that creating a manual database backup is just not a basic job. So as to change this, we’ve developed an easy to understand tool that will back up your whole database with one click. The backup file shall be set for you in less than a minute, depending on the size of the chosen database.

There are no restrictions on the amount of back–ups you can create for any particular database.

PgSQL databases are significantly less sought after as compared to the popular MySQL databases. However, they’re a preferred choice for developers seeking the uttermost security for their web sites and web apps. Due to the incredibly user–friendly Databases Manager built–into the WiteTigr Computers and More Control Panel, you can control all of your PostgreSQL databases with only a click of the mouse.

You are going to find PgSQL databases included by default inside the advanced shared hosting plans packages. If you are using a standard hosting package, you’ll be able to request PgSQL databases to be added in your web hosting account as upgrades.

The MySQL databases on our web servers work with the most current release of the InnoDB storage engine. InnoDB has been designed to guarantee the max efficiency for web sites that process sizeable amounts of data. It presents CPU performance that could not be matched by other disk–based relational database engines.

InnoDB is ACID–compliant and provides complete transaction support, so that it is possible to update/insert/create/alter/drop several times for a single "operation" of your web app. Furthermore, it makes use of row–level locking as an alternative for MyISAM’s table–level locking, that enhances multi–user concurrency and functionality.

Our company offers you a fairly easy approach to monitor the database usage on your busy web sites. Through the detailed database stats interface, that’s built into the Site Control Panel, you are able to monitor the load generated by your busy websites in real time. The delivered information will let you evaluate the database load changes by the hour, on a daily basis or monthly.

It’s possible to observe the database load for all your web sites from the Database Stats part of the Site Control Panel. The table on–screen reveals the database lookups generated in the present month. To assess data for a previous month, simply click on the back arrows placed at the top.