We give you a simple to operate Databases Manager, bundled up with our Online Control Panel, from where you could generate completely new MySQL and PgSQL databases instantly. Moreover, you are able to oversee all their adjustments via the convenient access offered to the phpMyAdmin and phpPgAdmin software instruments.
Tidy and Uncomplicated User interface
Take care of all your databases from a single location
The Databases Manager in the Online Control Panel provides a robust but straightforward interface. You are able to set up a completely new MySQL or PostgreSQL database by just typing in a user name and security password. In addition, you could make a backup file or modify the password of the database with a click of the mouse.
Within the Databases Manager you will possess immediate access to the administrative area for all your databases, so you’re able to make easy modifications in the event you have to.
Easy Database Backup
Back up your databases in just a moment
We’ve made the manual database backup creation into a very simple activity. To do this: within the Databases Manager, click on the ’clock’ icon near the database that you want to back up and wait around for a couple of seconds for the backup process to take place. Depending on the size of the database, the creation of a backup file can take somewhere between a few seconds and a minute.
You can create as many copies of a database as you wish. We have not specified any limits for the volume of databases you could back up either.
Support for PgSQL
Assured safety for your databases
PgSQL databases are much less sought after as opposed to the widespread MySQL databases. Having said that, they’re a preferred option for programmers seeking the uttermost safety for their websites and apps. Because of the user–friendly Databases Manager built into the Sites Always Up Control Panel, you can control all of your PostgreSQL databases with only a click of the mouse.
You are going to find PgSQL databases integrated by default inside the best Linux web hosting packages. Assuming that you are using a regular hosting package, you’ll be able to ask for PgSQL databases to be added in your website hosting account as upgrades.
The brand new face of MySQL
We have added InnoDB – the brand new default MySQL database engine on each of our servers. InnoDB is ideal for big database sites that demand high levels of overall performance and scalability. Experiments have indicated that sites utilizing InnoDB based tables reach a 3–fold general performance boost for large joins, in contrast to those working with MyISAM tables.
InnoDB works by using row–level locking in order to get rid of the general performance issues found at the high usage times of the earlier release of the database engine – MyISAM, which employs table–level locking.
Detailed Database Stats
Comprehensive statistics for your databases
Monitoring the load generated by the databases for your busy site will let you prevent all kinds of overload difficulties that might slow it down and ward off visitors. For this specific purpose, we’ve designed a in–depth Database Stats tool into the Online Control Panel. There you can see detailed information about the arriving requests to your databases for every single hour, day and month.
Based on the number of day–to–day and per hour queries, it will be easy to find out which databases are employed the most and also consider measures to enhance their load.