Database Manager

The Database Manager within our Control Panel has an effective but simplified interface. You’re able to configure a new MySQL or PostgreSQL database by just typing in a user name and password. What’s more, you could make a backup file or change the security password of an database with just a click of the mouse.

Through the Database Manager you’ll possess immediate access to the administration area for every one of your databases, which means you can make simple corrections if you happen to have to.

Via the Database Manager you’ll be able to produce an archived copy of your database anytime you need! Therefore, you are going to always have a data backup of your operating content in the event your web site gets broken into or if you mistakenly get rid of a database. To make a back–up: click on the ’clock’ icon next to any database and after that just wait for a few seconds for the backup process to be finalized.

There won’t be any limitations about the number of databases you can back up or the volume of backup copies you can create for a database.

PgSQL databases are much less sought after in comparison to the popular MySQL databases. However, they are a preferred option for web developers who seek the finest security for their sites and web apps. Via the easy–to–use Database Manager built into the UTB Hosting Control Panel, you can manage your PostgreSQL databases with merely a click of the mouse.

You can discover PgSQL databases bundled by default with the advanced shared hosting service packages. Assuming that you are using a regular hosting package, you can ask for PgSQL databases to be added in your web hosting account as upgrades.

The MySQL databases on our servers utilize the most up–to–date release of the InnoDB storage engine. InnoDB has been developed to ensure the max effectiveness for websites that process massive volumes of data. It boasts CPU efficiency that can not be matched up by any alternative disk–based relational database engines.

InnoDB is ACID–compliant and offers total transaction support, which means that it’s possible to update/insert/create/alter/drop a couple of times for one "operation" of your web application. At the same time, it makes use of row–level locking instead of MyISAM’s table–level locking, that raises multi–user concurrency and efficiency.

From your all–encompassing database statistics tool built–into the Control Panel, it is possible to keep a record of the load produced through your active websites 24 / 7. Every overload trouble with your web sites can slow the loading speeds and have a negative impact on the overall experience of your respective site visitors. Consequently, having details about the database load live, it is also possible to resolve overload difficulties quickly.

The database statistics user interface displays details of the volume of daily, hourly and monthly queries, so that you can examine just how the load is spread over different time periods.