Databases Manager

The Databases Manager in our Hosting Control Panel comes with a powerful yet convenient–to–use user interface. You are able to configure a new MySQL or PostgreSQL database by just specifying a username and security password. In addition, you may create a backup file or alter the password of your database with a click of the mouse.

Within the Databases Manager you have direct access to the administration area for all of your databases, meaning you can make easy corrections should you need to.

In case you have dealt with databases, you are aware that making a manual database backup is not an elementary job. In order to change this, we have created a simple tool that will back up the entire database with merely one click. The backup file will be ready for you in under a minute, based on the size of the selected database.

There aren’t any confines on how many backup copies you could make for a particular database.

The majority of the Linux cloud packages packages feature PgSQL support. While dropping behind MySQL when considering reputation and employment, PgSQL databases are famous for offering up the top level of safety for your web site content and articles. It is the key reason why companies such as Skype and Yahoo make use of PgSQL databases instead of MySQL.

When it comes to database administration, PgSQL is equally effortless to use as MySQL.

We have set up InnoDB – the new default MySQL database engine on every one of our servers. InnoDB is good for massive database web sites that demand high levels of functionality and scalability. Trials show that sites using InnoDB based tables achieve a 3–fold efficiency boost for very large joins, compared to those applying MyISAM tables.

InnoDB makes use of row–level locking in order to eliminate the performance difficulties detected at the high usage times of the earlier variant of the database engine – MyISAM, which utilizes table–level locking.

Through the comprehensive database stats tool integrated into the Hosting Control Panel, you’re going to be able to keep tabs of the load generated by your busy web sites 24 hour a day. Virtually any overload problem with your sites could slow the loading speeds and have a negative effect on the overall impression of your respective website visitors. Consequently, by having info about the database load right away, it’s possible to mend overload issues quickly.

The database stats user interface shows data of the quantity of daily, hourly and monthly queries, so its possible to analyze just how the load is distributed over different time periods.