From within the Database Manager built–into the Control Panel, it is also possible to set–up completely new MySQL and PgSQL databases immediately! Additionally, you have immediate access to the admin area software tools (phpMyAdmin and phpPgAdmin, respectively), which means you can quite easily revise the database you want.
Clean and Uncomplicated User interface
Handle all your databases from one location
The Database Manager inside the Control Panel provides a refined yet uncomplicated interface. You’ll be able to set up a completely new MySQL or PostgreSQL database simply by specifying a username and security password. Additionally, you can create a back–up file or customize the password of your database with merely a click of the mouse.
From the Database Manager you’ve got immediate access to the administrative area for each of your databases, which means you can make easy changes in case you need to.
Easy Database Back–up
Back up your databases in just a minute
We’ve transformed the manual database backup formation into a very simple task. To do this: inside the Database Manager, click on the ’clock’ image near the database that you want to back up and then hang on for a few seconds for the process to take place. Depending on the size of your database, the generation of a backup file can take between a couple of seconds and a minute.
You can make as many backup copies of a database as you wish. We’ve not fixed any limitations on the amount of databases you could back up either.
Just about the most protected open source databases
Almost all of our Linux cloud packages plans provide PgSQL support. While falling behind MySQL when considering acceptance and usage, PgSQL databases are famous for providing the greatest level of stability for your site content material. This is the key reason why companies such as Skype and Yahoo rely upon PgSQL databases as opposed to MySQL.
With regards to database administration, PgSQL is identically uncomplicated as MySQL.
The fresh new face of MySQL
We have installed InnoDB – the brand new standard MySQL database engine on every one of our machines. InnoDB is perfect for massive database websites that need high performance and scalability. Tests have indicated that sites employing InnoDB based tables attain a 3–fold functionality grow for significant joins, in comparison with those working with MyISAM tables.
InnoDB utilizes row–level locking in order to be able to take away the performance problems observed at the peak consumption times of the earlier version of the database engine – MyISAM, which utilizes table–level locking.
Detailed Database Stats
Comprehensive stats for all your databases
Keeping tabs on the load generated by the databases on your dynamic web site will let you reduce any sort of overload troubles that can slow it down and ward off site visitors. Therefore, we’ve incorporated a in depth Database Stats tool inside the Control Panel. There you can see extensive information regarding the incoming requests to your databases for every hour, day and month.
Depending on the amount of daily and hourly queries, it’s possible to find out what databases are utilized the most and then take procedures to enhance their work.