Database Manager

Taking control of your databases now is easier than ever, because of the Site Control Panel interface for MySQL and PgSQL control! Even if you do not have substantial knowledge of handling databases, you will find it effortless to use the Database Manager.

You could make a brand new database by just keying in the username and security password or produce a database back–up with merely a mouse click. In addition, within the Data Manager you’ll get direct access to the administrative area for every database, so you’re able to efficiently edit it.

We’ve developed the manual database backup formation into a simple job. To execute that: inside the Database Manager, click on the ’clock’ image on the side of the database that you want to back up and after that wait around for a few seconds for the backup process to take place. With regards to the size of the database, the generation of the back–up file can take somewhere between a few seconds and a minute.

You can create as many backups of a database as you desire. We have not specified any limits about the amount of databases you could back up too.

You are going to find PgSQL support in every one of our shared hosting plans. PgSQL databases may not be as sought after and widely used as MySQL, but they supply the highest possible level of stability for your site content. Therefore, many well–known businesses like Skype and Yahoo work with PgSQL databases. Taking care of PgSQL databases is as easy and simple as MySQL, thanks to the incredibly user–friendly interface of the Database Manager.

PgSQL databases are incorporated automatically within the most sophisticated web hosting packages. For the standard plans, they are presented as upgrades.

The MySQL databases on our machines make use of the most up–to–date build of the InnoDB storage engine. InnoDB has been created to ensure the optimum effectiveness for web sites that process significant amounts of data. It grants CPU performance that could not be matched up by other disk–based relational database engines.

InnoDB is ACID–compliant and offers full transaction support, meaning you’re able to update/insert/create/alter/drop many times for one "operation" of your web application. Moreover, it uses row–level locking in lieu of MyISAM’s table–level locking, that improves multi–user concurrency and performance.

Keeping track of the load caused by the databases for your active web site will let you reduce all overload difficulties that can slow it down and chase away website visitors. For this specific purpose, we’ve designed a complete Database Stats tool directly into the Site Control Panel. There you shall find in–depth information about the arriving requests to your databases for each and every hour, day and month.

Depending on the quantity of daily and by the hour queries, it will be straightforward to find out what databases are utilized the most and consider procedures to enhance their load.