Databases Manager

Supervising your databases is much simpler than in the past, thanks to the Web Hosting Control Panel user interface for MySQL and PgSQL management! Provided you do not have detailed experience of handling databases, you will find it an easy task to handle our Databases Manager.

You could make a new database by simply specifying the user name and security password or generate a database backup with simply a mouse click. Likewise, within the Data Manager you will possess direct access to the administrator area for every database, meaning you can quite easily modify it.

Within the Databases Manager you’ll be able to generate an archived copy of your database whenever you wish! This way, you’ll always have a back–up of your operating content in the event your web site gets broken into or you erroneously get rid of a database. To generate a back–up: click on the ’clock’ symbol next to a certain database and after that wait for a couple of seconds for the backup process to be concluded.

There aren’t any restricts on the amount of databases you are able to back up or the amount of backup copies you can make for a database.

Nearly all of the shared web hosting service packages grant PgSQL support. Whilst dropping behind MySQL with respect to level of popularity and employment, PgSQL databases are famous for giving the top level of stability for your website content material. It is the key reason why companies such as Skype and Yahoo use PgSQL databases as an alternative to MySQL.

With respect to database administration, PgSQL is identically quick as MySQL.

With UILhosting.com, you’ll always find the latest edition of MySQL plus the default MySQL storage engine – InnoDB, installed.

InnoDB is much more dependable than the former storage engine’s edition – MyISAM. It is ACID–compliant and, most significantly – it provides total transaction support. Additionally, it utilizes row–level locking, as an alternative for MyISAM’s table–level locking, that would always lead to functionality issues at high usage periods.

Through the in–depth database statistics tool built–into the Web Hosting Control Panel, you’re going to be able to keep track of the stress produced from your active sites 24 x 365. Any overload problem with your websites could slow the loading speeds and have a negative influence over the overall impression of your respective site visitors. Which means that, having data about the database load instantly, it will be possible to solve overload troubles as soon as possible.

The database data interface displays data of the amount of daily, hourly and monthly queries, so its possible to assess just how the load is allocated over different periods of time.