Databases Manager

The Databases Manager in our Website Control Panel provides a powerful nevertheless simplified user interface. You’ll be able to configure a completely new MySQL or PostgreSQL database by simply typing in a user name and password. Additionally, you could make a backup file or modify the password of your database with simply a click of the mouse.

Within the Databases Manager you’ll have immediate access to the administrator area for each of your databases, in order to make easy changes should you have to.

Provided you have worked with databases, you know creating a manual database back–up is just not an elementary task. So as to change this, we have created a simple tool that can back up your entire database with merely a single click of the mouse. The back–up file shall be prepared for you in less than a minute, depending upon the size of the selected database.

There are no limitations on exactly how many copies you could make for a particular database.

The majority of the Linux cloud web hosting service plans present PgSQL support. Although dropping behind MySQL in terms of acceptance and application, PgSQL databases are renowned for offering the best level of security for your site content material. This is the primary reason why brands like Skype and Yahoo employ PgSQL databases rather than MySQL.

With regards to database administration, PgSQL is equally straightforward as MySQL.

We have incorporated InnoDB – the brand new standard MySQL database engine on all of our servers. InnoDB is ideal for huge database sites that need high effectiveness and scalability. Trials have demonstrated that web sites working with InnoDB based tables achieve a 3–fold operation boost for huge joins, in comparison with those employing MyISAM tables.

InnoDB makes use of row–level locking in an effort to remove the efficiency issues discovered at the peak consumption times of the prior variant of the database engine – MyISAM, which utilizes table–level locking.

assistedeverything offers you an uncomplicated route to monitor the database usage on your powerful sites. Via the thorough database statistics user interface, that’s integrated into the Website Control Panel, you are able to keep an eye on the load produced by your dynamic web sites in real time. The displayed info will allow you to assess the database load changes by the hour, each day or monthly.

It’s possible to monitor the database load for all your sites in the Database Stats portion of the Website Control Panel. The table onscreen presents the database queries accumulated during the present month. To examine details for an earlier month, just click on the back arrows located at the top.