Database Manager

Managing your databases now is easier than before, as a result of Site Control Panel user interface for MySQL and PgSQL management! Even if you do not have considerable experience of dealing with databases, you will find it very easy to handle the Database Manager.

You could make a brand new database simply by specifying the username and password or produce a database backup with just a click of the mouse. Likewise, with the Data Manager you’ll get direct access to the administrator area for each and every database, so its possible to effectively update it.

We have transformed the manual database back–up creation into a quite easy task. To execute that: within the Database Manager, click the ’clock’ image beside the database that you want to back up and wait around for a few seconds for the backup process to take place. Depending on the size of the database, the generation of a backup file will take somewhere between a couple of seconds and a minute.

You can make as many backup copies per database as you wish. We have not set any confines on the amount of databases that you could back up either.

You will find PgSQL support in every one of our Linux web hosting service packages. PgSQL databases might not be as sought after and widespread as MySQL, nevertheless they provide the top level of stability for your web site content and articles. For this reason, many well–known companies such as Skype and Yahoo work with PgSQL databases. Controlling PgSQL databases is as elementary as MySQL, as a result of the user–friendly interface of the Database Manager.

PgSQL databases are bundled by default in the most sophisticated web hosting plans. For the basic packages, they’re presented as upgrades.

With DatotaHost, you will always discover the latest version of MySQL plus the default MySQL storage engine – InnoDB, installed.

InnoDB is more secure in comparison to the old storage engine’s version – MyISAM. It’s ACID–compliant and, most importantly – it grants full transaction support. Furthermore, it utilizes row–level locking, in lieu of MyISAM’s table–level locking, that used to cause efficiency troubles at peak usage times.

With the all–inclusive database stats tool built–into the Site Control Panel, you will be able to keep track of the stress accumulated from your dynamic websites round the clock. Virtually any overload difficulty with your web sites could slow the loading rates and have a damaging influence over the overall experience of your visitors. Which means that, by having data about the database load instantly, you’ll be able to mend overload issues as soon as possible.

The database stats interface displays details of the quantity of daily, hourly and monthly queries, so that you can evaluate how the load is allocated over various periods of time.