From the Databases Manager included in the Control Panel, you will be able to create new MySQL and PgSQL databases straight away! Also, you’ll have immediate access to the administrator area software tools (phpMyAdmin and phpPgAdmin, respectively), so you’re able to almost instantly modify the database you want.
Tidy and Very easy User interface
Manage all your databases from within one location
The Databases Manager inside the Control Panel provides a powerful yet simple to use user interface. It is possible to set up a whole new MySQL or PostgreSQL database by simply specifying a username and password. Also, you can make a back–up file or change the security password of an database with simply a click of the mouse.
Via the Databases Manager you have direct access to the management area for all your databases, meaning you can make easy modifications if you ever have to.
Simple and quick Database Backup
Database backup copies are just a mouse click away
From the Databases Manager you’ll be able to generate an archived copy of your database when you would like! Thus, you’ll always have a data backup of your operating content material in case your web site gets hacked or you erroneously delete a database. To produce a backup: click on the ’clock’ icon alongside a particular database and afterwards wait for a few seconds for the backup process to be executed.
There are not any limits about the quantity of databases you can back up or the amount of backups you can create for a database.
PgSQL Support
By far the most protected open source databases
A majority of our Linux website hosting bundles deliver PgSQL support. Whilst falling behind MySQL regarding acceptance and employment, PgSQL databases are renowned for presenting the highest level of stability for your web site content. This is the reason why companies such as Skype and Yahoo make use of PgSQL databases and not MySQL.
With regards to database management, PgSQL is as hassle–free as MySQL.
InnoDB Databases
The newest face of MySQL
The MySQL databases on our web servers use the most up–to–date version of the InnoDB storage engine. InnoDB was developed to ensure the max effectiveness for websites that work with sizeable volumes of data. It presents CPU effectiveness that can not be matched up by any other different disk–based relational database engines.
InnoDB is ACID–compliant and supplies 100% transaction support, meaning that you can easily update/insert/create/alter/drop many times for one "operation" of your application. Also, it utilizes row–level locking as a substitute for MyISAM’s table–level locking, that increases multi–user concurrency and effectiveness.
Detailed Database Stats
In depth stats for all of your databases
Keeping track of the load made by the databases on your dynamic site will help you prevent all kinds of overload difficulties that could slow it down and ward off site visitors. Therefore, we’ve built in a comprehensive Database Stats tool directly into the Control Panel. There you can find thorough info about the arriving requests to your databases for every hour, day and month.
Depending on the volume of daily and by the hour queries, it will be straightforward to determine which databases are used the most and consider measures to optimize their load.
