Databases Manager

Managing your databases is much easier than in the past, due to the Web Control Panel user interface for MySQL and PgSQL management! Provided you do not have extensive knowledge in making use of databases, it will be very easy to manage the Databases Manager.

You can make a brand new database merely by typing the user name and password or produce a database back–up with merely a mouse click. At the same time, via the Data Manager you will possess direct access to the management area for each individual database, so that you can almost instantly modify it.

We’ve changed the manual database backup formation into a simple job. To execute this: in the Databases Manager, click on the ’clock’ icon on the side of the database that you want to back up and wait for a few seconds for the process to take place. With regards to the size of the database, the creation of any back–up file will require somewhere between a few seconds and a minute.

You may create as many backup copies per database as you want. We haven’t set any limits about the quantity of databases that you could back up either.

A lot of our Linux hosting packages grant PgSQL support. While falling behind MySQL when it comes to level of popularity and utilization, PgSQL databases are renowned for providing the top level of protection for your site content. That’s the reason why brands like Skype and Yahoo rely upon PgSQL databases rather than MySQL.

When considering database administration, PgSQL is as easy to use as MySQL.

We have added InnoDB – the new default MySQL database engine on every one of our machines. InnoDB is designed for big database sites which require high effectiveness and scalability. Experiments have revealed that websites using InnoDB based tables attain a 3–fold effectiveness grow for very big joins, compared to those making use of MyISAM tables.

InnoDB employs row–level locking as a way to eliminate the operation difficulties seen at the maximum usage times of the earlier variant of the database engine – MyISAM, which employs table–level locking.

Via the detailed database stats tool built–into the Web Control Panel, you are going to be able to keep tabs of the load produced through your busy web sites twenty–four hours a day. Virtually any overload trouble with your sites could slow the loading speeds and have a damaging effect on the overall experience of your respective visitors. So, having data about the database work in real time, you will be able to mend overload difficulties at once.

The database stats user interface reveals information of the amount of daily, hourly and monthly lookups, so you’re able to analyze the way the load is allocated over various periods of time.