Database Manager

Taking control of your databases is much simpler than ever before, thanks to the Control Panel interface for MySQL and PgSQL management! In case you do not have in depth experience in making use of databases, it will be an easy task to deal with the Database Manager.

You can make a completely new database by simply typing the user name and security password or make a database backup with merely a click of the mouse. In addition, via the Data Manager you will have direct access to the management area for every single database, which enables you to instantly update it.

With the Database Manager you’ll be able to produce an archived copy of your database when you desire! Therefore, you are going to always have a back–up of your active information in case your site gets broken into or you mistakenly erase a database. To make a backup: click the ’clock’ icon beside a given database and afterwards simply wait for a couple of seconds for the process to be performed.

There are no confines on the quantity of databases you can back up or the number of backups you may make for a database.

A majority of the Linux hosting packages feature PgSQL support. Whilst dropping behind MySQL regarding popularity and usage, PgSQL databases are famous for giving the best level of stability for your site content and articles. It is the basic reason why businesses like Skype and Yahoo use PgSQL databases and not MySQL.

When it comes to database management, PgSQL is as straightforward as MySQL.

With Audiospecific, you shall inevitably find the most up–to–date edition of MySQL plus the default MySQL storage engine – InnoDB, set up.

InnoDB is a lot more stable when compared to the past storage engine’s version – MyISAM. It is ACID–compliant and, above all – it provides full transaction support. You’ll find, it uses row–level locking, in contrast to MyISAM’s table–level locking, that previously used to trigger efficiency issues at high usage periods.

Via the detailed database statistics tool included in the Control Panel, you will be able to keep track of the load generated by your active sites around the clock. Any overload problem with your websites could reduce the loading rates and have a negative effect on the overall experience of your website visitors. Consequently, having information for the database work instantly, it will be easy to resolve overload problems immediately.

The database statistics user interface displays information of the number of daily, hourly and monthly queries, which enables you to analyze the way the load is distributed over various periods of time.