Within the DIY Websites Site Control Panel you will find a fully–featured, convenient–to–use Database Manager! Utilize it to experience total control of all your databases. You are able to very easily set up new MySQL and PgSQL databases and manage them through the phpMyAdmin and phpPgAdmin software tools, respectively.
Tidy and Very easy Interface
Maintain all your databases from a single location
The Database Manager inside our Site Control Panel features an effective but still convenient–to–use user interface. It’s possible to set up a completely new MySQL or PostgreSQL database simply by entering a username and password. Moreover, you can create a backup file or alter the security password of the database with merely a click of the mouse.
Via the Database Manager you will get direct access to the admin area for all of your databases, allowing you to make simple and easy modifications in the event you have to.
Effortless Database Backup
Take care of your database information with simply a click of the mouse
Assuming you have dealt with databases, you know that creating a manual database back–up isn’t a simple job. In an effort to change this, we have developed an effortless to use tool that can back up your complete database with merely a single mouse click. The backup file shall be available for you in less than a minute, depending on the size of the selected database.
There aren’t any confines on how many backups you could make for any specific database.
Just about the most risk–free open source databases
The majority of our web hosting plans plans provide PgSQL support. While falling behind MySQL with regards to acceptance and utilization, PgSQL databases are renowned for giving the greatest level of security for your website content. That’s the key reason why businesses like Skype and Yahoo go with PgSQL databases instead of MySQL.
With respect to database administration, PgSQL is identically quick as MySQL.
The fresh face of MySQL
We’ve incorporated InnoDB – the brand new default MySQL database engine on all of our machines. InnoDB is great for sizeable database web sites that need high overall performance and scalability. Trials have indicated that websites making use of InnoDB based tables attain a 3–fold general performance increase for very big joins, when compared to those working with MyISAM tables.
InnoDB employs row–level locking in an effort to eliminate the effectiveness problems observed at the high usage times of the prior version of the database engine – MyISAM, which employs table–level locking.
Detailed Database Stats
Comprehensive stats for all your databases
Tracking the load made by the databases on your active web site will let you avoid all overload troubles that could slow it down and ward off website visitors. For this purpose, we have incorporated a complete Database Stats tool in the Site Control Panel. There you shall find extensive info on the inbound requests to your databases for each hour, day and month.
Using the amount of daily and by the hour queries, you’ll be able to find out what databases are used the most and then take procedures to optimize their load.