Databases Manager

The Databases Manager in the Site Control Panel comes with a robust but easy to navigate interface. You’ll be able to set up a completely new MySQL or PostgreSQL database by simply specifying a user name and password. Also, you can make a back–up file or modify the security password of a database with simply a click of the mouse.

Through the Databases Manager you will possess immediate access to the administration area for every one of your databases, meaning you can make convenient alterations in the event you have to.

We’ve designed the manual database backup creation into a quite simple task. To do this: in the Databases Manager, click on the ’clock’ icon beside the database that you would like to back up and then hang on for a few seconds for the process to take place. Depending upon the size of the database, the generation of a backup file will require somewhere between a couple of seconds and a minute.

You can make as many copies of a database as you wish. We have not specified any limits for the quantity of databases that you could back up as well.

Practically all of WorldwebOne’s website hosting bundles feature PgSQL support. While dropping behind MySQL when considering popularity and utilization, PgSQL databases are famous for providing the greatest level of stability for your site content and articles. That’s the reason why businesses like Skype and Yahoo go with PgSQL databases as opposed to MySQL.

With respect to database management, PgSQL is just as straightforward as MySQL.

We’ve incorporated InnoDB – the brand new default MySQL database engine on each of our machines. InnoDB is perfect for sizeable database web sites that demand high efficiency and scalability. Tests have shown that websites making use of InnoDB based tables attain a 3–fold general performance increase for massive joins, as opposed to those applying MyISAM tables.

InnoDB works by using row–level locking in order to eliminate the operation difficulties discovered at the high consumption times of the prior version of the database engine – MyISAM, which utilizes table–level locking.

Keeping track of the load accumulated by the databases for your powerful web site will help you prevent any sort of overload problems that could slow it down and chase away website visitors. Therefore, we’ve built–in a comprehensive Database Stats tool into your Site Control Panel. There you can get all–encompassing info on the inbound requests to your databases for each and every hour, day and month.

Depending on the amount of daily and hourly queries, it will be easy to determine which databases are being used the most as well as consider measures to optimize their load.