Database Manager

Database management may seem like a difficult task to novice hosting clients, but with the Database Manager, it’s actually really simple! To make a whole new database, you simply ought to provide your username and password. Database backup copies are a click away as well.People who need to look into their databases and alter them can make use of the phpMyAdmin and phpPgAdmin tools.

We have designed the manual database back–up creation into a quite simple job. To execute this: within the Database Manager, click on the ’clock’ symbol on the side of the database that you intend to back up and hang on for a couple of seconds for the backup process to take place. Depending on the size of your database, the generation of the backup file is going to take somewhere between a couple of seconds and a minute.

You can make as many backup copies per database as you would like. We haven’t determined any restrictions for the amount of databases you could back up either.

Nearly all of the shared web hosting plans packages feature PgSQL support. While falling behind MySQL with regard to popularity and usage, PgSQL databases are renowned for offering up the highest level of stability for your website content and articles. This is the basic reason why companies like Skype and Yahoo go with PgSQL databases instead of MySQL.

With respect to database administration, PgSQL is just as easy to use as MySQL.

We have installed InnoDB – the brand new default MySQL database engine on all our servers. InnoDB is great for sizeable database sites which need high overall performance and scalability. Trials have revealed that web sites using InnoDB based tables attain a 3–fold efficiency boost for large joins, in comparison to those utilizing MyISAM tables.

InnoDB employs row–level locking in order to be able to remove the general performance problems detected at the maximum consumption times of the previous release of the database engine – MyISAM, which utilizes table–level locking.

Monitoring the load produced by the databases within your active website will help you reduce any sort of overload issues that might slow it down and chase away website visitors. For that reason, we have integrated a comprehensive Database Stats tool within the Site Control Panel. There you can see comprehensive info about the arriving requests to your databases for every single hour, day and month.

Using the number of daily and by the hour queries, you are going to be able to find out which databases are utilized the most and also take measures to enhance their work.