Databases Manager

The Databases Manager in our Online Control Panel has an effective nevertheless simplified interface. It’s possible to set up a brand new MySQL or PostgreSQL database by just specifying a user name and password. Also, you can create a backup file or change the security password of an database with just a mouse click.

Via the Databases Manager you’ll get immediate access to the administrator area for all of your databases, which means you can make simple modifications when you need to.

If you have worked with databases, you already know that creating a manual database back–up is not a basic task. As a way to change this, we have created an easy to understand tool that can back up your entire database with just a single mouse click. The backup file shall be available for you in less than a minute, with respect to the size of the chosen database.

There aren’t any confines on the actual number of back–ups you can make for any chosen database.

Most of our Linux shared web hosting packages present PgSQL support. Whilst falling behind MySQL regarding global recognition and utilization, PgSQL databases are famous for delivering the top level of safety for your website content and articles. That’s the primary reason why businesses like Skype and Yahoo go with PgSQL databases in lieu of MySQL.

In terms of database administration, PgSQL is as quick as MySQL.

We’ve added InnoDB – the new default MySQL database engine on every one of our servers. InnoDB is made for massive database sites that need high levels of general performance and scalability. Tests show that web sites making use of InnoDB based tables achieve a 3–fold performance increase for huge joins, in contrast to those employing MyISAM tables.

InnoDB makes use of row–level locking so as to eliminate the efficiency issues seen at the peak usage times of the previous release of the database engine – MyISAM, which uses table–level locking.

From your comprehensive database stats tool incorporated into the Online Control Panel, you’ll be able to keep a record of the stress created through your dynamic web sites around the clock. Virtually any overload difficulty with your websites could reduce the loading speeds and have a damaging effect on the overall experience of your respective visitors. Consequently, having information for the database work immediately, it’s possible to fix overload problems promptly.

The database statistics user interface shows information of the amount of daily, hourly and monthly queries, to help you to evaluate how the load is distributed over different periods of time.