While in the WorldwebOne Site Control Panel you’re going to find a full featured, intuitive Databases Manager! Put it to use to have total command over all of your databases. You can easily set up new MySQL and PgSQL databases and administer them with the phpMyAdmin and phpPgAdmin software tools, respectively.
Neat and Very easy Interface
Manage all of your databases from one location
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.
Easy Database Back up
Back up your databases in a minute
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.
Essentially the most risk–free open source databases
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.
The fresh face of 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.
Detailed Database Stats
In depth stats for your databases
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.