Database Manager

Administering your databases is simpler than ever before, on account of the Web Control Panel user interface for MySQL and PgSQL management! In case you do not have extensive expertise in handling databases, you will find it easy to use the Database Manager.

You could make a whole new database by simply entering the user name and security password or generate a database back–up with simply a mouse click. In addition, from the Data Manager you will have direct access to the administration area for each individual database, so you’re able to immediately update it.

We have changed the manual database backup creation into a very easy task. To do this: inside of the Database Manager, click on the ’clock’ image near the database that you want to back up and afterwards hang on for a few seconds for the process to take place. Depending upon the size of the database, the building of the backup file will take somewhere between a few seconds and a minute.

You can make as many backup copies of a database as you want. We haven’t determined any boundaries on the quantity of databases that you could back up as well.

You are going to find PgSQL support in all our website hosting service packages. PgSQL databases may not be as popular and widespread as MySQL, nevertheless they provide you with the top level of protection for your website content and articles. Due to this, a number of famous companies like Skype and Yahoo use PgSQL databases. Handling PgSQL databases is as simple and easy as MySQL, due to the incredibly user–friendly interface of the Database Manager.

PgSQL databases are provided automatically with the most sophisticated web hosting bundles. For the standard plans, they’re included as upgrades.

We have installed InnoDB – the brand new standard MySQL database engine on our machines. InnoDB is great for significant database websites which need high overall performance and scalability. Trials indicate that web sites applying InnoDB based tables attain a 3–fold overall performance grow for very large joins, when compared with those working with MyISAM tables.

InnoDB uses row–level locking as a way to eliminate effectiveness issues spotted at the peak usage times of the earlier version of the database engine – MyISAM, which employs table–level locking.

Keeping track of the load accumulated by the databases within your busy website will let you stop all sorts of overload issues that might slow it down and ward off site visitors. For this reason, we’ve built in a comprehensive Database Stats tool into the Web Control Panel. There you can get all–encompassing information about the arriving requests to your databases for each hour, day and month.

Using the quantity of daily and per hour queries, it’s possible to find out which databases are used the most and also consider measures to enhance their work.