Databases Manager

Supervising your databases now is easier than before, as a result of Website Control Panel interface for MySQL and PgSQL control! Even if you do not have thorough expertise in dealing with databases, you will find it simple to work with our Databases Manager.

You can make a whole new database by merely specifying the username and security password or create a database backup with a mouse click. At the same time, via the Data Manager you will get direct access to the management area for each database, which enables you to quickly modify it.

We have developed the manual database backup creation into a very simple task. To execute that: inside of the Databases Manager, click on the ’clock’ icon next to the database that you want to back up and then wait for a few seconds for the backup process to take place. Depending on the size of the database, the building of the back–up file will require between a couple of seconds and a minute.

You may make as many copies of a database as you desire. We haven’t specified any confines on the volume of databases you could back up either.

A lot of AnyPursuit’s Linux shared hosting packages present PgSQL support. Whilst dropping behind MySQL with regard to level of popularity and usage, PgSQL databases are famous for offering up the maximum level of safety for your website content material. It is the basic reason why companies like Skype and Yahoo use PgSQL databases as a substitute for MySQL.

With regard to database management, PgSQL is identically straightforward as MySQL.

We’ve installed InnoDB – the new default MySQL database engine on all of our servers. InnoDB is made for substantial database web sites which require high functionality and scalability. Experiments have demonstrated that web sites working with InnoDB based tables attain a 3–fold general performance grow for big joins, as compared with those working with MyISAM tables.

InnoDB works by using row–level locking so as to clear away the performance issues spotted at the high usage times of the previous variant of the database engine – MyISAM, which uses table–level locking.

Tracking the load accumulated by the databases within your powerful website will help you avoid any sort of overload troubles that can slow it down and chase away website visitors. For this purpose, we have bundled a thorough Database Stats tool in the Website Control Panel. There you can see complete information on the inbound requests to your databases for every single hour, day and month.

Based on the volume of daily and per hour queries, it will be easy to find out which databases are being used the most as well as take steps to enhance their load.