Database Manager

The Database Manager in the Web Control Panel boasts a robust but still convenient–to–use user interface. It is easy to configure a completely new MySQL or PostgreSQL database by simply typing in a username and password. What’s more, you may create a back–up file or customize the security password of the database with only a click of the mouse.

Through the Database Manager you have immediate access to the admin area for all of your databases, allowing you to make quick alterations should you need to.

We have evolved the manual database back–up creation into a quite simple job. To execute that: inside the Database Manager, click the ’clock’ icon next to the database that you plan to back up and wait for a few seconds for the process to take place. With respect to the size of the database, the building of any back–up file can take between a few seconds and a minute.

You may create as many copies of a database as you would like. We’ve not set any confines for the volume of databases that you could back up as well.

Nearly all of our Linux shared web hosting service plans provide PgSQL support. While falling behind MySQL in terms of level of popularity and application, PgSQL databases are famous for offering up the highest level of stability for your website content and articles. It is the primary reason why companies such as Skype and Yahoo rely upon PgSQL databases as an alternative to MySQL.

With respect to database management, PgSQL is equally simple as MySQL.

We have incorporated InnoDB – the new default MySQL database engine on each of our web servers. InnoDB is great for huge database web sites which need high overall performance and scalability. Trials have revealed that sites utilizing InnoDB based tables attain a 3–fold performance boost for very large joins, in contrast to those employing MyISAM tables.

InnoDB works by using row–level locking in order to eliminate effectiveness issues witnessed at the maximum usage times of the previous variant of the database engine – MyISAM, which utilizes table–level locking.

Via the all–encompassing database statistics tool included in the Web Control Panel, it is possible to keep a record of the stress produced from your dynamic websites round the clock. Virtually any overload problem with your sites could reduce the loading rates and have a bad influence over the overall experience of your site visitors. So, by having details for the database work instantly, it will be straightforward to resolve overload issues without delay.

The database stats interface shows information of the volume of daily, hourly and monthly lookups, so that you can assess just how the load is spread over several time periods.