Database Manager

Overseeing your databases is less complicated than in the past, due to the Site Control Panel user interface for MySQL and PgSQL management! Provided you do not have considerable expertise in dealing with databases, you will find it effortless to deal with our Database Manager.

You could make a whole new database by simply entering the username and security password or produce a database back–up with simply a click of the mouse. In addition, within the Data Manager you have direct access to the administrative area for each database, meaning you can quite simply manage it.

Through the Database Manager you are able to make an archived copy of your database anytime you want! That way, you’ll always have a backup of your operating content material if your website gets hacked or if you incorrectly get rid of a database. To create a backup: click on the ’clock’ symbol beside a given database and then simply wait for a couple of seconds for the backup process to be executed.

There are no confines for the number of databases you would be able to back up or the amount of back–ups you can make for any database.

Most of Best Reseller Hosting’s cloud web hosting packages present PgSQL support. Whilst falling behind MySQL with respect to popularity and usage, PgSQL databases are famous for delivering the greatest level of safety for your site content. That’s the key reason why businesses like Skype and Yahoo rely on PgSQL databases rather than MySQL.

When considering database administration, PgSQL is just as easy to understand as MySQL.

We have added InnoDB – the new default MySQL database engine on each of our web servers. InnoDB is designed for large database sites which need high levels of efficiency and scalability. Experiments indicate that web sites using InnoDB based tables attain a 3–fold performance increase for very large joins, in contrast to those working with MyISAM tables.

InnoDB takes advantage of row–level locking in order to clear away the effectiveness difficulties discovered at the maximum usage times of the previous version of the database engine – MyISAM, which uses table–level locking.

Monitoring the load made by the databases in your dynamic website will let you reduce all kinds of overload difficulties that can slow it down and chase away website visitors. Therefore, we have built in a in depth Database Stats tool directly into the Site Control Panel. There you can get comprehensive info about the inbound requests to your databases for each and every hour, day and month.

Depending on the number of daily and hourly queries, you’ll be able to find out what databases are employed the most and then take actions to optimize their work.